Product template uploads (Amazon)
When selling on Amazon Marketplace, there are basically three ways to transfer product information to Amazon:
- Manually adding products
- Upload through templates
- Through API access.
This article is about this second approach. It's currently (2024.12) only about updating existing product information.
Static & dynamic fields
There seem to be a lot of diffent kinds of templates, with the differences between those kinds often lost on me. However, one distinction that is not lost on me, is between what I call templates with static fields and with dynamic fields. Example of a static and dynamic field: country_of_origin - country_of_origin[marketplace_id=A13V1IB3VIYZZH]#1.value.
Why this distinction is important:
- Templates with static fields, can easily be generated from scratch as
.csvfiles. They need only two columns (one for identification, one with product information) to be useful - Templates with dynamic fields, seem to only work as Excel .xlsm files. Copying the content to csv files, doesn't work. I also have the impression that LibreOffice can process them correctly, but not safe them in a way that Amazon can use them
- Fields related to GPSR Compliance Documents, seem only available as dynamic fields - Quite unfortunate.
Downloading templates
- Default location for downloading empty templates:
Seller Central » Catalogue » Add products via upload » Page: Upload Products & Inventory. - Often, reports concerning existing inventory, can be used for this as well:
Seller Central » Reports » Inventory reports
Page: Upload Products & Inventory
Here, you can download templates for adding new products, or for updating existing products. In either case, the file that you download, will be empty: You have to take care of the contents yourself. Like by copy-pasting stuff from a downloaded inventory file.
Download inventory reports
Yes, this article is about uploading. However, at times I need to download my inventory, to update some columns. In Dec. 2024, I want to update/add some image fields because of the GSPR.
None of the reports that can be customised, offer the possibility to incorporate image-related fields:
- Active listing report
- Open listing report
- Inactive listing report
- All listings report
- Cancelled listings report.
The only report so far (Dec. 6, 2024) that includes all image fields, is the Category Listings Report. But AFAIK, I can't use this to upload stuff (except for Amz.de, where we do pan-European FBA)
CSV templates
As mentioned at static fields: You can easily create your own CSV template. See GPSR-related images upload in bulk (Amazon) for details.