Amazon Integration Guide

 Table of Contents 

  1. Introduction
  2. Creating a FarApp Account
  3. Setting Up Amazon
  4. Setting Up NetSuite
    1. Preparing NetSuite to Connect to FarApp
    2. Installing the FarApp Bundle on NetSuite
    3. Creating Subtabs for the Item Creation Screen
    4. Installing the FarApp for SuiteSuccess Bundle on NetSuite
    5. Creating the Product Sync Fields Using the FarApp for SuiteSuccess Bundle
    6. Configuring NetSuite to Allow You To View Field ID's and Internal ID's
  5. Setting Up FarApp
    1. Connecting FarApp to NetSuite
    2. Connecting FarApp to Amazon
    3. Setting Up MFN and FBA Order Sync and Fulfillment Sync for Amazon
      1. Custom Transaction Body Fields
      2. Mapping the SKU Field
      3. MFN (Merchant Fulfilled), FBA (Fulfilled By Amazon) and SFP (Seller Fulfilled Prime) Orders
      4. Importing Your First Order
      5. Updating Your First Order
      6. Setting Up Order Sync
      7. Enabling MFN and/or FBA Order Sync and Fulfillment Sync
    4. Setting Up Product Sync for Amazon
      1. Storefront Flag Field
      2. Setting Up Full Product Sync or Price/Qty Sync Mappings
      3. Creating a Test Product in NetSuite
      4. Retrieving a Test Product Into FarApp and Posting it to a Storefront
      5. Enabling Product Sync
    5. Setting Up Amazon Fees and Settlement Report Processing For NetSuite
      1. Order Fees
      2. Refunds
      3. Service Fees
      4. Other Transactions
      5. Testing and Enabling Your Settlement Report Processing Sync
    6. Setting Up Refund Sync for Amazon
      1. The Refund and Return Process for FBA Orders
      2. The Refund and Return Process for MFN Orders
      3. Setting Up Refund Sync for both FBA and MFN Orders
    7. Setting Up Your Notification Settings
  6. Connecting FarApp to Your 3PL's
  7. Credit Cards and PCI Compliance
  8. Next Steps and Additional Information

 

Introduction

Welcome, and thank you for choosing FarApp. To get started with your FarApp integration, please follow the steps below. Not all of our customers follow all of the steps, however, because not all of our customers will need to connect the same things (e.g. if you do not want to set up Refund Sync, please skip that portion).

We provide a number of support plans for our customers to best meet the needs of their businesses. You can read more about each plan here: https://support.farapp.com/hc/en-us/articles/222413588-Support-Tiers For customers in the Managed/Priority or Enterprise Integration or Ongoing plans, if you would like to not go through the steps in this article, or if you would like assistance going through it, please open a ticket with us and we will be able to assist you. If you are not part of either of these plans, but would like to sign up for one, please contact us and we will set you up with your desired plan.

 

Creating a FarApp Account

  1. Navigate to http://www.farapp.com/
  2. Click "Sign Up"
  3. On the new screen, populate the required fields and agree to the Subscription.
  4. Click "Submit."
  5. Check your inbox for an email from FarApp at the email address you entered in step 3 and follow the link provided in the email to activate your FarApp subscription at http://www.app.farapp.com/dashboard.

 

Setting Up Amazon

This article assumes that you are already registered as a seller with Amazon and are familiar with seller central. If you have not done so already, please set up a seller account with Amazon: https://services.amazon.com/selling/getting-started.htm

 

Setting Up NetSuite

This article also assumes that you have already created a NetSuite account and are familiar with creating Items, Sales Order/Cash Sales and the accounting processes you will be using.

Preparing NetSuite to Connect to FarApp

  1. From your NetSuite home page, go to Setup > Company > Enable Features, and select the SuiteCloud tab.
  2. In the section "SuiteTalk (Web Services)", make sure the Web Services checkbox is checked. If not, check the box, and save your settings.
  3. Go to Setup > Integration > Web Services Preferences and make a note of your Account Number for use below.
  4. Go to Setup > Integration > Web Services Preferences. In the upcoming steps you will be giving FarApp access to your NetSuite. You can choose to assign the user you give FarApp an the administrator role (usually internal ID 3). If you do not want to give the FarApp user the administrator role, you will need to make sure that the FarApp user has the following permissions:
    • Lists > Accounts Full
    • Lists > Customers Full
    • Lists > Items Full
    • Lists > Locations View
    • Lists > Payment Methods View
    • Lists > Documents and Files Full
    • Transactions > Sales Order Full
    • Transactions > Sales Order Approval Full
    • Transactions > Find Transaction Full
    • Transactions > Item Fulfillment View
    • Setup > Web Services Full
    • Setup > Accounting Lists View
    • Setup > Custom Item Fields View
    • Setup > Custom Transaction Fields Full
    • Setup > Custom Fields Full
    • Setup > Custom Lists Full
    • Setup > Custom Record Types Full
    • Setup > Other Custom Fields View
    • Setup > Other Lists View
    • Setup > Custom Body Fields Full
    • Lists > Currency View
    • Lists > Shipping Items
    • Transactions > Invoice View
    • Transactions > Fulfill Sales Orders View
    • Transactions > Credit Memos
    • Transactions > Fulfill Sales Orders Full (for 3PL integrations only)

Installing the FarApp Bundle on NetSuite

FarApp's NetSuite bundle (just called FarApp for simplicity) is used to push item updates to FarApp from NetSuite in real-time to improve update speeds. If FarApp is doing product and/or inventory updates, you should install the bundle. You can read more about using the FarApp bundle here: https://support.farapp.com/hc/en-us/articles/219375948-FarApp-NetSuite-Bundle

*Please note, if you don't enter your FarApp credentials (the credentials you use to log into FarApp) in the two separate locations mentioned in the section below, you will get invalid credentials errors in NetSuite after installing the bundle. This will prevent you from creating transactions in NetSuite until the credentials are entered.

