Categories, Product Types, and Item Types in the Amazon Flat File Template
NetSuite Connector syncs items to Amazon using flat file templates. For more information about importing a template file to NetSuite Connector, read the SuiteAnswers article Import Amazon Custom Flat File Templates to NetSuite Connector.
Amazon uses the following attributes from the template file to classify an item:
-
Category – You can use several Amazon categories during product sync. Some categories can inherit product attributes from other templates.
For information, read Import Amazon Custom Flat File Templates to NetSuite Connector
-
Product Type – The product type is a required field for some templates. The value of this field helps further classify an item into categories. To check if product type is included in your template, in the Data Definitions worksheet of the template, check for product_type or feed_product_type field in the Local Label Name column. If the field is included and if the rightmost cell of the row has the Required value, you must populate the product type. Amazon permits only valid values for this field. The Accepted Values column indicates where you can find the valid values. Usually, the Product Type column in the Valid Values worksheet contains the list of valid values that you can populate in your list in NetSuite.
-
Item Type – The item type is an optional field and not included in all templates. If included, the field lets Amazon classify the item in the Amazon browse tree so that a customer finds the item by browsing through Amazon categories. To check if item type is included in your template, in the Data Definitions worksheet of the template, check for item_type or item_type_keyword field in the Local Label Name column. If the field is included and if the rightmost cell of the row has the Required value, you must populate the item type. The Accepted Values column indicates where you can find the valid values. Usually, these values are available in the Amazon’s Browser Tree Guide (BTG) for the corresponding flat file template. You can find and download the BTG files from the Amazon seller central website help.
After you have the BTG corresponding to your template, look in the main worksheet that has the Node ID, Node Path, and Query columns. The values at the right of the text item_type_keyword: in the Query column are the valid values for the item type field. Do not include the text item_type_keyword: when adding these values to your list in NetSuite.