ProductCategories

ProductCategories is an auto generated table

Select

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

The driver will use the Magento API to filter the results by CategoryId_p while the rest of the filter is executed client side within the driver.

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

You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to any other columns will cause an error.

Insert

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

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

Update

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

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

Delete

Product categories can be deleted by providing the Id column.\

DELETE FROM ProductCategories WHERE Id = 1

Columns

Name

Type

ReadOnly

Description

Id [KEY]

Int

False

This is an auto-generated column

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

ChildrenData

String

False

This is an auto-generated column

ProductCount

Int

False

Product count

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

CategoryId_p

Int

This is an auto-generated column

Id_p

String

This is an auto-generated column

Last updated