I gang

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.

Færdigheder: MySQL, PHP

Se mere: 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

Om arbejdsgiveren:
( 54 bedømmelser ) Stanhope Gardens, Australia

Projekt-ID: #4101784

Tildelt til:

rsdsoftsl

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

$30 AUD in 0 dage
(194 bedømmelser)
7.0

10 freelancere byder i gennemsnit $37 for dette job

eelance

i can do that for you.

$35 AUD in 0 dage
(323 bedømmelser)
6.8
scriptphp87

Hello Please read more than private message thank you

$200 AUD in 2 dage
(39 bedømmelser)
5.6
weonlydo

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

$30 AUD på 1 dag
(33 bedømmelser)
5.4
MaTeMaTiKci

This is extremely easy for me. Check your PBM.

$30 AUD in 0 dage
(46 bedømmelser)
5.2
freshjah

Hi this is a simple update.

$30 AUD på 1 dag
(13 bedømmelser)
4.4
technofreakz

I am a Linux Consultant..

$50 AUD in 2 dage
(18 bedømmelser)
4.1
ntlabs

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

$30 AUD in 0 dage
(12 bedømmelser)
3.8
codemannz

I can do this straight away.

$30 AUD in 0 dage
(4 bedømmelser)
2.5
salichani

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 in 2 dage
(4 bedømmelser)
2.1
yamaas

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 på 1 dag
(2 bedømmelser)
1.7
webnetpublisher

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 på 1 dag
(0 bedømmelser)
0.0