Random "Out of stock" in product listings price-drop

[afi1]

Hi!

 

First time writing here... after many helps received on the forums.

 

In my site, at the price-drop page in the Spanish translation, each time I refresh (F5) it, a different product is shown in the product listings as out of stock, when the product DOES have stock available.

 

You can find the Spanish Version Here, you can see that each time you refresh the page, a different product is shown as out of stock

http://www.puppylicious.com/mx/promocion

 

In English, I don't have that issue (saddly for now, 95% of my customers are spanish speakers...)

http://www.puppylicious.com/en/prices-drop

 

My PS version is 1.5.3.1

and I'm using a custom template, so any guidance where to start digging in would be really helpfull

 

Tks!!!

[mfedorets]

Hi, as I could see all your products use attributes.

When products list is rendered Prestashop tries to query information about default attributes combination and when customer is trying to order a product from product list not from product page - default combination will be ordered.

 

For some reason every page update produces different information about attributes stock - if you looked carefully you should observed the "Out of stock" title is always accompanied by "Product available with different options" titles - system wasn't able to query information about default attributes combination and as consequence enforce customer to visit product page.

 

It may be a bug in SQL query so you could register this issue in Prestashop Bugtracker.

 

As temporary solution you can use setting to always enforce users to visit product page if product has attributes: Preferences -> Products -> Display the "add to cart" button when a product has attributes (No).

Edited August 23, 2013 by mfedorets (see edit history)