News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

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

Started by welrachid, January 08, 2020, 01:32:37 AM

Previous topic - Next topic

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
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!
Best regards,
Wel

Studio 42


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?
Best regards,
Wel

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?
Best regards,
Wel

Studio 42