*Please be sure to only install the FarApp bundle on the account you currently have connected to FarApp here: https://app.farapp.com/settings#/netsuite_settings (e.g. if you have both a NetSuite sandbox and live NetSuite, please ensure you only install it on one of these at a time)

To install the bundle, follow these steps in NetSuite. Once started, you must complete them:

  1. Make sure you are logged in to NetSuite as an admin user.
  2. Go to Customization->SuiteBundler->Search & Install Bundles.
  3. Enter FarApp in the KEYWORDS box and click the Search button.
  4. Find the result named just "FarApp" and click on the name.
  5. Click Install. It may take a little time but this will install the bundle.
  6. Once installation completes, go to Customization -> Scripting -> Script Deployments
  7. From the Drop down that says 'Scripts' select 'Push Item Updates to FarApp'
  8. Click 'Edit' on the deployment that shows up in the list
  9. Click the 'Parameters' tab and enter your FarApp credentials (i.e. the ones you use to login to app.farapp.com) in the text fields
  10. Click 'Save'
  11. Go to Setup->Company->General Preferences.
  12. Go to the Custom Preferences tab.
  13. In the FarApp section, enter your FarApp credentials (i.e. the ones you use to login to app.farapp.com).
  14. If you have user-event scripts in NetSuite that modify an item record as you save the item record (for example, upon save, it auto-computes the prices and updates them), then check the "HAVE ITEM-MODIFYING USER-EVENT SCRIPTS" box. Otherwise, leave it unchecked for improved performance.

Once the above is done, any item and/or inventory changes will be pushed to FarApp in real-time.

Creating Subtabs for the Item Creation Screen

When you create an item in NetSuite, you will need to populate a number of fields with information like the item's description, weight, color, etc. NetSuite organizes these fields within subtabs. FarApp requires several unique fields in order to sync your items from NetSuite to your storefronts automatically. These steps will walk you through creating special subtabs for these fields.

  1. Make sure you are logged into your NetSuite account.
  2. Navigate to "Customization" > "Forms" > "Subtabs".
  3. Navigate to the “Item” tab.
  4. Fill out the following (without the quotes) in the title field: “Marketplace/Cart". Click "Save".
  5. Navigate back to "Customization" > "Forms" > "Subtabs".
  6. Navigate to “Item” tab.
  7. Fill out the following two entries (without the quotes) in the title fields: “Optional” and “Required”. Make the Parent "Marketplace/Cart" for both entries. Save.
  8. Navigate back to "Customization" > "Forms" > "Subtabs".
  9. Navigate back to “Item” tab.
  10. Fill out the following (without the quotes) in the title field: “Amazon". Click "Save".
  11. Navigate back to "Customization" > "Forms" > "Subtabs".
  12. Navigate to “Item” tab.
  13. Fill out the following three entries (without the quotes) in the title fields: “Not Common”, “Optional”, and “Required”. Make the Parent "Amazon" for each entry. Save.
  14. Navigate back to "Customization" > "Forms" > "Subtabs".
  15. Once you are finished, your Custom Subtabs should look like this:Screen_Shot_2017-04-26_at_1.50.56_PM.png
  16. Please note that if you name something incorrectly, once you install and run the FarApp Marketplace/Cart - Item Fields bundle (coming up in the next section), the bundle will provide feedback on what tab or subtab you need to return to and recreate.

Installing the FarApp for SuiteSuccess Bundle on NetSuite

*Please note that if you are installing the FarApp for SuiteSuccess Bundle on NetSuite you need to have completed the steps above for "Creating Subtabs for the Item Creation Screen."

  1. SuiteSuccess is a special NetSuite program that you may or may not be a part of. You can learn more about it here: http://www.netsuite.com/portal/services/suitesuccess.shtml You do not need to be a part of the SuiteSuccess program to use FarApp's special NetSuite bundle for it. FarApp's SuiteSuccess bundle will automatically create the basic item fields that FarApp will require. To begin installing the bundle, login to your NetSuite account.
  2. Navigate to Customization > SuiteBundler > Search & Install Bundles
  3. Enter ‘farapp for suitesuccess’ in the "KEYWORDS" field and Click "Search"
  4. Select “FarApp for SuiteSuccess - Item Fields”
  5. Click "Install"
  6. Click "Install Bundle", then Click "Ok"
  7. This will redirect you to the list of your installed bundles. You will see the first in the list as “Loading”. After allowing some time, click Refresh and confirm you see “FarApp for SuiteSuccess - Item Fields”

Creating the Product Sync Fields Using the FarApp for SuiteSuccess Bundle

  1. Next, please navigate to SetUp > FarApp > FarApp SuiteSuccess Marketplace Fields.Screen_Shot_2017-03-13_at_2.49.29_PM.png
  2. Here, please select the Marketplace/Cart you will be integrating with and then enter in the number of accounts you plan to set up with FarApp for that Marketplace/Cart. You can do this multiple times if you have multiple Marketplaces/Carts that you want to integrate.Screen_Shot_2017-03-13_at_2.49.19_PM.png

Configuring NetSuite to Allow You To View Field ID's and Internal ID's

  1. Go to Setup > Company > Enable Features > SuiteCloud and check the box for Client SuiteScript if it hasn’t already been checked.
  2. Go to Home > Set Preferences > General Tab > Set Defaults and check the box for Show Internal IDs if it hasn’t already been checked.
  3. For additional information on this, please reference this article: https://support.farapp.com/hc/en-us/articles/216635418-NetSuite-Internal-IDs-and-Field-IDs

 

Setting Up FarApp

