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 |