Step 8 - 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

Setting Up 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 Category Mappings

While flag fields determine whether or not FarApp should pull item out of NetSuite, the category fields/mappings define to which storefront or category within the storefront item should be posted. 

  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.

Comments