- Bruxel.AI Blog
- Product data quality: seven mistakes that cost sales
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
Chapters
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
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 MattarTry it with your catalog
Create your free account and try Bruxel with your own products using the welcome credits.
Keep reading
· 4 min read
How to choose a PIM: ten questions to ask before you sign
A neutral guide to choosing a PIM: what to ask about data, channels, team, suppliers, integrations, AI, price and exit, and how to test it with your catalog.
· 3 min read
Catalog completeness: how to measure what each product is missing
A catalog-wide completeness percentage says little. How to measure completeness per product and per channel, what to do with the gap list and how to prioritize.
· 3 min read
From Excel to PIM: how to migrate your catalog without losing data
Moving your catalog from spreadsheets to a PIM does not require cleaning it first. How to prepare the file and what to check on the first load.