CSV Import – can I specify a price INC tax?

[danielgildenlow]

Ok, so I have tons of products to import by CSV, and their prices are including tax (I have Swedish 25% tax in my shop). So, if I import them using the typical method, I can either import them without tax to get the prices right (but then I guess I'll have to edit every product afterwards to apply the tax rule), or I can import them with the tax rule (but then they will be too expensive). Is there a way I can do this without having to edit all prices in my database table?

 

If not, I guess this is what I'll do:

– Open Numbers (or Excel)

– Paste all product CSV fields into a table

– Create a new column after price

– Make that column sum the preceding price column (x 0.8)

– Select that column as price excluding tax on import