ODBC Driver for BigCommerce

Build 23.0.8839

ShippingMethods

Lists all shipping methods.

Table Specific Information

Select

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

  • Id supports the '=' comparison.
  • ZoneId 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 ShippingMethods

SELECT * FROM ShippingMethods WHERE ZoneId = 1

SELECT * FROM ShippingMethods WHERE ZoneId = 1 and Id = 1

Columns

Name Type References Description
Id [KEY] Integer Shipping Method Id.
Name String Shipping Method name.
Type String Shipping Method type.
Enabled Boolean Minimum subtotal of the free shipping.
HandlingFeesPercentageSurcharge Decimal Percentage surcharge of the handling fee.
HandlingFeesFixedSurcharge Decimal Fixed surcharge of the handling fee.
IsFallback Boolean Whether or not this shipping zone is the fallback if all others are not valid for the order.
Settings String Shipping method settings.
ZoneId Integer The Shipping Zone Id

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