One of my clients decided to reduce prices by 5% across the board. This kind of change is not hard to make in phpMyAdmin. Their database prefix was “zen_” so I used the commands
update zen_products set products_price = products_price * 0.95; update zen_products set products_price = round(products_price, 2);
If you wanted to increase prices by 5% instead, the first command would simply be
update zen_products set products_price = products_price * 1.05;
Note that this only changes the regular prices of products; products on sale or special are not changed. I’ll talk about those in a future blog post.