I have something like a few hundred items i need to make inactive.
Before i make these items inactive, is there a report or script that i could run to see when the last these items were sold so i would know exactly which items i want to make inactive.
Also, is there an easy way to make items inactive by running a script that looks for items that have never been sold or a date on the script that the items last sold to make these items inactive?
Any help/suggestion on this would be great. Thanks
The best way to accomplish this is go to Reports > Item> then pull up the Quantity List and just go with all records. Now you can enable the Last Sold by pressing the 5th button from the active report tool bar and go down and checked the Last Sold field press okay. Now sort the data by last sold so those items comes which are not sold and then start with selling date so on. You can filter the report to show only those items which have zero on hand quantity also. apply the 3rd button of the report for filtering the data.
Option #1 Now for the making items inactive 2 ways one you can go one by one or by manually selecting the item. Click on Wizards on the top and then select the item wizard select from the drop down the 120 Task make the item inactive. after that you have option to select the specific department, category, suppliers, manually and the filter.
Manually selecting item will help you try this and then add the item one by one. See if you are happy with it.
Option #2 Go to Store Administrator program and connect to your data base. then click on the Query Button> Click New. Type this first your verification:
Select * from item where LastSold >='2007-01-01' --list you out all the items sold after given date or put whaterever date you want.
Now Run this to make items inactive for given criteria update item set inactive=1 where lastsold>'2007-01-01' -- change the date per your requirement.
I don't think I had that many beers down in the hotel lobby (its managers night at the hampton inn in tiffin, OH)....but wouldn't the query flag as inactive items that have sold AFTER jan 1 2007 if your update query is update item set inactive=1 where lastsold>'2007-01-01' ....?
I'm thinking you'd want to set items as inactive if their date last sold is before jan 1 2007....ie flip the alligator mouth to read update item set inactive=1 where lastsold by Akber
Whether you have a few hundred or thousands of items to mark inactive, the following utility makes this easy and also cleans up orphaned class codes for matrix items.
Download our RMS Toolkit 30 Day Trial at:
formatting link
Run the installer and select DRS Tools. Run DRS Tools and connect to your HQ database if multi-store, or your Store Operations database if single store. Select Maintenance, Mark (Items) Inactive. Press F5 to view all current candidates (zero in stock, no activity in one year). Change the date if you want to view more recent items. Select Mark All if you agree with the listing, or use the filter boxes to narrow the list. Enable the checkbox option to remove matrix class orphans. Click Save and you are done. If you are an HQ user, issue a worksheet 250 for recently changed items to all stores. If you decide to purchase our toolkit you would run this routine once a month or once a year to manage your inactive items in a few clicks. You can also quickly return inactive items to active status which is handy for seasonal items carried from one year to the next.
Greg Digital Retail Solutions
formatting link
(v1.2, 1.3, and 2.0 compliant) "Save a million keystrokes."
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.