Ignore “best” until the rows are comparable
A large list can look authoritative while repeating the same source or hiding missing information. Judge distinct rows, current links and evidence that affects the decision. This guide does not take orders or confirm stock.
Start by confirming identity
Before comparing photos or price, check whether two rows are genuinely different. Converted addresses and different thumbnails can still lead back to the same source item.
Why a long spreadsheet can waste time
More rows create a sense of choice, but row count is not the same as useful variety. The same source item may appear under several labels, and copied images can make duplicate destinations look different. Remove duplicates before judging the range.
Build a three-row comparison
Pick one category and one intended use, then select no more than three plausible rows. Three is enough to expose missing information without turning the session into another mixed spreadsheet.
| Column | What to record | Why it matters |
|---|---|---|
| Identity | Category, variant, source domain and destination title | Shows whether the rows describe the same kind of item. |
| Evidence | Useful photo angles, measurements, material clues and included pieces | Separates visible facts from promotional wording. |
| Cost context | Displayed price, quantity, packed-weight estimate and missing costs | Stops the lowest headline price from winning automatically. |
| Uncertainty | The most important unanswered question | Gives the next click a purpose. |
Remove duplicates before comparing price
Two rows are probably duplicates when their raw source URL, image sequence, variant list and unusual description details match. A converted link may look different while preserving the same underlying source. Keep one copy—the row with clearer notes or the more direct link—and discard the rest from the shortlist.
Check freshness without pretending there is a perfect timestamp
A visible “updated” date helps, but it does not prove every row was reviewed. Open the destination and look for current variants, working images and a title that still matches the sheet. If a row has no date, judge freshness by the destination rather than guessing from the spreadsheet design.
The link resolves, item identity matches, variants are understandable and the evidence is still visible.
The link redirects elsewhere, images are missing, the variant changed, or the title no longer describes the destination.
Use a reason code for every saved row
Add a six-word note such as “best measurement table; weight still unknown” or “clear hardware photos; compare interior size.” This creates a decision trail. If you cannot write a concrete reason, the row probably survives only because it looked exciting.
A five-minute comparison routine
- Choose one neutral category and one intended use.
- Open three rows that appear genuinely different.
- Remove duplicate sources and mismatched variants.
- Record the strongest evidence and biggest gap for each.
- Check price only after identity and evidence.
- Keep one or two rows; leave the rest behind.
Keep the row you can describe without repeating its sales label: what it is, what the page actually shows, what it may cost to ship, and what still needs checking.