Whenever we are clicking on a Product on Admin site, we are getting this Error.
Exception #0 (Exception): Item (Magento\CatalogInventory\Model\Stock\Status) with the same ID "1" already exists
-
Check duplicate entry in catalogInventory_stock_status table.– Sohel RanaCommented Jun 8, 2018 at 17:39
-
i already checked that. There is not duplicate entry. But there are 4-5 entries of each product but with different stock_id(1,2,3,4,5)– Mind_blowCommented Jun 9, 2018 at 1:15
-
Take backup then remove Row number(2,3,4,7 and 8). Then try after reindex.– kunjCommented Jun 9, 2018 at 3:04
-
i deleted these records and then did the reindex. Reindex again created those deleted record !!! Still getting same error.– Mind_blowCommented Jun 9, 2018 at 14:22
Add a comment
|
1 Answer
It occurs when you have duplicated entries in your stock status collection.
If you customized the catalog/product page, try to debug your stock status collection, or turn on the mysql queries log and see if have duplicated ids in the last logged query.
answered Jun 8, 2018 at 18:03
-
1Thanks @douglas-ianitsky Please explain a bit in detail. It will help me to Resolve. I have also attached the pic of DB table catalogInventory_stock_status Commented Jun 9, 2018 at 1:18