how can get Bestsellers or Most Popular products?

[Ahmad]

@aimeos
how can I get just top 10 product, I mean I want to query that sent to mysql just get top 10 not all products?

[aimeos]

You can use slice():

Code: Select all

$cntl = \Aimeos\Controller\Frontend::create( $context, 'product' );
$items = $cntl->use( ['text', 'price', 'media'] )->product( <ids> )->slice( 0, 10 )->search();

See: https://github.com/aimeos/ai-controller ... #L158-L175

[peter69]

Hi,

In case it is useful to anyone, I have made the following function to return the best-selling products. It works with the latest version (2022.07.2) of Laravel Aimeos to date.

Code: Select all

public function getBestSellersByCategory ($categoryID, $domains, $context, $limit = 10) {
        $manager = \Aimeos\MShop::create( $context, 'order/base/product' );
        $result = $manager->aggregate(
            $manager->filter(),
            'order.base.product.productid', 'order.base.product.quantity', 'sum'
        )->slice( 0, $limit );
        // find the products which are sold most in $result (product ID is the key, count is the value)
        $cntl = \Aimeos\Controller\Frontend::create( $context, 'product' );
        return $cntl
                    ->uses( $domains )
                    ->category([$categoryID])
                    ->product( $result->keys()->toArray() )
                    ->search();
    }

This function must be in a decorator.

Regards,

[aimeos]

Very cool!

[peter69]

Thanks!!! )

[loeffe1]

I have created a decorator in \Aimeos\MShop\Service\Provider\Decorator and included this function, but how can I use it? Aren't decorators configured via the Services tab and limited to Delivery and Payment?

[aimeos]

A service decorator is the wrong place because it's only used for delivery/payment options as you've already stated.
Create a HTML client decorator for the component you want (e.g. catalog/lists) instead:
https://aimeos.org/docs/latest/frontend ... omponents/