ShippingZones
Lists all shipping zones.
Table Specific Information
Select
The provider uses the BigCommerce API to process WHERE clause conditions built with Id, which supports the '=' comparison.
The rest of the filter is executed client-side within the provider.
For example, the following query is processed server-side:
SELECT * FROM ShippingZones WHERE Id = 1
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Zone Id. | |
| Name | String | Zone name. | |
| Type | String | Zone type. | |
| FreeShippingEnabled | Boolean | Indicator if free shipping is enabled. | |
| FreeShippingMinimumSubTotal | Decimal | Minimum subtotal of the free shipping. | |
| FreeShippingExcludeFixedShippingProducts | Boolean | Indicator whether or not to exclude fixed shipping on products. | |
| HandlingFeesDisplaySeparately | Boolean | Indicator whether or not to display the handling fees separately. | |
| HandlingFeesPercentageSurcharge | Decimal | Percentage surcharge of the handling fee. | |
| HandlingFeesFixedSurcharge | Decimal | Fixed surcharge of the handling fee. | |
| Enabled | Boolean | Whether this shipping zone is enabled. |