When I trying to re-index salesrule_rule index, It gives me bellow error and the sales rule grid is not loading in magento admin. Please advice.

Item (Magento\SalesRule\Model\Rule\Interceptor) with the same ID "165" already exists.

Attached is the MySQL result when I run query to see all the rules having 165 as rule_id

enter image description here

  • did you migrate your data? run the following in your phpmyadmin select * from salesrule where rule_id = 165; and if you can update the above question with the results then i can give you a more accurate solution – Dava Gordon Sep 16 at 16:24
  • Hi @DavaGordon, highly appreciate your prompt reply. I updated the question with information you requested. – Ajith Sep 17 at 16:29
  • DavaGordon, I didn't migrate any data recently. – Ajith Sep 17 at 16:36
  • row 443 and 477 look like they could possible be the issue you are having as they have the same date ranges – Dava Gordon Sep 18 at 10:11
  • Dava Gordon, I removed above rules one by one and had no luck. I then removed all the rules with rule_id=165. Then issue fixed :) needed rules re-created. Thanks a lot for guidance – Ajith Sep 18 at 17:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.