The 'Magento Customer to NetSuite Customer Add/Update' data flow brings in customer information from Magento to NetSuite. The flow supports both 'create & update' operations and includes basic customer details, default billing & shipping addresses. For example, when a customer is created or updated in Magento, the Integration App exports the records into NetSuite instantly. If the record already exists in NetSuite, the corresponding data is updated. If the customer does not exist in NetSuite, a new record is created and associated with the order placed.
The Integration App provides 'Advanced Settings' to enable you to customize the data flow. Refer Order Import data flow to view the advanced settings and to understand how to operate the Integration App.
NOTE ABOUT CUSTOMER IMPORT SETTINGS
Order imports fail if customer record with same ID already exists in NetSuite
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 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.