The import wizard turns a supplier's CSV or Excel price list into catalogue wines in four steps.
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.