ShippingZones

Lists all shipping zones.

Table Specific Information

Select

The connector 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 connector.

For example, the following query is processed server-side:

SELECT * FROM ShippingZones WHERE Id = 1

Insert

To insert a new ShippingZone, a set of Locations are required to be inserted along with it. This can be done by populating a temporary ShippingZoneLocations table with the desired values for the option you are creating, and later using this table as a value for the Locations column during insertion:

INSERT INTO ShippingZoneLocations#Temp (CountryIso2, Zip) values ('US', '11103')
INSERT INTO ShippingZones (Name, Type, locations) VALUES ('United States', 'zip', 'ShippingZoneLocations#Temp')

Update

UPDATE ShippingZones SET Enabled=true WHERE Id = 7

Delete

DELETE FROM ShippingZones WHERE Id = 7

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Zone Id.
Name	String	False		Zone name.
Type	String	False		Zone type. The allowed values are zip, country, state, global.
FreeShippingEnabled	Boolean	False		Indicator if free shipping is enabled.
FreeShippingMinimumSubTotal	Decimal	False		Minimum subtotal of the free shipping.
FreeShippingExcludeFixedShippingProducts	Boolean	False		Indicator whether or not to exclude fixed shipping on products.
HandlingFeesDisplaySeparately	Boolean	False		Indicator whether or not to display the handling fees separately.
HandlingFeesPercentageSurcharge	Decimal	False		Percentage surcharge of the handling fee.
HandlingFeesFixedSurcharge	Decimal	False		Fixed surcharge of the handling fee.
Enabled	Boolean	False		Whether this shipping zone is enabled.
Locations	String	False		Array of zone locations.