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,