Inventory
Inventory is an auto generated table. The supported operations are Update, and Querying data from this table.
Table Specific Information
Select
The 本製品 will use the AdobeCommerce API to filter the results by ProductSku while the rest of the filter is executed client side within the 本製品.
The ProductSKU column must be specified in the WHERE clause to retrieve results from Inventory.
For example:
SELECT * FROM Inventory WHERE ProductSKU = 'sjl-8082'
Update
To update a product inventory, the ItemId of an existing item must be set along with 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 |