Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

easiest way to batch update a mysql databse field with prices

Avatar of G1rdy
G1rdy asked on
PHPMySQL Server
7 Comments1 Solution614 ViewsLast Modified:
Hi Experts, I have an ecommerce store that is driven by a mysql database and I can access the database through PHPmyadmin.

In the database I can see the database table that has the prices of the products and I can download a full csv file of the items, all 1700 of them but I would like to change the prices by a fixed value on every line to meet recent changes in exchange rates. My fear is having never done anyting like this I just need a bit more confidence to make the change and hit the button and not destroy the thing!

So my question or questions are.

Should I download the full tables csv and use excel to update the prices by the required multipler of .9469 and then re-import the csv file into the database, if so how do I do this and what should I be aware of as the risks.

or

Can I run a command on the database through phpmyadmin just tchange the value field in that table by the required value of 0.9469?

Either way I need to be sure I do not destroy the database as it would take months to rebuild.

The fields in the database table "qkcv_catalog_product_entity_decimal" are:

value_id
entity_type_id
attribute_id
store_id
entitly_id
value

New to the raw database stuff so please be gentle with me.

Thanks in advance



ASKER CERTIFIED SOLUTION
Avatar of AngryBinary
AngryBinary

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers