Removing Special Price Site Wide

[seanscully]

Can anyone shed light on a shortcut to removing all my Special Price Info without having to open each item one by one?

[Ajeh]

ALERT: THIS WILL DELETE ***ALL*** YOUR specials.
If your Specials are all set with the Specials in the specials table, you can empty it with:

 TRUNCATE TABLE specials;

You can run that in the Tools ... Install SQL Patches ...

NOTE: backup your database ...