Merge Customer Utility Wanted

[Terrible Tom]

I've already tried the DRS VIP Zone - it worked great, but they want $50 per
cashier for every RMS database. I have five stores, sixty cashiers in the
collective databases, and am not paying $3K + maintenance for VIP Zone. If I
could pay for my registers and an office PC or two per location, I'd be all
over it.

I have used the KB queries to merge duplicate customers but it is a tedious
process in an HQ environment. After you've indentified the duplicate
accounts you must check HQ to see which store(s) the customer has shopped at
before merging the customer records in the appropriate store ops databases.
Then you need to wait for a WS401 to run at both stores before deleting the
empty record at HQ.

What I'm looking for is a simple little utility or script for merging
duplicate customers - preferably one that was developed by some enterprising
soul that doesn't mind giving it away.

Tom

 

[Craig]

Tom,

That's surprising about Vip Zone. I bought it a couple of years ago and only
paid per lane once. They never even asked how many cashiers I have.

Craig

 

[Terrible Tom]

Yeah, it's actually worse than I thought...

http://www.digitalretailer.com/DRS-PriceSchedule.pdf

$999 for 20 registers + $100/five registers. *Registers is defined by
register list in store ops. I have five stores and several users at HQ are
listed in each store ops database so I'd pay for some users five times.

I guess the price isn't horrible, but we're in the retail furniture &
appliance business. My biggest store just had our worst May since 2000. My
smallest store had their worst May on record. To say that I don't have any
extra cash is an understatement.