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. The connector processes other filters client-side within the connector.
- Id supports the '=,IN' comparison operators.
- MerchantOwnedOnly supports the '=' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM DeliveryProfiles
SELECT * FROM DeliveryProfiles WHERE Id = 'Val1'
SELECT * FROM DeliveryProfiles WHERE MerchantOwnedOnly = true
Insert
The following column can be used to create a new record:
Name
Update
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. | |
| ProductVariantsCount | Int | True |
The product variant count. | |
| ProductVariantsCountPrecision | String | True |
The count's precision, or the exactness of the value. | |
| MerchantOwnedOnly | Bool | True |
If 'true', returns only delivery profiles that were created by the merchant. |