Zen Cart Logo
Forums / Setting Up Specials and SaleMaker / Removing Special Price Site Wide

Removing Special Price Site Wide

Locked

Views: 2,095

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
1 May 2009, 12:00 AM
#1
seanscully avatar

seanscully

Zen Follower

Join Date:
Apr 2006
Location:
Largo, Florida USA
Posts:
99
Plugin Contributions:
0

Removing Special Price Site Wide

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
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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