DeliveryProfiles
Stores delivery profile configurations, defining how products are grouped and shipped from different locations.
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 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 unique identifier for the delivery profile record. | |
| Name | String | False |
The display name of the delivery profile as defined by the merchant. | |
| Default | Bool | True |
Indicates whether this delivery profile is set as the store's default profile for shipping and delivery settings. | |
| LegacyMode | Bool | True |
Indicates whether the shop is operating in legacy compatibility mode for delivery profiles, preserving older shipping configurations. | |
| OriginLocationCount | Int | True |
The total number of active origin locations associated with this delivery profile. | |
| ZoneCountryCount | Int | True |
The number of countries included in the delivery zones that have active shipping rates. | |
| ActiveMethodDefinitionsCount | Int | True |
The total number of active shipping rate definitions configured under this delivery profile. | |
| LocationsWithoutRatesCount | Int | True |
The number of fulfillment or origin locations that do not currently have defined shipping rates. | |
| ProductVariantsCount | Int | True |
The total number of product variants assigned to this delivery profile. | |
| ProductVariantsCountPrecision | String | True |
Indicates whether the product variant count value is exact or estimated. | |
| MerchantOwnedOnly | Bool | True |
If true, limits results to delivery profiles created directly by the merchant rather than by third-party apps or integrations. |