Define one decision before building the comparison
A comparison works only when the rows answer the same need. “Three jackets” may still be a poor set if one is a thin shirt layer, one is insulated, and one includes a removable liner. Decide the category, use, required size or specification, acceptable configuration, and the detail that matters most.
Decision sentence
“I am comparing [category] for [use], in [size/specification], and the deciding detail is [fit, construction, compatibility, dimensions, or packed weight].”
If you cannot complete this sentence, return to category browsing. More rows will only add clutter.
Normalize the rows before comparing price
Check that every row refers to the same unit and option. A displayed price may represent a deposit, one component, a minimum-quantity tier, a smaller size, or a default variation. Quantity, included pieces, and packaging can change both product value and likely shipping weight.
- Same product family and intended use
- Same or genuinely comparable size, model, or configuration
- Same unit and quantity context
- Same included components or a clearly recorded difference
- Current source-page option, not only the spreadsheet thumbnail
Use a compact comparison table
| Field | Row A | Row B | Row C |
|---|---|---|---|
| Exact category / option | Record | Record | Record |
| Best QC views | 2–3 useful views | 2–3 useful views | 2–3 useful views |
| Size / specification | Value + source | Value + source | Value + source |
| Source match | Matched / uncertain | Matched / uncertain | Matched / uncertain |
| Price context | Option + date | Option + date | Option + date |
| Weight / bulk clue | Known + unknown | Known + unknown | Known + unknown |
| Main unresolved question | One sentence | One sentence | One sentence |
| Decision | Keep / pause / remove | Keep / pause / remove | Keep / pause / remove |
The table does not need a complicated score. It should expose missing details and stop one attractive field—usually price or a thumbnail—from controlling the decision.
Useful details matter more than photo count
Ten repeated photos can be weaker than four well-chosen views. A measurement chart tied to the selected option is more useful than a generic size label. A source page that matches the row is easier to trust than an unexplained converted link.
Worth keeping
- Angles that matter for the product
- Readable measurements or specifications
- Matching source and selected option
- A date or other current context
- A clear note about what is still unknown
Easy to overvalue
- Popularity labels or urgency
- Repeated thumbnails
- Generic “true to size” wording
- Price without option context
- Unexplained rating or endorsement
Give price the right amount of influence
Price is meaningful only after the compared unit, option, quantity, and date are clear. A small product-price difference may be less important than missing measurements, heavier packaging, an uncertain source match, or incompatible specifications.
Do not manufacture a precise “total” when current official shipping, service, tax, or other required information is unavailable. Instead record scenarios: lower product price with uncertain weight; higher product price with clearer measurements; similar price but stronger source match.
Remove duplicate and near-duplicate rows
Spreadsheets often circulate the same item through different titles, images, converted URLs, or old prices. Compare product identifiers, source domains, image details, option structure, and descriptions. If two rows lead to the same underlying listing, keep the cleaner record rather than treating them as independent choices.
A 15-minute comparison workflow
Minutes 1–3
Write the decision sentence and remove different categories or configurations.
Minutes 4–7
Review the QC photos and record the most useful view for each row.
Minutes 8–11
Match source, option, price context, and weight or bulk clues.
Minutes 12–15
Write keep, pause, or remove with one reason and one unknown.
Stop when more browsing no longer changes your notes. A useful comparison leaves you with fewer choices and a clearer next question.
End with a decision record
One-row decision note
Status: keep / pause / remove
Why: the detail that supports the choice
Unknown: the remaining issue that could change the result
Next check: exact source, photo, measurement, specification, or official service information needed