Three Buyer Profiles and the Parcel Each One Should Build

Buyer profiles are usually written as budgets, and a budget makes a poor profile because two people spending the same $300 need different parcels. The sharper axis is the median of the category being bought. Shoes sit at a median of $68.68 across 24 entries and Headwear at $16.22 across 24 entries, a gap of 4.2 times between two categories that occupy the same pool and the same parcel network. The three profiles below are separated by that ratio and by how many rows each one needs.

Profile A is the single-object buyer. One row matters and everything else is context: a pair of sneakers, chosen against a Shoes band that runs $24.09 to $100.84 with a median of $68.68. The saved row for the Nike Dunk Low at /middlemen/nike-dunk-low-sneakers-2024-new-color-skateboard-4780232366/ is the shape of this profile, one entry carrying the whole decision. Profile A reads a list to find a single row and treats the other 194 as noise, which is a rational use of a pool this size.

Profile B is the outfit builder. Four to six rows have to work together, and the categories are the ones where the bands overlap: Hoodies and Sweaters at a median of $37.18 across 26 entries, T-Shirts at $22.23 across 24, Headwear at $16.22 across 24. The reference rows are the Gallery Dept hoodie at /middlemen/gallery-dept-hoodie-4476399058/, the Stussy tee at /middlemen/stussy-8-ball-t-shirt-24-styles-8293013129/ and the LV beanie at /middlemen/lv-checkerboard-beanie-6-styles-5347408760/. Profile B is the only one of the three that needs a colour and size decision to survive across rows.

Profile C is the volume buyer. Eight or more cheap rows, drawn from the bottom of the T-Shirts and Headwear bands, where $13.61 and $7.94 are the floors. Profile C is also the profile most exposed to a spreadsheet error, because a mixed bag invites mixing categories, and Accessories alone spans $5.17 to $451.10 across 24 entries. One accessory row pulled in at the wrong end of that band can outweigh the other nine rows combined without looking unusual in a list.

A profile is visible in a sheet before anything is bought, because it shows up as a distribution rather than as a total. A saved list dominated by Shoes is profile A regardless of what it is worth. A list holding four to six rows spread across Hoodies, T-Shirts and Headwear is profile B. A list of eight or more rows concentrated in the two cheapest bands, with T-Shirts below $22.23 and Headwear below $16.22, is profile C. The count and the category mix decide the profile, and the budget only decides how far into it the buyer goes.

Profile A builds a one-item parcel and should plan for it. A shoe at the category median of $68.68 attracts $1.40 of domestic shipping, $3.43 of commission and $2.21 of surcharge under default settings, which is $75.72 before freight, and the $45 freight line takes the parcel to $120.72. Freight is 37 percent of that total, and the parcel carries one item, so the freight is concentrated on a single object rather than spread across several.

Profile A also owns the volumetric case. A carton of 40 by 30 by 20 centimetres bills at 4.00 kg under a 6000 divisor against an actual weight of 2.5 kg, and the 1.50 kg difference costs $13.50 at a marginal rate of $9 per kg. A shoe box reaches that shape easily. Consolidation at /instrument/parcel-merge/ offers profile A nothing, because there is no second item to merge, so the only levers are the carton and the divisor.

Profile B builds a three-item parcel and gets the largest single improvement from doing so. A hoodie at $37.18, a tee at $22.23 and a beanie at $16.22 give a subtotal of $75.63, domestic shipping of $4.20, commission of $3.78 and a surcharge of $2.51, which lands at $131.12 with freight. The marginal cost of the second and third items is $10.40 against $38.45 of goods, because the $45 freight line was already being paid by the first item alone.

Profile C builds a seven-item parcel. Three tees at the median, three headwear pieces at the median and one pair of shorts at the Pants and Shorts median of $44.62 produce a subtotal of $159.97, domestic shipping of $9.80, commission of $8.00 and a surcharge of $5.33, for a landed figure of $218.10. Freight is 20.6 percent of that total against 37 percent for profile A, and the landed cost per item falls to $31.16. Apparel parcels also tend to be bounded by actual weight rather than volume, since the billed weight is the greater of the two.

A four-item variant of profile B is worth pricing as well, because the fourth row is where the pattern changes. One hoodie at $37.18, two tees at $22.23 each and one beanie at $16.22 give a subtotal of $97.86, domestic shipping of $5.60, commission of $4.89 and a surcharge of $3.25, which lands at $156.60 with freight. Freight falls to 28.7 percent of the total and the landed cost per item is $39.15, so the fourth row buys a lower share of fixed cost than the third one did, but the goods value has moved close to the £135 and €150 lines.

The first divergence is what consolidation can do for each profile. Profile A has one item, so merging changes nothing and the freight line is fixed at $45 whatever happens. Profile B gains $38.45 of goods for $10.40 once the first item has carried the freight. Profile C gains the most in absolute terms, but the gain arrives in a lump, because a seven-item parcel sits close enough to the weight at which a second carton becomes necessary that the improvement can disappear in a single billing decision.

The second divergence is which weight controls the bill. Profile A is volume-exposed, because a single shoe box is mostly air and the divisor does the deciding. Profile C is weight-exposed, because seven pieces of apparel occupy less space than they weigh relative to the divisor. Profile B sits between the two and is the profile for which the divisor choice matters least, which is a reason to avoid over-tuning a divisor setting before the parcel shape is known.

The third divergence is the tax line, and it separates the profiles by goods value rather than by item count. Profile A at $68.68 stays below the UK £135 and German €150 lines on any plausible conversion. Profile C at $159.97 crosses the German €150 line and sits close enough to the UK £135 line that the conversion used in the sheet decides it. Canada is the exception that flattens the comparison, because a CAD 20 threshold with 13 percent tax and a CAD 9.95 handling fee is crossed by the first item in all three profiles.

The fourth divergence is what a rejection costs. If profile A loses its single item, the whole $120.72 is at risk and the parcel has no remaining purpose. If profile C loses one of seven rows, the freight is already committed and the loss is the item plus its share of a fixed cost. That is the argument for profile C carrying the speculative rows and profile A carrying none, and it is the reason a first haul benefits from being shaped like B rather than like either extreme.

A fifth divergence is calendar time, which a spreadsheet records poorly and prices not at all. Profile A can dispatch as soon as one item clears intake. Profile B waits for three items to clear, so it holds a completed item in the warehouse until the slowest row arrives. Profile C waits for seven, and seven rows make it likely that at least one sits below the five-photo gate or needs a size question answered, which stretches the wait further and pushes against the free storage window that follows intake.

The sixth divergence is where each profile should split rather than merge. Profile C should split when the billed weight of a single carton exceeds actual weight by more than 1.50 kg, which is $13.50 at a marginal rate of $9 per kg, because a second parcel often costs less than the volumetric excess. Profile B should almost never split, since its goods value is small and the second $45 freight line would exceed the fee block it is trying to spread. Profile A has nothing to split.

Read together, the three profiles describe three different uses of the same worksheet. Profile A needs one row read closely, against the Shoes band of $24.09 to $100.84. Profile B needs four to six rows read against each other, which is where a merged parcel at /instrument/parcel-merge/ earns its place. Profile C needs the categories kept apart so that an accessory row at the top of a $5.17 to $451.10 band cannot quietly redefine the parcel.