change default combination if out of stock

[bostamaster]

Hello;

I want to change the default product combination automatically if it is out of stock.

I think it is an important feature that prestashop should have.

Any Idea? thank you.

[carlosmartinez]

some problem here

[ufikas]

Same here. Any solutions around?

[Cabaskrilla]

Has anybody found a good solution to this yet?? Having same issue

[Cateye]

Hi everyone!

 

I was about to start a same topic!

 

On my shop, on Categories pages, the products out of stock go at the end of list by modifying the Category.php class (prestashop v1.4.3):

 

      if ($random === true)
      {
         $sql .= ' ORDER BY (p.quantity > 0) DESC, RAND()';
         $sql .= ' LIMIT 0, '.(int)($randomNumberProducts);
      }
      else
      {
         $sql .= ' ORDER BY (p.quantity >0) DESC, '.(isset($orderByPrefix) ? $orderByPrefix.'.' : '').'`'.pSQL($orderBy).'` '.pSQL($orderWay).'
         LIMIT '.(((int)($p) - 1) * (int)($n)).','.(int)($n);
      }

 

 

If someone knows how to do the same on Manufacturers, products on sale, new products pages, I would be really happy just like Pharrell Williams sings

[Attrexx]

Since this is a feature that should have been implemented in the PS core functionalities and for over 2 years NO solutions were given except 2 paid modules, I am going to SPAM all the threads that address this matter.
I am sorry but it doesn't seem fair at all that such an important base feature is made available via paid module when it should have been rolled out in a PS update long time ago   
 

I've seen so many PS stores losing customers because they see an Out of Stock message on a product that actually HAS stock on other combinations. It's already beyond ridiculous, this silence of the PS staff.
 

This a call of desperation to the PS staff, of a lot of PS users, not just mine.

Let the solution reveal itself at last!

#MegaBump

[tomerg3]

A bit late, but we will have a free module for this released in the next couple of days, stay tuned,

[tomerg3]

This module has been released, more information at https://www.prestashop.com/forums/topic/1011838-free-module-out-of-stock-combination-change/

 

[DanielaPetkova]

Give that man a beer - it works as should be by default. Thank you very much for the module.