Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Location
    Largo, Florida USA
    Posts
    95
    Plugin Contributions
    0

    Default 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?

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    64,886
    Plugin Contributions
    6

    Default 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:
    Code:
     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 ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

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

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

 

 

Similar Threads

  1. Replies: 1
    Last Post: 3 Dec 2008, 04:55 PM
  2. Removing price from special box
    By roy(irishtaxi) in forum Setting Up Specials and SaleMaker
    Replies: 0
    Last Post: 4 Jun 2008, 05:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •