ODBC Driver for WooCommerce

Build 20.0.7587

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 Description
InstanceId [KEY] Integer 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 Integer True

Id of the shipping zone.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587