Inventory
Inventory is an auto generated table. The supported operations are Update, and Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by ProductSku while the rest of the filter is executed client side within the add-in.
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 |