"one touch" price increase on my site?

[waterloominis]

Forgive my ignorance; I'm still taking over my store after losing my web guy. In the past he told me he could do an "across the board" price increase of all products on the store, using a percentage increase, but he never told me how he did it. Can anyone tell me how that could be done?

Thank you in advance!
Rob

[dragoon09]

I think what he is talking about it using Easy Populate (EP).

EP allows you to view your inventory via your favorite spreadsheet program. From this view you can change things enmass like prices, categories, weights, and just about every other category you need. When done, you can upload your spreadsheet in a tab-delimited .csv file format to your site under Tools>Easy Populate

You can download it here (version 1.2.5.4 - the one I use and have had little to no problems with):
http://www.zen-cart.com/index.php?ma...oducts_id=1633

There is also a Schoolboys wiki about here:
http://www.zen-cart.com/wiki/index.php/Easy_Populate

And a support thread here:
http://www.zen-cart.com/forum/showth...=easy+populate

If you need to learn how to use your spreadsheet program, I would suggest visiting the forums for your spreadsheet program.

[schoolboy]

You can run a SQL patch through admin>>>tools>>>insert sql patches.

Good idea to BACKUP the database first.

UPDATE products SET products_price = products_price * 1.2;

The value 1.2 will add 20%
The value 1.25 will add 25%
The value 1.3 will add 30%
The value 1.33 will add 33%
...

do you see the pattern?

This is a GLOBAL increase !!!

For more options, see: http://www.zen-cart.com/forum/showpo...32&postcount=5

[schoolboy]

I think what he is talking about it using Easy Populate (EP).

EP allows you to view your inventory via your favorite spreadsheet program. From this view you can change things enmass like prices, categories, weights, and just about every other category you need. When done, you can upload your spreadsheet in a tab-delimited .csv file format to your site under Tools>Easy Populate

You can download it here (version 1.2.5.4 - the one I use and have had little to no problems with):
http://www.zen-cart.com/index.php?ma...oducts_id=1633

There is also a Schoolboys wiki about here:
http://www.zen-cart.com/wiki/index.php/Easy_Populate

And a support thread here:
http://www.zen-cart.com/forum/showth...=easy+populate

If you need to learn how to use your spreadsheet program, I would suggest visiting the forums for your spreadsheet program.

Certainly EP is an option... best used when there are a large number of differences in the price increases.

[dgent]

Or even simpler, go into your admin and just adjust your default currency ratio from 1 to 1.2 for instance for a 20% hike. This will of course increase shipping costs too, everything.

[philip937]

You can run a SQL patch through admin>>>tools>>>insert sql patches.

Good idea to BACKUP the database first.

UPDATE products SET products_price = products_price * 1.2;

The value 1.2 will add 20%
The value 1.25 will add 25%
The value 1.3 will add 30%
The value 1.33 will add 33%
...

do you see the pattern?

This is a GLOBAL increase !!!

For more options, see: http://www.zen-cart.com/forum/showpo...32&postcount=5

I use this method too, but its worth noting that if you have any sales and specials prices that these need resetting as they will be defined in the price sorter field (thats my understanding anyway. so usually to be safe I remove all sale sales and specials, run the sql patch, then re-apply sales etc.