Percentage increase of price list

  • Posts: 251
  • Thank you received: 2
11 years 10 months ago #84507

How to update the price list, with a percentage increase, of the products of a category?

Thank you

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

  • Posts: 12953
  • Thank you received: 1778
11 years 10 months ago #84571

Hi Nello,

I think that you'll maybe be able to do it by using an SQL request.

Hope this will help you.

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

  • Posts: 251
  • Thank you received: 2
11 years 10 months ago #84574

Sure, but I have to do it only for a specific category...

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

  • Posts: 13201
  • Thank you received: 2322
11 years 10 months ago #84669

You will have to select the product_id from the table #__hikashop_product_category, then update the product price where product_id in the ids previously selected.

The following user(s) said Thank You: Nello

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

  • Posts: 251
  • Thank you received: 2
11 years 10 months ago #84852

I want to do it for a specific category, what I have to do?

Last edit: 11 years 10 months ago by Nello.

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

  • Posts: 2334
  • Thank you received: 403
11 years 10 months ago #85075

Hi,

Just like Xavier said above, you have to look at the id of the category you want to specify and include it in your SQL request with something like

WHERE category_id='your id'

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

  • Posts: 251
  • Thank you received: 2
11 years 10 months ago #85080

It is not so simple, because the product may contain variants with different prices are not directly connected with the category id.

It is incredible that you have not thought of a function to update the price lists...

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

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 10 months ago #85133

Hi,

It is incredible that you have not thought of a function to update the price lists...

We have in our TODO list a feature for mass actions on products. But this feature would require some development time and does not have a schedule yet.
After that, it's not that we do not thought about such feature but, there is very very few people who asked for it.
So, we focus on major features.. And I don't know a lot of shopping cart which have such feature.

After that, you can export your products and make a massive price modification with OpenOffice of Excel ; and then, import your new product prices (with just the column "product_id" and "product_prices").

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Last edit: 11 years 10 months ago by Jerome.

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

  • Posts: 251
  • Thank you received: 2
11 years 10 months ago #85142

All retailers need to update the prices, because almost every year the suppliers increased their prices by a percentage.

So I don't know why no software implements a feature so simple.

Actually, in hikashop software already exists a very similar function, the discount, which works in reverse. It would be enough to change that.

Regards

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

  • Posts: 82817
  • Thank you received: 13357
  • MODERATOR
11 years 10 months ago #85256

Using the discount system to do it would be a hack and not a long time solution. As we said, a proper feature to do that will be implemented. But it will take some time before we can do finish it. We're actually hoping to have it ready for the summer.

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

Time to create page: 0.107 seconds
Powered by Kunena Forum