Order Mappings in NetSuite Connector

NetSuite Connector lets you customize how 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 data is mapped from the source to NetSuite. NetSuite Connector allows you to set the following mapping types:

  • Fixed – Set a constant value to send to a NetSuite field. For example, use this mapping type if you want the memo field to always say "NetSuite Connector Order".

  • Order Header – Map order header fields 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 – Send values to NetSuite based on conditions in marketplace/cart fields. 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 lets you specify that orders from California say "Order Billed in CA" and orders from Texas say "Order Billed in TX" in the NetSuite memo field. You can set up as many conditions as needed to cover all possible values in your chosen field.

  • Order Line – Similar to Order Header, but maps line item fields 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 typically 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 for fields related to the order's customer.

Note:

This only affects new customers, not existing ones. 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

To apply a mapping to all storefronts, check the box in the Apply to All Channels column on the Order Mappings list. To open the order mappings list, go to Mappings > Orders and click the Order tab from the desired connector. You'll also see this column in the Order Item and Customer tabs.

Testing Order Mappings

NetSuite Connector lets you test your mappings to ensure they're working correctly. If your account is live with incoming orders, use the Test Mappings button on the Orders Mapping page to test your mappings. If your account isn't live or you don't have active orders, retrieve an order and then use the test button.

Using the Test Mappings Button

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

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