- Bruxel.AI Blog
- How to onboard products with your suppliers without chasing spreadsheets
How to onboard products with your suppliers without chasing spreadsheets
By Manuel Mattar3 min read
In short
Supplier onboarding stops being a spreadsheet back-and-forth when the supplier enters data directly in your system, with a form that follows your rules: what data each product type needs, what is required and which values are accepted. Your team reviews in a queue, approves or sends back with a reason, and every change is recorded.
The problem: the spreadsheet that goes back and forth
In many companies, onboarding a new product starts with an email: “Here is the template, fill it in.” The supplier fills it in their own way, renames columns, leaves gaps, writes dimensions in another unit. Someone on the team fixes it, asks for what is missing, waits for the answer and fixes it again. Each round takes days, and the product cannot be sold in the meantime.
The problem is neither the supplier nor Excel: it is that the information is captured outside the system where it will live, without the rules that system requires.
The alternative: suppliers enter data in your system
When the supplier enters data directly, with access limited to their brands, the conversation changes:
- The rules are in the form. What data each product type needs, which fields are required and which values are accepted. The supplier cannot submit without the required data.
- Values arrive normalized. If color is picked from a list, you don't get “Navy blue”, “Navy” and “Marine” as three colors.
- The supplier sees what is missing. Instead of waiting for an email back, they know right away what to complete.
Review: a queue, not an inbox
What the supplier submits should not go straight into the catalog. A validation queue lets your team:
- see what arrived, from whom and when;
- compare the submission against what your channels require;
- approve it, or send it back with a written reason.
A submission returned with its reason gets fixed faster than an email thread, and it leaves a record of what was asked and why.
What the supplier sees and what they don't
A supplier portal has to be strict about scope. The supplier needs to see and edit their brands' products, with their history and requirements. They don't need —and shouldn't— see your prices, channels, credits, team or other suppliers' products. Separating what they discuss with your team from what your team discusses internally matters too.
For suppliers with many products
Not every supplier onboards one product at a time. For those who send hundreds, accept a template-based file upload, but with the same validation as the form: before submitting, the system says which rows would go in, which would not and why. That way the file stops being a problem and goes back to being a loading format.
What to measure
To know whether the change works, measure a few things and always measure them the same way:
- Days from the supplier's submission until the product is approved.
- How many submissions are sent back and for what reason: if a reason repeats, the form is missing a rule.
- How many products arrive complete for the channel where you sell the most.
Those three numbers show where the bottleneck is: with the supplier, in the form or in the review.
How Bruxel handles it
In Bruxel the supplier joins your organization limited to their brands, with a short menu: their products, submit products and their uploads. The product onboarding form builds itself from what you already configure —your attribute groups, your category tree and your channels' requirements— and the supplier can submit one product at a time or a file with the template. Nothing submitted enters the catalog until your team approves it. The supplier portal guide explains what the supplier sees and writes, and the product onboarding with your suppliers use case shows it on video.
Where to start
Pick the supplier who sends you the most new products and one of their brands. Define which data is required for that type of product, invite them with access to that brand only and ask them to onboard their next products through the portal. Within a few weeks you will see how many correction rounds you save, and that tells you whom to invite next.
The video tutorial
Chapters
Video transcript
In this video, you'll invite a supplier to enter their brand's products.
Your supplier joins your organization as an editor, limited to their brands.
Enter their email, choose Editor, check “Limit to their brands” and pick theirs.
They get the invitation, and here you see it pending: supplier, one brand.
You decide which attributes they fill in: those in a group you mark “Filled in by the supplier”…
…and you put the attributes that belong to them in that group.
And on your store's channel, check “Counts toward supplier requirements”, so they know what's missing.
This is what your supplier sees: a portal with their brand, without credits, channels or your team.
They only see their brand's products, and how complete they are.
On each record they see what your store asks for: their part and what you complete.
They edit the attributes in their group; the rest show a lock.
New products don't go straight in: they're sent for validation.
They upload their file and review what would happen…
…and send it. Nothing exists in your catalog until you approve it.
You review it in Validation, with what would happen on approval.
If everything checks out, approve it: the products go into your catalog.
In the next video, your supplier adds a product step by step.
Frequently asked questions
Does the supplier see my whole catalog?
It shouldn't. The right setup lets them see and edit only their brands' products, with no access to your prices, your channels or other suppliers' products.
What if the supplier sends incomplete data?
A form with your rules does not let them submit without the required fields. And if something is not right during review, it is sent back with a written reason instead of an email that gets lost.
Can I still receive files from large suppliers?
Yes. The practical approach is to accept both routes: the form for one-by-one onboarding and a template-based file upload for those who send hundreds of products, with the same validation before submitting.
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.