zos Posted December 5, 2014 Share Posted December 5, 2014 Hello, I recently CSV imported several thousand of products into prestashop (1.6). Several hundred of them got the price wrong. Now thats not a big problem cause I can just run SQL statement equivalent of find&replace on those. The problem: in database I can only find pre-tax prices. I am not at all interested in pre-tax prices. I want to mass update FINAL RETAIL prices. I could theoretically manually subtract 22% (my country's tax) from final retail price and enter those. But thats a lot of extra work and I am worried rounding would get messy. My client won't be happy to see his prices go from 9.90€, 19.90€ etc to some botched 9.87€ or whatever. I did a search on the whole database and a part from the table for layered module there is no mention of the final prices at all. Any help would be greatly appreciated. TLDR; I need to mass change final retail prices, but i can only find pre-tax prices, which are pretty much useless. Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now