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.
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:
New to the raw database stuff so please be gentle with me.
Thanks in advance