dynamiczip:faq:customer_combiner
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
dynamiczip:faq:customer_combiner [2015/03/06 22:27] – external edit 127.0.0.1 | dynamiczip:faq:customer_combiner [2019/03/13 18:51] (current) – conni | ||
---|---|---|---|
Line 1: | Line 1: | ||
======Using the Professional Service Tools Customer Combiner====== | ======Using the Professional Service Tools Customer Combiner====== | ||
+ | The Professional Service Tools Customer Combiner can be used to combine two customers into one. It does this by modifying all occurrences of one of the Customer ID's to the other Customer ID. This can result in a duplicate key error if Customer ID is part of a unique key in any SQL table. For example, the [[dynamiczip: | ||
- | When using the Professional Service Tools Customer Combiner to combine | + | Also, if two customers have an identical address ID, you may receive the following error on the [[dynamiczip: |
**[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ' | **[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ' | ||
- | The [[dynamiczip: | ||
- | Each record in the DZ Customer Supplement table is used to identify whether a customer is taxable or exempt. Typically, customers being combined would have the same tax status, but you may still want to validate the end result. One way you could validate would be to run the [[dynamiczip: | + | ===== Solution ===== |
- | + | If you have already run the Customer Combiner | |
- | ====Solutions: | + | |
- | + | ||
- | Prior to running | + | |
- Open [[dynamiczip: | - Open [[dynamiczip: | ||
- | - Select the duplicate | + | - Select the offending |
- | - Repeat Step 2 for each duplicate. | + | - Run the Customer Combiner tool again. |
- | If you have already run the Customer Combiner and received the above error (for the DZ Customer Supplement Table: | + | If you have already run the Customer Combiner and received the above error (for the DZ Customer Supplement Table: |
- Open [[dynamiczip: | - Open [[dynamiczip: | ||
- | - Select the duplicate | + | - Select the offending |
- | - Repeat Step 2 for each duplicate. | + | - Run the Customer Combiner tool again. |
---- | ---- | ||
- | [[dynamiczip: | + | [[dynamiczip: |
[[dynamiczip: | [[dynamiczip: | ||
[[dynamiczip: | [[dynamiczip: | ||
dynamiczip/faq/customer_combiner.1425680836.txt.gz · Last modified: 2015/05/15 15:25 (external edit)