Order Mappings in NetSuite Connector

NetSuite Connector allows you to customize how your order data is mapped from a connector to NetSuite. This section covers the following topics about order mappings in NetSuite Connector:

Mapping Types

Mapping types determine how the source data will be mapped to NetSuite. NetSuite Connector allows you to set the following mapping types:

  • Fixed – This allows you to set a constant value to send to a NetSuite field. For example, if you want the memo field in NetSuite to always contain “NetSuite Connector Order,” then you should use this mapping type.

  • Order Header – This allows you to map header fields in an order to a NetSuite field. For example, if you want the memo field in NetSuite to contain the order date, then you should use this mapping type.

  • Order Header With Translation – This allows you to specify the value to send to NetSuite based on a set of conditions in fields in the marketplace or cart. You could think of this mapping as “if (marketplace field) equals (specific value), then send (another value) to NetSuite.” For example, if you want the memo field in NetSuite to map based on the state where the billing was made, you should use this mapping type. This allows you to specify that orders coming from California will say “Order Billed in CA” and orders coming from Texas will say “Order Billed in TX” in the NetSuite memo field. You can set as many conditions as you like to cover every possible value in your chosen marketplace or cart field.

  • Order Line – This is similar to Order Header Mapping but maps line item fields in an order to NetSuite. For example, if you want to map some data about the item to a transaction line custom field, you should use this mapping.

  • Order Line With Translation – This is similar to Order Header With Translation but maps line item fields in an order to NetSuite.

Creating or Editing Order Mappings

Order mappings are used for fields that apply to the whole order. These are usually header fields in the marketplace or cart.

To create or edit order mappings:

  1. Log in to app.farapp.com

  2. Select the connector and relevant account.

  3. Go to Mappings > Orders.

  4. On the Orders page, click the Order tab.

    NetSuite Connector displays all the mappings for your channel or account.

  5. Click Add Mapping.

    The Add NetSuite Mapping window appears.

  6. On the NetSuite Field list, do one of the following:

    • To map to a standard NetSuite field, select the field from the list.

    • To map to a custom NetSuite field or a custom segment, select Custom Field then enter the field ID you want to use.

      Note:

      The custom field id should start with custbody. Custom segments have IDs that start with cseg. To get the field id of a field in NetSuite, read NetSuite Connector Communication with Internal IDs and Field IDs.

  7. Click Add Mapping, then Close.

    The new mapping appears at the bottom of the mapping list.

  8. Locate your mapping and from the Mapping Type column, choose one of the following types:

    Note:

    Not all mapping types are available for all fields.

    • Fixed – Sets a constant value that will always post to NetSuite.

    • Order Header – Select from a list of header fields NetSuite Connector has pulled from an order.

    • Order Header With Translation – Allows you to specify the value based on “if this, then that” conditions.

    • Logic – Used for more complex mappings.

  9. From the <marketplace or cart> field/Fixed Value column, select the field or value you want to post to NetSuite. The value here will depend on the mapping type you chose in the previous step:

    Mapping Type

    Action

    Fixed

    Enter a constant value.

    Order Header

    Select from the list of header fields.

    Order Header With Translation

    1. Select from the list of header values.

    2. Click Click to View/Edit.

      A mapping window appears.

    3. Ensure to map the NetSuite value as needed for all existing rows, if any.

    4. Click Add Row.

    5. Enter the connector and NetSuite value.

      For example, if you selected the Location field and enter 1 in the connector value and 3 in the NetSuite value, whenever an order has the location 1, a value of 3 is posted in NetSuite.

    6. Repeat steps 4–5 to map all possible values for the field.

    7. (Optional) Enter a value in the Default Value field for NetSuite Connector to use when it finds an unmapped value.

    8. Click Save.

  10. Click Save.

Creating or Editing Order Line Mappings

Order line mappings are used to map to fields at the line item level in an order.

