Delete Items and Make Items Inactive

Posted by Lisa on January 27, 2009, 10:57 am

Please log in for more thread options

I am not the best with SQL statements. I know to backup first before trying
this.

First - A few years ago I uploaded a distrbutors catalog into our database
so our employees would know how much a item was if it was special order.
This was thousands of items. Therefore I have thousand of items that have
never been ordered or sold. I want to delete these items with a SQL
statement possibly?

Second - I would like to make items inactive that have not been sold since
12/31/2006 if possible.

If I do both of these items won't it make it faster on searchs? Or does
deleting the item make it faster?

Thank you for your help

Posted by DRS Support on January 27, 2009, 5:57 pm

Please log in for more thread options

Yes, your searches and reports will run faster.

DRS Tools installer: www.digitalretailer.com/files/DRSToolsSetup.zip
Installer password: dt033108

Select Maintenance, Mark Inactive and change date in upper right to match
you criteria, then press F5 to view the list.
Select Mark All, enable "Remove matrix class orphans" if you use matrix
items, and click Save.
When hourglass stops you are done. Press F5 to refresh (no items will list
unless you set cut-off date to a more recent date).

Select Maintenance, Delete Items, and press F5 to view all items that were
never used for over 1 year.
Select Mark All, Save.

Digital Retail Solutions
www.digitalretailer.com/RMSaddins -- v1.x/2.x compliant add-ins from $49
Trial downloads -- www.digitalretailer.com/trial
Search this newsgroup -- http://tinyurl.com/2lmk4w

>I am not the best with SQL statements. I know to backup first before

>trying

> this.

> First - A few years ago I uploaded a distrbutors catalog into our database

> so our employees would know how much a item was if it was special order.

> This was thousands of items. Therefore I have thousand of items that have

> never been ordered or sold. I want to delete these items with a SQL

> statement possibly?

> Second - I would like to make items inactive that have not been sold since

> 12/31/2006 if possible.

> If I do both of these items won't it make it faster on searchs? Or does

> deleting the item make it faster?

> Thank you for your help