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. | |
| SettingsIsDismissedId | String | True |
Id of the Settings dismissed object. | |
| SettingsIsDismissedLabel | String | True |
Label of the Settings dismissed object. | |
| SettingsIsDismissedDescription | String | True |
Description of the Settings dismissed object. | |
| SettingsIsDismissedType | String | True |
Type of the Settings dismissed object. | |
| SettingsIsDismissedValue | String | True |
Value of the Settings dismissed object. | |
| SettingsIsDismissedDefault | String | True |
Default value of the Settings dismissed object. | |
| SettingsIsDismissedTip | String | True |
UI tip of the Settings dismissed object. | |
| SettingsIsDismissedPlaceholder | String | True |
Placeholder of the Settings dismissed object. | |
| SettingsEnableForMethodsId | String | True |
Id of the Settings enable for methods | |
| SettingsEnableForMethodsLabel | String | True |
Label of the Settings enable for methods | |
| SettingsEnableForMethodsDescription | String | True |
Description of the Settings enable for methods | |
| SettingsEnableForMethodsType | String | True |
Type of the Settings enable for methods | |
| SettingsEnableForMethodsValue | String | True |
Value of the Settings enable for methods | |
| SettingsEnableForMethodsDefault | String | True |
Default value of the Settings enable for methods | |
| SettingsEnableForMethodsTip | String | True |
UI tip of the Settings enable for methods | |
| SettingsEnableForMethodsPlaceholder | String | True |
Placeholder of the Settings enable for methods | |
| SettingsEnableForMethodsOptionsAggregate | String | True |
Options of the Settings enable for methods | |
| SettingsEnableForVirtualId | String | True |
Id of the Settings enable for virtual object | |
| SettingsEnableForVirtualLabel | String | True |
Label of the Settings enable for virtual object | |
| SettingsEnableForVirtualDescription | String | True |
Description of the Settings enable for virtual object | |
| SettingsEnableForVirtualType | String | True |
Type of the Settings enable for virtual object | |
| SettingsEnableForVirtualValue | String | True |
Value of the Settings enable for virtual object | |
| SettingsEnableForVirtualDefault | String | True |
Default value of the Settings enable for virtual object | |
| SettingsEnableForVirtualTip | String | True |
UI tip of the Settings enable for virtual object | |
| SettingsEnableForVirtualPlaceholder | String | True |
Placeholder of the Settings enable for virtual object |