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 本製品 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. |