TaxProperties

Returns a list of Tax Properties.

Table Specific Information

The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side within the driver.

For example, the following queries are processed server-side:

SELECT * FROM TaxProperties WHERE Id = 1

SELECT * FROM TaxProperties WHERE Type = 'PRODUCT'

To insert a tax property, specify the Code, DisplayName, and Type columns.

INSERT INTO TaxProperties (Code, DisplayName, Type) VALUES ('material_code', 'Material Code', 'PRODUCT')

The Type column cannot be changed after a tax property is created.

UPDATE TaxProperties SET DisplayName = 'Updated Name' WHERE Id = 3

DELETE FROM TaxProperties WHERE Id = 3

DELETE FROM TaxProperties WHERE Id IN (3,4)


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Internal identifier for the tax property.
Code	String	False	The unique string a tax provider uses to programmatically reference this tax property.
DisplayName	String	False	The human-readable name for this property, displayed on the Products screen.
Description	String	False	Additional guidance displayed as a tooltip on the Products screen.
Type	String	False	The type of entity this property applies to. Allowed Values: Product and Customer
CreatedAt	Datetime	True	Date and time the tax property was created.
UpdatedAt	Datetime	True	Date and time the tax property was last updated.