Martan.from.The.Mars Posted April 24, 2014 Share Posted April 24, 2014 We could use some help here, which i believe could be useful for other community members Running 1.6.0.6, but it will be probably same on older versions. How do I set default combination/attribute based on stock and lowest price of that ccombination? Facts: We sell used items = products which cannot be reordered on demand We sell only items on stocks We are using combinations on most of our items (thousands) We are using only one combination/attribute group, with several values (>10) We are often running to situations, where default combination is soldout and Prestashop is not able to trigger change on another combination, which is also on stock and set new default variant. When no default combination is set, it shows wrong product pictures and prices until we set new default combination manually...This is really insane in such large catalog Can somebody (maybe VEKIA) offer some solution, lets say SQL statement, or SQL trigger, which can search products without default combinations and set them right? For our needs, it should be like this: 1) find combination with lowest price, which is also on stock (quantity>1) 2) set new default combination based on above criteria If it is possible, can it be triggered somehow, or run periodically to catch latest changes? Every help will be much appreciated Martin Ruzek 1 Link to comment Share on other sites More sharing options...
Recommended Posts