Connecting FarApp to NetSuite

  1. To get started, login at https://app.farapp.com/dashboard. This page will be the hub for your activity within FarApp, allowing you to setup and manage accounts, as well as test and oversee order processing. After this, please follow the steps below. Not all of our customers follow all of the steps, however, because not all of ours customers will need to connect the same things (i.e. if you do not want to connect a 3PL such as ShipWorks, please skip that portion).
  2. A popup window will prompt you to choose your Master System. You will be using NetSuite as your Master System.
  3. Click ‘Edit’ for the NetSuite connector, and enter your NetSuite account information. Please note that you can add multiple NetSuite logins on this page. Unless you have a SuiteCloud Plus license, most NetSuite accounts only allow a single concurrent session to NetSuite. If you process a large number of transactions (1,000+/day) or have a lot of SKUs (50,000+), it may benefit you to enter more than one NetSuite login. If you have SuiteCloud Plus, please let us know so that we can configure your account to take advantage of multiple concurrent sessions.
  4. Enter your Account Number that you made a note of above.
  5. Make sure to check the "Active" box for any additional logins that you want FarApp to use. If you want to deactivate one of these additional logins so that FarApp doesn’t use the login, you can either uncheck the box in the “Login Active” column or delete the row.
  6. Enter the email for the user you want to assign to FarApp. This is the email account with which you log into NetSuite. It can be an account dedicated to FarApp (e.g. farapp@yourdomain.com) or it can be one of your existing accounts. FarApp uses web services to communicate with NetSuite. Since web services sessions don’t conflict with interactive sessions, you can be logged into NetSuite at the same time as FarApp. The only benefit to providing FarApp its own credentials is if you want to control permissions separately for FarApp and/or if you want to be able to view the history of changes made by each user in NetSuite. If you do decide to provide FarApp its own unique login, please use your own domain (e.g. farapp@yourdomain.com) and not the “farapp.com” domain.
  7. Enter the password associated with this NetSuite account.
  8. Assign the user the internal ID of the NetSuite role you want to assign to this email. If you are not going to assign a role, please make sure the FarApp user has the permissions listed in the section above.
  9. Once you populate the information above, please click “Save Settings”. This will save the settings in FarApp and test them to make sure that FarApp can properly log into NetSuite.
  10. If the NetSuite account you are connecting FarApp to is a sandbox account, please go to https://app.farapp.com/dashboard, click on the the gear icon at the top right, select Settings and go to the NetSuite Settings Page in the left panel. Flag the first checkbox on that page for "The NetSuite account you're connecting is a sandbox account and not a production account." 

Connecting FarApp to Amazon

  1. Return to https://app.farapp.com/dashboard.
  2. If the pop up window for adding a connector is not already present click the "Add New Connector" button at the bottom of the page.
  3. In the pop up window, click the logo for Amazon then enter a name and nickname for the new account. 

Setting Up MFN and FBA Order Sync and Fulfillment Sync for Amazon

After connecting their marketplaces/carts, most customers test and setup order sync for Amazon. Posting a test order, however, will require that you have products you can purchase. If you don't, move on to product sync first in the next section and then return to this step.

*Important! Before you attempt to import an order using FarApp, make sure you can import an order manually with NetSuite. Any field that you cannot import manually FarApp will be unable to import as well.

In order to get order sync setup you will need to make sure that you can successfully import a test order into NetSuite. The first step to this process is getting your account setup to import a test order. There are two parts to this step: getting the custom transaction body fields FarApp requires setup, and mapping the SKU field to your orders. First we'll look at how to setup the mapping to your custom transaction body fields, then we'll take a look at setting up the mapping for your SKU field.

Custom Transaction Body Fields

FarApp requires two transaction body fields for order processing. We use these fields to ensure that duplicate orders do not get posted to your NetSuite account. Please note that if you followed the steps above for installing the FarApp for SuiteSucess bundle, these fields are automatically created for you. If you would like to manually create your own fields, or did not install the FarApp for SuiteSucess bundle, here are instructions on how to create these fields in NetSuite: https://support.farapp.com/hc/en-us/articles/217181157-Setting-Up-FarApp-s-Required-Custom-Transaction-Body-Fields

To get your custom transaction body fields setup in FarApp follow these steps:

  1. Click the gear icon in the top right corner of the screen, then click “Settings.”
  2. Once you have these fields created you’ll want to set them up in the “NetSuite Settings” page. Click the gear icon in the top right corner of the screen, then click “Settings.”
  3. Click “NetSuite Settings” on the menu bar that appears on the left hand side of the screen. You should now see the mapping screen. 
  4. You should see two text boxes on the screen, one that says “Custom transaction body storefront field” and another that says “Custom transaction body storefront order field” (If you do not, then it means you setup multiple connectors and will want to make sure that both the “Channel” and “Account” drop downs are set to “All”).
  5. Input the Field IDs for both of these fields (including the custbody portion). If you are unsure how to get the Field IDs follow the instructions here to get them: https://support.farapp.com/hc/en-us/articles/216635418-NetSuite-Internal-IDs-and-Field-IDs
  6. Click “Save” at the bottom of the screen. You are now ready to import your first order.

