Compare rows that answer the same question
To compare OOTDBuy spreadsheet rows fairly, start with candidates that answer the same question. A hoodie, a pair of shoes and a bag may all cost a similar amount, but they do not belong in one comparison. Start with a use case: “light everyday jacket,” “running-style shoe with clear sizing,” or “small bag with an adjustable strap.” Rows qualify only if they answer that same need.
If the category, intended use or required variant differs, place the row in another group. Otherwise the comparison will reward price or appearance while ignoring the fact that the items solve different problems.
Use a three-candidate limit
More options feel safer but often produce shallower checking. Keep the first three plausible rows, compare them, and replace one only when a new candidate is clearly stronger on a decision-changing field. Do not add a fourth row just because it exists.
Normalize the fields before scoring
Spreadsheet rows often use different words, currencies, chart formats and image styles. Rewrite each row into the same small set of fields. The act of normalizing is more valuable than a complicated score because it reveals which rows are not truly comparable.
Treat unknown as a real result
Do not convert missing information into a neutral score. “No size chart” is different from “average sizing.” “No side photo” is different from “acceptable side profile.” Keep unknowns visible so a cheap price cannot quietly erase them.
A useful comparison can end with no winner. If every row lacks a required measurement or the destination does not match the description, the correct action is to search again with a better question.
Score evidence, not excitement
Use three labels for each field: clear, partial or unknown. Clear means the available information directly answers the question. Partial means it helps but leaves a meaningful gap. Unknown means the row provides no usable answer.
Do not add all fields into a blind total. A required field can be a gate. If exact compatibility matters for electronics, a clear appearance score cannot compensate for an unknown model specification.
Compare price only after matching the variant
A displayed price may refer to a different size, color, minimum quantity, accessory-only option or package. Confirm that candidates include comparable variants and pieces before deciding one is cheaper. If that cannot be confirmed, write “price not normalized.”
Keep the item price beside expected weight and packaging. The shipping weight guide explains why a low row price can still produce a weaker overall decision.
Use tie-breakers in a fixed order
- Required evidence. Remove any candidate missing a non-negotiable measurement, specification or photo.
- Fewer important unknowns. Prefer the row that asks for less guessing.
- Clearer source match. Prefer the destination that agrees with the description and variant.
- More useful photo set. Prefer angles that answer your questions, not simply more images.
- Price and likely weight. Use cost context only after the evidence is comparable.
Write the decision note
Finish with one sentence: “Candidate B stays because it has the clearest size evidence and matching source; Candidate A lacks a side view, and Candidate C's listed price is for an unclear variant.” This sentence is an audit trail. If you cannot explain the result, the comparison needs another pass.
Know when to stop comparing
Stop when one candidate meets every required field, the remaining unknowns are named and another search is unlikely to change the decision. Also stop when none of the candidates passes a required field. Endless browsing is not additional verification.
Continue with the right guide
Use the QC photo guide when images are the tie-breaker, the sizing guide when charts conflict, and the source-link guide when destinations are unclear. End with the seven-point checklist.