How do you bulk delete tier price and tier price customer group?

Is it possible to do it by Magento Import or Magmi?

  • You want to delete all tier prices for all products? – user487772 Mar 28 '14 at 16:03
  • That is exactly what I want. – dasmikko Mar 31 '14 at 6:50

If it's just an occasional operation and you don't need to automate it just do:

DELETE FROM `catalog_product_entity_tier_price`;

And do full reindex afterwards.

| improve this answer | |
  • 3
    But before you do anything directly in the database do a database backup ;) – David Manners May 24 '14 at 8:45

Your Answer

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

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