JDBC Driver for Shopify

Build 23.0.8839

DeliveryProfiles

Returns a list of saved delivery profiles.

Table-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=,IN' comparison operators.
  • MerchantOwnedOnly supports the '=' comparison operator.

The 本製品 processes other filters client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM DeliveryProfiles WHERE Id='VALUE'

SELECT * FROM DeliveryProfiles WHERE MerchantOwnedOnly='true'

Insert

INSERT statements are mapped to the 'deliveryProfileCreate' GraphQL mutation.

The following column can be used to create a new record:

Name

UPDATE

UPDATE statements are mapped to the 'deliveryProfileUpdate' GraphQL mutation.

The following column can be updated:

Name

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

Name String False

The name of the delivery profile.

Default Bool True

Whether this is the default profile.

LegacyMode Bool True

Whether this shop has enabled legacy compatibility mode for delivery profiles.

OriginLocationCount Int True

The number of active origin locations for the profile.

ZoneCountryCount Int True

The number of countries with active rates to deliver to.

ActiveMethodDefinitionsCount Int True

The number of active shipping rates for the profile.

LocationsWithoutRatesCount Int True

The number of locations without rates defined.

ProductVariantsCountV2Capped Bool True

Whether the count has reached the cap of 500.

ProductVariantsCountV2Count Int True

The product variant count.

MerchantOwnedOnly Bool True

If 'true', returns only delivery profiles that were created by the merchant.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839