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 add-in 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. |