Show auctions in a module custom filtered

Hi,

You'll want to:
- create a HikaShop content module via the Joomla modules manager. You'll be able to have it display the products and sort them based on the "product_sale_end" (in the "ordering column" setting).
- develop a plugin of the group "hikashop" and implement the onBeforeProductListingLoad event:
www.hikashop.com/support/documentation/6...reProductListingLoad
In it, you first want to check $order so that you skip if $order doesn't contain product_sale_end (that way you only add the custom condition on your module products listing, and not on other product listings).
Then, you can run a MySQL query to get all the distinct auction_product_id from the hikaauction_auction table, and then you can add a filter to the $filters parameter like so:

$filters[] = 'b.product_id IN ('.implode(',', $auction_product_ids).')';