Category – This is the highest-level classifier. Each flat file template represents a different Amazon category. If you only list in one Amazon category, FarApp will just use the flat file template for that category. However, if you list to multiple categories (i.e. you use multiple templates), you'll want to create a field in your backend system (e.g. NetSuite) that indicates which template a particular item should post to. So for example, if you have a clothing item, it should have a field that indicates the item should post to the "Clothing, Accessories & Luggage" template.
Product Type – The product type is a required field if it exists in your template. The value of this field further classifies an item within its category on Amazon. You can find whether the Product Type is included in your template by opening the Excel template, going to the "Data Definitions" worksheet, and looking for "Product Type" in the "Local Label Name" column. It will have a field name similar to product_type or feed_product_type. If it's included in your template, and has a value of "Required" in the rightmost field, then you must populate it. Amazon only allows specific values for this field. The "Accepted Values" column will indicate where you can find these valid values. Usually, they can be found in the rightmost "Valid Values" worksheet of the Excel template. Look for the "Product Type" column in this worksheet for the valid values that you'll want to populate in your list in your backend system.
Item Type – This field isn't always required and isn't included in all templates. If it is included, it's used to determine where the item is classified within Amazon browse tree so a customer can find your item by browsing through Amazon's categories. You can check whether "Item Type" is included and required for each category by opening the Excel template, going to the "Data Definitions" worksheet, and looking for "Item Type" in the "Local Label Name" column. It will have a field name similar to item_type or item_type_keyword. If it's included in your template, and has a value of "Required" in the rightmost field, then you must populate it. Amazon only allows specific values for this field. The "Accepted Values" column will indicate where you can find these valid values. They are almost always found within Amazon's Browse Tree Guide (i.e. BTG) for the corresponding flat file template. You can find and download the BTG from the same table referenced here. Once you have the BTG corresponding to your template, look in the main worksheet that has the "Node ID", "Node Path" and "Query" columns. The valid "Item Type" values are the values to the right of "item_type_keyword:" in the Query column. When adding these values to your list in your backend system, please don't include the "item_type_keyword:" text.