Bulk Merchandise Order Spreadsheet: Reconcile Every Variant

A bulk merchandise order sheet should show whether the exact items approved for production match the items assigned to recipients. A correct grand total is not enough: forty allocated shirts can still contain the wrong size mix.

Build the sheet around three questions: what has been approved, who receives each item, and what remains unresolved. Keep the supplier’s import file separate from this planning record. They serve different purposes, even when both use a spreadsheet.

Separate product approval from recipient allocation

Use a variant master for the physical item and an allocation sheet for the people or dispatch groups receiving it. Link the two with a stable variant reference. Keep shipping addresses in a separate restricted record rather than copying them into every worksheet and email attachment.

A practical variant master includes:

Field	What it establishes
Variant reference	The stable link between records
Exact model and supplier reference	Which product is being ordered
Confirmed size and color	The approved physical option
Artwork revision	Which approved design belongs on it
Approved quantity	Units authorized for this version
Allocated quantity	Units assigned to recipients or groups
Difference	Units unassigned or overallocated
Approval status	Whether the row can proceed

An internal reference does not prove availability. Confirm the actual model and option before treating a row as ready. The SKU naming guide explains how to keep identifiers consistent without turning them into stock claims.

Give each allocation one clear meaning

Use one allocation row for one recipient reference, one variant and one quantity. If a person receives two different items, use two rows. If a carton goes to an office for local distribution, identify that dispatch group and maintain its contents clearly.

Useful allocation columns are recipient reference, variant reference, quantity, dispatch group, selection-confirmed status and exception note. Keep the recipient’s selection separate from an administrator’s assumption. A blank size is unresolved; it is not permission to choose a medium.

For apparel, ask recipients to use the actual product’s measurements and fit information. Linking to the size-guide explainer is more useful than assuming the same size label fits identically across models.

Reconcile each variant before the total

Consider this fictional teaching example. The approved order contains forty shirts, and forty units have been assigned:

Variant	Order	Alloc.	Diff
Navy, M	12	12	0
Navy, L	18	17	1
Black, M	10	11	-1
Total	40	40	0

Here, Order means approved quantity, Alloc. means allocated quantity, and Diff is Order minus Alloc. The total passes, but the order does not. One navy large remains unassigned, while black medium is overallocated by one. Sending this file without checking the rows could leave the distribution team with a shirt that nobody requested and a recipient without the right item.

Calculate allocated units by summing allocation rows for each variant reference. A SUMIFS calculation can do that in a spreadsheet; verify its ranges against your actual layout. Then subtract allocated units from approved units. Positive differences require an explanation, such as deliberately retained spare stock. Negative differences require correction or a new approval.

Flag exceptions instead of hiding them

Add checks for unknown variant references, duplicate recipient-item assignments, nonpositive quantities and quantities that are not whole numbers. A duplicate is a review flag rather than automatic proof of error: someone may legitimately receive two of the same item.

Use a short exception list with an owner and a decision deadline. Examples include an unconfirmed address, unavailable size, changed artwork or a recipient who has declined. Do not fix these silently by substituting a product or changing the approved quantity.

If spare units are intentional, assign them to a named reserve group. That keeps the arithmetic explainable without pretending every unit already has an individual recipient.

Map the supplier file as a separate step

A planning worksheet is not a universal upload template. The selected supplier may require its own product identifiers, address fields, artwork references and rules for grouping order lines. Download its current template and confirm which products and production methods the import supports. Do not guess identifiers from a product name or copy another supplier’s columns.

Keep the master worksheet intact and create a separate mapped export. Confirm how the system handles leading zeros, blank cells, country codes and repeated order references. Review the resulting records after import, including quantities, artwork placement, shipping addresses and approval settings. A successful upload proves the file was accepted; it does not prove that the order matches the approved brief.

These checks are a planning workflow, not evidence that Brilliantor offers an automated import integration. Ask the actual supplier which steps release production and which changes remain possible afterward.

Freeze the approved version and check the handoff

Name the file version, approval date and person authorized to release it. Record later changes rather than overwriting the evidence of what was approved. If a recipient changes size after the freeze, check whether production can still change and obtain the necessary revised approval.

Before handoff, verify that variant totals reconcile, every exception has a disposition, artwork references match the approved files, and the intended shipping groups are correct. Have a second person trace a few allocations back to the master record, including any personalized items.

The merchandise quote request guide covers the earlier pricing brief. This spreadsheet becomes useful after those choices are sufficiently clear to control an order. Contact Brilliantor with the product references, quantity split and unresolved decisions when you need help defining that handoff.