Mapping the 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. To get your SKU field mapped, follow these steps:

  1. Navigate to the General Settings for your MarketPlace/Cart by clicking the gear icon in the top right, clicking "Settings", selecting "Marketplace/Cart Settings" (if you have only one Marketplace, instead of Marketplace/Cart it will say the name of the Marketplace, ex: "Magento Settings"), and then selecting General Settings (direct link is https://app.farapp.com/settings#/marketplace_cart_settings/general_settings).
  2. If you have multiple channels/accounts, make sure you select the appropriate ones from the dropdowns that appear at the top. On this page you will see a text field labeled "NetSuite SKU Field" as shown here:
  3. In NetSuite, find the field ID of the field that you use as your SKU field and enter it into the text field (e.g. itemId for Item/Name Number), then click "Save" at the bottom of the page.

MFN (Merchant Fulfilled), FBA (Fulfilled By Amazon) and SFP (Seller Fulfilled Prime) Orders

Amazon orders come in two types: MFN (Merchant Fulfilled) and FBA (Fulfilled By Amazon). There are other types of orders as well such as SFP (Seller Fulfilled Prime), but these are considered a subtype of MFN. FarApp can tell if an MFN order is also a SFP order. If you have any special mappings you would like set up for just SFP orders to differentiate them from other MFN orders, please contact FarApp by opening a support ticket and supply an example of an MFN order and a SFP order and explain the logic you would like to use to differentiate them.

FBA orders are fulfilled by Amazon using inventory for your various SKU's that you have already shipped to Amazon where they store them and fulfill orders for you. Because FBA orders do not require you to fulfill them, they can be treated as already fulfilled. Because of this, by default FarApp posts FBA orders to your NetSuite as Cash Sales. If you would like to post them as Sales Orders instead, please contact us via support ticket and let us know that you would like to use a different default setting. For more information on FBA Orders, please see https://support.farapp.com/hc/en-us/articles/217185727-Amazon-FBA-Setup.

MFN orders require you to fulfill them, so by default FarApp will post them to your NetSuite as Sales Orders.

Importing Your First Order

Now that you have setup the required order fields, let’s try importing an order.

  1. Click the “Orders” tab at the top of your screen. This will take you to the orders screen which will show you all the orders you have imported through FarApp.
  2. On the right side of the blue menu bar, you will see a gear icon; hover over this icon and select “Retrieve Order.”
  3. Fill in the correct Channel, Account, and Order ID, and select “Retrieve”. You should see the order appear in FarApp.
  4. Now that the order has appeared, you can try posting it to NetSuite. To the right of the order, click the pen-and-paper button and select “Post Order to NetSuite.”
  5. In a few moments (you may need to refresh the page), you will either see the order turn green to indicate the order posted successfully, red to indicate that there was a posting error, or grey with a status of "complete" to indicate the order has posted as a Cash Sale to NetSuite and no fulfillment is required. If you retrieved an FBA order, its status should be "complete" once posted.
  6. If the order turns red, you have a posting error. Hover over the order to see the error; many errors can be resolved by updating your mappings. Since this is your first order two errors you will have to fix are that the shipment and payment methods are not mapped. If the order is an FBA order, you will need to set up your shipment method mapping here https://app.farapp.com/settings#/marketplace_cart_settings/order_sync/shipment_settings in the "Default shipment method to use for FBA orders:" field and your payment method mapping here https://app.farapp.com/settings#/marketplace_cart_settings/order_sync/payment_settings in the "Payment method for Amazon-fulfilled (FBA) Amazon orders:" field. If it is an MFN order, however, here are the links to instructions for setting these mappings up on your own:
  7. Since NetSuite does not report all errors with an order at once, you may find yourself clearing up one error to see a new one appear. This is the normal process to follow when importing an order.
  8. Once you have cleared all the errors and the order is showing as green check the order in NetSuite to confirm that all your desired data is in NetSuite.
  9. If there are fields missing in the NetSuite order you’ll want to follow the steps in the “Updating Your First NetSuite Order” section.
  10. If all the fields are present, congrats! You have successfully pulled in a NetSuite order using FarApp. Continue to the “Setting Up Order Sync” section so we can start automatically pulling in your orders.

Updating Your First Order

Since you are missing some fields in your NetSuite order you’ll need to add some more mappings. Repeat step 6.3 of “Importing Your First Order” until you have mappings for all the fields you want. Once that is done follow these steps to update your order in NetSuite:

  1. Click the “Orders” tab from the menu at the top of the page.
  2. Click the pen-and-paper icon to the right of your test order.
  3. Click “Update Order In NetSuite.”
  4. You should see the order turn blue and see a loading icon appear to indicate the order is posting. Once it changes back to green, the order has updated, and you can check NetSuite again.
  5. If you still do not see fields showing up in NetSuite, but you have setup the mapping for that field in FarApp, try manually adding the values to those fields. If you cannot, or if NetSuite deletes the values after you save the order, then there is setup you need to do on your NetSuite account to post to these fields. Once you are able to manually enter values into those fields, FarApp will be able to post to those fields as well.
  6. If all the fields are present, congrats! You have successfully pulled in a NetSuite order using FarApp. Continue to the “Setting Up Order Sync” section so we can start automatically pulling in your orders.

Setting Up Order Sync

Before you can setup order sync on app.farapp.com you will need to select your “Order Cutoff Date” for your connector. Follow these steps to set this up:

  1. Click the gear icon in the top right corner of app.farapp and select 'Settings' from the menu that appears
  2. Select "Marketplace/Cart Settings" from the menu on the left (If you have only one Marketplace, instead of Marketplace/Cart it will say the name of the Marketplace, ex: "Amazon Settings"), and then select 'General Settings'.
  3. If you have multiple Marketplaces or accounts, make sure you select the appropriate ones from the blue menu bar at the top of the page.
  4. You should see a date entry field that says 'Import orders created after' (for setting up Amazon you will see two date entry fields, one for your MFN orders and one for your FBA orders) (Examples pictured below)
  5. Select the date that you want to start importing orders from

General Order Cutoff Date:

Amazon Order Cutoff Dates:

Enabling MFN and/or FBA Order Sync and Fulfillment Sync

Now that you have successfully imported an order to FarApp you can enable Order sync for your channel. Here are the steps to accomplish this:

  1. Click the “Dashboard” tab from the menu at the top of the page.
  2. Click the “Edit” button to the right of your connector.
  3. To activate your MFN Order sync, click “MFN Order Sync: Inactive”, you should see it change to “MFN Order Sync: Active.”
  4. To activate your FBA Order sync, click “FBA Order Sync: Inactive”, you should see it change to “FBA Order Sync: Active.”
  5. To activate your Fulfillment Sync (only needed for MFN orders) Click "Fulfillment Sync: Inactive", you should see it change to "Fulfillment Sync: Active"
  6. Check the Orders screen periodically. You should start to see orders come in every 20 minutes and fulfillments post back to your channel every 90 minutes.

Setting Up Product Sync for Amazon

FarApp syncs products from NetSuite to Amazon. FarApp accomplishes this through its Product Mapper, which takes the NetSuite data for your items and translates it so that your posting channel will recognize and accept this data. You can access your Product Mapper here: https://app.farapp.com/settings#/marketplace_cart_settings/product_sync

FarApp offers two types of product sync 1) Full Product Sync and 2) Price/Qty Sync. We have customers who use one, the other, or both on their connectors. Here's what they do:

  1. FarApp syncs full product data such as title, description, images, price, quantity, etc from NetSuite to your storefront.
  2. FarApp only syncs price and/or quantity data from NetSuite to your storefront. You have the option of only syncing quantity data, price data or both. The SKU's using this sync must already exist in the storefront. Since FarApp is only sending price and/or quantity data to the storefront along with the SKU it wants to update, FarApp does not actually possess enough information to create a SKU on the storefront. This means that the SKU should already exist on the storefront with the title, description, images, etc that you want.

