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. Following columns are supported server side, all other columns are processed client side.

Id supports the '= ' operator.
Class supports the '=' operator.
Priority supports the 'ORDER BY' operator.
Orders supports the 'ORDER BY' operator.

SELECT * FROM TaxRates WHERE Id = 4
SELECT * FROM TaxRates order by Priority
SELECT * FROM TaxRates order By Orders

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

CData Python Connector for WooCommerce

TaxRates

Table Specific Information

Select

Insert

Columns