TaxClasses
Returns tax classes, including name and date details.
Table-Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the Id column, which supports the = operator.
The rest of the filter is executed client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM TaxClasses WHERE Id = 1
Insert
To insert a tax class, specify at least the following column: Name.
INSERT INTO TaxClasses (Name) VALUES ('sample name')
Update
The following is an example of how to update the TaxClasses table:
UPDATE TaxClasses SET Name = 'updated demo tax new' WHERE Id = 5
Delete
The following are examples of how to delete from the TaxClasses table:
DELETE FROM TaxClasses WHERE Id = 19
DELETE FROM TaxClasses WHERE Id IN (20, 21)
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The unique identifier of the tax class. |
| Name | String | False |
The name of the tax class. |
| DateCreated | Datetime | True |
The date when the tax class was created. |
| DateModified | Datetime | True |
The date when the tax class was last modified. |