running ExpressionEngine with Cartthrob - we've come up against a situation where the client has requested to remove a global Tax setting, so that they can have all prices on the site already inclusive of VAT.
The price is currently set as a custom variable, alongside some other custom variables for previous price settings and others (we inherited this site from another dev team). Our problem is that we now need to add 20% to all prices, to bring them in line with correct pricing now there is no global tax in effect.
What is the best way of achieving this, in a way that doesn't involve manually changing each product entry? My initial thought was to perform an export of the dataset (CSV or otherwise) for products, create a calculation in the resulting file to generate new prices, and then reimport into EE. I tried exporting by creating a custom export template with download csv headers, but it resulted in an empty export. I also tried looking to the database for manipulating via sql, but of course the custom variables are not stored within a flat table structure.
Any advice would be greatly appreciated - worth noting I do need to be able to import this back in at the end of the process too! Thanks in advance,