Inventory levels
See stock for every tracked variant at every location, filter for low or empty shelves, choose columns, understand min stock, max stock, reorder points and bin locations, and export the list to CSV.
The Inventory levels page shows how much stock you hold of every product variant at every location, using the quantities Shopify reports. Use it to find low or empty shelves, choose the columns you see, and download the list as a spreadsheet. To change a quantity, use a stock adjustment, a transfer or a stocktake; receiving a purchase order also adds stock.
Open the page
- In the top bar, open Inventory and choose Inventory levels. The page is headed Inventory.
- Each row is one variant at one location. The list shows 50 rows at a time; use Previous, Next or a page number to move through it.
Only variants whose inventory Shopify tracks are listed. If the list is empty, run your first sync: on the dashboard (click StockWay at the left of the top bar), open the New menu and choose Sync from Shopify.
What the columns mean
| Column | What it shows |
|---|---|
| Product | The product title. Always shown. Click it to open the product page. |
| Variant | The variant title. Click it to open the variant page. |
| SKU, Barcode, Vendor | As set in Shopify. Click the SKU to open the product page. |
| Location | Where the stock is held. |
| Bin | The bin or shelf location, if you have imported one. |
| Available | Units Shopify can still sell. |
| On hand | Units physically at the location, including committed ones. |
| Committed | Units reserved for orders that are not fulfilled yet. |
| Incoming | Units Shopify shows as on their way to this location. Stock on a transfer or a placed purchase order appears here only when StockWay has Shopify's inventory transfer permissions (see Transfers). |
| Min | The variant's minimum stock at this location, if one is set. |
Choose your columns
- Click Columns.
- In Select columns, tick the columns you want: Variant, SKU, Barcode, Vendor, Location, Bin location, Available, On hand, Committed, Incoming and Min stock.
- Click Update.
The choice is saved for your store, so everyone who opens the page sees the same columns. Until someone changes it, the page shows Variant, SKU, Location, Available, On hand, Committed and Incoming.
Search, filter and sort
- Search SKU, barcode, or title finds rows by SKU, barcode, variant title or product title. Results update as you type.
- The location list shows All locations, or narrows the page to one active location.
- Low stock only shows rows that are low (see below). Out of stock only shows rows with Available at 0 or below.
- Click a column heading to sort by it, and click it again to reverse the order. Product, Variant, SKU, Location and the four quantity columns can be sorted. The page opens sorted by Available, lowest first, so shortages come to the top.
How low stock is decided
A row is low when its Available quantity is at or below its Min stock. If no Min stock is set for that variant at that location, the Low stock threshold is used instead (account menu, Preferences, Inventory card; it is 5 unless you change it). Low rows show the Available figure highlighted.
The same rule decides the low stock notifications under the bell. The dashboard's Low stock card uses the Low stock threshold alone.
The low stock reports (Reports > Low Stock) use their own rule, built on the rate of sales and the lead time rather than Min stock: out of stock, or due to run out sooner than the lead time. They can therefore disagree with this page. The SKU/Variants low stock report opens on Show all, which lists every variant; set Slow sellers to Exclude slow sellers to see only those running out.
Min stock, max stock and reorder points
Min stock and Max stock are StockWay's own numbers for each variant at each location. Shopify has no such fields, so setting them never changes your stock. Set them on a location page, or for many variants at once with the Minimum Stock and Maximum Stock imports (see Products and variants).
- Min stock decides low stock as described above. The purchase planner also treats it as a floor: when stock plus what is already on order is below it, the planner suggests enough to bring it back up.
- Max stock is saved and shown on the location page, but StockWay does not use it in any calculation yet.
The reorder point is the stock level at which you need to reorder. It appears as ROP on the Low stock report. StockWay works it out for each variant at each location: average units sold per day, multiplied by the lead time in days, rounded up. The lead time comes from the most specific setting available: a lead time set for that product on its vendor's Lead Times page or a supplier's Lead & restock times page, then its supplier's lead time, then its vendor's, then Default supplier lead time (days) in Preferences.
For now StockWay can read only the last 60 days of your orders from Shopify. Sales rates, and so reorder points, are measured over 60 days at most, even if you choose a longer period.
To set your own reorder points, use the Reorder Points import. An imported value replaces the calculated one for that variant at that location, and the purchase planner uses it as a floor in the same way as Min stock. Importing a blank value later hands the variant back to the automatic calculation.
Bin locations
A bin location records where a variant sits inside a location, for example A-12-3. Each location can have its own. You set bin locations with the Bin/shelf Locations import; there is no box to type one on screen. They appear in the Bin column here (turn it on under Columns), on the location page and in the Locations card of the variant page.
Export the list
- Set the search, location, filters and sort you want.
- Click Export CSV.
The file, named inventory- followed by today's date, contains every matching row in the same order, not just the page on screen. It has every column except Bin, whether or not it is on screen, plus a Low stock column (Yes for low rows). Numbers have no thousands separators, so they add up in a spreadsheet. An export stops at 50,000 rows; if there are more, the last line of the file says so, and you can narrow the list by location or search to export the rest.
How up to date the numbers are
- Changes you make in StockWay are written to Shopify first and show here straight away. Changes made in Shopify, such as sales, arrive shortly after Shopify reports them.
- StockWay also refreshes locations and stock quantities from Shopify automatically, about once an hour.
- For a full refresh at any time, choose Sync from Shopify in the dashboard's New menu or on the Locations page.
Still have a question? Email us and we will help you get set up.
ilyasstaibi1992@gmail.com