One listing can contain several choices
The main image is not necessarily the selected variant. When comparing options, record the size and color exactly as shown at the destination. If labels are unclear or translated differently, retain the original label alongside your note.
Use separate rows when it helps
Two options from one listing may deserve separate rows if you are comparing their measurements or availability. Repeat the source URL and add an option field. This is clearer than compressing several incompatible choices into one cell.
Attach evidence to the right option
A measurement or photograph should remain connected with the product and variant it describes. Avoid moving an image between rows merely because the products look similar. Record any missing connection as uncertainty.
Reopen before deciding
A saved option may be removed or changed. Revisit the destination at the decision point and check that the intended selection still matches your notes. The directory itself does not confirm current variants or stock.
Define a variant record explicitly
A variant record should identify the listing and the selected option together. Keep the option label as shown at the source, adding your own explanation separately if necessary. This is useful when labels are translated, abbreviated, or similar across several choices. Your interpretation should not overwrite the wording you need to recognize when returning to the page. Record an observation date when a source detail matters to the comparison.
If two choices need different notes, use separate rows. Repeating the listing URL is acceptable when it preserves the difference between options. Avoid one cell that lists several colors followed by one measurement with no indication of which color or size it concerns. The spreadsheet’s structure should make the relationship visible. A clear variant record also helps when another person provides feedback: they can identify the selection they reviewed and you can attach their observation without assuming it applies to every option available under the same product page.
Compare a jacket and a top with the right questions
Two clothing candidates may share a printed size label while serving different purposes. A jacket intended for layering and a top intended for a closer fit should not be compared only by that label. Define your intended use, then choose relevant dimensions and a measuring method. Record the garment reference you are using for your personal comparison so the reasoning can be revisited later.
Keep each dimension attached to the option that produced it. If a measurement comes from a chart rather than an item photograph, label that source. If it was observed on a particular item, preserve the item context. You can then compare like information instead of combining a chart value for one candidate with an unclear photo reading for another. This does not require a complicated database. A few labeled fields for option, source type, dimension, unit, and method can make the difference between a useful comparison and a table that appears precise while mixing incompatible references.
Handle missing options without inventing equivalence
If the option you saved is no longer clear at the destination, preserve the original selection and mark the current question. Do not substitute the nearest-looking choice and carry all earlier observations across automatically. A different size or style may require a fresh comparison. Similar appearance can suggest where to investigate, but it does not establish that the options are interchangeable.
Record the current visible labels and the date you observed them. If you obtain clarification, attach it to the original question and explain the relationship established. If the relationship remains uncertain, keep the candidate unresolved or create a separate row for the new choice. This preserves a useful history and prevents the spreadsheet from implying that a measurement or image belongs to an option it never documented. A careful variant comparison makes uncertainty visible at the point where it matters, instead of hiding it behind a single product name that covers several different choices.
Keep personal preference outside the source fields
Your preferred color, fit, or use case belongs in your own comparison fields. Preserve the source labels separately. This lets you revise your preference without changing the record of what the destination showed. It also helps explain why two people can use the same source information and choose different candidates. Their decision criteria may differ even when their observations agree.
Write a concise reason for your preference when it affects the shortlist. For example, a candidate may better match the dimensions of a familiar garment or provide a clearer option reference for your task. That is a scoped personal conclusion, not a general ranking of every item in the category. When sharing the comparison, include the criteria so another reader understands the decision. They can then reuse the source references while applying their own needs, rather than inheriting an unexplained favored label that appears to be an objective property of the product.
A practical exercise
Create two rows for different intended options from one listing, keeping the shared source URL in both. Give each its own question and observation fields. Add a measurement only to the row whose option the evidence actually describes. Leave the other unresolved. This demonstrates why repeating a reference can be useful: the repetition preserves option identity instead of forcing two choices into one record and making a later reader guess which selection a number or image note belongs to.