dynamiczip:faq:customer_combiner
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dynamiczip:faq:customer_combiner [2017/01/04 18:46] – [Solution] chuck | 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 ===== | ===== Solution ===== | ||
- | Prior to running | + | If you have already run the Customer Combiner |
- Open [[dynamiczip: | - Open [[dynamiczip: | ||
- Select the offending record and click Delete. | - Select the offending record and click Delete. | ||
- | - 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 offending record and click Delete. | - Select the offending record and click Delete. | ||
- | - Repeat Step 2 for each duplicate. | + | - Run the Customer Combiner tool again. |
---- | ---- | ||
- | [[dynamiczip: | + | [[dynamiczip: |
[[dynamiczip: | [[dynamiczip: | ||
[[dynamiczip: | [[dynamiczip: | ||
dynamiczip/faq/customer_combiner.1483555618.txt.gz · Last modified: 2017/01/04 18:46 by chuck