ADO.NET Provider for Shopify

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060