Returns Product Categories.

Table Specific Information

Select

The connector 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 comparisons.
• PageTitle supports the = and LIKE comparisons.
• IsVisible supports the = comparison.
• TreeId supports the =, IN, and NOT_IN comparisons.
• CategoryUUID supports the =, IN, and NOT_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 Categories WHERE Id = 18;
SELECT * FROM Categories WHERE Id IN (19,20);
SELECT * FROM Categories WHERE Id NOT IN (19,20);
SELECT * FROM Categories WHERE Name = "test";
SELECT * FROM Categories WHERE Name LIKE "%test%";

Insert

To insert a category, specify at least the following columns: ParentId, Name, TreeId and Description.

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

Update

UPDATE Categories SET Description= 'Testing123' WHERE Id = 18

Delete

DELETE FROM Categories WHERE Id = 18

Columns