1. NetSuite Connector
  2. NetSuite Connector Sync Management
  3. NetSuite Connector Order Sync Management
  4. Setting up Custom Order Mappings in NetSuite Connector

Setting up Custom Order Mappings in NetSuite Connector

NetSuite Connector provides you the capability to create custom order mappings with custom logic.

Note:

This is an advanced feature.

Overview

Custom mappings are created on the order mappings page for your connectors. To access these pages, log in to NetSuite Connector, select your connector and account in the NetSuite Connector menu on the left, and go to Mappings > Orders. Afterwards, click Order at the top of the page. You must know how to create basic mappings.

Order Header with Translation Mapping Type

Order Header with Translation mappings are used when you have certain values coming from the marketplace/cart that you want to map to a specific value in NetSuite for a field. In this example, there are different Store IDs in Shopify that you want to map to specific Departments in NetSuite.

To map order headers with translation mapping:

  1. Click Add Mapping at the top right of the page.

  2. Select a NetSuite field from the dropdown. In this example select Department.

  3. Click Add Mapping.

  4. Click Close.

    The mapping should now show up under Order Mappings.

  5. The mapping should now show up under Order Mappings.

  6. In the Mapping Type for the new Department mapping, select Order Header with Translation.

    This changes the Field/Fixed Field Value column to a drop-down selection.

  7. From the drop-down select Store ID.

    A pop-up will appear with mapping options.

  8. Under the Shopify Value column, enter the Store ID value from Shopify and then the corresponding NetSuite value (such as the Internal ID of the Department you want to map the Store ID to).

  9. Click Add Row.

    This adds a new Store ID and NetSuite mapping value.

  10. Click Save and then Close.

Order Header with Logic Mapping Type

In this example, orders are shipped within the US, and you want to will use a different order Location for California than you do for the rest of the US.

To map order headers with logic mapping:

  1. Click Add Mapping at the top right of the page.

  2. Select a NetSuite field from the dropdown. In this example select Location.

  3. Click Add Mapping.

  4. Click Close.

    The mapping should now show up under Order Mappings.

  5. The mapping should now show up under Order Mappings.

  6. Complete the Edit Logic Mapping table:

    • In the Check If row:

      1. In the first column select a condition for the filter.

        • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

        • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

        • Computed Value – a value that is a result of a condition or an equation or operation.

      2. In the second, third, fourth, and fifth column:

        • If Order Header Value is selected in the first column:

          1. In the second column, select an order header value from the dropdown.

          2. In the third column, select a condition how to evaluate from the dropdown.

          3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

          4. In the fifth column, enter a value to evaluate against in the Value 2 field.

        • If Fixed Value is selected in the first column –

          1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

          2. In the third column, select a condition how to evaluate from the dropdown.

          3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

          4. In the fifth column, enter a value to evaluate against in the Value 2 field.

        • If Computed Value is selected in the first column –

          1. In the second column, click Click to View/Edit Value.

          2. In the Value type row, select either Select Value Conditionally or Calculate Value.

          3. Complete the form.

            • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

            • If Calculate Value is selected:

              1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

              2. In the second column:

                • If Order Header Value is selected in the first column, select an order header value from the dropdown.

                • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

                • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

              3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

              4. Click Save Changes.

    • In the If True, Set Value To row:

      In the first column select a condition for the filter.

      • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

      • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

      • Computed Value – a value that is a result of a condition or an equation or operation.

      In the second, third, fourth, and fifth column:

      • If Order Header Value is selected in the first column:

        1. In the second column, select an order header value from the dropdown.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Fixed Value is selected in the first column –

        1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Computed Value is selected in the first column –

        1. In the second column, click Click to View/Edit Value.

        2. In the Value type row, select either Select Value Conditionally or Calculate Value.

        3. Complete the form.

          • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

          • If Calculate Value is selected:

            1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

            2. In the second column:

              • If Order Header Value is selected in the first column, select an order header value from the dropdown.

              • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

              • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

            3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

            4. Click Save Changes.

    • In the Otherwise, Set Value To row:

      In the first column select a condition for the filter.

      • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

      • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

      • Computed Value – a value that is a result of a condition or an equation or operation.

      In the second, third, fourth, and fifth column:

      • If Order Header Value is selected in the first column:

        1. In the second column, select an order header value from the dropdown.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Fixed Value is selected in the first column –

        1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Computed Value is selected in the first column –

        1. In the second column, click Click to View/Edit Value.

        2. In the Value type row, select either Select Value Conditionally or Calculate Value.

        3. Complete the form.

          • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

          • If Calculate Value is selected:

            1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

            2. In the second column:

              • If Order Header Value is selected in the first column, select an order header value from the dropdown.

              • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

              • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

            3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

            4. Click Save Changes.

    Note that in rows two and three, the Location we use is set when the condition is true, and the condition to use when it's false.

  7. Click Save Changes.

