"..., if the retailer already has three stores, running independent copies of Store Operations Manager, you have to decide which Store Ops database is the most complete and reliable, as the HQ database is created from a Store Ops database. The other two stores will then inherit their item list from a store exported from HQ. The primary reason for this is that all stores need to have the same identifier for centrally managed data (ie, items)."
Does Microsoft have any tools to help merge data from existing Store Operations databases into a common Headquarters database? There are more than just items which need to be centrally managed in HQ; there's departments, categories, reason codes, tax codes, tender types, suppliers, and that's just off the top of my head.
Customer also need to come up to HQ. They do originate at the store, but if the same customer was added at two diffferent stores, and assuming they want to use global customers, is there any tool to allow you to merge these two customers into one? I don't expect this to be a single SQL script or one-click tool, but something to let you compare customer records on common fields, review the ones with the same or similar information, then decide which one to keep.
There's also the matter of bringing sales history from these stores together. since the sales at the store originated with item and customer info which wre not previously in HQ, any transaction history I try to bring in will reference the customer and item ID at the store, not the one created by HQ.
Again, I'm looking for tools that are available from Microsoft or are downloadable from PartnerSource. If I need to buy a third-party tool form someone, I'll go ahead and develop these SQL scripts and tools of my own.
-- Bill Yater Blue Horseshoe Solutions snipped-for-privacy@bhsolutions.com