How to increase all product prices by 10%

Please Log in or Create an account to join the conversation.

Please Log in or Create an account to join the conversation.

Please Log in or Create an account to join the conversation.

Replied by Davide on topic How to increase all product prices by 10%

I don't remember an option, there are option only for discount. You can use a MYSQL query:

UPDATE #__eshop_products SET product_price = product_price + product_price * .10

If you use special price or group offerts you must update all table

PS Replace #__eshop_products with your table name and backup DB first

Please Log in or Create an account to join the conversation.

Replied by Terry Rugg on topic How to increase all product prices by 10%

Thank you for your reply Davide.

Yes I'll back up DB and then give that a try.

Thanks, Terry

Please Log in or Create an account to join the conversation.

Please Log in or Create an account to join the conversation.

Replied by Terry Rugg on topic How to increase all product prices by 10%

Hi Davide and Giang,

Just to note, yes - that worked perfectly using the SQL query.

Thank you

Please Log in or Create an account to join the conversation.

Please Log in or Create an account to join the conversation.

Replied by Lee Hughes on topic How to increase all product prices by 10%

I'm in phpMyadmin now and I am trying to find the table for my products, I want to change prices for all products in a certain category. I can't find it in the tree

Please Log in or Create an account to join the conversation.

Replied by Davide on topic How to increase all product prices by 10%

#__eshop_products: products
#__eshop_productcategories: categories for single product
#__eshop_categories: categories
#__eshop_categorydetails: categories name

Please Log in or Create an account to join the conversation.