Ask any People Ops lead or office manager what actually slows down a swag rollout, and you'll rarely hear "production." You'll hear the data. Before a single hoodie ships, someone has to collect a current shirt size and a correct shipping address for every recipient — and that quiet, unglamorous step is where most merch timelines fall apart.
The default tool for the job is a spreadsheet passed around over email or Slack. It works, barely, for a dozen people in one office. It breaks the moment you're shipping to a distributed team, onboarding new hires every week, or handling more than a few dozen recipients.
Why the spreadsheet method breaks down
The problems compound quietly:
- Sizes are guesses. When a manager fills in sizes on behalf of their team, you get "probably a large" — which turns into reprints, returns, and disappointed recipients.
- Addresses go stale. People move, and a spreadsheet exported three weeks ago ships kits to the wrong door.
- It's a privacy grey area. Home addresses and personal phone numbers sitting in a shared, downloadable file is exactly the kind of data handling most security and HR teams want to avoid.
- Version-control chaos. Two people edit two copies, and now nobody knows which tab is the source of truth.
- Endless chasing. There's always a fraction who never fill it in, and someone burns a week on reminder pings.
- It does not scale to new hires. Every new cohort restarts the whole cycle from zero.
What good employee data collection looks like
The fix isn't a better spreadsheet — it's removing the middle layer entirely. A few principles make the difference:
- Self-service beats proxy entry. The person who knows their own size and address should be the one entering it — once, directly.
- One source of truth. Details should flow into a single system tied to the order, not a file that gets copied and re-copied.
- Privacy by default. Collect only what the order needs, over an encrypted connection, and use it only to fulfill that order.
- Always-on, not one-and-done. New hires should be able to add their details any time, without spinning up a new project each quarter.
The shareable collection link
This is the model we build into every Sterling Merch order. When your order is confirmed, we generate a private, company-branded collection link — something like sterlingmerch.com/collect/yourcompany. You share it once, by email, Slack, or inside your onboarding flow, and each employee spends about 45 seconds entering their own name, size, shipping address, and preferences.
Because every recipient enters their own details, sizes are accurate the first time and addresses are current on the day they submit. Everything lands in one place, tied directly to your order — no exports, no merging tabs, no re-keying. And you can keep the link live so that new hires add themselves as they join, and we trickle-ship a welcome kit to each one automatically.
| Shared spreadsheet | Collection link | |
|---|---|---|
| Who enters the data | A manager, on everyone's behalf | Each employee, for themselves |
| Size accuracy | Estimated — reprints common | First-hand — right the first time |
| Address freshness | As old as the last export | Current at time of submission |
| Privacy | Downloadable file, widely shared | Encrypted, order-scoped, not shared |
| New hires | Restart the process each time | Add themselves anytime; link stays live |
| Your effort | Chasing and merging | Share one link |
How to roll it out to your team
If you're moving off spreadsheets, a smooth rollout takes about a day of lead time:
- Announce it once. A single message — "Your welcome kit is coming, add your details here" — gets far higher completion than a spreadsheet request.
- Put the link where people already are. Pin it in your onboarding doc, HRIS, or the new-hire Slack channel so it is not buried in an inbox.
- Set a soft deadline with a reason. "By Friday, so your kit ships on time" lifts response rates more than an open-ended ask.
- Let reminders run automatically. Recipients who have not submitted can be nudged without you tracking a list by hand.
- Keep it open for the next cohort. Do not close the link after the first batch — reuse it for every new joiner.
A note on privacy
Home addresses and phone numbers are personal data, and employees are right to care how they're handled. The collection-link model is deliberately privacy-first: details are entered over an encrypted connection, scoped to your specific order, and used only to produce and ship it. They are not sold, and they are not shared. That is usually an easier conversation with your security and legal teams than "a shared spreadsheet of everyone's home address."
The takeaway is simple: the bottleneck in getting great swag to your team is almost never the merch — it's the data. Remove the spreadsheet, let people enter their own details once, and the whole timeline gets shorter and more accurate. If you'd like a collection link set up for your next run, tell us what you're planning and your dedicated manager will handle the rest.