Excel Add-In for BigCommerce

Build 23.0.8839


Lists all shipping methods.

Table Specific Information


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


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