ShippingMethods
Lists all shipping methods.
Table Specific Information
Select
The provider 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 provider.
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 |