Import Sales Orders from BigCommerce to NetSuite
While importing a new sales order, the integration app first checks whether there is an existing sales order in NetSuite with the same ExternalID as the mapped sales order. If the search finds a match, the new order is considered a duplicate and not imported.
When you run the “BigCommerce Order to NetSuite Order Add”
you can select a start date to pull the historical data. On the pop-up window, you can either select:
- Automatic: Choose this option to process and sync data from the last flow run time.
- Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.
- Map Ship Methods: This lets you map the shipping methods between BigCommerce and NetSuite. You can also provide a default value in case no match is found.
- Map Payment Methods: This lets you map the payment methods between BigCommerce and NetSuite. You can also provide a default value in case no match is found.
- BigCommerce Order Id(s): Provide up to 5 BigCommerce order ids separated by a comma (,) and click Save for an on-demand import of orders from BigCommerce to NetSuite.
Note: If you add more than 5 order ids, only the first 5 orders are processed and the remaining orders are ignored. - Add BigCommerce orders with status: This lets you define the order status in BigCommerce for which the orders should be imported into NetSuite.
- Remove phone number if invalid on BigCommerce order: This lets you define a business rule where invalid phone numbers on BigCommerce orders are automatically removed before the order is added to NetSuite.
Import Customers from BigCommerce to NetSuite
The Customer Import flow imports customer information on a scheduled basis from BigCommerce to NetSuite.
Editing a customer in BigCommerce will not trigger the sync to NetSuite. Only new customers are imported when an order is placed in BigCommerce.
When you run the “BigCommerce Customer to NetSuite Customer Add/Update” flows, you can select a start date to pull the historical data. On the pop-up window, you can either select:
- Automatic: Choose this option to process and sync data from the last flow run time.
- Custom: Choose this option to select a custom start date and time from when you wish to process and sync data