how display the most sold products this year

  • Posts: 719
  • Thank you received: 3
8 years 8 months ago #252724

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2

Hi,
I'd like to show the most sold products this year on the front end of the site.
I'm be able to display that on my backend but i have a problem on the frontend
I've created an Hikashop content module and I've set it like on my screenshot.
The problem is that I have the most sold products of ever and not of this year
How can i do to have this year or in the last x months?
Thanks a lot
Best regards


my site with Hikashop
www.lacasettabio.it
Attachments:

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

  • Posts: 12953
  • Thank you received: 1778
8 years 8 months ago #252748

Hello,

There is actually no option to do that so the solution will be to directly develop it which will require development skills.

Another solution can be to reset every year the "product_sales" column of your "#_hikashop_product" table to 0 using an SQL request so that you'll be able to correctly sort your products based on the year sales.

Best regards,
Mohamed Thelji.

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

  • Posts: 719
  • Thank you received: 3
8 years 8 months ago #252841

Hi,
Have you planned to include this feature in your to do list?
Eventually I decide to do a reset every year could you explain better how to do it?
Thanks a lot
Best regards


my site with Hikashop
www.lacasettabio.it

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

  • Posts: 83995
  • Thank you received: 13605
  • MODERATOR
8 years 8 months ago #252918

Hi,

We don't have a plan for that for now.

The MySQL query would require to put in place a small PHP script or bash script that you would trigger with a cron task of your server.
I would recommend to contact your server administrator for help on achieving that.
The query itself is really easy as it's just an update to 0 on the product_sales column of the product table as mohamed explained.

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

Time to create page: 0.072 seconds
Powered by Kunena Forum