Excel Add-In for BigCommerce

Build 23.0.8839


Lists all shipping zones.

Table Specific Information


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 


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.

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