Skip to content

Stock Inquiry ​


Table of Contents ​


1. Scenarios ​

Quick links: Confirm shippable quantity before stocking up | Ship near-expiry batches first | Trace allocations when chasing an order

Scenario 1: Confirm a product really has stock to ship before a promotion ​

Situation: A merchant tells you there is a campaign this weekend and a few hot items will get heavy orders. Before it starts, you want to confirm how much the warehouse can actually ship, so it does not run out the moment the campaign opens.

Use this feature: In the list columns, check the product's Available Quantity — the Quantity (the put-away quantity, excluding pending putaway) minus the quantity locked by other orders and the held quantity. It is the amount truly available to ship.

Result: You know exactly how much each item can ship. If the figure is low, you can ask for replenishment or have the merchant throttle orders early, instead of discovering mid-campaign that stock exists on paper but cannot actually ship.


Scenario 2: Clear out a near-expiry batch so it gets picked first ​

Situation: During the morning aisle walk you notice a food batch is close to expiry. The same product has several intake batches in the warehouse, so you first need to confirm how much of this batch is left and where it is, before arranging to clear it first.

Use this feature: Different batches of the same product are separate inventory records here — distinguished by Batch, Expiration Date, and Manufacturing Date. Use Search and filter to narrow to that product and find the near-expiry batch by Expiration Date range. When allocating shipments the system already ships the earliest-expiring stock first; here you can confirm that is happening.

Result: You know the quantity and location of the near-expiry batch and can proactively clear it or report it, reducing write-off losses.


Scenario 3: Customer service reports an order stuck unshipped — trace who is holding the stock ​

Situation: A merchant forwards a complaint that an order placed long ago still has not shipped. You suspect this product's stock is locked up by a pile of orders and want to confirm how much is "locked" and by which orders.

Use this feature: In the list columns, check the product's Allocated Quantity — the amount reserved by orders but not yet shipped. As an operator, clicking that figure takes you to Orders locking this inventory, where you can review which orders are holding the stock, one by one.

Result: You can see clearly which orders are locking this inventory and how much each holds, judge whether it is awaiting replenishment or a stuck order that needs handling, and give customer service a clear answer.


2. Features ​

The inventory list is your real-time view of "what stock exists right now, and how much of each can ship." The system splits the same product into separate inventory records by intake batch, expiration date, manufacturing date, inventory type, and custom attributes, each showing quantity and available quantity in real time. Stocking up, replenishment, expiry management, and tracing shipment allocations all start here. This list shows only the stock in the warehouse you belong to (this warehouse); when your organization has several warehouses, switch to Warehouse Overview to see each product's quantity in every warehouse.

Inventory List - Page Overview

Quick jump: Search and filter | List columns | View and handle a single record | Batch actions | Warehouse Details and Warehouse Overview

The top search box accepts multiple keywords at once and matches Product SKU, Product Name, Batch, and inventory custom attributes. For more precise conditions, use the filters below:

By default the list shows only in-stock records (still holding stock); depleted inventory does not appear.

FilterHow to use
Merchant NameWith multiple merchants, choose the merchant to view; single-merchant accounts do not see this filter
Expiration DatePick a date range to find batches whose expiry falls within it (e.g. "expiring by month-end")
Manufacturing DatePick a date range to filter by manufacturing date
Pending putaway onlyChoose "Yes" to list only inventory that still has stock sitting in a receipt's staging location awaiting putaway — use it to sweep up stock forgotten in staging; choose "No" to list only inventory with nothing pending putaway. Only dynamic-location warehouses have pending putaway stock; virtual and dedicated-location warehouses put stock away at acceptance, so "Yes" returns an empty list there
Staging Receipt NumberEnter receipt numbers (one per line) to list only inventory that still has stock in that receipt's staging location; once the receipt is fully put away it no longer matches

For the rest (Product SKU, Product Name, Inventory Type, Batch), just type or select by name.

2.2 List columns ​

An inventory record's identity is defined by five attributes together: Inventory Type, Batch, Expiration Date, Manufacturing Date, and Inventory Custom Attributes. If any one of these five differs, it is a different inventory record, counted separately.

