[SOLVED] Deleteing Discounts

[[email protected]]

Greetings!

Currently encountered a problem: if I CSV-import new discount price for a bunch of products, it doesn't overwrite previous discount. It, actually, becomes prior to previous discount, and "activates". The previous discount price, as I already said - stays.

This means a huge problem - if I want to DELETE all the discounts. I try to import new discount price = "0" for each product, but nothing happens, it doesn't activate.

I simply cannot manually delete all the discount - there's about 3 different discount prices in each of the 1000 products.

Any way to clear all discounts? Maybe, using SQL? Where should I search for?

Many thanks for help!

[[email protected]]

This was solved by clearing ps_specific_price and ps_specific_price_priority from data.

[PascalVG]

Hi Nika,

Just for completeness sake, so others may use this: did you clear it directly in the database, using SQL?

 

Thanks,

pascal

[[email protected]]

I'm Ilya )

 

Yes, I did it by just using phpmyadmin and turncrate function in it. Not by deleting tables, but by deleteing data in them.