Import and export with Excel
The whole price list in one .xlsx file: models, constructions, colour and bicolour surcharges, and accessories. Before saving, the import shows what it will add and change; it never deletes anything and can be undone for 30 days.
Downloading the price list
Above the price list there is an “Import / export” menu. “Download for Excel” saves the whole price list as an .xlsx file with separate sheets: models, constructions, colour surcharges, bicolour and accessories.
The file is handy as a backup before a bigger change, for reviewing prices with a manufacturer, and as an import template — once edited, it goes back into Alstre without any column mapping.
Importing step by step
“Import from Excel” in the same menu opens the import page. It takes you through four stages:
- FileExcel (.xlsx) or CSV, up to 5 MB and 2000 models; the first row holds the column names. The file is read in your browser — only the selected columns are sent to the server. “Download the current price list as a template” gives you a file in the right layout.
- ColumnsMap each column to a price list field: Type, Brand / Manufacturer, Model, Pricing method, Net price, Minimum per piece or the size limits; mark the rest “— skip —”. You need at least a brand or a model. A file without a type column goes entirely into the type chosen in “Type for rows without a type”.
- ReviewThe preview sorts rows into New models, Changes, Unchanged and To fix, and the “What happens” column tells you what will change in each model. Constructions, colours and accessories get their own “Other sheets” section.
- DoneThe result: how many models were added and updated, how many rows were skipped, and an “Undo this import” button.
What the import changes and what it doesn't
- It adds and updates. A model from the file that isn't in the price list is added; an existing one gets the values from the file. Models are matched by type, brand and model.
- It never deletes. Models not in the file and skipped columns stay as they are. The one exception: a bicolour surcharge of 0 in the file removes that surcharge.
- All or nothing. Rows with errors are skipped and the rest is saved in one go. If someone changed the price list in the meantime, the import stops and shows the preview again.
- It understands five languages. The type (“window”, “interior windowsill”) and the pricing method (“pcs”, “m²”, “per metre of perimeter”) can be written in any panel language.
On the constructions and accessories sheets, the “Applies to” column takes “All models” or model names separated by semicolons. Constructions, colours and accessories are loaded only into a type that has models — in the price list or on the models sheet of the same file.
Undoing an import
On the import page, the “Recent imports” list shows the file, who ran it, when and the result. For 30 days after the import, “Undo” removes the added models and restores the previous values of the updated ones — across all sheets at once.
