Checking Syncs for NetSuite Connector Deployment
Validate the following configurations:
-
Order and fulfilment sync
-
Product or Price/Qty sync
-
Refund sync (or Amazon settlement sync)
-
Sandbox vs. Production NetSuite
-
Multiple connectors ready to go-live
-
3PLs
Order and Fulfillment Sync
To validate the sync, verify that NetSuite has sourced and populated the sales order with correct values:
-
Tax total in NetSuite matches the tax total in the marketplace or cart.
-
Order total in NetSuite matches the order total on the order in the marketplace or cart.
-
Line items in NetSuite match the line items on the order in the marketplace or cart.
-
Quantity of line items in NetSuite matches the quantity of line items on the order in the marketplace or cart.
-
All mapped order, item, and customer fields populate as expected, including the tokenized credit card information.
-
If mapped in NetSuite Connector, correct shipment and payment methods populate on the order.
If you have made mapping adjustments, update the order in NetSuite to apply the mappings and confirm that the orders are posted correctly. To test, you should select orders that are in Order Posted, Pending Fulfillment status in NetSuite Connector. If you update orders that are marked Complete, their status will change back to Pending Approval or Pending Fulfillment in NetSuite. Also, NetSuite Connector will re-sync the completed order. Follow these steps to update a pending order.
To update a pending order:
-
Log in to app.farapp.com.
-
Select the connector and the relevant account.
-
Go to Data Flows > Orders.
-
Search the order that you want to map by entering the order ID in the Search field and pressing Enter.
-
On the order, click the Action menu (pencil icon) and select Update Order in NetSuite.
After doing the mapping adjustments, set the order cutoff date in the Import Orders Created After field in the Advanced Options of the Order Settings page (Settings > Orders).
For more information, read Initial Order Sync Activation Cutoff Date.
Product or Price/Qty Sync
Before enabling the product or price/qty sync, make sure you test multiple SKUs to your marketplace or cart and confirm the SKUs are posted as expected. NetSuite Connector uses flag field to control syncing updates for an item.
For information about the flag field, read NetSuite Connector Storefront Flag Fields.
When you first enable product or price/qty sync, try syncing a small subset of items. After confirming the items are synced without any errors, flag the remaining items to sync. Check the following to ensure the product sync works properly:
-
Make sure the items are flagged properly in NetSuite and the mapping for the flag field in NetSuite Connector is correct.
-
Verify that the product information from NetSuite to NetSuite Connector is accurate and contains all the details you want NetSuite Connector to sync to the marketplace or cart.
-
Verify that the data posted by NetSuite Connector shows correctly in the marketplace or cart.
-
Prior to going live, populate your inventory in NetSuite before enabling the product or price/qty sync.
Note:If you are updating the products using CSV file import in NetSuite, do not check the Run Server SuiteScript and Trigger Workflows box. Check the box only if you do not want to enable NetSuite Connector’s real-time sync.
You can make mapping adjustments from the Product Mappings page in NetSuite Connector. Make sure you select the correct sync type and category (if you have that option). For custom mappings that require support, contact NetSuite support.
Follow these steps when enabling product or price/qty sync:
-
Flag 100 items to sync.
-
Enable product or price/qty sync.
-
Wait for the 100 items to sync.
-
Confirm that data on several of the 100 items appears correctly in the marketplace or cart.
-
Flag 1000 items to sync.
-
Wait for the 1000 items to sync.
-
Confirm that data on several of the 1000 items appears correctly in the marketplace or cart.
-
Flag remaining items to sync.
Refund Sync (or Amazon Settlement Sync)
Check the following to ensure that refund sync is working properly:
-
For refund sync from NetSuite to marketplace or cart:
-
Ensure the refund records in NetSuite are tied to the correct orders.
-
Verify that the order is updated in NetSuite Connector and synced to the marketplace or cart.
-
Verify that the refunds are posted correctly to the marketplace or cart.
-
-
For refund sync from marketplace or cart to NetSuite:
-
Verify that when you process a refund in the marketplace or cart, the order is updated in NetSuite Connector and the refund is posted to NetSuite.
-
Verify that the transaction type created in NetSuite matches with what is being synced to NetSuite Connector, that is, refund authorizations, credit memos, or cash refunds.
-
Ensure that the data posted in the refund transactions is correct. For example, amount, quantity, and SKU.
-
You can update the refund sync settings in NetSuite Connector from the Refund Settings page.
Amazon settlement sync is tested using orders that NetSuite Connector has already synced to NetSuite. Therefore, the leading practice is to test the settlement report processing couple of weeks after NetSuite Connector goes live.