JDBC Driver for WooCommerce

Build 24.0.9062

TaxRates

Retrieve and modify tax rates.

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: Id, Class. All other columns are processed client side.

SELECT * FROM TaxRates WHERE Id = 4

Insert

This table does not have any required attributes when performing an insert.

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique identifier for the resource.

Country String False

Country ISO 3166 code. See ISO 3166 Codes (Countries) for more details

State String False

State code.

Postcode String False

Postcode/ZIP.

City String False

City name.

Rate String False

Tax rate.

Name String False

Tax rate name.

Priority Integer False

Tax priority. Only 1 matching rate per priority will be used. To define multiple tax rates for a single area you need to specify a different priority per rate. Defaults to 1.

Compound Boolean False

Whether or not this is a compound rate. Compound tax rates are applied on top of other tax rates. Defaults to false.

Shipping Boolean False

Whether or not this tax rate also gets applied to shipping. Defaults to true.

Order Integer False

Indicates the order that will appear in queries.

Class String False

Tax class. Defaults to standard.

Postcodes String False

Postcodes/ZIP.

Cities String False

City names.

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