UPC to ASIN Matching: Good Things to Think About

UPC to ASIN Matching: Good Things to Think About

Knowing and increasing your listing to SKU ratio is a sure way to grow your top line. So how do you determine your ratio? If you’re selling the same item on three different listings it would be 3 to 1. Many merchants have a listing to SKU ratio of less than one to one. This means you have access to a large SKU supplier catalog, but you’re only listing a small percentage of those products for sale.

If you’re averaging $250,000 a month in sales, and your listing to SKU ratio is 0.5 to 1, what would your sales look like if it was 2 to 1 – or 3 to 1? Sales wouldn’t exactly double or triple due to the Pareto Principle – 80% of your sales come from 20% of your items. However, you’d definitely see a big lift! More listings mean more sales. Best of all, it doesn’t cost you anything but the effort you put in. You’re more effectively leveraging inventory you already have access to.

 

Why Matching to ASINs by UPC is a Bad Idea

So, if more listings mean more sales, why aren’t more merchants going out and matching to as many listings as possible? The answer is because they feel like they’re stuck between a rock and a hard place: either doing it by hand which requires an enormous amount of time and effort – or taking a chance on an inefficient automated solution such as Amazon’s Inventory Loader. This tool can be quite inaccurate as it only searches for matches by Universal Product Code (UPC). There are many downsides to this approach such as:

  • Using UPC to identify a product but failing to verify package quantity. Products offered in different units of measure (6-pack, 12-pack, etc.) are not clearly identified.
  • Amazon’s data is only as good as the third-party sellers who provided it. Some products have wrong UPCs as well as wrong or missing manufacturer part numbers.
  • It’s not uncommon for there to be 10-15 different ASINs for a single UPC. As a result, Amazon’s Inventory Loader can, and often does, match UPCs to the wrong ASINs.

The Consequences of UPC to ASIN Mismatches

As you may or may not know, one mismatch can result in a flood of customer returns, order cancellations, negative feedback, and possibly even account suspension. 

If you match to a listing for an expensive product and publish the price of an inexpensive product you could blow through a lot of inventory that normally sells for more. You’re on the hook for fulfilling the item you match to, not the item you have. Some merchants just eat the loss if the price difference isn’t too big. The alternative is cancelling all the orders and having your order defect rate (ODR) go through the roof. This puts your account – and entire business – at risk.

As an aside, ODR is calculated by dividing the number of orders with ‘defects’ (chargebacks, A-Z claims, or negative feedback) by the total number of orders from the same date range. If it’s greater than 1% account suspension or even closure is likely.

From what we’ve seen, many merchants shy away from using Amazon’s Inventory Loader because the risk outweighs the reward. So they end up veering toward the other end of the spectrum – where an actual person has to drive the process forward and eyeball everything to ensure the UPC matches the ASIN. Even if you hired an offshore team or a group of college interns to do the legwork this approach is both expensive and slow, and isn’t exactly scalable.

Best Practices for Selecting the Right ASIN

The bottom line is that without a system to automate the process and put safeguards in place to protect against bad matches, selecting the right ASIN takes a lot of time and elbow grease. However, if your only choice is to do it by hand, here are the product attributes you should consider (in addition to UPC) to increase the likelihood of an accurate match.

  • EAN
  • ISBN
  • Manufacturer/brand
  • Manufacturer part number
  • Package quantity/unit of measure
  • Price

Of course, matching your UPC to the right ASIN should be your primary goal. But what if there are multiple ASINs that meet your attribute match criteria? Figuring out which ASIN has the best sales rank should be your secondary goal so you can allocate more inventory to this listing.

Plus, if there are multiple ASINs for the same item, why not match to all of them? While Amazon doesn’t encourage duplicate ASINs, the fact is they do exist – sometimes in the same category, sometimes in different categories. Besides, different listings – especially in different categories – enable their customers to more easily find what they’re looking for. All you’re doing is increasing the likelihood they buy from you.

Matching UPCs to ASINs Faster and With Less Errors

