I have a prestashop v1.4.9 shop that has around 700 items with sale price with 10% tax included however this price is in the wrong field it is in the Before Tax field which means if I add 10% gst on top all the prices will be incorrect.
I need someone to do a bulk update via phpMyAdmin to select 10% GST and minus 10% from the current listed price.
Here's some steps which I think will explain it all
1. Search for all id_tax_rules_group = 0
(I edited 2 products so this will find products that have not the incorrect price)
2. Then edit all of the products it finds for "price"
3. The price column currently list the price of the item without TAX
4. We need to make
1. id_tax_rules_group = 1
2. price = (price before tax)
5. Need to use a formula to work out price before tax here it is
EG: $599 (with tax)
Before tax = 599 / 11 = $54.454545 (this is the 10% tax)
Then minus the 10% tax from the current number in the price column
= 599 - (599 / 11) = 544.54545454
6. Please backup the database before you make any changes. Can't lose this database
I have attached a sample of what it looks like now and what it should look like. Its a quick and simple job only a few lines of code needed to change all this information.
10 freelancers are bidding on average $37 for this job
Long experience in Web design and development with (X)HTML, CSS, PHP, JS/JQuery, MySQL, Joomla, Wordpress. I can edit your database to calculate price w/o GST and change tax code accordingly.
Hi! I am interested in working on your project. I am accurate hard working. I have been working on several projects in this area, and I can promise finishing your project on time and with the expected results
Well met. I can complete this for you tonight if you accept my bid and I can get working immediately, otherwise I am busy for the rest of the week. Please see PM for details.