Excel Add-In for WooCommerce

Build 23.0.8839


Retrieve and modify tax rates.

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



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


Name Type ReadOnly 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


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


Cities String False

City names.

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