ProductCategories

ProductCategories is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table.

Table Specific Information

The add-in uses the AdobeCommerce API to filter the results by Id while the rest of the filter is executed client side within the add-in.

The Id column can be used to filter data within this table. The Id can be used only with the equals (=) operator.

The following examples show the types of queries processed server side.

Retrieve all product categories:
```
SELECT * FROM ProductCategories
```
Retrieve detailed information about a single product category:
```
SELECT * FROM ProductCategories WHERE Id = 1
```

The Name and IsActive columns are required to create a new category.

INSERT INTO ProductCategories (Name, IsActive, Position) VALUES ('New category', '1', '0')

To update a category, you must set the Id column.

UPDATE ProductCategories SET Name = 'New category', IsActive = 1 WHERE Id = 1

Product categories can be deleted by providing the Id column.

DELETE FROM ProductCategories WHERE Id = 1


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	This is an auto-generated column
CategoryId	String	False	categoryId
AvailableSortBy	String	False	This is an auto-generated column
Children	String	False	This is an auto-generated column
CreatedAt	Datetime	False	This is an auto-generated column
ExtensionAttributes	String	False	This is an auto-generated column
IncludeInMenu	Bool	False	This is an auto-generated column
IsActive	Bool	False	Whether category is active
Level	Int	False	Category level
Name	String	False	Category name
ParentId	Int	False	Parent category ID
Path	String	False	This is an auto-generated column
Position	Int	False	Category position
UpdatedAt	Datetime	False	This is an auto-generated column
ProductCount	Int	False	Product count