I have many duplicated rows of the same product in the Admin>Catalog>Stocks while in Admin>Catalog>Products I have only one row for the same products.
I have uploaded my products using webservice, could it be the reason/bug?
How to fix these duplicated rows?
SELECT * FROM `ps_stock_available` WHERE `id_product` = 221
returns only one row, but in Admin>Catalog>Stocks there are many rows for this product
I have removed some orphans from ps_stock_available with this SQL, but it did not help
delete FROM `ps_stock_available` WHERE not exists (select p.id_product from ps_product p where p.id_product=ps_stock_available.id_product)