Row missing in ps_stock_available, appears only if I open a product in Prestashop backend

[absol]

Hi everyone,

I've imported several products from another e-commerce and everything works fine.

 

Everything except one detail: for some products there's not the ps_stock_available row so I can see them but for some reason I can't buy them. If I open one of them in the backend and edit Quantity > "Set Default" (I don't know why these products are set as "Refuse order") the row appears in the database and I can buy the product.

 

Is there a way I can automate this process or fix this problem?

Thanks a lot, have a nice day.

[Multipurpose]

I found this 'bug' in PS 1.6.0.14 with multistore enabled. Only the rows of product combination are added in the shop you're currently working. If shop ID=1 is set, only rows for shop ID=1 are set in ps_stock_available.

You will have to manually edit the quantities in shop ID=2 to 1 and then back to 0. The rows are then added and set to 0.

 

absol, are you using multistore? Are you using product combinations? Which PrestaShop version are you using?

 

Apparently, the ps_stock_available will only work well if you set the shop correctly (probably "all stores" is the only one working) AND if you do not use the import function of PrestaShop.

 

This is definitely a bug in PrestaShop. Does anybody know if this was fixed in a version after 1.6.0.14?