ShippingZoneMethods
Retrieve and modify shipping zone methods.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns
support only the = comparison, unless stated otherwise. The available columns for this table are: InstanceId, ZoneId.
All other columns are processed client side. If the 'ZoneId' filter is not specified, the driver will fetch a list
of all the zones and perform a request for each zone in the list.
SELECT * FROM ShippingZoneMethods WHERE InstanceId = 4 AND ZoneId = 11
Insert
The following attributes are required when performing an insert: MethodId, ZoneId.
INSERT INTO ShippingZoneMethods (MethodId, ZoneId) VALUES ('flat_rate', 1)
Columns
| Name | Type | ReadOnly | References | Description |
| InstanceId [KEY] | Long | False |
Shipping method instance ID. | |
| Enabled | Boolean | False |
Shipping method enabled status. | |
| MethodDescription | String | False |
hipping method description. | |
| MethodId | String | False |
Shipping method ID. | |
| MethodTitle | String | False |
Shipping method title. | |
| Order | Integer | False |
Shipping method sort order. | |
| Title | String | False |
Shipping method customer facing title. | |
| SettingsTitleId | String | True |
A unique identifier for the setting. | |
| SettingsTitleLabel | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsTitleDescription | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsTitleType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsTitleValue | String | False |
Setting value. | |
| SettingsTitleDefault | String | True |
Default value for the setting. | |
| SettingsTitleTip | String | True |
Additional help text shown to the user about the setting. | |
| SettingsTitlePlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsTaxStatusId | String | True |
A unique identifier for the setting. | |
| SettingsTaxStatusLabel | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsTaxStatusDescription | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsTaxStatusType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsTaxStatusValue | String | False |
Setting value. | |
| SettingsTaxStatusDefault | String | True |
Default value for the setting. | |
| SettingsTaxStatusTip | String | True |
Additional help text shown to the user about the setting. | |
| SettingsTaxStatusPlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsTaxStatusOptions | String | True |
Options under Tax Status. | |
| SettingsCostId | String | True |
A unique identifier for the setting. | |
| SettingsCostLabel | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsCostDescription | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsCostType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsCostValue | String | False |
Setting value. | |
| SettingsCostDefault | String | True |
Default value for the setting. | |
| SettingsCostTip | String | True |
Additional help text shown to the user about the setting. | |
| SettingsCostPlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsTypeId | String | True |
A unique identifier for the setting. | |
| SettingsTypeLabel | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsTypeDescription | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsTypeType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsTypeValue | String | False |
Setting value. | |
| SettingsTypeDefault | String | True |
Default value for the setting. | |
| SettingsTypeTip | String | True |
Additional help text shown to the user about the setting. | |
| SettingsTypePlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsTypeOptions | String | True |
Setting Type Options. | |
| SettingsClassCostsId | String | True |
A unique identifier for the setting. | |
| SettingsClassCostsLabel | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostsDescription | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostsType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostsDefault | String | True |
Default value for the setting. | |
| SettingsClassCostsPlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostsTip | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostsValue | String | True |
Setting value. | |
| SettingsClassCostId29 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel29 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription29 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType29 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault29 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder29 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip29 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue29 | String | True |
Setting value. | |
| SettingsClassCostId30 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel30 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription30 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType30 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault30 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder30 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip30 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue30 | String | True |
Setting value. | |
| SettingsClassCostId31 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel31 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription31 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType31 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault31 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder31 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip31 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue31 | String | True |
Setting value. | |
| SettingsClassCostId32 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel32 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription32 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType32 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault32 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder32 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip32 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue32 | String | True |
Setting value. | |
| SettingsClassCostId33 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel33 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription33 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType33 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault33 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder33 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip33 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue33 | String | True |
Setting value. | |
| SettingsClassCostId34 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel34 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription34 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType34 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault34 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder34 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip34 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue34 | String | True |
Setting value. | |
| SettingsClassCostId54 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel54 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription54 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType54 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault54 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder54 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip54 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue54 | String | True |
Setting value. | |
| SettingsClassCostId55 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel55 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription55 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType55 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault55 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder55 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip55 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue55 | String | True |
Setting value. | |
| SettingsClassCostId56 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel56 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription56 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType56 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault56 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder56 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip56 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue56 | String | True |
Setting value. | |
| SettingsClassCostId57 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel57 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription57 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType57 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault57 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder57 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip57 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue57 | String | True |
Setting value. | |
| SettingsClassCostId58 | String | True |
A unique identifier for the setting. | |
| SettingsClassCostLabel58 | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsClassCostDescription58 | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsClassCostType58 | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsClassCostDefault58 | String | True |
Default value for the setting. | |
| SettingsClassCostPlaceholder58 | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsClassCostTip58 | String | True |
Additional help text shown to the user about the setting. | |
| SettingsClassCostValue58 | String | True |
Setting value. | |
| SettingsNoCostId | String | True |
A unique identifier for the setting. | |
| SettingsNoCostLabel | String | True |
A human readable label for the setting used in interfaces. | |
| SettingsNoCostDescription | String | True |
A human readable description for the setting used in interfaces. | |
| SettingsNoCostType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
| SettingsNoCostDefault | String | True |
Default value for the setting. | |
| SettingsNoCostPlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
| SettingsNoCostTip | String | True |
Additional help text shown to the user about the setting. | |
| SettingsNoCostValue | String | True |
Setting value. | |
| ZoneId [KEY] | Long | False |
Id of the shipping zone. |