Compare rows in the same category with the same required option. Record what each row proves, what it leaves unclear, and what would make you reject it. If a required field is missing, treat that as missing evidence—not as a reason to assume the best.
Start with one requirement and two preferences
Before opening several rows, write one non-negotiable requirement. It might be a specific measurement, connector type, material detail, or usable color. Then add no more than two preferences. This prevents an attractive image or small price difference from quietly changing the question you meant to answer.
Requirement
A condition the item must satisfy. If it is not confirmed, the row cannot advance.
Preference
A feature that helps break a tie after every requirement has been met.
Use the same comparison columns every time
| Column | What to record | Why it matters |
|---|---|---|
| Exact option | Size, color, model, version, or bundle shown | Prevents comparing unlike variants |
| Source match | Whether title, images, and option align with the destination page | Reduces link or listing confusion |
| Photo coverage | Whole item, key detail, measurement, label, or interface view | Shows what is visible and what is absent |
| Measurements | Values, units, and whether they describe the product or packaging | Makes size comparisons more concrete |
| Price context | Visible base price, selected-option price, and any unclear range | Avoids treating a teaser range as a final figure |
| Weight or bulk | Any stated weight, dimensions, or bulky shape note | Helps you ask better shipping questions |
| Open question | The single missing fact that blocks your decision | Keeps research focused |
A two-row example
Suppose Row A has clearer detail photos and the required measurement, while Row B has a lower visible price but no measurement image. If the measurement is your requirement, Row A currently has stronger evidence. Row B may still be useful, but it remains “unclear” until the missing field is resolved.
This method does not declare one seller or product better. It ranks the quality of the information available for your decision.
Apply hard stop conditions
- The destination page no longer matches the spreadsheet image or title.
- The required option cannot be found or confirmed.
- A measurement is essential, but no reliable measurement is visible.
- The page redirects through an unfamiliar login, payment, or download prompt.
- The row depends on a claim that the visible source does not support.
Use a tie-breaker only after requirements pass
When two rows satisfy the same requirement, compare the quality of photo coverage, the clarity of the option, and the number of unresolved questions. Price can be a final preference, but it should not erase missing evidence.
Copy this note into your shortlist
Row: [name or URL]
Required option: [value]
Requirement confirmed by: [visible source]
Photo coverage: [what is shown]
Missing evidence: [one question]
Price context: [base / selected option / unclear]
Status: [keep / unclear / reject]
Reason: [one sentence]