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 adapter 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 | 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. |
| 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. |
| ZoneId | Long | True |
Id of the shipping zone. |