Import products from Excel or CSV

If you have many products, you do not have to enter them one by one. Upload an Excel file (.xlsx) or a CSV file, for example your wholesaler's price list or an export from other software. You do not have to change the file first: Saloon matches the columns for you.

Import products

1. Go to Catalog › Products in the menu and choose Options › Import products.
2. Drag your file into the window or click Choose a file. No file yet? Click Download template for an empty list with the right columns and an example line. Click Next step.
3. Under Check the columns, check which column belongs to which field. Change what is wrong, or choose Do not import. A column must be matched to Product name.
4. If your file has quantities and you have more than one location, choose under Location of the stock where the stock goes. Click Next step.
5. Under Check the products, see what will happen, split into To import, Remarks and Skipped. Nothing has been saved yet.
6. Click the button with the number of products, for example Import 24 products. Keep the window open until the import is done, then click Done.

What you can import

• Product name, Brand, Category, Supplier, Short description and Product description.
• Content and Unit, for example 250 and ml, or 250 ml together in one column.
• SKU and Barcode.
• Retail price (including VAT) and Supply price (excluding VAT).
• For sale at checkout: yes or no per product. If you do not match this column, a product with a retail price is for sale. A product without a retail price comes in as not for sale.
• Stock, Low stock level and Reorder quantity. A product with one of these values tracks stock from then on. The quantity goes into the stock history as opening stock.

A brand, category or supplier you do not have yet is created for you. If the name exists, that one is used.

What is skipped

• A row without a product name.
• A product you already have: with the same SKU or barcode or, when the row has no codes, with the same name and brand.
• A product that is in the file twice.
• A value Saloon cannot read, such as a price with text in it, is left out. The product is imported without that value and shows under Remarks.

An import never changes a product you already have, so you can safely upload a file twice. With Download these rows you save the skipped rows or the rows with a remark, so you can fix them and import them again.

Who may import

You need the permission Can import products in bulk for this. You set it under Settings › Team members › Permission roles, in Catalog. Without it you do not see the option.

Frequently asked questions