Increase price on all products universally?

[miles]

If I want to set back to normal (no increase), how do remove it from the database?

[afo]

If I need to decrease prices by 5% do I change the 1.35 referenced in the quote to 0.95?

Yes.

Miles' question is a little trickier if the prices were previously increased. I'll have to think about how to decrease after an increase.

[Ajeh]

The easier solution for that would be to add a new field to "hold" the products_price ... such as:
products_price_original

Copy all the prices to that field first, then you can update the products_price as needed ...

When you want to put the prices back, you can copy those original prices stored in products_price_original ...

Otherwise, you could do a reverse calculation on the products_price field for how you altered the price ...

The difference between the two would be rounding issues ...

[genesis@genesissyste]

[font=verdana]remember backup mysql................[/font]
[font=verdana] [/font]
[font=verdana]backup, [/font]
[font=verdana]backup, [/font]
[font=verdana]backup [/font]
[font=verdana]before do anithing[/font]
[font=times new roman][/font]

[miles]

The easier solution for that would be to add a new field to "hold" the products_price ... such as:
products_price_original

I opened PHP MyAdmin. Is this the right TABLE where I should add a new field?

zen_products

Now I have already noticed the products_price field in zen_products table. If this the right table, how do I create a new field (products_price_original)?

[Virtual]

Hello Ajeh, Thanks for your great advice. Would you please advise how to do a Global Update of the pricing on a particular category of products on our ZenCart as opposed to all products? In our instance we want to increase our Stickers from $2.5454 net to $2.73 net?

The stickers are grouped into further categories however all the prices should be upgraded as above. Our site is:
http://papercraftsupplies.com.au/shop/index.php

We're using Version 1.3.8a (the most recent version)
We don't have any add-ons
We have customized templates in accordance with the e-Start User Guide.

Many thanks,
Eva

[Ajeh]

You could do it based on the master_categories_id on each product but this would not do the subcategories as that is not immediately realted ...

UPDATE products SET products_price = products_price * XX.XX where master_categories_id = YY;

where XX.XX is the percentage to update the price and YY is the Master Category that the Products belong to ...

[Virtual]

Thank you so much Ajeh,

This information guided me to make the changes - which I was able to make within seconds!!! Wow!

Eva
P.S. I hope you enjoyed your cup of coffee yesterday.

[Ajeh]

Glad that this was able to help you out ... and we really appreciate the support to keep Zen Cart humming along ...

[time111]

You could do it based on the master_categories_id on each product but this would not do the subcategories as that is not immediately realted ...

UPDATE products SET products_price = products_price * XX.XX where master_categories_id = YY;

where XX.XX is the percentage to update the price and YY is the Master Category that the Products belong to ...

Hi,

Can you please say me how to change price for sub-category in place of master-category as you given above.

~ Time