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

Table Specific Information

Select

The driver uses the AdobeCommerce API to filter the results with these operators while the rest of the filter is executed client side within the provider. Client-side execution can be turned off by setting SupportEnhancedSQL to false in which case any search criteria that invokes other operators will cause an error.

Custom Attributes will be dynamically retrieved as columns when querying this table. The Products table supports server-side processing for all columns in the WHERE clause. Most of these columns support server-side processing for the >, >=, <, <=, =, IN, NOT IN and LIKE operators.

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

• Retrieve all products from your AdobeCommerce server:
  

  SELECT * FROM Products

• Retrieve a single product:
  

  SELECT * FROM Products WHERE Sku = 'sjl-8082'

• Filter by status:
  

  SELECT * FROM Products WHERE Status = 1

• Filter by created date:
  

  SELECT * FROM Products WHERE CreatedAt > '2017-08-01'

• Example query with multiple filters:
  

  SELECT * FROM Products WHERE Id IN (250, 260) AND Name LIKE '%d%' AND Visibility = 4 LIMIT 50

INSERT

To create a new product, Name, AttributeSetId, and Sku are required.

INSERT INTO Products (Sku, AttributeSetId, Name) VALUES ('sjl-1999', '4', 'insert prod')

Update

To update a product, you must set the Sku and Price columns.

UPDATE Products SET Price = '88', CustomAttribute1 = 'ValidValue' WHERE Sku = 'sjl-1999'

Delete

Products can be deleted by providing the Sku column.

DELETE FROM Products WHERE Sku = 'sjl-1999'

Columns