Using CellarOS

Importing price lists

The import wizard turns a supplier's CSV or Excel price list into catalogue wines in four steps.

Start from Suppliers — open a supplier's actions menu and choose Import a CSV / Excel list.

Step 1, Upload

Importing always happens against a supplier, so the supplier is already chosen for you. Upload a .csv, .xls or .xlsx file (up to 10 MB).

CellarOS reads the headers and rows, and if it has imported from this supplier before, it pre-loads their saved column mapping.

Step 2, Map columns

Match each CellarOS field (wine name, producer, country, region, grape, type, vintage, format, case size, unit price, price note, stock) to a column from your file. The wizard auto-guesses from the header names; you only fix what it got wrong. Wine name is required.

Step 3, Preview

See a sample of how your wines will be imported, after normalisation:

  • Types are recognised across languages and trade shorthand (e.g. rouge, bianco, champagne → Sparkling, skin contact → Orange). If your supplier uses a word we don't know, we'll offer it to you to map, and remember your answer for their next list.
  • Grapes & regions are standardised (e.g. Shiraz → Syrah, Burgundy → Bourgogne).
  • Prices, vintages and bottle formats are parsed from messy text (currency symbols, 75cl, Magnum, "NV", etc.).
  • Each wine is geocoded from its region and country.

Step 4, Import

Confirm to create the wines, linked to the supplier. Re-importing an updated list updates existing wines (matched on supplier + name + vintage + format) rather than duplicating them, and the column mapping is saved back to the supplier for next time.

Importing from a PDF price list is planned for a later release.