Data Flow: Shopify Customer to NetSuite Customer Add/Update
Error Code: unique_cust_id_reqd
Error Message: 'Failed while creating customer, message:A customer record with this ID already exists. You must enter a unique customer ID for each record you create. To correct this record, click back and enter a new customer ID in the Customer field. Then, click Submit.'
Reason: A Customer record with the same First and Last Name already exists in NetSuite.
Resolution:
There are multiple ways to resolve this error.
One way is to enable the NetSuite 'Auto Generate Numbers' feature for Type Customer.
- In NetSuite, go to Setup > Company > Auto Generate Numbers. Under Type, enable for the type Customer.
- Then, go to integrator.io dashboard and open the Error dialog of the job.
- Select the Job and select Retry to re-run the Order + Customer Import flow successfully.
An alternate way is to go to Shopify and change the Customer record details on the Order to a different name.
Reason 2: The existing NetSuite customer is the same customer who placed the order, but its Celigo Shopify Customer Id Map entry for your store is missing.
Resolution: Restore the Customer Id Map entry. For steps, see Order imports fail if customer record with same ID already exists in NetSuite.
Important: Don't enable auto-generated numbers to resolve this cause. For an existing customer, it creates a duplicate customer record.