Appending a Set Value to Order Numbers in NetSuite Connector
You may want to add a prefix to the order numbers when sending the orders from NetSuite Connector to NetSuite. This requirement is common for Shopify, because Shopify adds order prefixes, but NetSuite Connector drops the prefixes when sending the orders into NetSuite. If you are mapping the order number to a field like PO# in NetSuite, you can add a logic mapping in NetSuite Connector. The logic mapping should be for appending a set value before or after the order number.
To append a set value before the order numbers:
-
Log in to app.farapp.com.
-
Select the connector and then select the relevant account.
-
Go to Mappings > Orders.
-
Click the Order tab.
-
Click Add Mapping.
The Add NetSuite Mapping popup window opens.
-
From the NetSuite Field dropdown list, select PO #.
-
Click Add Mapping.
A confirmation message appears indicating the field is added to the end of your list of mappings.
-
Click Close.
A new row for the Order mapping appears at the end of the mappings list.
-
In the newly added row, from the dropdown list in the Mapping Type column, select Logic.
-
Click the Logic Mapping – Click to View/Edit link in the
<Marketplace or Cart Name>
Field / Fixed Value column.The Edit Logic Mapping window appears.
-
Make the following settings in the Edit Logic Mapping window:
-
From the Value Type field, select Set Value.
-
From the Set Value To dropdown list, select Fixed Value.
-
In the text field next to the Set Value To dropdown list, enter the prefix that you want to append to the order number.
-
Click Append Value.
The window expands with few more settings in the Appended With section.
-
(Optional) To add the value after the order number, switch the values that you enter before and after clicking Append Value.
-
In the Appended With section:
-
From the Value Type dropdown list, select Set Value.
-
From the Set Value To dropdown list, select Order Header Value.
-
From the dropdown list next to the Set Value To dropdown list, select Order ID.
-
-
Click Save Changes.
A confirmation message displays in the popup window.
-
Click the Close button.
-
-
Click Save.