Could someone tell me if there is a way to totally remove old items from a store database in a batch mode instead of deleting one by one? I am setting up 3 new stores to open, I am creating each new store's database from an existing store since all of our settings and receipt templates will be the same at the new stores. Since the new stores will not carry most of the items already in the database I would just like to delete the 90% the will not be using and leave the 10% percent they will use. Any help doing this would be appreciated. TIA!
Delete Old items & Catgories from store database
Mar 26, 2008
1 Replies
Hi Jett - here's some thoughts
You can use SQL commands to delete in batch mode but before going this route, I would try exporting your items from your existing store operations database to excel, deleting items there, (ie run an item quantity report then export to excel) then use a tool like the microsoft import utility (QSCIMPORT) which you can get from CustomerSource. If you don't have access to customersource, you may want to engage an RMS-certified partner to help you with this. If you give them the final import spreadsheet, its not even an hour's worth of labor to create your new databases.
H> Could someone tell me if there is a way to totally remove old items from a
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required