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:\

SELECT * FROM Inventory WHERE ProductSKU = 'sjl-8082'

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.\

UPDATE [Inventory] SET Qty = '87' WHERE ProductSKU = 'sjl-8082' AND ItemId = '1'

Columns

Name	Type	ReadOnly	Description
SearchCriteria	String	False	This is an auto-generated column
TotalCount	Int	False	Total count.
Backorders	Int	False	Backorders status
EnableQtyIncrements	Bool	False	Whether Quantity Increments is enabled
ExtensionAttributes	String	False	This is an auto-generated column
IsDecimalDivided	Bool	False	This is an auto-generated column
IsInStock	Bool	False	Stock Availability
IsQtyDecimal	Bool	False	This is an auto-generated column
ItemId	Int	False	This is an auto-generated column
LowStockDate	String	False	This is an auto-generated column
ManageStock	Bool	False	Can Manage Stock
MaxSaleQty	String	False	Maximum Qty Allowed in Shopping Cart data wrapper
MinQty	String	False	Minimal quantity available for item status in stock
MinSaleQty	String	False	Minimum Qty Allowed in Shopping Cart or NULL when there is no limitation
NotifyStockQty	String	False	Notify for Quantity Below data wrapper
ProductId	Int	False	This is an auto-generated column
Qty	String	False	This is an auto-generated column
QtyIncrements	String	False	Quantity Increments data wrapper
ShowDefaultNotificationMessage	Bool	False	This is an auto-generated column
StockId	Int	False	Stock identifier
StockStatusChangedAuto	Int	False	This is an auto-generated column
UseConfigBackorders	Bool	False	This is an auto-generated column
UseConfigEnableQtyInc	Bool	False	This is an auto-generated column
UseConfigManageStock	Bool	False	This is an auto-generated column
UseConfigMaxSaleQty	Bool	False	This is an auto-generated column
UseConfigMinQty	Bool	False	This is an auto-generated column
UseConfigMinSaleQty	Int	False	This is an auto-generated column
UseConfigNotifyStockQty	Bool	False	This is an auto-generated column
UseConfigQtyIncrements	Bool	False	This is an auto-generated column
StockItem	String	False	This is an auto-generated column
StockStatus	Int	False	This is an auto-generated column

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
ItemId_p	String	This is an auto-generated column
ProductSku_p	String	This is an auto-generated column