Ask a retail buying team what happens in the weeks before a promotional period and they will tell you about spreadsheets. Each supplier sends their promotions, pricing and product details in their own format. Some use the template. A lot use last year's template. A few send a PDF. The buying team opens each one, checks it, re-keys it into the merchandising system and emails back about the parts that do not make sense. The supplier replies with a corrected spreadsheet, and it starts again.
For a grocer with hundreds of suppliers, that is weeks of skilled people doing data entry, and the errors that get through are the ones customers see: the wrong price on the shelf, or a product in the catalogue that is not in stock.
Why it stays this way
Suppliers send spreadsheets because that is what they were asked for, years ago. The retailer's system has no way for a supplier to enter data directly, so email is the only door in. And the buying team has become very good at reading the spreadsheets, so the cost stays hidden inside a job that looks like buying rather than typing.
What reduces the load
- A mandatory template with validation. A locked spreadsheet with drop-downs and checks catches some errors at the supplier's end. It still has to be re-keyed, and suppliers still send the old one.
- Import instead of type. If the template is consistent, it can be imported. That removes the typing for suppliers who comply and leaves the buying team chasing the ones who do not.
- One contact per supplier. This cuts the duplicates and competing versions, but it does not solve the format problem.
Letting suppliers enter their own data
Retailers who have fixed this have opened a door into their system: a supplier portal where each supplier logs in and enters their promotions, pricing and product data into structured forms. The fields are the retailer's fields, the validation is the retailer's rules, and a submission that does not pass does not get through. The buying team reviews what has been entered in the same platform instead of re-keying it. Deadlines, status and history are visible to both sides, so the chasing stops as well.
That is what we built for a major independent grocer: a supplier promotions portal where suppliers submit promotions and data in the retailer's structure from the start, and the team reviews and approves from one place. Weeks of re-keying became days of review, and the data was right before it reached the shelf.
A supplier portal is a bounded project with a clear return. The suppliers already have the data and the retailer already has the rules. What gets built is the door between them, and it tends to pay for itself within the first promotional cycle it runs.
If your buying team is typing in supplier spreadsheets, have a look at what we build for retail, or tell us how supplier data arrives today.
