Merge customers from two different stores

I have had plenty (OK, too much) experience with merging accounts at the Store Ops level. The KB article on this topic includes the necessary queries and it seems to work just fine.

Today I came across my first duplicate customer where the second account was created at another store.

Is there a way to merge the purchase history & A/R for two accounts from separate databases?

Tom

Reply to
Terrible Tom
Loading thread data ...

I have had plenty (OK, too much) experience with merging accounts at the Store Ops level. The KB article on this topic includes the necessary queries and it seems to work just fine.

Today I came across my first duplicate customer where the second account was created at another store.

Is there a way to merge the purchase history & A/R for two accounts from separate databases?

Tom -- The worst words in business: "We''ve always done it that way" -- Stop Fishing for eMail.

Reply to
Jeff

Jeff,

After considering your suggestion and looking at a few tables, I think that I can accomplish my goal by performing the KB procedure on both SO databases. With global customers, both customer records exist in both databases. If I merge the records in both DBs, the 401s should take care of the rest.

I will proceed and let you know how it goes...

Tom

"Jeff" wrote:

Reply to
Terrible Tom

It worked.

Thanks to my WAN, I was able to connect to the remote store DB with SO Admin and run the queries remotely. After both stores completed a 401, the accounts look exactly like I'd expect if I had merged two accounts from the same store.

Of course, if you have lots of stores this could be quite a process...

Tom

Reply to
Terrible Tom

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.