Team Orders With Twenty Names and Numbers

A roster in a spreadsheet

Every September a sports shop's inbox fills with rosters. A coach or team manager sends a spreadsheet of players, numbers and sizes, and asks for jerseys before the first game.

Then the changes arrive. A parent writes that her son wants 17, not 71. Another player joins. A surname is spelled two ways in two emails.

Staff retype every line into the order system by hand, in the busiest weeks of the year, and each retyped line is a chance to print the wrong name.

Why the cart cannot hold a roster

An online cart is built for one buyer choosing items one at a time. A jersey can carry a size option and perhaps a text box for a name.

But each jersey needs its own trip through the cart. Twenty players means twenty passes, by one tired manager or by twenty families who never see each other's orders.

Nobody can see the roster as a whole, so duplicate numbers go unnoticed. Coaches skip the cart and email spreadsheets, and the website plays no part in the shop's largest orders.

What a team order needs

A team order is one order with many lines, not many orders. The page that takes it should collect everything the shop needs before production starts.

• The team details: name, colours, logo file, the contact person and the date of the first game.
• The roster: each player's name as it should be printed, with number and size, one line each.
• A deadline after which the roster closes and production is scheduled.
• A payment choice: one payment from the team, or one from each family.
• A proof showing every name and number exactly as they will appear.
• Pickup or delivery, with the date the order will be ready.

The proof matters most, because it is the last moment a mistake costs nothing. After printing, a misspelled name means a new jersey.

One form for the whole roster

The roster form works best as a table: one row per player, with columns for the printed name, number and size. The manager adds rows as needed and can save a draft.

The form can catch what people get wrong. It can flag two players with the same number, numbers outside the league's range, and names too long to fit across the shoulders.

Some managers would rather send a spreadsheet. Offer a template with the same columns to download, so what comes back can be read in without retyping.

A deadline everyone can see

Printing runs in batches, and a team order with stragglers holds up everything behind it. Put the deadline at the top of the page and in every confirmation email.

Say what happens after it: late players can join a second batch, at a set price and a later date.

A manager who knows that in advance can plan for it, and can tell parents before the first practice.

Paying as a team or family by family

Some teams collect fees and pay one invoice. Others want each family to pay for its own player, and the shop should not have to chase twenty payments by phone.

The page can offer both. With family payment, the manager builds the roster and each family receives a link to pay for its own line.

The manager sees who has paid and who has not. The roster goes to production when every line is paid or the manager agrees to cover the rest, a rule worth stating on the page.

A worked example

A 3D printing shop in a row of units near the highway makes models for inventors and parts for machinery. Each fall it also makes personalised bag tags for minor hockey and soccer teams.

Every tag carries the team logo, a player's name and a number. Orders came by email as spreadsheets in a dozen layouts, and staff copied the names into the design file by hand.

One season a whole team's tags went out with two players' numbers swapped. The shop then built a team order page.

The manager enters the team, uploads the logo and fills in a roster table that refuses duplicate numbers and names longer than the tag can hold.

Families can pay their own lines through a link, and the manager can see which lines are still open.

When the roster closes, the shop produces a proof sheet showing every tag, and the manager approves it before anything is printed.

Names go from the roster straight into the design file, so nobody retypes them, and the approved sheet is saved with the order.

Proofs that someone actually reads

A proof works only if the right person reads it. Ask the manager to check every line against the team list, rather than sending a general request to approve.

Show each name at the size it will be printed. A list in plain type hides problems that a drawing of the actual jersey back makes obvious.

Record who approved the proof and when. Changes after approval can still be made, at a price stated on the page.

Sizes, spares and late additions

Youth and adult sizes vary between makers. A size chart with measurements, and sample garments at the shop for players to try, saves exchanges after printing.

Suggest one spare blank jersey per team for the player who joins in October. It can be printed later without reopening the whole order.

The counter-case

A shop that handles three team orders a year, all from coaches it has known for a decade, may not need a page of its own. A phone call and a shared spreadsheet serve them well.

The proof and the deadline matter all the same. A template to download, a written deadline and a proof emailed for approval cover most of what the page would do.

Before next season's rosters arrive

1. Count last season's team orders and how they arrived.
2. Write down what each order needed to know.
3. Build one roster form with checks for numbers and names.
4. Set a deadline and show it everywhere.
5. Offer payment by the team or by each family.
6. Send a proof of every line before printing.
7. Keep the approved proof with the order.

Step six protects the shop more than any other. The other steps reduce retyping; the proof turns a misspelled name into a correction instead of a reprint.

Limits, previews and confirming the exact wording on a single personalised item are covered in engraving text typed into a box with no limit.

Frequently asked questions

West Coast Media Solutions Inc. provides web design, web development, hosting, digital marketing, and business consulting to organisations across Canada, drawing on more than twenty-five years in the field.