A dependable pool service crew shirt order checklist uses one row for every wearer and one separate row for every approved reserve purpose. It confirms the size source, role version, exact product and variant, quantity rationale, artwork proof, and approval status before totals are sent. Empty or uncertain cells remain visible; they are not replaced with guesses.
Set up the workbook in four tabs
Small teams do not need complicated software, but they do need separation between facts, decisions, totals, and history.
Roster holds current wearers and approved reserve purposes. Product and proof holds exact item references, current source links, variants, artwork areas, and proof versions. Order build converts confirmed roster rows into totals. Change log records every edit after the order version is frozen.
Give the workbook an owner, version, and cutoff date. Store it in one known location so text messages and handwritten notes do not become competing orders.
Build one complete roster row
Each wearer row should include:
- Employee or contractor identifier used by the business
- Current role and shirt-version eligibility
- Confirmed size and the exact size source used
- Product reference and selected variant
- Garment color, when part of the approved decision
- Design or proof version
- Core quantity and reserve quantity, each with a reason
- Confirmation owner and date
- Status: waiting, confirmed, changed, removed, or ordered
Do not infer a size from a previous employer, appearance, or another brand. Give the wearer access to the current exact-product size source and record their confirmation through the company's normal process.
If names appear on shirts, store the exact approved display name separately from the roster identifier. Recheck spelling and eligibility; a payroll name is not automatically shirt copy.
Add reserve rows with explicit purposes
An unlabeled “extras” line hides whether the item can actually serve the crew. Create separate rows such as confirmed-new-hire issue, route-lead transition, or shared no-role reserve. Assign each a permitted design version and size only when the business has evidence for that need.
The shirt rotation plan should supply the quantity rationale. This worksheet does not decide how many shirts a role needs; it transfers documented gaps into an order.
Verify current minimums, availability, pricing, and order terms directly. Do not assume that a previous order policy or a general store message applies to the exact current purchase.
Create a product-and-proof key
Use short internal codes only after defining them in a key. Each code should map to an exact live product URL or current provider reference, variant, approved garment color, design version, and proof file.
Record the date when product details were checked. If the exact variant disappears or the listing changes, mark affected roster rows blocked. Do not silently substitute another shirt, even if its name or image looks similar.
Connect the proof to the authoritative artwork package. The logo file preparation guide explains how to keep the master asset and approved variants clear.
Reconcile totals two ways
First, total the order by wearer: each confirmed person plus each documented reserve purpose. Second, total it by purchasable combination: exact product, variant, color, size, and artwork version.
The grand totals must match. If they do not, look for a filtered-out row, duplicate wearer, reserve counted twice, changed status, or two product codes that refer to the same selection.
Also reconcile role versions. A correct overall size total can still be wrong if route-lead artwork was counted as the standard technician version.
Do not round quantities merely to create neat bundles. Any commercial tier, minimum, or discount needs a current verified source and a separate approval decision.
Use three gates before approval
Roster gate
Confirm that active wearers, role transitions, planned departures, and start dates reflect the cutoff date. Remove former staff from the active build without deleting their historical record.
Fact gate
Confirm exact product reference, selected variant, current size source, available choice, artwork area, and care source. Mark missing facts as blocked.
Proof gate
Confirm company spelling, service descriptor, logo variant, role wording, wearer names if used, front/back assignment, product mapping, and approved version. A mockup is not automatically the approved proof.
One named order owner should sign after all three gates pass. A group-chat reaction is not a durable approval record.
Manage the cutoff without losing real changes
Freeze the order build at a specific version and time. After that point, do not edit confirmed rows directly. Add a change-log entry with requester, affected wearer, old value, new value, reason, source, cost or schedule impact if verified, and decision status.
The order owner can accept the change into a new version, defer it to a follow-up order, or reject it with a reason. This makes a late size correction visible without corrupting the version already under review.
Keep future hires in a forecast section until their details are confirmed. Ordering an assumed size for an unnamed role may create inventory, but it does not create a reliable issue plan.
Run a spoken row check
For a small crew, read each confirmed row aloud with the wearer or role owner: person, role, product, variant, color, size, version, core quantity, reserve quantity, and source date. Ask the reviewer to confirm the whole combination rather than only the size.
Then sample the totals backward. Pick one line from each product-size-version total and trace it to its roster purpose. If a line cannot be traced, it should not proceed.
Archive an order snapshot
Save the final roster, totals, source links, current product facts, artwork package, proof approval, change log, and submitted order reference together. Record what was actually ordered if it differs from the build.
That snapshot becomes evidence for replacements and the next roster review, but it should not be copied without checking current facts. Products, variants, sizes, artwork areas, prices, and terms can change.
When the worksheet is complete, owners can compare current categories in the Custom Pool Service Uniforms collection. Revalidate every exact selection and commercial term on the current listing before submitting the order.