1. Home
  2. Point-Of-Sale Software
  3. Several questions about managing my databases

Several questions about managing my databases

Several questions:

  1. I have a store where several accounts were setup for the same customer. Is there a way to merge all the sales history data to 1 account and purge the other account.

  1. When I imported my data from QS2000 my customers all got new ship to addresses. I don't have any ship to addresses how can I remove them all from my database?

  2. I want to purge from my database all the items that have not sold in the past 3 years. I have non in stock and I am looking for an automated way to do this. I have over 75,000 items in my database and going through it manualy is almost imposible.

Thank you in advance for your help

Reply to
David H.
Loading thread data ...
1 - Not possible in a way that is easy. 2 - contact me and I will send you a SQL script to do this 3 - Though this can also be done with SQL script I do not recommend this as we must ensure that there are no orphan records left behind. However, at Retail Realm we havea utility to do this. Contat me for detail.

Afsh> Several questions:

Reply to
Afshin Alikhani

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.