Specials products shows Out of Stock

[logan1ro]

The products in specials category always shows Out of Stock. Even the manufacturers, supliers and best sellers categories shows the same.
Any solutions?

Thank you.

http://www.toscanamall.com/en/prices-drop
http://www.toscanamall.com/en/best-sales

[kelvinlym]

I'm having the same issue but with the manufacturer module. I'm using the prestashop default theme. No changes except for deleting the stock movement data from phpmyadmin (only the default data with the ipods and macbooks).

Also I've changed the "Manufacturers" block to "Catalogues" using the translation tool at the back office. But I doubt that will cause any issues.

@logan1ro, just to see if we have similar issue, did you delete the stock movement database values through phpmyadmin too?

If stock management is not an issue, allowing customers to order out of stock items will solve this problem. However, if stock management is important, then I hope someone can help shed light on this bug.

Thanks

[logan1ro]

The stock is an issue to me

Any ideas?

[kelvinlym]

@logan1ro Did you delete any stock movement data from your database?

[VNguyen]

Friends,

Which version of PS you are using now for that trouble?

Regards,
VNguyen

[kelvinlym]

version 1.4.017

I found this issue already reported in the bug tracker.

[logan1ro]

My version is 1.4.017. I didn't delete the stock movement data.
You mean like DROP TABLE or tables (stock_mvt, stock_mvt_reason and stock_mvt_reason_lang)?

[LEDestock]

I'm having the same issue with the same blocks , I fixed the manufacturer block using this method :

The problem can be resolved by making the following modifications in the file : classes/Manufacturer.php, function getProducts (line 268) :

REPLACE :
(p.`price` * ((100 + (t.`rate`))/100)) AS orderprice

BY
(p.`price` * ((100 + (t.`rate`))/100)) AS orderprice, pa.`id_product_attribute`

and insert the line
LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1)

after the last existing LEFT JOIN :
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`

I don't know how to fix the other blocks..

[logan1ro]

Not a solution for me...sorry

[hups]

Has anyone found the solution to this yet?
Having similar problems in the manufacturers block. Some of the products are showing ut of stock but if you click on the actual product it then shows in stock. This will scare customers away though as they will see out fo stock first.
Can't work out why some of the products show out of stock and some show in. Thought if it was a specific problem then they would all show out of stock...

p.s I haven't deleted anything from my php admin. All I changed was the manufacture.tpl file so that it shows an image and a description for manufacturer.

[logan1ro]

Any solutions?

[Allyt]

Well interestingly I have just come across this little issue too. Price drop / specials when listed in the centre column as price drop, are displayed as included in the on sale / reduced price products but display out of stock.

 

I compared the products that were in stock in the same list with those showing out of stock and the only significant difference was the use of combinations.

 

Having stocked the shop with 3 products that are each available in a different size, managing the stock by those combinations, my 'in stock' items displayed in the price drop listing had the default combination at the top of the combinations set list. In other words the first combination that was added to that products combination list was the selected default.

 

If however, the 3rd or 4th combination is selected as the default, the price drop listing displays 'out of stock' for that item, albe it when viewing the product in other areas of the shop, it is available for purchase as it is in stock.

 

The work around therefore is to start again with stocking the combinations listing

 

Hope this helps someone else on the trail of investigation

 

Ally

 

Using = PrestaShop™ 1.4.4.1