📥 Update your catalogue in a spreadsheet, then import it back
Export your products, edit prices, stock and translations in Excel, and import the file back - with a full check before anything is saved.
Editing a catalogue one product at a time is fine for five products and miserable for five hundred. You can now export your products, do the work in a spreadsheet, and import the file back in one go.
Find it on the Products page: Import CSV, next to the export button.
Nothing is saved until you say so
Uploading a file doesn't change anything. Erpilo reads it first and shows you a report:
- how many rows the file has, how many are fine, and how many have problems
- exactly what's wrong with each bad row, by line number - "Line 15: SKU already exists", so you can find it in your spreadsheet immediately
- what will be created and what will be updated
Only when you press Apply import does anything get written. Rows with problems are skipped; the rest still go through, so one bad line never blocks the whole file.
If some rows fail, you can download just those rows as a CSV with an extra error column explaining each one. Fix that small file and import it on its own - no need to hunt through the original.
Choose how it should behave
| Mode | What it does |
|---|---|
| Create and update | New rows are created, existing products are updated. |
| Create new products only | Errors if a row matches something you already have. |
| Update existing products only | Errors if a row doesn't match anything. |
Update-only is the safe choice when re-importing an edited export. If Excel quietly mangled a product code, that row reports an error instead of creating a duplicate product.
What it will and won't touch
- Leave a column out and it stays as it is. The file only changes what it actually contains - that's what makes it safe for a team member to export without the cost column, edit names, and import back without wiping anyone's purchase prices.
- Product groups and VAT rates sort themselves out. A group or VAT rate that doesn't exist yet is created for you, and the report tells you which ones before you confirm - worth a glance for typos.
- Variant prices and stock update properly. Change a variant and its parent's price range and total stock are recalculated automatically.
- Structural changes stay in the product editor. Creating brand-new variants, moving a variant to a different parent, or switching a product between goods and services aren't done by import - those need the proper screens.
A couple of practical notes
Stock is set directly. Importing a stock quantity writes it straight onto the product, exactly like typing it into the product form. It doesn't create stock movements or accounting entries - so if you reconcile inventory against your books, a bulk stock change won't show up as a movement.
Files up to 500 rows apply immediately. Larger files run in the background, and the page shows live progress.
Open CSVs properly. Use Data → From Text/CSV in Excel and set the product code and barcode columns to Text, or Excel will reformat them before Erpilo ever sees the file.