Customer Export

Exported customer data

• email address
• full name
• address book

Note that for states to be exported properly, they must be defined in NetSuite accordingly. While this is not an issue for US, it may be one for other countries. If you find out that specific customers cannot be exported due to states not being defined, make sure the NetSuite information at Setup->Company->States/Provinces/Countries matches the one in Magento.

Customer identifier

In Magento, the customer identifier is the email address and website id, i.e. multiple customers with the same email may exist on different websites if configured. To prevent integrity constraints, we use email_websiteId for the externalId field in NetSuite, i.e. john@example.com_1 . While the site suffix may be unnecessary for some merchants, it is there to fully support all Magento configurations. Note that the email without suffix is still stored in the email field, on which NetSuite does not impose a unique constraint.

Customer export & sync time

To honor the concept of "customer" in NetSuite, customers are not pushed from Magento when registering, but when placing their first order. After this point, customer data will be pushed again when:

• placing another order
• changing account information

Since customer data can be edited in the Magento front-end, it will always be pushed to NetSuite when changed. This means that any manual edits for the customer in NetSuite will be lost, if affecting the address book, name, or email.