For more information on the two types of product sync, please see this article: https://support.farapp.com/hc/en-us/articles/225117028-Full-Product-Sync-and-Price-Qty-Sync

Storefront Flag Field

Regardless of the type of sync you are doing, FarApp requires a custom field for use as a “Storefront Flag” – one for each storefront that FarApp posts products to (Amazon, eBay, Shopify, etc.). (Note: if you have multiple accounts, there will be one flag for each account.) This allows you to add/remove items on the storefront by setting the value in NetSuite.

If you installed the FarApp for SuiteSuccess bundle above, FarApp would have created your flag field(s) for you. You can enter the following values for a flag field on an item:

FarApp for SuiteSuccess Storefront Flag Field Valid Values

Value
Definition
Notes
(blank) or "Ignore Item"
Ignored by FarApp FarApp will not load data from NetSuite if the flag field is blank.
Add/Update Item
Add/Update product data to storefront.  
Remove Item
Delete product/listing from storefront. Once an item has been flagged as "Add/Update Item", it is VERY important that it be flagged "Remove Item" when you want the item delisted. Setting a "Add/Update Item" flag to blank or "Ignore Item" means that FarApp will NOT load updates from NetSuite, and will remember that the item was flagged "Add/Update Item".
Post Children as Stand-Alone
Parent of stand-alone items (“Post Children as Stand-Alone” means post only Children). This is currently only supported for Amazon and eBay. Used for NetSuite matrix-item parents. Children will post as stand-alone (non-variation) items. FarApp needs the parent data to populate the children, so this tells FarApp to load, but not post, the parent data.

 

If you did not install the FarApp for SuiteSuccess bundle in NetSuite, you will need to create a custom item field for each Storefront Flag. The field(s) MUST be a single-character, free-form text field. This article explains how to create custom fields for your items: https://support.farapp.com/hc/en-us/articles/236072108-Adding-Custom-Item-Fields-in-NetSuite Items with this flag set to “Y” are added/updated on the storefront. Items with the flag set to “N” will be deleted from the storefront. Items where the flag is blank will be ignored by FarApp.

FarApp will load (from NetSuite) all items that have a value in the Storefront Flag field, and ignore any items that don’t. By only flagging items that need to be posted (add/update/delete), you remove clutter, reduce errors, and improve processing time for your products.

Here are the valid values you can use for a flag field that you set up yourself as a free-form text field:

Free-Form Text Field StoreFront Flag Valid Values

Value
Definition
Notes
(blank)
Ignored by FarApp FarApp will not load data from NetSuite if the flag field is blank.
Y
Add/Update product data to storefront.  
N
Delete product/listing from storefront. Once an item has been flagged as Y, it is VERY important that it be flagged N when you want the item delisted. Setting a Y flag to blank means that FarApp will NOT load updates from NetSuite, and will remember that the item was flagged Y.
C
Parent of stand-alone items (“C” means post only Children). This is currently only supported for Amazon and eBay. Used for NetSuite matrix-item parents. Children will post as stand-alone (non-variation) items. FarApp needs the parent data to populate the children, so this tells FarApp to load, but not post, the parent data.


The basic process of using the flag field is that items should go from blank to Y or Add/Update Item when you want them to list. They should go from Y or Add/Update Item to N or Remove Item when you want them deleted. After they’ve been deleted, they should then be “blanked” so that FarApp will eventually purge them and remove clutter. Items should NOT go from blank to N or Remove Item, as this will cause FarApp to try to delete items that don’t exist on the storefront, and will produce errors. Similarly, changing a flag from Y or Add/Update Item to blank tells FarApp to stop updating the item-data from NetSuite, so it will remain on the storefront without being deleted (and may be updated, depending on the storefront and your setup configuration).

You can read more about flag fields here: https://support.farapp.com/hc/en-us/articles/217185977-Storefront-Flag-Fields

Once you've set up the flag field in NetSuite you can begin setting up your product mappings.

