How to Build an OSSBuy Spreadsheet Shortlist

Why a Shortlist Helps

A shortlist prevents you from treating the first interesting record as the only option. The OSSBuy Spreadsheet can contain many records across shoes, clothing, accessories, bags and lifestyle categories. Some will have clearer source pages than others. Some will have better sizing information. Some will have lower shipping risk.

The purpose of a shortlist is to compare a small group of serious candidates, not to save every product that looks interesting.

Choose One Research Goal

Start with one goal: running shoes, a heavyweight hoodie, a T-shirt with a specific print, a jacket for layering, a bag with a certain capacity or a hat with a known fit. A clear goal makes the shortlist useful.

Begin at the Spreadsheet Hub and choose the most relevant category. If your goal is clothing, compare clothing records. If your goal is accessories, do not mix in shoes and jackets just because they look appealing.

Collect Five to Ten Candidates

A practical shortlist usually starts with five to ten records. Fewer than that may not give enough comparison. More than that can become hard to manage. Use category pages such as Shoes, Hoodies and Sweaters, Accessories or Bags and Watches.

At this stage, do not decide yet. Save the source link, product title, category and any visible price reference.

Remove Records With Broken or Confusing Links

Open every source listing and remove records that redirect to unrelated pages, show deleted listings, lose the expected option or no longer match the spreadsheet record. This simple step can cut the shortlist quickly.

If a link is uncertain but still interesting, keep it in a separate “maybe” section instead of mixing it with stronger candidates. The link-check guide explains what to compare.

Rank by Evidence, Not Excitement

It is natural to prefer the best-looking photo, but a shortlist should reward evidence. A strong candidate has a clear source page, identifiable options, useful photos, reasonable size information and no obvious mismatch between the spreadsheet record and the live listing.

A weaker candidate may still look good, but it has missing sizing, confusing options, unclear seller/store reference or limited photos. Keep the difference visible in your notes.

Add Category-Specific Notes

For shoes, note size system, insole or outsole clues, box, sole and colorway. For T-shirts, note chest width, length, fabric and print placement. For hoodies, note chest, sleeve, lining, fabric weight and parcel volume. For jackets, note fill, layering room, measurements and shipping weight. For pants, note waist, rise, inseam, thigh and leg opening.

For bags and accessories, note dimensions, capacity, strap, hardware, packaging and whether the listing shows the exact option you want.

Use Price After Filtering for Fit

Price is easier to compare after you remove poor candidates. A cheap record with unclear size or a changed source page is not automatically better. Compare price only after checking whether the product identity, options and sizing are acceptable.

Also consider shipping impact. A boxed shoe, padded jacket or structured bag can cost more to ship than a small accessory, even when the product price looks attractive.

Move the Best Three Into Final Review

After filtering, choose the best three candidates for final review. Reopen the source pages, compare options again and check whether any QC evidence or measurement information changes your ranking.

This final group should be small enough that you can carefully compare each item. If you cannot explain why a candidate is in the top three, it probably belongs outside the shortlist.

Keep a Recheck Date

Spreadsheet records and source listings can change. If you do not order immediately, write down the date you checked the source page. Before ordering later, reopen the page and verify the current details again.

An old shortlist is not a final decision. It is a research record that needs a fresh check.

Shortlist Template

• Category and product title.
• Source link and check date.
• Selected option and visible price.
• Sizing notes or missing measurements.
• Photo or QC concerns.
• Shipping weight or packaging concern.
• Final status: strong, maybe or reject.

Next Steps

After building a shortlist, compare the strongest candidates with the comparison guide. If sizing is the main risk, use the sizing guide. If warehouse images are available, continue with the QC photo guide.