ShippingZones
Lists all shipping zones.
Table Specific Information
Select
The 本製品 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 本製品.
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. |