Country of Origin Help
I'm hoping someone can help as i am receiving no help from amazon regarding this issue even after a number of phone calls where i have been cut off or had to explain myself to 20 different advisors and emails where i get a generic reply.
I have had the email which states that i will need to enter my COO for all my listings over every marketplace i sell on.
Amazon sent the instructions on how to do this - Create Category Listings Report - Open spreadsheet - Enter COO in to correct column - make sure that you set this to a partial update - save file - upload it back to amazon using Add Products via Upload.
Sounded like a breeze until i waited for the file to upload to only be met with a error file as long as my arm and to make matters worse the report was in the marketplaces language.
I just want to COO to update not receive a error file which most of it (after google translating parts) have nothing to do with the COO.
Can anyone help or do i have to go through my listings 1 by 1 which is going to take me all year?
Country of Origin Help
I'm hoping someone can help as i am receiving no help from amazon regarding this issue even after a number of phone calls where i have been cut off or had to explain myself to 20 different advisors and emails where i get a generic reply.
I have had the email which states that i will need to enter my COO for all my listings over every marketplace i sell on.
Amazon sent the instructions on how to do this - Create Category Listings Report - Open spreadsheet - Enter COO in to correct column - make sure that you set this to a partial update - save file - upload it back to amazon using Add Products via Upload.
Sounded like a breeze until i waited for the file to upload to only be met with a error file as long as my arm and to make matters worse the report was in the marketplaces language.
I just want to COO to update not receive a error file which most of it (after google translating parts) have nothing to do with the COO.
Can anyone help or do i have to go through my listings 1 by 1 which is going to take me all year?
2 replies
Seller_5N18Y9Oic1CDD
u can fix those backend stuff easily from gsheets using hopted writebacks. it's basically a seller central connector with spreadsheets and pretty much 99% fit to what you described
Amyy_Amazon
Hi @Seller_f5XXcLYklrdfI
Thanks for reaching out.
A few tips to avoid errors on the bulk upload:
- Ensure you select "Edit (partial update)" in the Listing Action column for all product listings - this tells the system to only update the COO field and ignore other columns
- Only fill in the COO column and leave all other fields as they are in the downloaded report
- The COO value must be selected from the drop-down list (not typed manually)
- Upload the file via Catalogue > Add Products via Upload > Upload file > Submit products
- Download and update the CLR file immediately - avoid next-day updates
If the bulk upload continues to give errors, you can also update COO one at a time via: Inventory > Manage All Inventory > Edit Listing > Safety & Compliance > Country/Region of Origin
Relevant help pages:
Providing Country of Origin for goods shipped cross-border
Download Category Listings Report
Regards,
-Amyy