DeliveryProfiles
Returns a list of saved delivery profiles.
Table-Specific Information
Select
The connector 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 connector processes other filters client-side within the connector.
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. |