Order imports into NetSuite sometimes fail when customer records with same Customer IDs are already present in NetSuite. You may see the following error:
"Failed to add/update customer for order #1xx1. 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 and enter a new customer ID in the Customer field."
In the following example, note the field CUSTOMER ID. If another customer comes with the same name, customer creation will fail.
This error occurs because the Auto ID feature in NetSuite is not enabled. Note that the customer name is used to to create the Customer ID. Any time a new customer comes with a name that already exists in NetSuite, customer creation will fail. To avoid such errors, please enable the Auto ID generation feature in NetSuite.
To set up auto-generated numbers in NetSuite, go to the link ‘Set up Auto-generated Numbers’ (or click https://system.na1.netsuite.com/app/setup/numbering.nl?whence=) and provide the necessary information.
Comments
This really should be a pre-requisite to initial setup in the Celigo 'Orders' documentation. Most companies will be selling at a retail level on Ebay and therefore will often get people with the same name.
I came across the issues at the very end of implementation which has now halted my work until I can review all of the effects of implementing the solution.
Please sign in to leave a comment.