Skip to content

Import and export of stock


Stock import – step by step

  1. On the Stock page, open the Import action (e.g. a button that opens an import modal).
  2. 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.
  3. 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)
  4. 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_warehouse column (and variant_stock_by_warehouse for variants) has the form warehouse-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_price column (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.