I am using Magento 2.3.2. When i am tring to add Customer Group Price for child product of configurable products in admin panel then i am getting below error when save the product:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '16092-1-0-30.0000-0' for key 'UNQ_6D3040166530765494A77D7288801D79', query was: INSERT INTO catalog_product_entity_tier_price (entity_id, all_groups, customer_group_id, qty, website_id, percentage_value) VALUES (?, ?, ?, ?, ?, ?)

but it's working for Simple Products as expected.

I am not able to understand why i am getting this error.

Once i have truncated that table but still getting Integrity constraint violation: 1062 Duplicate entry

Any help??

enter image description here

1 Answer 1


First of all, you can't add the tier price or even price for configurable products(except custom extension). If you want to add tier price for the configurable product then you need to add it in the child product.

Please check this and let me know if you need further information.


  • yes you are right, I mean when i adding tier price for child product of configurable product then i am getting that error but now i test this issue is coming with every product. Nov 27, 2019 at 17:36
  • Let's do basic steps first, do indexing with reset and reindex all command and see if you are getting this issue or not.
    – Nits
    Nov 27, 2019 at 17:38
  • i have done that steps many times and also delete that particular record from table catalog_product_entity_tier_price but still not working Nov 27, 2019 at 17:46
  • Now try to remove third party extension and see it is working fine or not. If still it is not working then let me know I will help you in this. Email Me: [email protected]
    – Nits
    Nov 28, 2019 at 6:14
  • After disable third party extension (Magesales_MultiStoreViewPricingTierPrice) its working for me. Thanks for the suggestions. happy coding...!!! Dec 2, 2019 at 19:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.