Globally Changing prices of products.

Hi all, hope you can help me :)

I have a shop with 1500 products in it, and have to alter the price of them all by a set % is there an easy way to do this?

The items are in categories and subcategories. I was thinking that maybe I could export them to a spreadsheet, alter them globally, then upload the new file? Any advice appreciated as I am a total noob with this :(

Thanks

T

Are you wanting to alter all 1500 products by the same % or each category of products?

Do you have attributes with prices or just product prices?

Hi , this has now been done thanks :smile:

Linda's hesitance in immediately suggesting EasyPopulate is well-placed... If you're just working with basic product data (none "priced by attributes"), then EasyPopulate enables "mass updating" using a tab-delimited txt spreadsheet.

If you have products whose pricings are also dependent on attributes (sizes of a particular garment, for example), then EasyPopulate has some limitiations.

There are also ways to do updates on prices in part or as a whole depending on what the criteria is ...

For example, update all prices by plus 10% is a single command ...

Update all prices in a given category where the category is the master_categories_id can also be done with a single command per master_categories_id ...

Updating both prices and attributes can be done with a bit of coding ...

For other things, programs like EP might be useful ...

Well I paid a programmer to alter the prices globally and it is done, but the store has really slowed down. I have an awfull feeling he has scripted it to do this rather than altered the actual prices.

Also all the stock levels are set to zero now :(

Will easy populate allow me to globally set the stock levels?

Is this the rright page for download ?
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=460

Thanks

T

After consulting the zen cart owners manual (if you use Zen cart BUY THIS BOOK) :D

I have discovered that you can set it to allow checkout on non stock items, and also not to show out of stock etc.

This is perfect for dropshippers, or florists etc, wehere the stock is made at the point of sale :D

GREAT BOOK!

And no I am NOT on commission LOL

Did you buy the hard copy book or the downloadable one? How up to date can the hard copy be vs the digital one?

Ajeh:

There are also ways to do updates on prices in part or as a whole depending on what the criteria is ...

For example, update all prices by plus 10% is a single command ...

Update all prices in a given category where the category is the master_categories_id can also be done with a single command per master_categories_id ...

Updating both prices and attributes can be done with a bit of coding ...

For other things, programs like EP might be useful ...

I was reading your advice to another new zenner and wondered where I'd find the info to do what you're describing here. I'd like to be able to change the prices or add prices to a whole category. Could you please point me in the right direction? thank you.
george

You can check the products table in phpMyAdmin to see what the master_categories_id is or ... in the Zen Cart Admin go to the Categories/Products ... if all the Category is not marked with a yellow icon, that means there are not any Linked Products ... if the Category is marked with a yellow icon that means there are Linked Products ...

If you use Linked Products, check to see if those Products are all using the same master_categories_id ... you can see this by editing the Product ...

If all Products use the same master_categories_id, then you can use that to control which Category gets the prices updated ...

For example, if categories_id 10 is the master_categories_id you can update the products_price to $5.00 more with:

UPDATE products SET products_price = products_price + 5.00 WHERE master_categories_id = 10;

and that can be run in the Tools ... Install SQL Patches ...

The, go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

NOTE: the Update Products Price Sorter uses the master_categories_id when building the default price for the Product ... so if using Linked Products, it is important that master_categories_id be set correctly ...

Ajeh:

You can check the products table in phpMyAdmin to see what the master_categories_id is or ... in the Zen Cart Admin go to the Categories/Products ... if all the Category is not marked with a yellow icon, that means there are not any Linked Products ... if the Category is marked with a yellow icon that means there are Linked Products ...

If you use Linked Products, check to see if those Products are all using the same master_categories_id ... you can see this by editing the Product ...

If all Products use the same master_categories_id, then you can use that to control which Category gets the prices updated ...

For example, if categories_id 10 is the master_categories_id you can update the products_price to $5.00 more with:

UPDATE products SET products_price = products_price + 5.00 WHERE master_categories_id = 10;

> 
> and that can be run in the Tools ... Install SQL Patches ...
> 
> The, go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...
> 
> NOTE: the Update Products Price Sorter uses the master_categories_id when building the default price for the Product ... so if using Linked Products, it is important that master_categories_id be set correctly ...

Thank you Linda. I will see if I can figure out what to do from what you've described. You were very helpful.

Ajeh:

You can check the products table in phpMyAdmin to see what the master_categories_id is or ... in the Zen Cart Admin go to the Categories/Products ... if all the Category is not marked with a yellow icon, that means there are not any Linked Products ... if the Category is marked with a yellow icon that means there are Linked Products ...

If you use Linked Products, check to see if those Products are all using the same master_categories_id ... you can see this by editing the Product ...

If all Products use the same master_categories_id, then you can use that to control which Category gets the prices updated ...

For example, if categories_id 10 is the master_categories_id you can update the products_price to $5.00 more with:

UPDATE products SET products_price = products_price + 5.00 WHERE master_categories_id = 10;

> 
> and that can be run in the Tools ... Install SQL Patches ...
> 
> The, go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...
> 
> NOTE: the Update Products Price Sorter uses the master_categories_id when building the default price for the Product ... so if using Linked Products, it is important that master_categories_id be set correctly ...

Hi Linda,

I too have the same need, but i want to update all prices globally, by a percentage not just a set amount, could you please advise? thanks in advance,

regards,

ed

Change the setting for:
products_price = products_price + 5.00

to what you want to use ...

If you want to do ALL Products, then remove the WHERE condition:
WHERE master_categories_id = 10