Setting Up Full Product Sync or Price/Qty Sync Mappings

  1. To set up either of the product syncs, go to https://app.farapp.com/settings#/marketplace_cart_settings/product_sync. For an explanation of how to use the page, please see this article: https://support.farapp.com/hc/en-us/articles/225798028-Product-Inventory-Sync-Data-Mappings-in-app-farapp-com
  2. If you are setting up Price/Qty Sync for Amazon, click Add New Category and select InventoryLoader from the dropdown menu.
  3. If you are setting up Full Product Sync for Amazon, click Add New Category and select the category from the dropdown menu you would like to post items to. If you do not see the category you want to post to, please read this article, https://support.farapp.com/hc/en-us/articles/217185657-Amazon-Flat-File-Templates, and open a support ticket with us where you provide the Amazon Flat File template you would like to add. We will create a new category for you from this template.
  4. Once you have added the category you want to work with you will need to set up a mapping for the required field: CATEGORY.
    1. To add a mapping click the Add Mapping Row button near the bottom left of the page.
    2. Select a storefront field to map from either the Required, Standard or Uncommon drop down menus.
    3. Click "Add Mapping" and close the popup window. You can then click on the Category mapping and configure it. Please read the help text in the new popup window that will let you know how to construct the mapping.
  5. Next, you will need to repeat steps similar to those above to set up more mappings. If you are doing a Price/Qty Sync, please view the list of required fields at https://support.farapp.com/hc/en-us/articles/225117028-Full-Product-Sync-vs-Price-Qty-Sync#priceandquantitymappings. If you are doing a Full Product Sync, please create mappings for the following required fields: Flag Field, CATEGORY, brand, manufacturer, sku, title.
  6. Then you will probably need to set up mappings for the following Standard fields: msrp, quantity, upc and bullet_point_1 through 8.
  7. If you are setting up a Full Product Sync that will include FBA items, please see https://support.farapp.com/hc/en-us/articles/217185727-Amazon-FBA-Setup.

Creating a Test Product in NetSuite

These steps will walk you through creating a test product to use to confirm that FarApp posts it to your marketplace/cart correctly.

  1. Make sure you are logged into your NetSuite account.
  2. Navigate "Lists" > "Accounting" > "Items" > "New" (to create a new item)
  3. Fill out the required fields for your particular Marketplace/Cart:
    1. Amazon: flag field, brand, manufacturer, sku, title
    2. Fill out any other fields that you have set up mappings for
    3. Copy the Internal ID (should be near the top left of your screen) of product you just created.

Retrieving a Test Product Into FarApp and Posting it to a Storefront

Once you have completed these mappings and created a test product with all the necessary fields populated (including the flag field), you are ready to retrieve your first product into the FarApp dashboard's Products Page. You will not need to do this for all your products; FarApp will do this automatically once it is completely configured, but we will retrieve and post one item as a test product to confirm that the mappings you created above are working.

  1. Navigate to the Products Page in your FarApp dashboard: https://app.farapp.com/products
  2. Click on the gear icon in the blue bar > Retrieve Product from NetSuite
  3. A new window will appear. Enter the internal ID of the product you want to test with into the field and click "Retrieve." The internal ID is an identifying number that NetSuite assigns to your items.
  4. If do not see your product appear after retrieving it, please see this article: https://support.farapp.com/hc/en-us/articles/226283328-Why-didn-t-my-product-appear-in-the-Products-page-after-retrieving-it-

Now that you have retrieved your first product into FarApp, FarApp needs to post the product to Amazon. Again, this is something that FarApp will do automatically once it has been completely configured, but we will manually tell the item to post now in order to confirm that it posts correctly.

  1. From the Products Page, click on the Pen & Paper icon to the right of your test item > Post to Amazon.
  2. The process to post a single item can sometimes take up to several minutes. Please wait to confirm that you see that the status on the item changes from "In FarApp" to "Product posted to Amazon, result pending." Amazon has a two step process for posting items and now we are waiting for Amazon to finish their confirmation process for the item posting.Screen_Shot_2017-09-19_at_9.12.52_AM.png
  3. You can periodically click "Check Pending Posting Result" in the Action menu to the right of the item if it takes some time for Amazon to return confirmation for the posting.Screen_Shot_2017-09-19_at_9.13.14_AM.png
  4. Eventually Amazon will return a result and the status should change to "Product posted to Amazon." If the product row turns red at this step and you see an error message when hovering your cursor over the row, please takes steps to correct the error and try posting the item again (which may require reloading the item from NetSuite who you make changes to the item there).
  5. If the item says that it has posted to Amazon, you can navigate to your seller central and check the data on the item there. The goal is that all the data for you item in NetSuite will have synced to Amazon via the mappings that you created.

Enabling Product Sync

Now that you have successfully posted a Product to Amazon, you can enable Product Sync for your Amazon channel. Here are the steps to accomplish this:

  1. Click the “Dashboard” tab from the menu at the top of the page.
  2. Click the “Edit” button to the right of your Amazon connector.
  3. Click “Product Sync: Inactive”, you should see it change to “Product Sync: Active.”
  4. Check the Products Screen periodically. You should start to see your Products be retrieved into FarApp and then posted to Amazon.

You may notice the "PriceQty Sync: Inactive Button" on that page as well. Your Product Sync syncs price and quantity data already and FarApp's PriceQty Sync functionality is not actually applicable to Amazon. You an ignore that button.

You have now successfully posted your first product via FarApp and enabled your Product Sync. If you skipped the Order Sync section earlier in order to set up your Product Sync first, please return to that section now to complete the set up of your Order Sync.

Setting Up Amazon Fees and Settlement Report Processing For NetSuite

FarApp can import your fees, refunds, and other transactions from the Amazon settlement reports. These reports are generated by Amazon weekly or bi-weekly (the frequency depends on your account at Amazon). Please let us know if you want us to process settlement reports for you. Please reference farapp.com for pricing on this feature: https://www.farapp.com/connector/amazon/ Not all our customers connected to Amazon choose to use FarApp to sync their Settlement Reports to NetSuite.

Unfortunately, the fees, refunds and other transactions from the Amazon settlement reports are not something that FarApp can access through the Amazon Reports API. Your reports will have to be released for external access on a weekly or bi-weekly basis. If this has not already been set up for your account, you will need to ask Amazon to set up your account to release the reports on a scheduled basis.

To request this, please open a ticket with Seller Support and ask Amazon to automatically run the reports. Doing this will cause the report to automatically generate each time they close a settlement and send you payment. The only drawback to this is that this will only generate reports moving forward. No prior reports will be generated.

