Out of stock at the end

  • Posts: 229
  • Thank you received: 13
3 weeks 4 days ago #372036

-- HikaShop version -- : 6.4.1
-- Joomla version -- : 6.1.0
-- PHP version -- : 8.3

Hi. how can i display my products by their creation date, but out of the stock products to be at the end of the list ?

Please Log in or Create an account to join the conversation.

  • Posts: 85733
  • Thank you received: 14061
  • MODERATOR
3 weeks 4 days ago #372037

Hello,

There is no built-in option to keep the date sorting while sending out-of-stock products to the end, the "Display out of stock products" setting is only a yes/no toggle. It can be done with a small HikaShop plugin, though.

First, set your listing or menu "Sort by" to the creation date the way you want it. Then create a HikaShop plugin (in the "hikashop" group) with this method, which adds an out-of-stock criterion in front of your existing sort:

public function onBeforeProductListingLoad(&$filters, &$order, &$obj, &$select, &$select2, &$a, &$b, &$on)
{
    // Push products with a quantity of 0 to the end, keeping your date sort within each group
    $stock = '(' . $b . '.product_quantity = 0)';
    if (stripos($order, 'ORDER BY') !== false) {
        $order = preg_replace('#ORDER BY\s+#i', 'ORDER BY ' . $stock . ', ', $order, 1);
    } else {
        $order = ' ORDER BY ' . $stock;
    }
}

The result is "in stock first, then your creation-date order" within each group. Two notes: only products whose quantity is exactly 0 are moved, so products that do not manage stock stay where the date sort puts them; and a product that is out of stock only through its variants (while its own quantity is not 0) will not be moved, since this looks at the product's own quantity.

If you are not comfortable creating a plugin, your developer can set this up quickly.

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum