Once a category specific file has been downloaded, then it is time to complete the data before uploading.
The file is separated into a number of different sections. Which I will go through form left to right below. The required fields are at the left of the sheet with the optional fields to the left of this. Note that only filling in the required fields will leave a very thin listing, seller should fill in as much detail as possible
Valid Values
Many of the fields in the upload template must be chosen from a list of options. These options are given in the Valid Values tab in the upload template.
Required fields section
There are a number of required fields on the file, these are:
- Feed file type. Determines the attributes for the product. Based on category selection
- Item SKU. Your stock number for the product
- External product ID. The barcode for the product e.g. UPC, EAN, ASIN (Use if the product exists on another Amazon site already)
- Item name. Product title
- Manufacturer
- Brand name
- Browse node. Category for the product in the form of a numerical code. Can be obtained from the download inventory file page or a Browe node tree guide can be obtained from the Amazon website
- Quantity. Must be zero for FBA items.
- Main image URL. Each product must have at least 1 image
Details on the required and optional fields is given in the Data Definitions tab.
Images section
There is a tab on the inventory template which give required image specification for new Amazon products.
Images included in the image file must be available from a downloadable location and the full URL must be used.
Right: https://i.imgur.com/yQTzcVj.jpeg
Wrong: yQTzcVj.jpeg or https://i.imgur.com/yQTzcVj
If you are looking or a free website hosting company for your product then https://imgur.com/ is one option.
When creating listings use multiple images to improve conversion rate and give more information buyers.
Variation section
This section is only used if variations are being created. Details on variation listing creation is given here.
Basic and Discover sections
Despite being optional this section contains vital information about a product such as description, bullet points and part number which should be completed for every listing.
Fulfilment section
These fields are required for FBA items. To create FBA items the dimensions must be completed and the Fulfilment centre must be set to Amazon_EU (for the EU).
Compliance section
Fill these fields out for items being sent into FBA for Hazmat clearance. Most important is the battery and Hazmat information.
Offer section
Details on the offer the seller is creating including
- Merchant shipping template. This sets the shipping rates for the product is using FBM.
- Condition
- Tax Code. Set from a set of valid tax codes available on the Amazon site
If you are uploading to multiple EU countries then the prices must be set for each country in the Offer (UK, FR, IT, ES, FR, NL) section. EU prices in Euros.
B2B section
For setting discounted prices for business customers. Can we set as percentage discount or a fixed price.
Upload files
Once the file is completed it can be uploaded as and Excel workbook in inventory > add products via upload > upload an inventory file.
The status can be seen under the Monitor upload status tab. Once the file has been uploaded there will be a process report to download. Incomplete product can be viewed in catalogue > drafts.
