Custom Order Mappings with NetSuite Connector

TL;DR

NetSuite Connector empowers users to create custom order mappings, allowing for tailored data integration between e-commerce platforms and NetSuite. This feature is essential for businesses needing specific logic in data handling, enhancing operational efficiency.

How to Create Custom Order Mappings

The NetSuite Connector enables the creation of custom order mappings tailored to your business needs. These mappings allow integration between your e-commerce platform (like Shopify) and NetSuite, translating specific values for better data management.

Accessing the Order Mappings Page

To begin modifying your mappings:

1. Log in to NetSuite Connector.
2. Select your connector and account.
3. Navigate to Mappings > Orders.
4. Click Order at the top to access the order mappings page.

Using Order Header with Translation Mapping Type

Order Header with Translation mappings are used when you want values from your e-commerce platforms mapped to specific fields in NetSuite. Here’s how:

1. Click Add Mapping in the top right.
2. Select a NetSuite field (e.g., Department) from the dropdown.
3. Click Add Mapping.
4. Click Close. This mapping should now appear under Order Mappings.
5. For the new Department mapping, set the Mapping Type to Order Header with Translation.
6. Choose Store ID from the drop-down list.
7. Enter the Store ID and the corresponding NetSuite value, such as the Internal ID of the relevant Department.
8. Click Add Row to add more mappings as needed.
9. Finally, click Save to finalize your mappings.

Using Order Header with Logic Mapping Type

To set conditional values based on order scenarios (e.g., different Locations for specific states):

1. Click Add Mapping.
2. Select a field (like Location).
3. Add mapping and close the dialog.
4. Fill out the Edit Logic Mapping table, specifying conditions under which values will change based on the order header data.
5. Define the logic using available options (e.g., Order Header Value, Fixed Value, Computed Value).
6. Save your changes.

Efficient Value Mapping with Appended Values

You can also combine multiple values into Appended Values for more complex mapping scenarios:

1. Click Add Mapping.
2. Choose a NetSuite field again.
3. Proceed through the mapping setup as outlined above.
4. Fill in conditions and values based on your needs and, finally, click Append Value.

This feature can greatly enhance your data integration workflows and help maintain accurate and relevant records in NetSuite, especially useful for companies with unique operational requirements.