Creating and Editing Order Mappings in NetSuite Integration

TL;DR: This guide covers how to create and edit order mappings in NetSuite integration, enabling you to manage field mappings for orders effectively. Proper mappings ensure accurate data transfer between your marketplace and NetSuite, enhancing overall efficiency.

What Are Order Mappings?

Order mappings in NetSuite are configurations that determine how order data is transferred between external platforms (like marketplaces) and the NetSuite system. These mappings typically refer to header fields of an order, ensuring critical information is accurately reflected within NetSuite.

How to Create or Edit Order Mappings

To establish or modify order mappings, follow these steps:

1. Log In: Sign in to app.farapp.com.
2. Select Connector and Account: Choose the relevant connector and account for your integration.
3. Navigate to Mappings: Go to Mappings > Orders.
4. Open the Orders Page: Click on the Order tab to view existing mappings.
   • The NetSuite Connector will display all mappings associated with your channel or account.
5. Add a Mapping: Click Add Mapping.
   • This action opens the Add NetSuite Mapping window.
6. Select NetSuite Fields:
   • For standard fields, select from the available options.
   • For custom fields or segments, choose Custom Field and enter the field ID.
     • Note: Custom field IDs typically start with custbody, while custom segments begin with cseg. Refer to the NetSuite documentation for details on field IDs.
7. Finalize the Mapping: Click Add Mapping and then Close.
   • Your new mapping will now appear at the bottom of the list.
8. Choose Mapping Type: Locate your mapping and select its type from the Mapping Type column.
   • Options include:
     • Fixed: A constant value will be posted to NetSuite.
     • Order Header: Select from the retrieved order header fields.
     • Order Header With Translation: Define values based on conditions like 'if this, then that'.
     • Logic: Used for complex mappings.
9. Map the Desired Values: From the <marketplace or cart> field/Fixed Value column, choose or enter the specific value to post to NetSuite.
   • Depending on the mapping type selected:
     • For Fixed, enter a constant.
     • For Order Header, select a header field.
     • For Order Header With Translation:
       1. Choose from the list of values.
       2. Click Click to View/Edit to fine-tune mappings.
       3. Confirm mapping of NetSuite values for all existing rows.
       4. Add Row for more mappings and input the connector and NetSuite values.
       5. Set a Default Value if necessary for unmapped scenarios.
       6. Click Save to complete.
10. Save the Mapping: Finally, click Save to apply all changes.

Important Considerations

When mapping fields, ensure you reference the correct field IDs, as visible transaction numbers or labels in NetSuite may not accurately reflect the internal field IDs. Using the wrong identifiers can cause failures in field mapping and data transfer. Always confirm mappings, especially if there have been any label changes to the fields.

Conclusion

Order mappings are crucial for ensuring that your order processing flows smoothly between your marketplace and NetSuite. Proper establishment of these mappings can lead to improved accuracy and efficiency in data transfer.

Who This Affects:

• Administrators: Responsible for setting up mappings.
• Developers: Might need to modify mappings based on business requirements.
• Integration Specialists: Ensures seamless connectivity and data flow.

Key Takeaways:

• Order mappings help maintain data integrity across systems.
• Correct field IDs are vital for successful integration.
• Streamlined mappings improve order processing efficiency.

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