Price Increase in Bulk

Views: 1,067

Results 1 to 7 of 7
19 Jul 2011, 8:44 PM
#1
laisunshine avatar

laisunshine

New Zenner

Join Date:
Nov 2007
Posts:
59
Plugin Contributions:
0

Price Increase in Bulk

Hello,
I am wondering if there is an easy way to increase the price of my products all at once? Its not going to be for all products, just a few. I just don't want to have to go into each listing to change the prices.

Any ideas are greatly appreciated. Thank you!

:blush:

19 Jul 2011, 9:35 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Price Increase in Bulk

If there are a significant NUMBER of products to update, then Easy Populate 1.2.5.4 by Langer, is probably your best solution.

20 years a Zencart User

19 Jul 2011, 9:44 PM
#3
laisunshine avatar

laisunshine

New Zenner

Join Date:
Nov 2007
Posts:
59
Plugin Contributions:
0

Re: Price Increase in Bulk

I had a feeling that this was going to be the answer. I was just hoping that I didn't have to install an addon. Thank you again!

19 Jul 2011, 10:00 PM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Price Increase in Bulk

Installing EP is one of the easier mods...

There are TWO folders:

ADMIN
TEMP

Just re-name ADMIN to your admin folder's name, and then FTP both the admin and the temp folder to your server. Do not worry about any of the "loose files" under those two folders. They stay on your machine.

(Make sure that in your FTP, you can see your admin*** folder - because you must make sure the FILES inside the EP admin folder get sent to the correct location).

Takes 20 seconds to complete - maybe less.

THEN, in your ZC admin panel, go to TOOLS and click Easy Populate.

When opening for the first time EP will ask you to click a configuration link (top of screen). Click that.

THEN... go to Configuration Menu and open EP configuration. The only setting you need bother about is the DATE formatting. Leave the rest.

I have a TUTORIAL in the WIKI on using Easy Populate.

20 years a Zencart User

20 Jul 2011, 3:08 PM
#5
laisunshine avatar

laisunshine

New Zenner

Join Date:
Nov 2007
Posts:
59
Plugin Contributions:
0

Re: Price Increase in Bulk

Is it pretty easy to use once it is installed? I would just like to update my products within a category and maybe update more after that. Thank you!

21 Jul 2011, 8:03 PM
#6
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Price Increase in Bulk

You could do this through MySQL commands, run through the Install SQL Patches, under TOOLS.

You will need to find your product ID numbers, and these are visible when you look at a list of products under a given category.

It's the number over on the absolute left of the listing.

The SQL command (for each product) will read:

UPDATE products SET products_price = 15.99 where products_id = 27;

Parts in BLUE don't change... parts in RED are your variables.
You can run a whole lot at once...
UPDATE products SET products_price = 13.99 where products_id = 23;
UPDATE products SET products_price = 11.95 where products_id = 29;
UPDATE products SET products_price = 29.99 where products_id = 46;

It requires careful checking... as you can imagine...

20 years a Zencart User

29 Jan 2013, 8:54 AM
#7
alexjoverton avatar

alexjoverton

New Zenner

Join Date:
Aug 2009
Location:
Bellac, France
Posts:
7
Plugin Contributions:
0

Re: Price Increase in Bulk

could you do this with attributes as well?

Thanks for your response.