Price Increase in Bulk

[laisunshine]

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!

[schoolboy]

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

[laisunshine]

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!

[schoolboy]

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.

[laisunshine]

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!

[schoolboy]

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...

[alexjoverton]

could you do this with attributes as well?

Thanks for your response.