DeliveryProfiles
Returns a list of saved delivery profiles.
Table-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The provider processes other filters client-side within the provider.
- Id supports the '=,IN' comparison operators.
- MerchantOwnedOnly supports the '=,IN' comparison operators.
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. | |
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. |