← Back to Changelog

Import your price list from a spreadsheet

Products now has an Import price list button beside Add item. Choose a CSV or Excel file with a row per item — up to 2,000 items and 5 MB — and the import reads it without saving anything.

You then see what importing would do: how many items will be created, how many will have their prices updated, and any rows with problems, such as a missing name. Columns are matched by their headings, and each one can be changed before you go ahead: if your file says Price, that is read as the selling price unless you say otherwise.

Nothing is saved until you choose Import. A row whose item code or SKU matches an existing item only updates that item's prices and leaves everything else as it was. New items are created as they appear in the file.

A supplier column and a supplier price column fill in that supplier's prices, and a customer column makes a new item visible only to that customer. Send the same file to the assistant on WhatsApp and it will show you the same summary and import on your confirmation.

Web

New

  • Products has an Import price list button that reads a CSV or Excel file and shows what it will do before anything is saved
  • Columns are matched by their headings and you can change what any column is read as before importing
  • A row whose item code or SKU matches an existing item updates its prices and leaves everything else as it was
  • Supplier prices and which customers an item is visible to can be filled in from the same file