Scheduling Reports

  1. Go here (login required).
  2. Click on Your Account and then select Make changes to your account.
  3. Enter the following information into the contact form:
    • Contact Reason:  Please turn on automatic settlement report for my account.

    • Changes:  I would like to request that the following settlement reports be automatically scheduled for my account: 

      Flat File Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE
      XML Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_XML
      Flat File V2 Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2

  4. Once Amazon has responded to this request and confirmed that your reports have been scheduled, you can continue with the sections below (please note: because Amazon will only start generating reports going forward, you may have to wait some time before a report gets generated that FarApp can work with.

Order Fees

Order fees unfortunately are not part of Amazon's order data, so we don't import them at the same time as we import the order. But once a new settlement report is generated, we will update the corresponding orders in NetSuite with the fees.

In order to support this, you'll need to create a "Other Charge For Sale" type item in NetSuite for each fee type in Amazon. When setting up these items, make sure the "Can be Fulfilled" checkbox is not flagged (under the basic properties tab). Here is a list of SKUs that you'll need to create:

Note: Please make sure you don't have trailing spaces in the names when you make the SKUs.

  • BalanceAdjustment
  • BuyerRecharge
  • Commission
  • CS_ERROR_ITEMS
  • Current Reserve Amount
  • Customer Return
  • Customer Service Issue
  • Customs Reimbursement
  • Damaged:Inbound
  • Damaged:Outbound
  • Damaged:Warehouse
  • Discount Not Applied
  • DisposalComplete
  • FBA Inventory Storage Fee
  • FBA transportation fee
  • FBACustomerReturnPerOrderFee
  • FBACustomerReturnPerUnitFee
  • FBACustomerReturnWeightBasedFee
  • FBAInboundDefectFee_BAGGING
  • FBAInboundDefectFee_LABEL_ISSUE
  • FBAInboundDefectFee_SUFFOCATION_STICKER
  • FBAInboundDefectFee_TAPING
  • FBAInboundTransportationFee
  • FBAPerOrderFulfillmentFee
  • FBAPerUnitFulfillmentFee
  • FBAWeightBasedFee
  • Fee correction
  • FREE_REPLACEMENT_REFUND_ITEMS
  • GiftWrap
  • GiftwrapChargeback
  • GiftWrapTax
  • Goodwill
  • INCORRECT_FEES_ITEMS
  • INCORRECT_FEES_NON_ITEMIZED
  • Inventory Placement Service Fee
  • Item Not Received
  • Lost:Inbound
  • Lost:Outbound
  • Lost:Warehouse
  • Manual Processing Fee Reimbursement
  • MISSING_FROM_INBOUND
  • MULTICHANNEL_ORDER_LOST
  • NonSubscriptionFeeAdj
  • POS_NOSKU
  • Previous Reserve Amount Balance
  • Principal_Promotion
  • RefundCommission
  • RemovalComplete
  • REMOVAL_ORDER_LOST
  • RestockingFee
  • Return Adjustment
  • ReturnShipping
  • REVERSAL_REIMBURSEMENT
  • SalesTaxServiceFee
  • Shipping
  • Shipping label purchase
  • Shipping Reimb.
  • ShippingChargeback
  • ShippingHB
  • ShippingTax
  • Storage Fee
  • StorageRenewalBilling
  • Subscription Fee
  • Tax
  • Unplanned Service Fee - Barcode label missing
  • VariableClosingFee
  • WarehousePrep
  • WAREHOUSE_DAMAGE
  • WAREHOUSE_DAMAGE_EXCEPTION
  • WAREHOUSE_LOST
  • WAREHOUSE_LOST_MANUAL
  • Shipping label purchase for return
  • Manual Processing Fee
  • TaxDiscount

Refunds

Refunds are also imported from the settlement report. By default, we import these against the corresponding orders in NetSuite. But if preferred, we can bring in one summary transaction for all the refunds combined. If the transactions span two months, by default we will split the summary transaction into two.

Service Fees

Service fees in the settlement report that are not associated with specific transactions in NetSuite are imported as new summary transactions (cash sale if positive or cash refund if negative). These summary transactions include line items for all the service fees on the settlement report. If the transactions span two months, by default we will split the summary transaction into two.

Other Transactions

Likewise, other transactions in the settlement report that are not associated with specific transactions in NetSuite are imported as new summary transactions (cash sale if positive or cash refund if negative). These summary transactions include line items for all the other transactions on the settlement report. If the transactions span two months, by default we will split the summary transaction into two.

Testing and Enabling Your Settlement Report Processing Sync

After you have read through the above sections and created all the SKU's that FarApp requires to sync Settlement Reports, please open a ticket with us. You will need to provide an order that FarApp has synced to NetSuite for you that Amazon has also already generated settlement data for. Because of these two requirements, customers often set up Settlement Report processing several weeks after going live with FarApp. When you do provide us with an order, we will post the order fees and other adjustments to the order in your NetSuite and have you confirm that the fees have posted as you expect. After that we will post all the fees and adjustments for the settlement period that are not associated with a specific order, such as compensation for lost of damaged FBA items. We will then have you confirm that thees fees have posted as you expect. After that, FarApp will activate your Settlement Report processing sync. This entire set up and testing processing can take several weeks.

To access your Settlement Settings in FarApp, please follow this link: https://app.farapp.com/settings#/marketplace_cart_settings/settlement_sync

Setting Up Refund Sync for Amazon

If you have set up Settlement Report processing for Amazon following the steps in the section above, you do not need to set up a dedicated Refund Sync for Amazon. You will notice that refund data syncs with the rest of Amazon's settlement data.

If you would like to forego a full settlement data sync, you can set up a sync just for refunds. Please read the following to learn about how Amazon handles refunds for different types of orders and how to test and enable your Refund Sync.

The Refund and Return Process for FBA Orders

  1. Amazon handles the return of the inventory and restocks items where appropriate.
  2. FarApp can then sync the details of the refund back to NetSuite. We can do this as either a normal refund sync which can be configured here, https://app.farapp.com/settings#/marketplace_cart_settings/refund_sync, or as part of the weekly or biweekly settlement report process (see section above). Amazon only releases refund data to us at the same time it generates settlement report data, so FarApp has to wait to sync refund data to NetSuite until Amazon release the refund data when it generates its weekly or biweekly settlement report.

The Refund and Return Process for MFN Orders

  1. You manually create a return authorization in NetSuite.
  2. Once you receive the returned item, you create an item receipt in NetSuite. This returns the item to the correct inventory location.
  3. You process the refund in Amazon.
  4. FarApp can then sync the details of the refund back to NetSuite. We can do this as either a normal refund sync which can be configured here, https://app.farapp.com/settings#/marketplace_cart_settings/refund_sync, or as part of the weekly or biweekly settlement report process (see section above). Amazon only releases refund data to us at the same time it generates settlement report data, so FarApp has to wait to sync refund data to NetSuite until Amazon release the refund data when it generates its weekly or biweekly settlement report.

Our engineers are planning to implement functionality in 2017 to allow you to process the refund in NetSuite so we can sync the data about it back to Amazon, but as of now refunds only sync from Amazon to NetSuite, which is why the Refund Settings page only includes a section title "Outgoing Refund Settings (Amazon to NetSuite)."
For MFN orders, FarApp cannot automate steps 1 and 2 because we have no way of knowing when you received the returned merchandise or in what condition it was in, so that is why you need to manually enter that information into NetSuite.

Setting Up Refund Sync for both FBA and MFN Orders

Please fill out the desired settings here: https://app.farapp.com/settings#/marketplace_cart_settings/refund_sync Most customers leave the positive and negative refund adjustment fields blank (if they are required, that will be discovered in later steps). Most customers fill out their settings like this image:

After you have filled out these settings, please contact FarApp by opening a support ticket and supplying an order that has been refunded in Amazon for which settlement data already exists. Please also state that you would like to sync refunds on their own and not part of full Settlement Report processing. Our operations team will assist you by test posting the refund data to NetSuite for you. Once you confirm that the refund appears as expected in your NetSuite, you can turn on your Refund Sync in your dashboard here: https://app.farapp.com/storefronts/Amazon/default/edit

You can monitor your refunds in FarApp using this screen: https://app.farapp.com/othertransactions Be sure to select either Amazon or NetSuite as your source channel as appropriate and also select the appropriate transaction type. FBA Orders that posted as Cash Sales originally will post their refunds as Cash Refunds.

Setting Up Your Notification Settings

It is important to monitor the "health" of your FarApp integration by staying on top of any orders, items, refunds, etc that might have errors when FarApp tries to sync data for them. The best and easiest way to do this to configure you Notification settings in FarApp so FarApp will send you daily error report emails for your different types of syncs.

You can manage all the various notifications that FarApp can send at https://app.farapp.com/settings#/notification_settings. All settings accept a comma-separated list of email addresses to send the reports to. Some notifications may not be sent unless your FarApp account is currently processing those types of feeds. For example, if FarApp isn't setup to process custom record updates, then adding your emails to that field won't have an effect.

 

Connecting FarApp to Your 3PL’s

ShipStation

FarApp provides a connector between ShipStation and NetSuite that allows you to pull orders in from NetSuite to ShipStation and push fulfillments back from ShipStation to NetSuite. In order to set this up, please follow the steps in our ShipStation Integration Guide: https://support.farapp.com/hc/en-us/articles/115011334208-ShipStation-Integration-Guide

ShipWorks

FarApp provides a connector between ShipWorks and NetSuite that allows you to pull orders in from NetSuite to ShipWorks and push fulfillments back from ShipWorks to NetSuite. In order to set this up, please follow the steps in our ShipWorks Integration Guide: https://support.farapp.com/hc/en-us/articles/115011371928-ShipWorks-Integration-Guide

Shipwire

FarApp provides a connector between Shipwire and NetSuite that allows you to pull orders in from NetSuite to Shipwire and push fulfillments back from Shipwire to NetSuite. In order to set this up, please follow the steps in our Shipwire Integration Guide: https://support.farapp.com/hc/en-us/articles/115011378588-Shipwire-Integration-Guide

ShippingEasy

FarApp provides a connector between ShippingEasy and NetSuite that allows you to pull orders in from NetSuite to ShippingEasy and push fulfillments back from ShippingEasy to NetSuite. In order to set this up, please follow the steps in our ShippingEasy Integration Guide: https://support.farapp.com/hc/en-us/articles/115011373528-ShippingEasy-Integration-Guide

Other

FarApp supports a number of additional 3PL's. You can see a full list of the 3PL's here: https://support.farapp.com/hc/en-us/articles/216635908-Supported-Marketplaces-Carts-and-3PLs We are working on developing documentation for the set up steps for these other 3PL's as well and will include those steps here once they are complete.

 

Credit Cards and PCI Compliance

 

Amazon is responsible for capturing payment and preventing credit card fraud on your orders. Amazon will settle with you every 1 to 2 weeks depending on your Amazon account configuration in Seller Central. As such, you can read about our credit card and PCI compliance policies here https://support.farapp.com/hc/en-us/articles/115011513148-Credit-Cards-and-PCI-Compliance but they will not apply to your Amazon orders.

 

Next Steps and Additional Information

Please see this article if you have any questions on the process for going live with FarApp: https://support.farapp.com/hc/en-us/articles/115012240747-The-Go-Live-Process

Please contact FarApp if you have any questions on the step above or have any suggestions for how we can improve our documentation.

Posting products to Amazon can be particularly complicated, so please let us know if you need any assistance deciding between InventoryLoader vs full product sync templates, etc. FarApp can also work with Business Pricing and Repricing, so please contact us if you would like to setup either of these additional features.

Return to Top

Comments