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. |