Author Topic: Personalized topten (top10) / most sold products for loggedin-users  (Read 200 times)


  • Jr. Member
  • **
  • Posts: 262
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable

I have a shop that is without prices. My B2B users can order stuff, that will be created in e-conomic and that way get priced.
Since i have "free" products in the shop (no pricing) the only way i can get the topten-feature to work is by commenting out the where part.
Code: [Select]
case 'topten':
$orderBy = 'ORDER BY p.`product_sales` DESC, p.`virtuemart_product_id` DESC'; //LIMIT 0, '.(int)$nbrReturnProducts;  //TODO set limitLIMIT 0, '.(int)$nbrReturnProducts;
$joinPrice = true;
// $where[] = 'pp.`product_price`>"0.001" ';
This will make all products show up as long as they are on product sales.
What i want to achieve is make sure that the most sold products for logged in users are shown instead of the "global" topten.
Can anyone tell me if this is possible in the current settings menu or do i need to make my SQL different to make sure that p.product_sales only contains data from orders that have a certain user_id?

Best regards,

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4168
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Personalized topten (top10) / most sold products for loggedin-users
« Reply #1 on: February 12, 2020, 15:34:56 pm »
I have a module that should work in your case.
If not, i can add  the option.