Import and export of stock
Stock import – step by step
- On the Stock page, open the Import action (e.g. a button that opens an import modal).
- Optionally choose a warehouse. If you leave it empty, the default warehouse is used (or the warehouse with code "ESHOP"); if no active warehouse exists, the import is skipped with an error.
- Upload a CSV or Excel file. Expected columns:
- product_id (required)
- variant_id (optional for simple products; required for products with variants — a row without it is skipped with an error)
- quantity or current_stock — target total quantity for that product/variant (sum across all warehouses)
- Submit the import.
What happens: The system reads the file and, for each row, finds the corresponding product (and variant if given). The quantity in the file is the target total — the system computes the difference from the current total across warehouses and applies that difference in the chosen warehouse. Each change is recorded in history as an import; rows with no change are skipped. The result summary shows how many rows were updated, how many skipped, and any per-row errors (e.g. invalid or missing products).
Per-warehouse stock in imports and exports
Besides a single stock number, you can transfer a per-warehouse breakdown.
- The
stock_by_warehousecolumn (andvariant_stock_by_warehousefor variants) has the formwarehouse-code=qty|warehouse-code=qty, e.g.main-warehouse=6|supplier=4. - The breakdown is authoritative — warehouses not listed in it are zeroed (not deleted).
- If a warehouse code doesn't exist, the warehouse is created automatically; names/codes containing "dodavatel", "extern" or "supplier" are flagged as supplier warehouses (Warehouses & Suppliers).
- The
recommended_pricecolumn (RRP) is transferred too — it is reference data only and does not affect the selling price.
Automatic imports
For automatic imports under Products > Automatic imports, ticking a field decides whether the feed may overwrite it on every run. Among others you'll find Recommended Price (in the pricing group), Stock By Warehouse (inventory) and Variant Stock By Warehouse (variant_fields). An unticked field is never overwritten — your manual value survives.
Export current stock
Use Export current stock on the Stock page to download a CSV with columns: product_id, variant_id, sku, name, current_stock. The current_stock values are the total stock per product/variant across all warehouses.