ShippingZones
Lists all shipping zones.
Table Specific Information
Select
The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Id supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM ShippingZones SELECT * FROM ShippingZones WHERE Id = 1
Columns
| Name | Type | 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. |