Knowledge Base Article

 Knowledge Base Index :   Custom SQL Queries


How to delete all specials from Inventory -> Edit Specials

These instructions will delete all specials from Inventory -> Edit Specials. Make a TRS backup before doing this or any mass edit.

  1. In TRS, go to File>Manual SQL Update. Enter your security code when prompted and click Yes to the warning message.
  2. Copy and Paste the following SQL command into the form.

  3. delete from prodspecials

  4. Click "Execute!" to run the query.


Article Details
Date Created December 26, 2013
Author Robert Pirone
Article Options [e-Mail this Article]     [Print this Article]     [Bookmark Article]


© Copyright JMM Software, Inc.
http://www.jmmsoftware.com/