The BigCommerce - NetSuite integration app creates NetSuite customer records for the buyers on your BigCommerce orders, and the BigCommerce Customer to NetSuite Customer Add/Update flow can also sync your BigCommerce customers to NetSuite on a schedule. This article explains which customers sync, how the integration app matches guest orders to existing customers, and the setting that syncs all customers. It's for integrator.io users who manage customer data between BigCommerce and NetSuite.
Which customers sync
By default, only new customers are imported, when they place an order in BigCommerce. Editing a customer in BigCommerce doesn't trigger a sync to NetSuite.
To sync all BigCommerce customers to NetSuite with the BigCommerce Customer to NetSuite Customer Add/Update flow, including customer sub-resources such as attributes, form fields, and store credits:
- In the integration app, go to Settings > Order > Order.
- Select Sync all customers, and then select Save.
If you don't need to update customer addresses, leave Sync all customers cleared to avoid performance-related errors.
To run the customer flow, go to Flows > Order, and select Run for BigCommerce Customer to NetSuite Customer Add/Update. To sync historical customers, choose a start date. For details, see Choose a start date for a delta flow.
Guest orders from registered customers
When a registered BigCommerce customer places an order as a guest, the BigCommerce Order to NetSuite Order Add flow finds the existing NetSuite customer record that has the same email address. It uses this secondary lookup criteria:
[["email","is","{{email}}"],"AND",["isinactive", "is", "F"],"AND",["custrecord_celigo_bgc_bcim_nsid.custrecord_celigo_bgc_bcim_storeid","is", "g3uzz5c7jx"]]When the lookup finds a customer record:
- If the record belongs to a guest customer, it's updated with the incoming information.
- If the record belongs to a registered customer, it isn't updated.
Note: The secondary lookup is updated automatically only if your flow still uses the integration app's earlier default lookup criteria.