phpMyAdmin Database Bulk Update

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.

Kemahiran: MySQL, PHP

Lihat lagi: bulk update column phpmyadmin, phpmyadmin bulk field edit, phpmyadmin simple database update, phpmyadmin bulk update, prestashop update, backup database, prestashop gst, prestashop price without tax, mysql edit database, please find attached price list, mysql prestashop, mysql update field, mysql update database, price tax prestashop, prestashop can add edit products, shop database, bulk select, phpmyadmin mysql, search php prestashop, prestashop add list price, prestashop products mysql, change steps prestashop, 700 products, prestashop change steps, update price prestashop

Tentang Majikan:
( 54 ulasan ) Stanhope Gardens, Australia

ID Projek: #4101784

Dianugerahkan kepada:


I can modify the data in your database right now. Will backup it of course.

$30 AUD dalam 0 hari
(194 Ulasan)

10 pekerja bebas membida secara purata $37 untuk pekerjaan ini


i can do that for you.

$35 AUD dalam 0 hari
(323 Ulasan)

Hello Please read more than private message thank you

$200 AUD dalam 2 hari
(39 Ulasan)

Hi from New Zealand. I can do this easy. Please see PM too.

$30 AUD dalam sehari
(33 Ulasan)

This is extremely easy for me. Check your PBM.

$30 AUD dalam 0 hari
(46 Ulasan)

Hi this is a simple update.

$30 AUD dalam sehari
(13 Ulasan)

I am a Linux Consultant..

$50 AUD dalam 2 hari
(18 Ulasan)

Database Expert Here, Checkout my Review and Inbox Please I'll complete the job in couple of hours sir.

$30 AUD dalam 0 hari
(12 Ulasan)

I can do this straight away.

$30 AUD dalam 0 hari
(4 Ulasan)

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.

$50 AUD dalam 2 hari
(4 Ulasan)

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

$30 AUD dalam sehari
(2 Ulasan)

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.

$50 AUD dalam sehari
(0 Ulasan)