When creating a new listing using a UPC, it is important to provide detailed information about your listing. Some information is required by Amazon in order to successfully create a listing. Other information may not explicitly required, but will help customers find your products and increase sales. This guide will show you how to understand these recommendations and requirements from Amazon and how you can implement them in SureDone.
This guide shows you how to use Amazon's Inventory File Template to understand what fields are required or relevant for your particular product listing. The last section of this guide will show you how to take that information, create fields in your account and map them to Amazon so that you can add all the product details you wish.
: Sometimes the accepted values listed in the Inventory File Template are not the same ones that Amazon requests via their API. We try to catch them all, but things are constantly changing - if you use an accepted value in this file and Amazon returns an error, they usually return the updated list in the error message. Please report it to us in a ticket at www.suredone.com/support
Scroll down the page about half-way and you should see the files in the left most column, they are organized by department. Just click on them to download the file, which we'll explain in detail below.
Once you open the file, you will be prompted to Enable Macros, click Enable. If your excel is not compatible with Macros or you get an error, don't worry - you should be able to get what you need from the template without them.
You can take some time to read the instructions, but remember that these files are originally designed for a different application within Amazon, so not everything will be applicable. The most important things will be mentioned here in this guide.
Data Definitions Tab
This tab contains a list of all possible fields that can be sent to Amazon. It includes everything from as basic as price, to more obscure details like battery_type or exterior_finish.
This page will tell you:
- The name of the field (both technical and user-friendly)
- What it is used for in Amazon
- What format the accepted values must be in (for example: An alphanumeric string; 1 character minimum in length and 50 characters maximum in length).
- The last column tells you whether the field is required, preferred, or optional. This is the most important column.
You'll notice that in some of the cells for Accepted Values it says "Please select a value from the Valid Values tab. This is the other important tab in this file, it lists out the only accepted values for certain product details. We'll get into that a little below.
You'll also notice that the Data Definitions Tab is organized and color coded. The first few colors are consistent across all categories, representing Basic information, Offer details, etc.Following that,each section will correspond to a different Product Type, which is a second classification used by Amazon to help organize their catalog.
The headers in the general sections apply to all your listings within this category, but the headers in the following sections are only applicable to that specific Product Type. If a field is relevant for more than one Product Type, it will be repeated for each relevant section. This color coding will mirror the color coding on the Valid Values Tab described below.
Valid Values Tab
This tab tells you what values are accepted for those that accept only specific inputs. For example, sole_materials must be one of the values in column BJ (see below).
The color coding for the general sections is the same, i.e. Basic Details are in peach, Offer Details are in red, etc. The color coding stops when you get to the Product Type specific fields, in which case they are all brown.
Because of this it s best to use the Data Definitions
tab to find your Product Type and the relevant fields and then use the Valid Values
tab to find the accepted options you can submit for those fields.
The fastest way is to copy the field_name (Column B) from Data Definitions tab, then go to the Valid Values tab and hit Control + F to Find the that value.
Above, you'll notice that Outer Material is listed twice with [ RidingApparel ] [ Helmets ] appended to it. That is because sometimes the accepted values for these fields can vary based on the Product Type.
When this happens the format is as you see in the picture above Field Name - [ProductType]. So make sure you are looking at the correct value. Fortunately, Amazon groups duplicated of the fields together so you will know quickly if it has duplicates.
How to Map these Fields in SureDone
Every field in these files should be available under Amazon s XML Mapping, of course they make updates from time to time without announcement, so if you find your's is missing, just let us know.
This section will guide you in setting up these fields in SureDone:
Tip: you should check out the Accepted Values cell in the Data Definitions tab (Column E) to set the best settings for your custom fields. Generally, a normal varcar field will work for any, but you may wish to customize these.
2. Go to Settings > Channels and click on Amazon XML Mapping
3. Select the Type of XML (Department) to edit:
You'll find the details which apply to all Products (basic details, offer details, etc.) under the first few groups. After that, they are listed by Department, in alphabetical order.
4. Find the attributes within the department that you want to map, click the drop down to the right, locate and select the custom field you made in step 1.
Repeat this process until you have all your needed fields mapped...
Tip: SureDone does it's best to select a Product Type for you to give you one less thing to worry about it, but if you find that you need to submit a different Product Type, just map it under the department XML mapping and submit your own value.