We have seen multiple threads on this topic, and I wanted to break it down into easy-to-follow steps to: 1) understand which SKUs are missing this attribute and 2) how to update the attribute in bulk.
***If the Category Listings Report is not available for your account, please leave a comment below, and I'll promptly raise a request to have it enabled.***
1) How do I know which of my SKUs are missing COO?
For this step, you will need to download the Category Listing Report (CLR) - Important: If this report is not available, please contact our Selling Partner Support and they will make it available for you.
- Go to Reports and select Inventory Reports from the menu bar in Seller Central.
- Select Category Listing Report under the available options.
- Ensure to set Select Status Filter as All to include all products.
- Click Request Report to download. - Note: It may take up to 45 minutes for this report to be generated. Under normal circumstances, creating a report takes less than a minute.*
- COO information can be found in different columns depending on the report type and categories. You can search with the keyword "Country or Origin".
2) How do I update the COO for my products in bulk?
- Visit the Add Products via Upload page.
- Click “Get Product Template” under “Update product details”.
- Open the template you have just generated and populate four columns:
- Column A feed_product_type: provide the product type of the ASIN for which you would like to update COO
- Column B item_sku: provide the SKU for which you would like to update COO
- update_delete column (column position will vary depending on product type): select Partial Update (this setting ensures that the values in your catalogue remain unchanged for attributes you are not populating in your template)
- country_of_origin column (column position will vary depending on product type): provide the COO for your product
- Save a copy of the file
- Visit the Upload Your Inventory File page.
- Browse to find your file or drag and drop it, then click upload.
For more information, please visit the resources below:
Providing Country of Origin information for your products
Step-by-step video: Gathering Country of Origin information
*(COO - Country of Origin – referred in Seller Central as Country/Region of Origin)*
Let me know in the comments if you have questions or concerns around this topic that are not covered in the resources available to you.
Regards,