JDBC Driver for WooCommerce

Build 24.0.9062

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.

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