JDBC Driver for BigCommerce

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462