NetSuite Item to Amazon Product Add/Update

The NetSuite Item to Amazon Product Add/Update integration flow allows you to import an item from NetSuite into Amazon. Whenever a simple inventory item or matrix item is created or updated in NetSuite, the Integration App exports the details of that item as a product on Amazon.
The flow allows you to map common fields as well as category and sub-category specific fields in Amazon with fields in NetSuite. The field mapping option displayed in the Product Mapping page in the Product section is created based on Amazon’s flat-file templates used to export products. Please note that Celigo doesn’t provide fields in NetSuite that need to be mapped for migrating the product information from NetSuite to Amazon. It is the responsibility of the user to create the required fields in NetSuite and map it with fields in Amazon.

When you run the flow after mapping the Amazon fields with NetSuite fields, the Integration App processes the information into the category-specific flat files and submits one feed for each parent category to Amazon. Once the flow runs you can monitor the progress of the flow in the Dashboard page. Once you run the flow, the main flow gets triggered first that exports all the items from NetSuite to integrator.io. Once the item gets exported to integrator.io separate flow specific to all parent categories gets triggered to move items in different categories to Amazon. The flow stays in the “In Progress” state until the feed is successfully processed on Amazon. Amazon can take a few to several mins to process the feed based on the details and number of items being exported in each category.

Note:

Amazon has a process in place called “Detail Page Control” by which the product information submitted by multiple sellers is merged and information from a seller is selected to be displayed on the Amazon product page. The Integration App does not control the criteria for selecting the content that is displayed on the Amazon product page.
Amazon only allows 15 feeds requests per hour.

The following section only explains exporting simple inventory item. To learn more about matrix item export from NetSuite to Amazon see, Export NetSuite Matrix Item as Amazon Product and Variations.

Screens depicting the data flow:

From the Advanced Setting section, select the appropriate value in the NetSuite saved search for syncing Item drop-down list and click Save.
Click the Field Mappings icon against the NetSuite Item to Amazon Product Add/Update flow. The Product Mapping page is displayed. For more information on the Product Mapping page, see Work with Field Mappings for the product flow.
Map the Amazon fields with the NetSuite fields and Click Save.
Create an item and enter the required information in the NetSuite fields which you have mapped against Amazon fields in the Product Mapping. You must select the ETAIL CHANNEL tab value as Amazon. A new item is created in NetSuite.
Select the 'Product' section and press the Run button for the NetSuite Item to Amazon Product Add/Update flow.
The flow status is visible on the Dashboard The status changes from 'queued' to 'in-progress' to 'completed' after the feed submitted through flow is successful.
When the flow is completed successfully, verify that the item is exported to Amazon in the 'Manage Inventory'

Note: This flow is only supported by the standard (previously "premium") and premium (previously "enterprise") edition of the Integration App.

Work with Field Mappings for the product flow

The Product Mapping page is displayed when you click on the Field Mappings icon against the NetSuite Item to Amazon Product Add/Update flow. The page allows you to map Amazon fields, as per the selected category, with the NetSuite fields to import a product from NetSuite to Amazon. The initial page displays the list of common fields required for all categories which need to be mapped to your NetSuite account fields. The Common fields display pre-mapped fields with NetSuite. If needed, you can change the common field mapping with your desired fields. If needed, you can also add additional fields.

The Product Mapping page allows you to leverage the following features:

Add Amazon categories: This allows you to add a specific category and sub-category (if applicable) for the item that you need to import.
Remove Category: This allows you to remove a specific category and sub-category (if applicable) from the list of added categories.
Collapse All: Hides the details of all mapped fields added by you for the sub-categories. Once you click Collapse All, only the mapped fields pertaining to the main category are displayed.

The following image displays the page details after the Collapse All is clicked.

Amazon Attributes: The checkbox allows you to control the fields that are displayed for mapping based on the following parameters. You can select one, multiple or all parameters to filter the fields that are displayed for mapping:
- Required: Displays the list of all the mandatory fields that must be mapped to import the item from NetSuite to Amazon.
- Preferred: Displays only the list of preferred fields that should be mapped to import the item from NetSuite to Amazon.
- Conditional: Displays only the list of conditional fields that may be mapped to import the item from NetSuite to Amazon.
- Optional: Displays only the list of conditional fields that may be mapped to import the item from NetSuite to Amazon.
Field Mappings: The checkbox allows you to control the fields that are displayed for mapping based on the following parameters. Once you select a parameter, the fields pertaining to the selected parameter are displayed.
- All: This is the default view for displaying the fields added for mapping to import product from NetSuite to Amazon. Displays all the added fields without filtering any field.
- Mapped: Displays all Amazon fields added for mapping which has been already mapped with NetSuite fields.
- Unmapped: Displays all the Amazon fields added for mapping which have not been mapped with NetSuite fields.