Creating Mappings for Fulfillment Sync in NetSuite Connector

The NetSuite Connector enables seamless synchronization of shipping details to various marketplaces or carts after an order is fulfilled in NetSuite. By default, it automatically syncs essential information necessary for fulfillment without any additional configuration required. This includes key fields such as:

• Carrier
• Ship Date
• Ship Method
• Tracking Number

Important: The connector can only map standard fields in the storefront's API and does not support mapping to custom fields created in the storefront.

If your business needs to map additional fulfillment fields beyond the default options, you can configure this in the NetSuite Connector by following these steps:

Steps to Create New Mappings for Fulfillment Sync:

1. In the NetSuite Connector, select the desired connector and relevant account.
2. Navigate to Mappings > Fulfillments.
3. Click Add Mapping.
4. In the Add Mapping window, click Add Shopify Mapping (this example uses the Shopify connector).
5. A confirmation message will appear indicating the new mapping has been added. Click Close.
6. Change the mapping type from Fixed to Logic by selecting from the dropdown menu.
7. Click Logic Mapping - Click to View/Edit.
8. In the Edit Logic Mapping window:
   • Keep the Value Type dropdown unchanged.
   • Set the First Check If field to Fulfillment Header Value.
   • For the Second Check If, select Ship Method.
   • In the Third Check If, choose Contains.
   • Set the Fourth field dropdown to Fixed and enter FedEx in the final field of the Check If line.

This configuration instructs the NetSuite Connector to verify if the shipping method includes the term "FedEx." The subsequent steps will define the action that should be taken based on this condition.

9. In the If True, Set Value To line, keep the first field as Fixed and input www.fedex.com in the second field.
10. The Otherwise, Set Value To field can remain unchanged, which implies that no action will take place if the shipping method does not contain "FedEx."
11. Finally, click Save to complete the mapping configuration.

Important Notes:

• The example provided illustrates a logic mapping setup tailored to demonstrate functionality. It should not be applied in a production environment because platforms like Shopify automatically generate appropriate tracking URLs for shipments based on the tracking number.

By following these steps, you can effectively create and manage mappings in the NetSuite Connector to ensure your fulfillment data is accurately communicated with your sales channels.

Source: This article is based on Oracle's official NetSuite documentation.

Key Takeaways

• The NetSuite Connector simplifies syncing of shipping details for fulfilled orders.
• Custom mappings allow for additional fulfillment information beyond standard fields.
• Logic mappings can be configured for conditions like shipping methods containing specific terms.
• Standard fields are prioritized; custom fields are not supported in sync operations.
• Best practices suggest reviewing automated tracking systems for efficiency.