when edition the product for the backend, I faced the unique constraint violation found in the Magento-2.3 . I have checked the exception log this shows

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '404-0-4-1.0000-0' for key 'UNQ_E8AB433B9ACB00343ABB312AD2FAB087', query was: INSERT INTO `catalog_product_entity_tier_price` (`entity_id`, `all_groups`, `customer_group_id`, `qty`, `value`, `percentage_value`, `website_id`) VALUES (?, ?, ?, ?, ?, ?, ?) 
  • Set Price Scope to Website (Stores -> Configuration -> Catalog -> Catalog -> Prices)-> Set the Price Scope website to Global. – Divya May 28 at 4:20
  • It solved my issue. – Divya May 28 at 4:20

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.