Removing Special Price Site Wide

1 May 2009, 12:00 AM

Zen Follower

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

4 May 2009, 5:02 PM

Oba-san

Re: Removing Special Price Site Wide

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 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!