Products

Products is an auto generated table

Select

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 driver will use the Magento API to filter the results with these operators while the rest of the filter is executed client side within the provider. You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that invokes other operators will cause an error.

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

  • Retrieve all products from your Magento server:\

  • Retrieve a single product:\

  • Filter by status:\

  • Filter by created date:\

  • Example query with multiple filters:\

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

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

Update

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

Delete

Products can be deleted by providing the Sku column.\

Columns

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.

Last updated