Bulk delete tier price and tier price customer group

Question

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?
– Tim Bezhashvyly
Commented Mar 28, 2014 at 16:03 — Tim Bezhashvyly, Commented Mar 28, 2014 at 16:03
That is exactly what I want.
– dasmikko
Commented Mar 31, 2014 at 6:50 — dasmikko, Commented Mar 31, 2014 at 6:50

Tim Bezhashvyly · Accepted Answer · 2014-03-31 09:32:31Z

12

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.

answered Mar 31, 2014 at 9:32

Tim Bezhashvyly

11.6k6 gold badges43 silver badges73 bronze badges

3

But before you do anything directly in the database do a database backup ;)
– David Manners
Commented May 24, 2014 at 8:45

Add a comment |

1 Answer 1