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
Asked
Active
Viewed 1,283 times
1
Teja Bhagavan Kollepara
- 3,816
- 5
- 32
- 69
Mind_blow
- 31
- 9
-
Check duplicate entry in catalogInventory_stock_status table. – Sohel Rana Jun 08 '18 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_blow Jun 09 '18 at 01:15
-
Take backup then remove Row number(2,3,4,7 and 8). Then try after reindex. – kunj Jun 09 '18 at 03:04
-
i deleted these records and then did the reindex. Reindex again created those deleted record !!! Still getting same error. – Mind_blow Jun 09 '18 at 14:22
1 Answers
1
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.
Douglas Ianitsky
- 1,028
- 1
- 7
- 18
-
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 – Mind_blow Jun 09 '18 at 01:18