ProductTaxProperties
Retrieves and manages tax properties associated with products.
Table Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- ProductId supports the = and IN comparisons.
The rest of the filter is executed client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM ProductTaxProperties WHERE ProductId = 157
SELECT * FROM ProductTaxProperties WHERE ProductId IN (157,158)
Insert
ProductTaxProperties only supports an upsert-style write: inserting a product that does not yet have tax properties creates the association, while inserting a product that already has tax properties updates it. TaxProperties must be a JSON-formatted object of key-value pairs.
INSERT INTO ProductTaxProperties (ProductId, TaxProperties) VALUES (157, '{"A-123456789":"26","B-6731789":"200"}')
Delete
DELETE FROM ProductTaxProperties WHERE ProductId = 157
DELETE FROM ProductTaxProperties WHERE ProductId IN (157,158)
Columns
| Name | Type | ReadOnly | Description |
| ProductId [KEY] | Integer | False |
The Id of the product. |
| TaxProperties | String | False |
A JSON-formatted object of key-value tax property pairs to associate with the product. These values are sent to the active tax provider during tax calculation. |