Several questions about managing my databases

May 28, 2006 1 Replies

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


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:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required