Stock Grid
The Stock Grid is the fastest way to update stock levels in bulk — after a physical count, a delivery, or a seasonal reset. It puts every sellable variant in a warehouse on one screen with an editable quantity column, and it works with Excel two ways: paste a column straight in, or export a file, edit it, and import it back.
Find it under Operations → Stock Grid.
Choosing a warehouse
Stock is always held per warehouse, so the grid shows one warehouse at a time. It opens on your default warehouse; use the selector in the header to switch.
Finding the right rows
| Control | What it does |
|---|---|
| Search | Matches SKU, barcode, or product name — in any language, not just the one you are viewing |
| Low stock only | Shows rows at or below their reorder point. Variants with no stock record count as low, since they are effectively at zero |
| Include inactive | Adds variants and products that are switched off |
Click any column header to sort. Sorting always falls back to SKU, so variants of the same product stay together.
Variants that have never held stock in this warehouse still appear, at zero. Entering a quantity creates the record for them.
Bundle products are not listed. A bundle holds no stock of its own — its availability is calculated from its components, so you adjust the components instead.
Editing quantities
Type directly into the Stock column. Edited cells are outlined and shown in bold, and the Available column updates as you type so you can see the effect before saving.
Nothing is written to the catalogue until you press Save Changes.
Pasting from Excel
- In your spreadsheet, select the column of quantities and copy it.
- In the grid, click the Stock cell of the first row it applies to.
- Paste. The values fill downwards from that row.
A toast confirms how many rows were filled and how many were skipped. Rows are skipped when the pasted value is not a whole number of zero or more, or when the paste runs past the bottom of the page.
If you copied two columns — say SKU next to quantity — the grid takes the last numeric cell on each line as the quantity, so that works too.
The copy button next to Import puts the rows on the current page onto your clipboard as tab-separated text — handy for a quick look in a spreadsheet without downloading anything. For a whole catalogue, use Export instead.
Working in a file
Pasting is quickest for a screen or two of rows. For the whole catalogue — or when someone else does the counting — download a file, edit it, and send it back.
Export
Export downloads everything matching your current filters, not just the page you are looking at. Set the warehouse and filters first, then export.
The file has six columns:
| Column | |
|---|---|
| SKU | Identifies the variant. Do not edit. |
| Product, Variant | Context so you know what you are looking at. Greyed out; ignored on import. |
| Warehouse Code | Which warehouse the row belongs to. Do not edit. |
| Reserved | Held for pending orders. Greyed out. |
| Stock Quantity | The one column you edit. Shown in bold. |
The header row is frozen with a filter already applied, so you can sort and filter in Excel straight away.
Import
Import takes the edited file back. Two things happen:
- A preview. The file is checked and you are shown how many rows would change, how many already match, and how many were read — before anything is written. Press Apply import to go ahead, or Cancel to walk away.
- The write, once you confirm.
An import is all-or-nothing. If any row has a problem, nothing is written and you get a list of the offending rows by their Excel row number, so you can jump straight to them:
| Row | SKU | Problem |
|---|---|---|
| 14 | NAC-SER-041 | 'abc' is not a whole number of zero or more. |
| 87 | NAC-TON-002 | No product variant with SKU 'NAC-TON-002'. |
Fix them in the file and upload again.
Columns are matched by their heading, not their position. You can reorder them, or add your own columns for notes, and the import still works — it only reads SKU, Warehouse Code and Stock Quantity. Blank rows are ignored.
A file can cover more than one warehouse: the Warehouse Code column decides where each row lands, so you can combine exports from several warehouses into one sheet.
Limits: 10,000 rows and 10 MB per file, and it must be .xlsx — save from Excel's
default format, not .xls or .csv.
Your edits follow you
Pending edits are kept as you move between pages and change filters. The bar at the bottom of the screen always shows how many unsaved changes you have, wherever you have navigated to. This means you can work through a large catalogue page by page and save once at the end.
Discard changes throws them all away after a confirmation.
Saving
Save Changes writes every pending edit. Rows where you typed the value that was already stored are dropped from the batch — they are not counted as changes and raise no events.
A save is all-or-nothing: if any row is rejected, nothing in that batch is written. The rejected rows are tinted red with the reason shown underneath the product name, so you can correct them and save again.
Very large saves are split into batches of 1,000 rows automatically. If a later batch is rejected, earlier ones have already been applied — the error message tells you exactly how many rows were saved before the failure.
What a save triggers
Changing stock is not just a database write. Each changed row:
- raises a stock-changed event, plus low-stock, out-of-stock or back-in-stock events where the new level crosses those thresholds
- queues a catalogue push to every marketplace that sells from this warehouse, so channels such as Trendyol pick up the new quantity
- appears on the low-stock dashboard and feeds demand planning
Rows you did not actually change trigger none of this.
Stock Grid or Stock Management?
- Stock Grid — catalogue-wide bulk editing. Use it when you are changing many rows.
- Stock Management — a single warehouse's existing inventory records, with per-row adjust by ±n and bin-location editing. Use it for one-off corrections where you want an adjustment rather than an absolute value.