PaymentGateways
Retrieve and modify payment gateways.
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 column for this
table is: Id. All other columns are processed client side.
SELECT * FROM PaymentGateways WHERE Id = 'id'
Update
The following attribute is required when performing an update: Id.
UPDATE PaymentGateways SET Title='Credit card / debit card', Description='Enter your card details' WHERE Id = 'woocommerce_payments'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Payment gateway ID. | |
Title | String | False |
Payment gateway title on checkout. | |
Description | String | False |
Payment gateway description on checkout. | |
Order | Integer | False |
Payment gateway sort order. | |
Enabled | Boolean | False |
Payment gateway enabled status. | |
MethodTitle | String | True |
Payment gateway method title. | |
MethodDescription | String | True |
Payment gateway method description. | |
MethodSupportsAggregate | String | True |
Supported features for this payment gateway. | |
SettingsTitleId | String | True |
A unique identifier for the setting. | |
SettingsTitleDefault | String | True |
Default value for the setting. | |
SettingsTitleDescription | String | True |
A human readable description for the setting used in interfaces. | |
SettingsTitleLabel | String | True |
A human readable label for the setting used in interfaces. | |
SettingsTitlePlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
SettingsTitleTip | String | True |
Additional help text shown to the user about the setting. | |
SettingsTitleType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
SettingsTitleValue | String | True |
Setting value. | |
SettingsInstructionsId | String | True |
Id value for the setting. | |
SettingsInstructionsDefault | String | True |
Default value for the setting. | |
SettingsInstructionsDescription | String | True |
A human readable description for the setting used in interfaces. | |
SettingsInstructionsLabel | String | True |
A human readable label for the setting used in interfaces. | |
SettingsInstructionsPlaceholder | String | True |
Placeholder text to be displayed in text inputs. | |
SettingsInstructionsTip | String | True |
Additional help text shown to the user about the setting. | |
SettingsInstructionsType | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. | |
SettingsInstructionsValue | String | True |
Setting value. |