Overview
The current customer merge mechanism has changed from using Product Customer ID (CID) to Global Customer ID. This article provides the instructions to get the Global CID that can be obtained either from the CloudOps team or through a ticket with the Support team.
Procedure
Run the following queries in the DB (DCP authdb database)
To get DCP instance Phoenix ID
select customer_id from admin_products where linked_customer_id="phoenix_CID" and product_id=5; -
The customer_id generated from this query can be considered the customers DCP Phoenix instance ID
To get DCP instance inSync ID
select customer_id from admin_products where linked_customer_id="inSync_CID" and product_id=4; -
The customer_id generated from this query can be considered the customers DCP inSync instance ID
Using the customer_id (DCP instance ID's) that were obtained from the previously made queries, we can get the Global CID.
select id, name, global_id from customer where id in (DCP Phoenix instance ID, DCP inSync instance ID);
The following is an example of the above queries in the case of account Hydrite chemical.
Their Customer ID for Phoenix is 19
Their Customer ID for inSync is 1812
From DCP authdb database
To get DCP Phoenix instance ID
mysql> select customer_id from admin_products where linked_customer_id="19" and product_id=5 limit 1;
+-------------+
| customer_id |
+-------------+
| 12 |
+-------------+
Hence the DCP Phoenix instance ID is 12.
To get DCP inSync instance ID
mysql> select customer_id from admin_products where linked_customer_id="1812" and product_id=4 limit 1;
+-------------+
| customer_id |
+-------------+
| 4394 |
+-------------+
Hence the DCP inSync instance ID is 4394.
The DCP Phoenix instance ID and DCP inSync instance ID values are then used in the final query as follows:
mysql> select id, name, global_id from customer where id in (12, 4394);
+-----------+-------------------------------------------+---------------------------------------------------------------+
| id | name | global_id |
+---------+------------------------------------------+---------------------------------------------------------------+
| 12 | Hydrite Chemical | 447179bd-4eca-4d81-81c2-4e9c7588fe33-12 |
| 4394 | Hydrite Chemical - inSync | 439cbad7-01ce-4f95-aa65-a5c2e415f2fd-4394 |
+-------+---------------------------------------+---------------------------------------------------------------+
Next Steps
The Global ID values that are returned in the above query can be then shared with SD and they will follow the exact same steps as previous for the merge. Refer DCP Account Merge Doc for the complete merge process.
The only change is that they need to replace the inSync and Phoenix Product Customer ID with the above Global ID's.