ColumnWhat it means
Inbound SourceThe source inbound and acceptance date of this batch; click the inbound to trace its origin
Inventory Custom AttributesExtra product attributes (e.g. color, size) used to distinguish variants of the same SKU
QuantityThe put-away quantity of this batch: stock on formal shelves plus stock already picked onto picking carts or totes but not yet shipped, including locked, held, and available portions; excludes pending putaway
Available QuantityThe amount truly available to ship = Quantity − locked − held
Pending PutawayQuantity accepted but still sitting at staging areas such as the inspection table, not yet put away to formal shelves; not part of Quantity and not counted as available
Staging LocationWhich receipts' staging locations the pending-putaway stock is sitting in (the staging location code is the receipt number) and how much in each; the small text below is that receipt's latest acceptance time, with the longest-waiting listed first. Clicking a receipt number opens its putaway if the receipt is closed; a receipt still being accepted cannot be put away yet, so its inbound opens instead. Stock in other staging locations (a staging area without a receipt, or another merchant's receipt staging location it was moved into) is listed last as "location code × quantity", not clickable and without the other merchant's receipt details; the quantities add up to Pending Putaway. Only dynamic-location warehouses have values; other rows show "-"
Allocated QuantityQuantity reserved by orders but not yet shipped; deducted after shipping (operators can click the figure to see the orders holding it)
Held QuantityQuantity held by an inventory hold; excluded from shipment allocation
StatusIn Stock = has available stock; Out of Stock = quantity is zero; Blocked = the whole batch is suspended

Multi-merchant accounts also have a Merchant Name column; the remaining columns (product name, SKU, batch, expiry, manufacturing date) are self-explanatory by name.

2.3 View and handle a single record ​

Click a product name in the list to open that inventory record's detail page (the link icon beside the name opens the product in a new tab instead). The detail page shows the record's five identity attributes, its quantities, and which shelves it sits on and how much on each; stock still in staging awaiting putaway, or already on picking carts or totes, is marked next to the shelf.

The top right of the page offers quick actions on this record. They require inventory edit permission; accounts without it do not see them:

ActionPurpose
HoldHold part of this record's quantity; once held it is excluded from shipment allocation (shown only when available quantity is greater than zero)
Quick Stock AdjustmentEnter this record's actual quantity at each shelf; submitting creates a pending stock adjustment right away, without picking the record on the adjustment page. Stock only changes after it is approved
Quick Inventory TransformationConvert this record to another inventory type (e.g. good stock to defective), without opening a separate inventory transformation

2.4 Batch actions ​

After selecting multiple records, you can act on them at once:

ActionDescription
Batch HoldHold multiple records at once, creating the matching inventory hold records; requires the inventory edit permission, and accounts without it do not see it
ExportExport the selected inventory to a file; check and download the result in "Import/Export Records"
Export Shelf InfoExport a list of which shelves the selected inventory sits on and how much is on each; see below

Both export buttons require the inventory export permission; accounts without it do not see them.

When exporting without a template, the last column of the export file is "Total Volume" = Quantity × the product's unit volume. The unit follows the Volume Unit setting and only one such column appears; the header states whether it is "CBM", "Sai", or "ft³":

  • Blank: the product has neither length/width/height nor carton dimensions to derive from, so its volume cannot be measured — it is not 0. Fill in the product dimensions and export again
  • When only carton dimensions are filled in: a product with no unit dimensions but with carton dimensions and "Items Per Large Unit (Box Quantity)" is derived as carton volume ÷ units per carton, for CBM, Sai, and ft³ alike
  • When exporting with Export Templates: a template can pick "Total Volume (CBM)", "Total Volume (Sai)", or "Total Volume (ft³)", and always outputs the unit you picked — changing Volume Unit later does not affect existing templates. Existing templates do not gain this column automatically; add it to the template for it to appear

Export shelf info ​

Use this export when you need to know "which shelves these products are on and how much is on each" before a stock count, replenishment, or a stock search. Paste several SKUs into the Product SKU filter at once, select all, then click Export Shelf Info:

  • One row = one inventory record's quantity on one shelf: a record spread over five shelves gives five rows, each with its own shelf location, row / column / layer / grid, zone, temperature, shelf type, and quantity, plus merchant, warehouse, SKU, product name, brand, barcode, items per large unit, items per mid unit, inventory type, batch, expiry, manufacturing date, inventory custom attributes, and inventory status
  • The shelf quantity is split into large units, mid units, and loose units: whole large units come first, the remainder is split into whole mid units, and what is left counts as loose, so the three add back up to the shelf quantity (for example, 30 of a product with 24 per large unit and 5 per mid unit → 1, 1, 1). When a product has no items-per-large-unit or items-per-mid-unit set, the matching column is left blank
  • Only formal shelves with a quantity above 0 are listed: stock still waiting for putaway at staging areas such as the inspection table, and stock already on picking carts or totes, is left out
  • Export templates are available: if you have created Export Templates of the "Inventory Shelf Info" type, you pick a template after clicking the button
  • When there is nothing to export: if no inventory is selected, or none of the selected inventory has stock on a formal shelf (for example, all out of stock), you see "No records to export" and no empty file is produced
  • The file has no Allocated Quantity: the locked quantity belongs to the whole inventory record, so repeating it on every shelf would double-count it; check it in this list instead

2.5 Warehouse Details and Warehouse Overview ​

When your organization has two or more warehouses, a "Warehouse Details | Warehouse Overview" switch appears at the top of the page; it is hidden with a single warehouse.

  • Warehouse Details: this page — it lists only this warehouse's batches and shelves, with the filters, columns and batch actions described above.
  • Warehouse Overview: a cross table with one row per product and one column per warehouse, showing only each warehouse's available quantity; see Warehouse Overview.
  • Keywords follow the switch: if you apply search keywords in Warehouse Details and switch to Warehouse Overview, the same keywords are carried over and applied, and vice versa. After you apply keywords, a "Need to check other warehouses?" hint appears above the table; its link opens the other warehouses with the same keywords.

3. FAQ ​

Quick jump: FAQ | Notes

3.1 FAQ ​

▪ Why do Quantity and Available Quantity differ? ​

Quantity is the put-away quantity of the batch (excluding pending putaway); Available Quantity is what is truly shippable after further subtracting locked and held quantities. To judge "can I ship right now," look at Available Quantity; a large total but zero available means the stock is all reserved or held.

▪ Why does the same product appear several times? ​

Whenever any of the five identity attributes (inventory type, batch, expiry, manufacturing date, custom attributes) differs, it is a separate inventory record counted separately. Different intake batches and expiry dates of the same product are each independent, which supports first-in-first-out and batch tracing.

▪ Why is there stock but the locked quantity is high and available is zero? ​

It means most of this batch is reserved by orders (Allocated Quantity) but not yet shipped. As an operator, click that figure to view the orders holding it and confirm whether they are awaiting normal shipment or a stuck order needs handling.

▪ Why isn't accepted stock counted as available yet? ​

Quantity that is accepted but still sitting at a staging area such as the inspection table, not yet put away to a formal shelf, counts as Pending Putaway and is not available. It moves into available quantity only after putaway is completed. To find all stock not yet put away at once, filter by "Pending putaway only", then use Staging Location to see which receipts the stock is stuck in and click through to handle it.

▪ This warehouse is out of stock — how do I know whether other warehouses have it? ​

When your organization has several warehouses, switch to "Warehouse Overview" to see each warehouse's available quantity; for a single product, check By Warehouse on the product page. Warehouse Details itself never lists other warehouses' batches.

▪ I can't find an inventory record in the list? ​

By default the list shows only in-stock inventory; depleted records (quantity reduced to zero) do not appear. If you are sure there is stock but cannot find it, first check whether the filters above (merchant, inventory type, expiry range) have narrowed the scope.

▪ Why doesn't the sum of the shelf info export rows match Quantity in the list? ​

The export only lists stock on formal shelves. Quantity in the list also includes stock already picked onto picking carts but not yet shipped, while stock waiting for putaway is shown separately under Pending Putaway. The two match only when the record has no pending putaway and nothing in the middle of picking.

▪ How do I hold part of the stock so it does not ship? ​

Click the product name to open the record's detail page and click Hold (or select multiple in the list and use Batch Hold). The held amount counts as Held Quantity and is excluded from shipment allocation. See Inventory Holds.


▪ Why can't I submit a larger actual quantity with Quick Stock Adjustment for a deleted product? ​

Deleted products can only be adjusted down, not up: if you enter an actual quantity larger than the system quantity, submitting is blocked with the deleted SKU listed, no adjustment is created, and the stock stays the same. Decreases (including down to 0) still go through, so you can clear the stock left after deletion. To add stock, create a new product with the same SKU first and receive or adjust it under the new product.


3.2 Notes ​

⚠️ Important Reminders ​

  • Quick Stock Adjustment only creates a pending stock adjustment; stock changes after the adjustment is approved. Confirm the count result is correct before submitting.
  • Quick Inventory Transformation moves stock from one inventory type to another (e.g. good to defective); after the conversion the batch's available and allocated calculations change accordingly.

💡 Tip: To judge "can I take and ship orders right now," always look at Available Quantity, not Quantity; Quantity includes the reserved and held portions.


FeatureDescriptionLink
Documents Locking InventorySee which orders, work orders or transfer orders are locking a given inventory record and how much each holdsGo
Stock AdjustmentAdjust inventory quantity in bulk and leave an adjustment recordGo
Inventory TransformationConvert inventory from one type to anotherGo
Inventory HoldHold part of the inventory so it is excluded from shipment allocationGo
Inventory MovementsView the history of every increase and decrease per inventory recordGo
Warehouse OverviewSee every product's available quantity in each warehouse on one pageGo

Last updated 2026-11-16 19:57