Increasing or Reducing Prices Globally in your Zen Cart

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.