To create or edit order line mappings:

  1. Log in to app.farapp.com

  2. Select the connector and relevant account.

  3. Go to Mappings > Orders.

  4. On the Orders page, click the Order Item tab.

    NetSuite Connector displays all the mappings for your channel or account.

  5. Click Add Mapping.

    The Add NetSuite Mapping window appears.

  6. On the NetSuite Field list, do one of the following:

    • To map to a standard NetSuite field, select the order line item field from the list.

    • To map to a custom NetSuite field, select Custom Field then enter the field ID you want to use.

      Note:

      The custom field id should start with custcol. To get the field id of a field in NetSuite, read NetSuite Connector Communication with Internal IDs and Field IDs.

  7. Click Add Mapping, then Close.

    The new mapping appears at the bottom of the mapping list.

  8. Locate your mapping and from the Mapping Type column, choose one of the following types:

    • Fixed – Sets a constant value that will always post to NetSuite.

    • Order Header – Select from a list of header fields NetSuite Connector has pulled from an order.

    • Order Header With Translation – Allows you to specify the value based on “if this, then that” conditions.

    • Order Line – Select from a list of fields NetSuite Connector has pulled in an order line item.

    • Order Line With Translation – This is similar to Order Header With Translation but maps line item fields in an order.

    • Logic – Used for more complex mappings.

  9. From the <marketplace or cart> field/Fixed Value column, select the field or value you want to post to NetSuite. The value here will depend on the mapping type you chose in the previous step:

    Mapping Type

    Action

    Fixed

    Enter a constant value.

    Order Header or Order Line

    Select from the list of header or line item values.

    Order Header With Translation or Order Line With Translation

    1. Select from the list of header or line item values.

    2. Click Click to View/Edit.

      A mapping window appears.

    3. Ensure to map the NetSuite value as needed for all existing rows, if any.

    4. Click Add Row.

    5. Enter the connector and NetSuite value.

      For example, if you selected the Location field and enter 1 in the connector value and 3 in the NetSuite value, whenever an order has the location 1, a value of 3 is posted in NetSuite.

    6. Repeat steps 4–5 to map all possible values for the field.

    7. (Optional) Enter a value in the Default Value field for NetSuite Connector to use when it finds an unmapped value.

    8. Click Save.

  10. Click Save.

Creating or Editing Customer Mappings

Customer mappings are used for fields that apply to the customer of an order.

Note:

This only applies to newly created customers. Existing customers will not be affected.

To create or edit customer mappings:

  1. Log in to app.farapp.com

  2. Select the connector and relevant account.

  3. Go to Mappings > Orders.

  4. On the Orders page, click the Customer tab.

    NetSuite Connector displays all the mappings for your channel or account.

  5. Click Add Mapping.

    The Add NetSuite Mapping window appears.

  6. On the NetSuite Field list, do one of the following:

    • To map to a standard NetSuite field, select the field from the list.

    • To map to a custom NetSuite field, select Custom Field then enter the field ID you want to use.

      Note:

      The custom field id should start with custentity. To get the field id of a field in NetSuite, read NetSuite Connector Communication with Internal IDs and Field IDs.

  7. Click Add Mapping, then Close.

    The new mapping appears at the bottom of the mapping list.

  8. Locate your mapping and from the Mapping Type column, choose one of the following types:

    • Fixed – Sets a constant value that will always post to NetSuite.

    • Order Header – Select from a list of header fields NetSuite Connector has pulled from an order.

    • Order Header With Translation – Allows you to specify the value based on “if this, then that” conditions.

    • Logic – Used for more complex mappings.

  9. From the <marketplace or cart> field/Fixed Value column, select the field or value you want to post to NetSuite. The value here will depend on the mapping type you chose in the previous step:

    Mapping Type

    Action

    Fixed

    Enter a constant value.

    Order Header

    Select from the list of header values.

    Order Header With Translation

    1. Select from the list of header values.

    2. Click Click to View/Edit.

      A mapping window appears.

    3. Click Add Row.

    4. Enter the connector and NetSuite value.

      For example, if you selected the Location field and enter 1 in the connector value and 3 in the NetSuite value, whenever an order has the location 1, a value of 3 is posted in NetSuite.

    5. Repeat steps 3–4 to map all possible values for the field.

    6. (Optional) Enter a value in the Default Value field for NetSuite Connector to use when it finds an unmapped value.

    7. Click Save.

  10. Click Save.

Apply an Order Mapping to All Storefronts in NetSuite Connector

You can apply a mapping to all storefronts by checking the box in the Apply to All Channels column on the Order Mappings list. To open the order mappings list, from the desired connector, go to Mappings > Orders, and click the Order tab. The same column also displays in the Order Item and Customer tabs.

Testing Order Mappings

NetSuite Connector allows you to test your mappings and ensure they are working properly. If your account is live and has orders coming in, you can test mappings using the Test Mappings button on the Orders Mapping page. If your account is not live or you do not have active orders, you can retrieve an order then use the test button.

Using the Test Mappings Button

If you have an existing order, you can use the Test Mappings button to ensure your mappings are working correctly.

To test order mappings using the Test Mappings button:

Note:

Testing mappings this way does not update the order in NetSuite.

  1. Log in to app.farapp.com

  2. Select the connector and relevant account.

  3. Go to Mappings > Orders.

  4. On the Order Mappings page, click the Order, Order Line or Customer tab.

  5. Click Test Mappings.

    The Test Mappings window appears.

  6. Enter an existing order ID already in NetSuite Connector, then click Show Mapping.

    NetSuite Connector displays a list of NetSuite fields and the values to those fields based on current mappings.

Related Topics

General Notices