JDBC Driver for WooCommerce

Build 24.0.9062

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

ShippingZones.Id

Id of the shipping zone.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062