Personalized topten (top10) / most sold products for loggedin-users

[welrachid]

Hi
J!3.9.14
VM3.6

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.
./administrator/components/com_virtuemart/models/product.php

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.
now..
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?

Thanks!

[Studio 42]

HI,
I have a module https://shop.st42.fr/en/products/products-any-ways.htm that should work in your case.
If not, i can add  the option.

[welrachid]

Hi.
Ok i'll buy the plugin. Does it support "ordered by this customer" if customer is logged in, else use "top 10 sales".
remmeber that my products are all "0.00" price value.
Is it correct understood that if you need to make updates/changes to the plugin, it does not require extra costs?

[Studio 42]

The module do not check for price the query use the user ordered items
About display  "top 10 sales" OR "ordered by this customer" ,you have a setting in the module : Access
Select "guest access" for top 10 and "registred access" for "ordered by this customer". (his is a native Joomla feature)

[welrachid]

so i male two modules, one for registered and one for guests. correct?

[Studio 42]

so i male two modules, one for registered and one for guests. correct?

YES