DeliveryProfiles
Lists saved delivery profiles that define shipping logic by product and location.
Table-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- Id supports the '=, IN' comparison operators.
- MerchantOwnedOnly supports the '=' comparison operator.
For example, the following queries are processed server-side:
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 |
The globally unique identifier of the delivery profile. | |
| Name | String | False |
The display name of the delivery profile. | |
| Default | Bool | True |
Indicates whether this is the default delivery profile. | |
| LegacyMode | Bool | True |
Indicates whether legacy compatibility mode is enabled for this shop's delivery profiles. | |
| OriginLocationCount | Int | True |
The number of active origin locations included in this delivery profile. | |
| ZoneCountryCount | Int | True |
The number of countries with active delivery rates in this profile. | |
| ActiveMethodDefinitionsCount | Int | True |
The number of active shipping rate definitions in this delivery profile. | |
| LocationsWithoutRatesCount | Int | True |
The number of locations in this profile that do not have rates defined. | |
| ProductVariantsCount | Int | True |
The number of product variants assigned to this delivery profile. | |
| ProductVariantsCountPrecision | String | True |
The level of precision applied to the product variant count value. | |
| MerchantOwnedOnly | Bool | True |
Indicates whether the profile is restricted to delivery profiles created by the merchant. |