Excel Add-In for WooCommerce

Build 23.0.8839


View and manage settings options.

Table Specific Information


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: Id, SettingId. All other columns are processed client side. If the 'SettingId' filter is not specified, the add-in will fetch a list of all the settings and perform a request for each setting in the list.

SELECT * FROM SettingOptions WHERE Id = 'woocommerce_excluded_report_order_statuses'


Name Type ReadOnly Description
Id [KEY] String True

A unique identifier for the setting.

Label String True

A human readable label for the setting used in interfaces.

Description String True

A human readable description for the setting used in interfaces.

Value String False

Setting value.

Default String True

Default value for the setting.

Tip String True

Additional help text shown to the user about the setting.

Placeholder String True

Placeholder text to be displayed in text inputs.

Type String True

Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox.

GroupId String True

An identifier for the group this setting belongs to.

SettingId String True

Id of the setting group.

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