Attached is a sample file to check the ASIN in column E on
[login to view URL]
in order to check if the quantity, product brand and product name is same as mentioned in the file.
Please note that quantity should consider always as 1 piece so if on Amazon it shows 3 pieces, pack of 2 etc then that ASIN should mark Red color in the file.
If the product is completely different on Amazon from the file then mark that ASIN Blue color in the file
And if the product name or product brand is different then it should mark as Yellow. And if all is well then leave it like that
And if ASIN does not find on Amazon then it should mark Black color.
Furthermore if the product is a Spray, Perfume, Deodorant, Shaving Gel, After Shave, Mousse, Pampers, Huggies then it should mark Red color for Amazon US and for Amazon UK it should cut and paste into EU sheet and should be checked for the above points.
Last but not least if either product number of product shade is mentioned on Amazon then it will consider as OK and you do not need to match 100% product details.
Attached please find the sample files for Amazon US with its reasons.