Joomla Extensions by Joomdonation

How to increase all product prices by 10%

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
8 years 11 months ago #78933 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic How to increase all product prices by 10%
Thank you Davide!

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

More
8 years 10 months ago #80685 by Juan Carlos
Replied by Juan Carlos on topic How to increase all product prices by 10%
By manufacturer:
UPDATE #__eshop_products SET product_price = product_price + product_price * .10 where manufacturer_id ='#'

By category I can not find the way, sorry

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

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
8 years 10 months ago #80856 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic How to increase all product prices by 10%
Hell Juan,

You just need to replace # by ID of manufacturer ID. Did you try?

Sincerely, Giang

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

More
8 years 10 months ago #80893 by Juan Carlos
Replied by Juan Carlos on topic How to increase all product prices by 10%
Thanks Giang
Great.

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

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
8 years 10 months ago #80936 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic How to increase all product prices by 10%
No problem at all Juan!

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

More
8 years 8 months ago #83134 by Rupinder Singh
Replied by Rupinder Singh on topic How to increase all product prices by 10%
Hi there

I myself could not find eshop_products table using phpmyadmin

Am i missing something?

regards

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

More
8 years 8 months ago #83143 by Rupinder Singh
Replied by Rupinder Singh on topic How to increase all product prices by 10%
Just found it, may be just a beginner level gotcha,

Just in case someone else stumbles over it, "Left hand Pane in PHPmyAdmin' only shows handful of tables for wach schema on first page, you need to select Page number on top of left pane under eahc schema to see other tables and databases
The following user(s) said Thank You: Giang Dinh Truong

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

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
8 years 8 months ago #83157 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic How to increase all product prices by 10%
Thank you Rupinder!

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

Moderators: Giang Dinh Truong

Support

Documentation

Information

Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.

Connect Us