Inventory
Inventory is an auto generated table. The supported operations are Update, and Querying data from this table.
Table Specific Information
Select
The driver uses the AdobeCommerce API to filter the results by ProductSku while the rest of the filter is executed client side within the driver.
You must specify the ProductSKU column in the WHERE clause to retrieve results from Inventory.
For example:
SELECT * FROM Inventory WHERE ProductSKU = 'sjl-8082'
Update
To update a product inventory, set the ItemId of an existing item and the ProductSKU.
UPDATE [Inventory] SET Qty = '87' WHERE ProductSKU = 'sjl-8082' AND ItemId = '1'
Columns
| Name | Type | ReadOnly | Description |
| Items | String | False |
Items |
| ProductSku [KEY] | String | False |
This is an auto generated column. |
| 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 [KEY] | Int | False |
This is an auto-generated column |
| LowStockDate | String | False |
This is an auto-generated column |
| ManageStock | Bool | False |
Can Manage Stock |
| MaxSaleQty | Double | False |
Maximum Qty Allowed in Shopping Cart data wrapper |
| MinQty | Double | False |
Minimal quantity available for item status in stock |
| MinSaleQty | Double | False |
Minimum Qty Allowed in Shopping Cart or NULL when there is no limitation |
| NotifyStockQty | Double | False |
Notify for Quantity Below data wrapper |
| ProductId | Int | False |
This is an auto-generated column |
| Qty | Double | False |
This is an auto-generated column |
| QtyIncrements | Double | 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 |