Product data quality: seven mistakes that cost sales

By Manuel Mattar3 min read

In short

Product data quality measures how complete, correct and consistent catalog data is. The most expensive mistakes are few and repeat themselves: duplicate SKUs, unnormalized values, measurements without units, specifications lost in the text and product records that say different things on each channel. They are prevented with rules in the system, not with manual reviews.

Quality shows up in sales

A catalog with poor-quality data does not look bad on a dashboard: it shows in operations. Products a channel rejects, filters that find nothing, returns because the size was different, customer service questions the product page should have answered. Each mistake looks small; together they cost sales every day.

These are the seven mistakes that repeat most in catalogs of every industry.

1. Duplicate or changing SKUs

Two products with the same SKU overwrite each other; a product that changes SKU between uploads appears twice. Since the SKU is the key that links every system, a mistake here spreads to the store, the ERP and every marketplace.

2. Unnormalized values

“Navy blue”, “Navy”, “Marine” and “NAVY BLUE” as four different colors. The store filter shows four options and each one finds part of the products. List attributes with allowed values prevent it.

3. Measurements without units

“250” does not say whether it is milliliters or grams; “12” does not say whether it is inches or centimeters. Without the unit, the value cannot be compared, filtered or converted for another market.

4. Specifications lost in the text

“Made of 2 mm stainless steel with a non-slip handle” inside a paragraph is information the store cannot filter or send to a channel. Specifications go in attributes; the description mentions them.

5. Different records on each channel

When each channel is edited separately, information drifts: a different price, dimension or photo in each place. Buyers who compare lose trust, and buyers who purchase receive something they did not expect.

6. Unreviewed images

Photos that don't match the variant, images without alt text, the same photo for three different colors. The image is the first thing buyers look at and the last thing anyone reviews.

7. Data without an owner

When nobody is responsible for a field, nobody fixes it. An attribute a supplier filled in two years ago is still there even though the product changed. Without an owner and a change history, nobody knows who changed it or when.

How to spot them

You don't need a huge audit to find these mistakes. A few simple checks are enough to start:

  • Repeated SKUs: sort the catalog by SKU and look for the ones that appear twice.
  • Unnormalized values: review the list of distinct values for each list attribute; spelling variants jump out.
  • Measurements without units: look for values that are just a number in measurement attributes.
  • Differences between channels: compare the record of your ten best sellers on each channel where they are published.
  • What customers ask: the questions that keep reaching customer service point to the field that is missing or wrong.
  • What channels reject: the error reports from each marketplace upload are a free list of the fields that need attention.

How to keep them from coming back

Fixing by hand works once; rules work every time:

  • Typed attributes with allowed values and units.
  • Required fields by family and by channel.
  • Review before publishing, with a clear approval step.
  • A change history that says what changed, who changed it and when, and lets you go back.
  • A single source for the product record, exported to each channel instead of edited in each one.

How Bruxel handles it

In Bruxel attributes are typed, with value lists and measurements with units, and families say what is required. Each product record keeps a history of what changed in each version and lets you go back to an earlier one, and the catalog quality reports show what is missing and where. Everything is exported from one place to each channel, as the export guide shows. To measure what is missing, continue with catalog completeness.

The video tutorial

Video transcript

In this video, you'll see what changed in a product and how to put it back the way it was.

Every time a product really changes, Bruxel saves a version. Here, you change the color.

“History” has every version, with its reason, who made it and when.

Open one and you'll see what changed: the value before and the value now.

What nobody typed, like an import or attribute detection, is shown by its reason.

Below, you pick any two versions and see the difference, even if they aren't consecutive.

An administrator can go back to an earlier version: before writing anything, it shows how it would end up.

Restoring deletes nothing: the product goes back to how it was and the history gains one more version.

In the next video, you'll translate a product into another language.

Frequently asked questions

Who should own data quality?

Every field should have a clear owner: the team that captures and corrects it. Overall quality is everyone's job, but if nobody owns a field, nobody fixes it.

How often should the catalog be reviewed?

Rules should check every change as it comes in. On top of that, a weekly review of best sellers and a monthly review of the rest catches what slips through.

Does AI help or hurt data quality?

It helps if it starts from real data and someone reviews what it proposes; it hurts if results are published without review, because it can fill a gap with a value that sounds right but is not true.

Sources

  1. Data quality (Wikipedia)

About the author

Manuel Mattar

Founder of Bruxel.AI

In 2014 he founded Wolf Sellers, an e-commerce agency in Mexico City, and later Bruxel.AI, the AI-powered PIM.

See all posts by Manuel Mattar

Try it with your catalog

Create your free account and try Bruxel with your own products using the welcome credits.

Keep reading

Product data quality: seven mistakes that cost sales