Returns a list of Tax Zones.

Table Specific Information

Select

The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

• Id supports the = and IN comparisons.

The rest of the filter is executed client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM TaxZones WHERE Id = 1

SELECT * FROM TaxZones WHERE Id IN (1,2,3)

Insert

To insert a tax zone, specify at least the Name, PriceDisplaySettingsShowInclusive, and ShopperTargetSettingsLocations columns.

INSERT INTO TaxZones (Name, Enabled, PriceDisplaySettingsShowInclusive, ShopperTargetSettingsLocations) VALUES ('EU Zone', true, true, '[{"country_code": "US", "postal_codes": ["2173"]}]');

Update

Note: The default tax zone (Id = 1) cannot be updated

UPDATE TaxZones SET Enabled = false WHERE Id = 5

Delete

Deleting a tax zone cascades to remove all associated tax rates. The default tax zone (Id = 1) cannot be deleted.

DELETE FROM TaxZones WHERE Id = 5

DELETE FROM TaxZones WHERE Id IN (5,6)

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Internal identifier for the tax zone.
Name	String	False	Human-readable name for the tax zone.
Enabled	Boolean	False	Whether the tax zone is enabled. Defaults to true. The default tax zone (Id = 1) cannot be disabled or deleted.
PriceDisplaySettingsShowInclusive	Boolean	False	Whether prices are displayed inclusive of tax for this zone.
PriceDisplaySettingsShowBothOnDetailView	Boolean	False	Whether both tax-inclusive and tax-exclusive prices are shown on the product detail view.
PriceDisplaySettingsShowBothOnListView	Boolean	False	Whether both tax-inclusive and tax-exclusive prices are shown on product list views.
ShopperTargetSettingsLocations	String	False	A JSON-formatted array of locations (country_code, subdivision_codes, postal_codes) that determine which shoppers this tax zone applies to.
ShopperTargetSettingsCustomerGroups	String	False	A JSON-formatted array of customer group Ids this tax zone applies to. Empty if the zone applies to all customer groups.