The BigCommerce Order to NetSuite Order Add flow imports orders from your BigCommerce store into NetSuite as sales orders on a schedule, together with the customer information on each order. Its settings control which orders are imported and how discounts, gift cards, store credits, shipping costs, and order total differences appear on the NetSuite sales order. This article is for integrator.io users who set up and run order syncing.
Prerequisites: Make sure that the eTail fields on the sales order lines in NetSuite, such as eTail Order ID, eTail Order Line ID, and eTail Order Line Tax, are enabled. The order settings don't work correctly without them.
How orders are imported
Before it creates a sales order, the flow checks NetSuite for an existing sales order with the same external ID. If it finds one, the order is treated as a duplicate and isn't imported.
The flow also syncs the payment provider's transaction ID from BigCommerce (payment_provider_id) to the eTail Transaction ID field on the sales order's eTail subtab. This field is included in the BigCommerce bundle.
New customers on an order are created in NetSuite when the order is imported. For how customers are matched and synced, see Sync BigCommerce customers to NetSuite.
Run the order flow
- In the integration app, go to Flows > Order.
- Select Run for BigCommerce Order to NetSuite Order Add. To import historical orders, choose a start date. For details, see Choose a start date for a delta flow.
The Dashboard shows the result of the run. When the run succeeds, the orders appear in NetSuite as sales orders.
Order settings
The order settings are in Settings > Order, on the Shipping, Payment, Tax, Order, and Customer subtabs.
| Setting | Description |
|---|---|
| Ship Method Mapping | Maps BigCommerce shipping methods to NetSuite shipping methods, with a default for methods that have no match. For details, see Map shipping and payment methods. |
| Map Payment Methods | Maps BigCommerce payment methods to NetSuite payment methods, with a default for methods that have no match. For details, see Map shipping and payment methods. |
| BigCommerce Order Id(s) | Imports specific orders on demand. For details, see Import specific orders on demand. |
| Add BigCommerce orders with status | The BigCommerce order statuses to import. |
| Add orders created after | Imports only orders created in BigCommerce after this date. |
| NetSuite discount item to track BigCommerce discounts | The NetSuite item that tracks discount amounts on BigCommerce orders. The discount code used on the order is mapped to the BigCommerce Discount Code field on the sales order's eTail subtab. |
| NetSuite item to track BigCommerce gift card redemption as a line item | A non-inventory or payment type item that records gift card redemptions as a separate line on the sales order. If you select a payment type item, discounts on the order aren't applied to the gift card line, because NetSuite doesn't calculate tax or discounts on payment type lines. |
| NetSuite item to track BigCommerce store credits as a line item | Optional. A non-inventory item that records the BigCommerce store credit amount as a line on the sales order. |
| NetSuite item to track BigCommerce shipping cost as a line item | Optional. A non-inventory item that records the order's shipping cost as a line on the sales order. |
| NetSuite item to track the variance adjustments as a line item | A non-inventory item that adds an adjustment line when the order totals differ between the two systems, so the totals match. |
| NetSuite item to track BigCommerce tax amount as a line item | Optional. A non-inventory item that records the order's tax amount as a line. For details, see Manage BigCommerce order sales tax in NetSuite. |
| Sync all customers | Lets the BigCommerce Customer to NetSuite Customer Add/Update flow sync all BigCommerce customers to NetSuite. For details, see Sync BigCommerce customers to NetSuite. |
| Sync BigCommerce order metafields | Syncs order metafields to the sales order. For details, see Sync order metafields. |
| Default NetSuite customer for BigCommerce orders | The internal ID of the NetSuite customer record to assign to the sales order. |
| Trim customer name if invalid on BigCommerce order | Trims first and last names longer than 32 characters to the first 32 characters before the order is added to NetSuite, so the import doesn't fail. |
| Remove phone number if invalid on BigCommerce order | Removes phone numbers with fewer than 7 digits or with letters before the order is added to NetSuite, so the import doesn't fail. |
Import specific orders on demand
To import specific orders without waiting for the schedule, enter their IDs in the BigCommerce Order Id(s) setting.
- In the integration app, go to Settings > Order > Order.
- In BigCommerce Order Id(s), enter up to 5 BigCommerce order IDs, separated by commas.
- Select Save.
If you enter more than 5 order IDs, only the first 5 orders are processed, and the rest are ignored.
Saving starts the BigCommerce order to NetSuite order Add (on-demand sync) flow, which creates the sales orders in NetSuite with the mappings of the BigCommerce Order to NetSuite Order Add flow.
Sync order metafields
BigCommerce order metafields store additional order information, such as a purchase order number or a quote number. You can sync them to the NetSuite sales order. This applies to the scheduled order flow, not to real-time flows.
- In the integration app, go to Settings > Order > Order.
- Select Sync BigCommerce order metafields, and then select Save. A lookup named Get order metafields from BigCommerce is added to the BigCommerce Order to NetSuite Order Add flow.
- Go to Flows > Order, and select Mapping for BigCommerce Order to NetSuite Order Add.
- For each metafield you want to sync, map the source field in the format
<namespace>.<key>, such asnamespace_1.key_1, to the NetSuite field that stores it. - Save the mapping, and then run the flow.