Update prices via CSV import
Guide to updating prices on many products via CSV import in Shoporama.
If you need to update prices for many products at once, you can do it easily via CSV import. Here we show you exactly how to do it step by step.
1. Create your CSV file
The file should contain two columns: the product SKU number and the new price, separated by a semicolon. We recommend including a header line:
own_id;price 1-5443-ST5;199.90 2-2289-GV4;351.00 3-7466-UT6;123.89
Important note
Use periods as decimal separators (not commas). Do not use thousand separator. Save the file as .csv.
2. Upload the file in Shoporama
- Go to Products and click "Import"
- Remove the
"in the "Possibly surrounded by" field - Click "Browse" and select your CSV file
- Click "Upload"
3. Verify and import
You will now get a preview of your file. Here you need to:
- Check that the columns show SKU number and Price in the dropdown fields
- Check "Unique" next to SKU - this ensures that prices are updated instead of creating new products
- Do not select a profile (products already have one)
- Uncheck "The uploaded prices include 25% Danish VAT" if the prices in your file are ex. VAT
- Click "Import"
Your prices will be updated within a few minutes.
Tip for updating
You can also update other fields via CSV import - for example, product titles, descriptions and stock count. Read more in our guide to CSV importing products.
Do you need help? Contact us at support@shoporama.dk.