1. Home
  2. Point-Of-Sale Software
  3. Database Cleanup/Revamp

Database Cleanup/Revamp

We are starting a new contract, and I will be adding new stores. However, we will not be selling all the merchandise that we had in the previous stores. What is the BEST way to rebuild my database without starting over from scratch?

My thought is to do the following:

-Choose one of my exisiting stores with the most data

-Break the HQ connection (USing instructions from Customersource)

-Ddelete all sales data, and old cashers, etc. I would LIKE to purge all items that have not sold in the past year and is not in a warehouse.

Once I have everything setup how I need it, we will use this template to populate the new HQ and thus the new stores.

Question I have is...What is the best way to purge all the unwanted items and keep all my databases and tables intact?

If there is a better way please advise. As always thanks for all help and assistance.

Ace Laidler

Reply to
Anthony Laidler
Loading thread data ...

If you have HQ create a store in HQ. Go to item tab andchangeth re-order point and restock level for those items you do not want in this store to ZERO. But at least this way if an item gets transferred accidently to a store you get no errors. As for purging old data just make them hidden and do not worry about them as SQL can handle larger database.

Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm = = = = = = "Anthony Laidler" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Afshin

Thanks for your response. I would like to reduce the size of my database since I would be going from 12000 items to about 5000 items. That is why I didn't want to keep all the old data that I would never sale again.

Any other ideas or suggesti> If you have HQ create a store in HQ. Go to item tab andchangeth re-order

Reply to
Anthony Laidler

I have not done this, yet... But there is a "last sold" date field for each item (on the inventory tab). My plan would be to not worry about it yet...

12K is not that much... I have 40,000 items. At some po> Thanks for your response. I would like to reduce the size of my database
Reply to
EricJRW

Reply to
Anthony Laidler

You could easily enable the "Block sales of this item" and "Item is inactive" options under Options on the Item Card properties in SO. that way the item is inactive yet available in the database so no orphaned records when doing reports and it will not be sold at POS. Deleting items is not and should never be a solution to managing items in RMS. How I wish that delete button could be permanently deleted in RMS both HQ and SO..... :-(

"Anthony Laidler" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
David

Well you can deactive the delete button if you set the security on it so that no one has access to it. Not sure about HQ... I've yet to install that.

Good point on relations... Need to think about that... Had not notcied the "do not sell" option before... Knew about inactive... But I like the DNS option... But I've got another probelm where my items db is "full" at ~40,000 items. I've got another post on that (you'll find it you search my name, I've not that many posts). It's not a big priority, as in this case the manager needs to delete items... But still, not sure why I have over a million transaction yet only 40K items...

Eric

"David" wrote:

Reply to
EricJRW

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.