Returns Product Categories.

Table Specific Information

Select

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

• Id supports the '=,<=,>=,<,>,IN, and NOT_IN' comparisons.
• ParentId supports the '=,<=,>=,<,>,IN, and NOT_IN' comparisons.
• Name supports the '= and LIKE' comparison.
• PageTitle supports the '= and LIKE' comparison.
• IsVisible supports the '=' comparison.

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

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

SELECT * FROM Categories WHERE Id = 18 

SELECT * FROM Categories WHERE Id >= 18 AND Id <= 25

SELECT * FROM Categories WHERE Name = "test"

Insert

To insert a new Categories, you need to specify at least the following columns: ParentId,Name, and Description.

INSERT INTO Categories (ParentId,Name,Description) VALUES (27,'Car Interior121', 'Accessories for testing car.')

Update

UPDATE Categories SET Description='Testing123' where id=18

Delete

DELETE FROM Categories WHERE Id = 18

Columns