Appended Values

You can string multiple values together into Appended Values, which allows you to create filters with values from NetSuite and are appended with a string of your choice.

To map order headers with appended values:

  1. Click Add Mapping at the top right of the page.

  2. Select a NetSuite field from the dropdwn.

  3. Click Add Mapping.

  4. Click Close.

    The mapping should now show up under Order Mappings.

  5. The mapping should now show up under Order Mappings.

  6. Complete the Edit Logic Mapping table:

    • In the Check If row:

      1. In the first column select a condition for the filter.

        • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

        • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

        • Computed Value – a value that is a result of a condition or an equation or operation.

      2. In the second, third, fourth, and fifth column:

        • If Order Header Value is selected in the first column:

          1. In the second column, select an order header value from the dropdown.

          2. In the third column, select a condition how to evaluate from the dropdown.

          3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

          4. In the fifth column, enter a value to evaluate against in the Value 2 field.

        • If Fixed Value is selected in the first column –

          1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

          2. In the third column, select a condition how to evaluate from the dropdown.

          3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

          4. In the fifth column, enter a value to evaluate against in the Value 2 field.

        • If Computed Value is selected in the first column –

          1. In the second column, click Click to View/Edit Value.

          2. In the Value type row, select either Select Value Conditionally or Calculate Value.

          3. Complete the form.

            • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

            • If Calculate Value is selected:

              1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

              2. In the second column:

                • If Order Header Value is selected in the first column, select an order header value from the dropdown.

                • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

                • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

              3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

              4. Click Save Changes.

    • In the If True, Set Value To row:

      In the first column select a condition for the filter.

      • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

      • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

      • Computed Value – a value that is a result of a condition or an equation or operation.

      In the second, third, fourth, and fifth column:

      • If Order Header Value is selected in the first column:

        1. In the second column, select an order header value from the dropdown.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Fixed Value is selected in the first column –

        1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Computed Value is selected in the first column –

        1. In the second column, click Click to View/Edit Value.

        2. In the Value type row, select either Select Value Conditionally or Calculate Value.

        3. Complete the form.

          • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

          • If Calculate Value is selected:

            1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

            2. In the second column:

              • If Order Header Value is selected in the first column, select an order header value from the dropdown.

              • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

              • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

            3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

            4. Click Save Changes.

    • In the Otherwise, Set Value To row:

      In the first column select a condition for the filter.

      • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

      • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

      • Computed Value – a value that is a result of a condition or an equation or operation.

      In the second, third, fourth, and fifth column:

      • If Order Header Value is selected in the first column:

        1. In the second column, select an order header value from the dropdown.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Fixed Value is selected in the first column –

        1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

        2. In the third column, select a condition how to evaluate from the dropdown.

        3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

        4. In the fifth column, enter a value to evaluate against in the Value 2 field.

      • If Computed Value is selected in the first column –

        1. In the second column, click Click to View/Edit Value.

        2. In the Value type row, select either Select Value Conditionally or Calculate Value.

        3. Complete the form.

          • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

          • If Calculate Value is selected:

            1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

            2. In the second column:

              • If Order Header Value is selected in the first column, select an order header value from the dropdown.

              • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

              • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

            3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

            4. Click Save Changes.

    Note that in rows two and three, the Location we use is set when the condition is true, and the condition to use when it's false.

  7. Click Append Value.

    An Appended With table shows.

  8. Complete the Appended With table:

    • In the Value Type row:

      • Set Value Conditionally – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

      • Calculate Value – a value that is a result of a condition or an equation or operation.

      • Set Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

    • In the second, third, and fourth row (the third and fourth row will appear depending on the selected option in Value Type in the first row):

      • If Set Value Conditionally is selected in the first column:

        In the Check If row:

        1. In the first column select a condition for the filter.

          • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

          • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

          • Computed Value – a value that is a result of a condition or an equation or operation.

        2. In the second, third, fourth, and fifth column:

          • If Order Header Value is selected in the first column:

            1. In the second column, select an order header value from the dropdown.

            2. In the third column, select a condition how to evaluate from the dropdown.

            3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

            4. In the fifth column, enter a value to evaluate against in the Value 2 field.

          • If Fixed Value is selected in the first column –

            1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

            2. In the third column, select a condition how to evaluate from the dropdown.

            3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

            4. In the fifth column, enter a value to evaluate against in the Value 2 field.

          • If Computed Value is selected in the first column –

            1. In the second column, click Click to View/Edit Value.

            2. In the Value type row, select either Select Value Conditionally or Calculate Value.

            3. Complete the form.

              • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

              • If Calculate Value is selected:

                1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

                2. In the second column:

                  • If Order Header Value is selected in the first column, select an order header value from the dropdown.

                  • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

                  • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

                3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

                4. Click Save Changes.

        In the If True, Set Value To row:

        In the first column select a condition for the filter.

        • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

        • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

        • Computed Value – a value that is a result of a condition or an equation or operation.

        In the second, third, fourth, and fifth column:

        • If Order Header Value is selected in the first column:

          1. In the second column, select an order header value from the dropdown.

          2. In the third column, select a condition how to evaluate from the dropdown.

          3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

          4. In the fifth column, enter a value to evaluate against in the Value 2 field.

        • If Fixed Value is selected in the first column –

          1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

          2. In the third column, select a condition how to evaluate from the dropdown.

          3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

          4. In the fifth column, enter a value to evaluate against in the Value 2 field.

        • If Computed Value is selected in the first column –

          1. In the second column, click Click to View/Edit Value.

          2. In the Value type row, select either Select Value Conditionally or Calculate Value.

          3. Complete the form.

            • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

            • If Calculate Value is selected:

              1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

              2. In the second column:

                • If Order Header Value is selected in the first column, select an order header value from the dropdown.

                • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

                • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

              3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

              4. Click Save Changes.

      • If Calculate Value is selected in the first column, complete the Set Value To row:–

        1. In the first column, select either Fixed Value, Order Header Value, Computed Value

        2. In the second column, enter any value to evaluate the condition against in the Value 1 field.

        3. In the third column, select a how to transform the value in the Value 1 field from the dropdown.

      • If Set Value is selected in the first column –

        1. In the first column, select either Fixed Value, Order Header Value, Computed Value

        2. In the second column, enter any value to evaluate the condition against in the Value 1 field.

  9. Click Save Changes.

Related Topics

NetSuite Connector Order Sync Management
Order Mappings in NetSuite Connector
Mapping Order Location in NetSuite Connector
Viewing Order Mapping in NetSuite Connector
Mapping a Subsidiary on Orders in NetSuite Connector
Troubleshooting Order or Fulfillment Sync Errors in NetSuite Connector
NetSuite Connector Order Sync FAQ

General Notices