By default FarApp imports the customer billing/shipping address, line items and their prices, and tokenized credit card data. To view a mapping template of the fields FarApp imports by default, please see the attached mapping worksheet. The sections below provide instructions on how to set up additional mappings.
Order Form
Please note that out of the box, FarApp will post orders using your preferred order form in NetSuite, but you can map a different form in the order mappings. You’ll want to make sure to only map fields that are visible and editable on the preferred (or mapped) form because NetSuite doesn’t allow writing to fields that aren’t visible or aren’t editable.
Customer Fields Used for Customer Creation and To Check If a Field is Hidden
- Login to your NetSuite account and go to Customization > Forms > Transaction Forms.
- From this list, click on Edit for the preferred form (the form with the correct "TYPE" value that has the "PREFERRED" column checked) or the form you’ve explicitly mapped.
- Select the Screen Fields tab to see the fields that you have for this form.
- You should see a few subtabs like 'Main', 'Items', 'Shipping'. Go to the appropriate subtab to find the field that FarApp is reporting as not visible or editable.
- When you find the field you should see a checkbox under the column 'SHOW' and a select field under 'DISPLAY TYPE'. Make sure the box for 'SHOW' is checked and that 'DISPLAY TYPE' is set to ‘Normal.’
- Now click Tabs, you should see a list of all the subtabs that you saw under 'Screen Fields'. Make sure that the subtab your field was under has the 'SHOW' column checked.
- If both Show checkboxes are checked, then FarApp will be able to post to the field so you can map it following the steps below.
- You can find more information on making fields visible/editable at https://support.farapp.com/hc/en-us/articles/218764857-Making-NetSuite-Fields-Visible-Editable
SKU Field
The SKU Field is the field that FarApp uses to link up the line items on your orders with their corresponding items in NetSuite. In order to properly match up the items, FarApp needs to know what field in NetSuite you use as your SKU field. It is important that all items on your marketplace(s)/cart(s) have SKUs that exactly match the SKU populated in your SKU field on the corresponding item in NetSuite. The leading practice is to use the Item Name/Number (itemId) field in NetSuite as your SKU field, but FarApp supports any NetSuite field as your SKU field. Please note that FarApp only supports pulling the SKU from the SKU field on the order and cannot pull the SKU from any other field.
Mapping Your SKU Field
Note: Each connector and account has its own SKU Field settings. Please make sure you are accessing the right connector and account when configuring these settings. Connectors and accounts can be selected in the FarApp menu (on the left). SKU Field settings for a connector can be found under Settings > Order > General.
- Navigate to your General Settings in FarApp. (See the above Note)
- On this page you will see a text field labeled NetSuite SKU Field.
- In NetSuite, find the field ID of the field that you use as your SKU field.
- Enter that field ID (e.g. itemId for Item/Name Number) into the NetSuite SKU field.
- Click Save at the bottom of the page.
Subsidiaries (only applicable if you have multiple subsidiaries in NetSuite)
FarApp needs to know which subsidiaries you’ll be connecting in FarApp.
Mapping Your Subsidiaries
- Navigate to your NetSuite Settings in FarApp.
- Populate the internal ID of the subsidiaries you’d like FarApp to use in the field labeled NetSuite subsidiaries used for FarApp connectors:
- Navigate to your Customer Mappings.
- Click the Add Mapping Row button and select Subsidiary from the NetSuite field dropdown.
- Click Add Mapping, then Close.
- A new mapping row for subsidiary will appear in your customer mapping table. In the Value column for the Subsidiary mapping, enter the internal ID of the subsidiary you’d like customers to be created under.
- Click Save.
Note: You’ll want to add subsidiaries for each of your connectors and accounts. Connectors and accounts can be selected in the FarApp menu (on the left). Customer Mappings for a connector can be found under Mappings > Orders > Customer.
Shipment Methods
Whenever FarApp sees an order with a new shipment method, that shipment method gets added to the left column of the Shipment Method Mappings table in your Shipment Method Settings. At that point, you’ll get an error letting you know that a shipment method mapping is missing so you can go in and map the new storefront shipment method to the corresponding NetSuite shipment method by selecting the appropriate shipment method from the dropdown in the NetSuite Shipment Methods column. You will only have to do this the first time an order comes in with a specific shipment method. After that all orders with that shipment method will use the mapping you set. The shipment method mappings themselves will only be set up once you begin importing test orders but you’ll need to complete the following steps to prepare for that.
Mapping Your Shipment Methods
- Navigate to your Shipment Method Mappings.
- Shipment methods aren’t preloaded into FarApp from your NetSuite. You can load your shipment methods from NetSuite by clicking the button on the far right of shipping method. Every time you adjust your shipment methods in NetSuite and/or if you have multiple subsidiaries in NetSuite and adjust the subsidiaries setting in FarApp, you’ll need to click this button in order to load the adjusted shipment methods or load the shipment methods from the additional subsidiaries.
- Select Do Not Post from the Default shipment method to post to when no match found: dropdown. This will ensure that orders can’t sync to NetSuite until a shipment method has been mapped and will notify you to map them (once you configure your notifications).
- Click Save at the bottom of the screen.
Note: Each connector and account has its own Shipment Methods. Please make sure you are accessing the right connector and account when configuring these settings. Connectors and accounts can be selected in the FarApp menu (on the left). Shipment Methods for a connector can be found under Mappings > Order > Shipping.
Order Header Mapping
Order Header mappings are used for fields that apply to the overall order and not to the line items in the order in NetSuite. An example of a field like this is the Memo field you see on orders in NetSuite. By default FarApp maps the fields that are necessary according to leading practice and mapping additional fields isn’t required. However, if you do need additional order fields to be mapped, follow these steps.
Mapping to the Order Header
- Navigate to your Order Mappings.
- If you have multiple channels/accounts make sure the proper channel and account is selected in the FarApp menu (on the left). Order Mappings for a connector can be found under Mappings > Orders > Order.
- You should now see all the mappings for your channel/account. If you see any mappings marked “Read Only” those are default mappings that FarApp sets up for you.
- Click the button labeled Reload NetSuite Lists (this can take a few minutes to run). You’ll need to do this whenever you want to map list values that were added in NetSuite since the last time this was run. The button is available in a few mapping screens but it’s the same button so you only need to click it once.
- To add a mapping to this list click Add Mapping Row at the upper right of the screen. This will bring up a window of the NetSuite order header fields to choose from.
- Select the order header field from the drop down list. If you are using a custom field, select Custom Field and then enter the field id of the field you want to use. The ID should start with “custbody”. If you do not know how to get the field ID of a field in NetSuite follow the instructions at https://support.farapp.com/hc/en-us/articles/216635418-NetSuite-Internal-IDs-and-Field-IDs.
- Once you’ve selected your field click Add Mapping and then click the close button on the popup screen.
- Your new mapping should show up at the bottom of the mapping list. Now you’ll want to select the “Mapping Type”. The types to choose from are:
- Fixed: set a constant value in the “Value” field that will always post to NetSuite.
- Order Header Mapping: Select from the fields FarApp has pulled in on an order.
- Order Header Mapping with Translation: Behaves like an if/then condition for the value you select. Once you select which field to base the translation off of, a pop-up window appears. In this screen you’ll want to click “Add Row” for each possible value the field you’ve selected could have. For example: if you use Location ID, place 1 in the value column of the first row and 3 in the value column of the second row, then whenever the Location ID shows up as 1, FarApp will post 3 to the NetSuite field you’ve selected to map to. When finished click the Save button.
- Logic: If you require more complex mappings, please see the following article for instructions: https://support.farapp.com/hc/en-us/articles/360001396847-Setting-Up-Custom-Order-Mappings
- Once you’ve selected your “Mapping Type”, select your “Mapping Value”. Please see the previous step about “Mapping Type” to help you figure out what the value should be.
- Mappings can be enabled/disabled with the On/Off toggle.
- Click Save and your new mapping should now show up in all future orders under the channel/account you specified.
- You can test your mappings by clicking Test Mappings in the upper right.
Order Line Mapping
Order Line mappings are used for fields that are specific to the items in an order and will be applied to all line items in an order.
Mapping to the Order Line
- Navigate to your Order Item Mappings.
- If you have multiple channels/accounts make sure the proper channel and account is selected in the FarApp menu (on the left). Order Mappings for a connector can be found under Mappings > Orders > Order Item.
- You should now see all the mappings for your channel/account. If you see any mappings marked “Read Only” those are default mappings that FarApp sets up for you.
- Click the button labeled Reload NetSuite Lists (this can take a few minutes to run). You’ll need to do this whenever you want to map list values that were added in NetSuite since the last time this was run. The button is available in a few mapping screens but it’s the same button so you only need to click it once.
- To add a mapping to this list click Add Mapping at the top right of the screen. This will bring up a window of the NetSuite order line fields to choose from.
- Select the order line field from the drop down list. If you are using a custom field, select Custom Field and then enter the field id of the field you want to use. The ID should start with “custcol”. If you do not know how to get the field ID of a field in NetSuite follow the instructions here: https://support.farapp.com/hc/en-us/articles/216635418-NetSuite-Internal-IDs-and-Field-IDs
- Once you’ve selected your field click Add Mapping and then click the Close button on the popup screen.
- Your new mapping should show up at the bottom of the mapping list. Now you’ll want to select the “Mapping Type”. The types to choose from are:
- Fixed: set a constant value in the “Value” field that will always post to NetSuite on the line level.
- Order Header Mapping: Select from the fields FarApp has pulled in from the order header of an order and posts the value on the line level.
- Order Header Mapping with Translation: Behaves like an if/then condition for the value you select and posts the value on the line level. Once you select which order header field to base the translation off of, a pop-up window will appear. In this screen you’ll want to click “Add Row” for each possible value the field you’ve selected could have. For example: if you use Location ID, place 1 in the value column of the first row and 3 in the value column of the second row, then whenever the Location ID shows up as 1, FarApp will post 3 to the NetSuite field you’ve selected to map to. When finished click the Save button.
- Order Line: Select from the fields FarApp has pulled in on the order line item
- Logic: If you require more complex mappings, please see the following article for instructions: https://support.farapp.com/hc/en-us/articles/360001396847-Setting-Up-Custom-Order-Mappings
- Once you’ve selected your “Mapping Type” select your “Mapping Value”. Please see the previous step about “Mapping Type” to help you figure out what the value should be.
- Click Save and your new mapping should now show up in all future orders under the channel/account you specified.
- You can test your mappings by clicking Test Mappings in the upper right.
Next Steps
Please proceed with Step 4: Order Sync Payment.
Comments
0 comments
Please sign in to leave a comment.