Inventory
Inventory is an auto generated table
Select
You must specify the product SKU to query this table. The driver will use the Magento API to filter the results by ProductSku_p while the rest of the filter is executed client side within the driver.
For example, the following query is the only one supported server side:\
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.
Update
To update a product inventory, you must set the ItemId of an existing item along with the ProductSKU.\
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