Managing multiple listings per item is tough to do without a platform. A duplicate SKU must be created for each ASIN, which makes inventory management and replenishment an absolute nightmare. Activity reports for each SKU must be generated and manually combined to find out which SKUs are selling and where, as well as how many and when to reorder.

On the other hand, increasing your listing to SKU ratio – and all the complexities that go with it – suddenly becomes feasible with the right platform underneath you. It automates this error-prone decision-making and judgmental process and lets you repeatedly generate consistent results from your rules. The result is a very rapid growth in your listing count while limiting the risk of bad matches. 

24 Comments

  1. descargar facebook on December 4, 2018 at 9:07 am

    I absolutely love your blog and find many of your post’s
    to be just what I’m looking for. Do you offer guest writers to write content to suit your needs?
    I wouldn’t mind composing a post or elaborating on a number of the subjects you write concerning here.
    Again, awesome weblog!



  2. What Equipment is Needed for Sling TV on November 20, 2018 at 10:51 am

    If some one wishes expert view about blogging afterward i suggest him/her to pay a quick visit this blog, Keep up the pleasant job.



  3. What Equipment is Needed for Sling TV on November 19, 2018 at 10:38 am

    Hi! Would you mind if I share your blog with
    my twitter group? There’s a lot of people that I think
    would really enjoy your content. Please let me
    know. Thanks



  4. What Equipment is Needed for Sling TV on November 18, 2018 at 1:08 pm

    Normally I don’t learn article on blogs, but I wish to say that this write-up very pressured me to take
    a look at and do it! Your writing style has been amazed me.
    Thanks, very nice post.



  5. What Equipment is Needed for Sling TV on November 18, 2018 at 9:23 am

    Hi there I am so thrilled I found your web site, I really found you by error,
    while I was looking on Digg for something else, Anyways
    I am here now and would just like to say kudos for a fantastic post
    and a all round enjoyable blog (I also love the
    theme/design), I don’t have time to browse it all at the minute but I have book-marked it and also included your RSS feeds, so when I have time I will be back to
    read a lot more, Please do keep up the fantastic job.



  6. sling tv coupons and promo codes for november 2018 on November 17, 2018 at 10:37 am

    Sling tv coupons and promo codes for november 2018
    This is a topic that’s close to my heart… Best wishes!

    Where are your contact details though? Sling tv coupons and promo codes for november
    2018



  7. What Equipment is Needed for Sling TV on November 17, 2018 at 7:52 am

    Hi my loved one! I want to say that this article is amazing, great written and include approximately all significant infos.
    I’d like to see more posts like this .



  8. sling tv coupons and promo codes for november 2018 on November 16, 2018 at 8:56 pm

    Sling tv coupons and promo codes for november 2018
    Thanks a lot for sharing this with all of us you really understand what you’re speaking
    approximately! Bookmarked. Please additionally seek advice from my website =).
    We may have a hyperlink change contract between us sling tv coupons and promo codes
    for november 2018



  9. What Equipment is Needed for Sling TV on November 16, 2018 at 11:07 am

    Do you mind if I quote a few of your posts as long as I provide credit and sources back
    to your webpage? My website is in the very same niche as yours and my
    visitors would genuinely benefit from a lot of the
    information you present here. Please let me know
    if this ok with you. Appreciate it!



  10. Sling TV on November 15, 2018 at 1:42 pm

    Great article.



  11. Sling TV on November 14, 2018 at 9:31 pm

    Wonderful post however I was wanting to know if you could write a litte
    more on this topic? I’d be very grateful if you could
    elaborate a little bit more. Cheers!



  12. Sling TV on November 14, 2018 at 2:02 pm

    Heya just wanted to give you a quick heads up and let you know
    a few of the pictures aren’t loading correctly.

    I’m not sure why but I think its a linking issue. I’ve tried it
    in two different web browsers and both show the same results.



  13. What Equipment is Needed for Sling TV on November 13, 2018 at 12:03 am

    Hi there, You have done a fantastic job. I’ll definitely digg it
    and personally suggest to my friends. I am sure they will be benefited from
    this web site.



  14. What Equipment is Needed for Sling TV on November 12, 2018 at 1:31 pm

    WOW just what I was searching for. Came here by searching for What Equipment
    is Needed for Sling TV



  15. What Equipment is Needed for Sling TV on November 12, 2018 at 8:07 am

    I always emailed this web site post page to all my associates, for the reason that
    if like to read it after that my friends will too.



  16. Sling TV on November 11, 2018 at 10:47 pm

    It’s really very difficult in this full of activity life
    to listen news on Television, so I only use web for that purpose,
    and get the latest information.



  17. Sling TV on November 11, 2018 at 11:55 am

    Your method of explaining all in this post is genuinely pleasant, every one
    can easily understand it, Thanks a lot.



  18. tubo de aluminio redondo precious weight on November 10, 2018 at 10:45 pm

    La produccion de mecanizado de piezas de acero, acero inoxidable, aluminio fundido y bronce por cuenta de terceros. Si necesitas más información sobre nuestros servicios de mecanizado de metales de materiales blandos, no tienes más que rellenar el siguiente formulario y nos pondremos en contacto contigo con la mayor brevedad posible.



  19. barandandilla inox watches on November 10, 2018 at 10:40 pm

    Ellos saben que los trabajos tiene que estar muy bien acabados, que son trabajos de mucha precisión, de muchísima calidad de acabado superficial y si se parte una herramienta se queda clavada en una ranura de ancho de 0,8mm ya no se puede sacar. Para iniciar su producción ha sido necesario instalar nuevas máquinas de producción, adaptar las líneas de fabricación y realizar los ensayos necesarios que garanticen los estándares medioambientales, seguridad y calidad de la compañía.



  20. Barandandilla inox on November 10, 2018 at 8:53 pm

    El mecanizado de piezas es el conjunto de técnicas mediante las cuales se da forma definitiva a las piezas y que se realiza con arranque de material. En Mecanizados Carmona nos importan nuestros clientes. Orientada a todos los tamaños de empresa, Ofrecemos una solución, innovadora en centros de mecanizado CNC de HOMAG.



  21. servicio tecnico frigorificos samsung on November 10, 2018 at 3:10 pm

    En los locales en los que se ejerza la actividad clasificada en este epígrafe, la deducción a que se refiere la letra c) de la regla 14.1.F de la Instrucción del impuesto será en todo caso del 20 . Epígrafe 53.4.- Comercio al por menor de materiales de construcción y de artículos y mobiliario de saneamiento. Epígrafe 54.2.- Comercio al por menor de accesorios y piezas de recambio para vehículos terrestres.



  22. Más de 20 años nos avalan y miles de clientes de en toda la Comunidad de Madrid han depositado su confianza en nuestro servicio técnico que se desplaza de forma gratuita a cualquier casa, chalet residencia para efectuar una reparación para evitar un gasto mayor. Nuestro objetivo es que el cliente quede satisfecho con la reparación arreglo (de Frigoríficos, Lavadoras, Neveras, Lavavajillas, Campanas, Secadoras, Persianas) y satisfacer con la máxima garantía a los clientes. Nuestro Lema es el buen trabajo y seguimos día a día para lograr que nuestra asistencia técnica low cost sea la más usada en Madrid Comunidad de Madrid. Por si esto fuera poco, estamos cerca de su casa, en Madrid y comunidad autónoma.



  23. Sling TV on November 10, 2018 at 1:05 pm

    I was suggested this blog by my cousin. I’m not sure whether this
    post is written by him as no one else know such detailed about my difficulty.
    You are incredible! Thanks!



  24. La protesta -la octava de estas características en democracia- ha arrancado sin incidentes graves, aunque tres integrantes de piquetes han sido detenidos en Madrid en torno a las dos de la madrugada por causar daños en establecimientos del centro de la ciudad, informa F. Javier Barroso, y una sindicalista ha resultado herida con un arma blanca en la cara.



Leave a Comment