Update prices via CSV import

If you need to update prices on many products at once, you can do it easily via CSV import in Shoporama. This is a great time saver if you get new prices from your supplier, need to make a seasonal adjustment or need to update cost prices. Here we show you exactly how to do it step by step and how to avoid the classic VAT error.

1. Create your CSV file

The file should contain two columns: the product SKU number (item number) and the new price, separated by a semicolon. We recommend including a header line so Shoporama can automatically recognize the fields:

own_id;price 1-5443-ST5;199.90 2-2289-GV4;351.00 3-7466-UT6;123.89

2. Upload the file in Shoporama

1. Go to Products and click "Import".
2. Check the "Possibly surrounded by" field. If your file does not have quotation marks around the values, remove the " from the field.
3. Click "Browse" and select your CSV file.
4. Click "Upload".

3. Verify and import

You will now get a preview of your file. Here you need to:

1. Check that the columns show SKU number and Price in the dropdown fields.
2. Check "Unique" next to SKU. This ensures that prices are updated on the existing products instead of creating new duplicates.
3. Do not select a profile. The products already have one assigned.
4. Consider the checkbox "Deduct 20% Danish VAT from prices". It is set to (checkmark) by default. Read the explanation below before importing.
5. Click "Import".

Your prices will update within a few minutes, depending on the number of products.

What does the checkbox "Deduct 20% Danish VAT from prices" do?

Prices in Shoporama are saved excluding VAT, while most supplier files and price lists include VAT. The checkbox controls whether Shoporama should deduct VAT from your prices on import.

• Check the box if your prices in the CSV file include VAT. Shoporama then multiplies each price by 0.8 and saves the VAT-free price.
• Uncheck the box if your prices are already excluding VAT (for example, if you work directly with cost prices or B2B prices). Otherwise, your prices will end up 20% lower than intended.

Other fields you can update

The same method can be used to update many other fields, e.g:

• sale_price, offer price.
• purchase_price, cost price (important for correct profit margin statistics).
• stock, stock count.
• name, description, meta_title, meta_description.

Remember to include SKU as a unique field so Shoporama knows which product to update. Read more in the guide to CSV importing products.

Frequently asked questions

What happens if an SKU does not exist in the shop?

By default, Shoporama creates a new product for each row where the SKU does not match. If you only need to update existing products (e.g. a new price list from the supplier), also check "Skip unique if not found". Then unknown SKUs are ignored completely.

My file uses comma as decimal, e.g. 199.90. Does it work?

Not directly. Check "Amount is in Danish format" and Shoporama will automatically convert Danish number format (199.90) to international format (199.90) on import. This applies to all price fields in the file.

Can I undo a CSV import if I make a mistake?

There is no "undo" button. Always export your products before importing so you have a backup. If something goes wrong, you can import the old export again to roll back. It's a good idea to test with 5-10 products before running the entire file.

How long does the import take?

It depends on the number of products. 100-500 rows typically take less than a minute. Up to 10,000 rows can take several minutes. The import runs in the background, so you don't need to keep your browser open.

How do I check that the prices are updated correctly?

Open a few samples in admin under Products or export the products again and compare with your import file. If you didn't reset the cache at the same time, the shop may show old prices for a short time afterwards. Read more in Cache in Shoporama.

What about variants, for example different sizes of the same product?

Each variant has its own SKU, so if you want to price variants individually, you need to specify them as separate rows in your CSV. If you want all variants to have the same price, you can simply update the main product price and let the variant prices follow.

Can I adjust prices with a percentage instead of entering a new price?

The CSV import takes fixed price values. For example, if you want to raise all prices by 5%, export the product list first, calculate the new prices in Excel (multiply by 1.05) and import the adjusted file back.

Does it affect active campaigns and discount codes?

No, it doesn't. The CSV import will only change the product's normal selling price and any promotional price. Active promotions, volume discounts and discount codes will still be calculated on top of the new price.

I forgot to uncheck the box and now all prices are 20% too low. What should I do?

This is a classic error. You have two options: 1) Import the original export you hopefully made before, so the prices roll back. 2) Create a new CSV with the same prices multiplied by 1.25 (e.g. in Excel) and import again without checkmarks. Then you're back to the original price.

My webshop is VAT exempt or sells abroad. Do I need to remove the checkmark?

Yes, you do. Shoporama always stores prices excluding VAT, and VAT is only added at checkout based on the customer's country. If your supplier prices are already pure prices without VAT, then uncheck the import checkbox. This is determined by your supplier invoice and accounting, not the online shop's VAT setting.

Where do I find the existing price list so I can start with an export?

Go to Products and click "Export". Select CSV format. You'll get a file with all your products that you can open in Excel or Google Sheets, edit the prices and import back. It's the safest way to avoid column name errors.

Do you need help? Contact us at support@shoporama.dk.