Record now
Example output 1: record now must remain explicit in the saved record.
Method · duplicate row reconciliation
A four-step Oopbuy Spreadsheet duplicate row reconciliation
Complete each observable field before making the keep, change, request, or recheck decision.
Before starting
Resolve identity before comparing evidence
- Final source URL
- Exact visible selection
- Evidence observation date
Four-step method
Turn a saved row into a traceable keep-or-merge decision
Every duplicate row reconciliation step leaves a named output. Pause the worksheet when its next decision would depend on a source, option, view, or measurement that is absent.
-
1. Resolve the source
Select the two candidate rows and resolve both final URLs.
-
2. Capture exact fields
Compare identity, option, evidence, and review-date fields.
-
3. Classify evidence
Classify differences as duplicate, variant, replacement, or unresolved.
-
4. Record the decision
Record the decision and preserve every field that should survive it.
Worked example
A plausible match can still remain unresolved
Two rows share an image and title, but their final URLs expose different options. Keep both until identity fields show whether they are variants or separate items.
Compare next
Example output 2: compare next must remain explicit in the saved record.
Do not infer
Example output 3: do not infer must remain explicit in the saved record.
Exception handling
Reopen only the field affected by new evidence
Preserve the earlier audit trail while adding the new source, observation, and decision.
- Two rows share a title but not a final source.
- Option or variant differences would be lost by merging.
- One row has newer evidence but no change history.
- The original source is unavailable.
Return to the live source with a traceable keep-or-merge decision
The saved record should explain both the decision and its limits.
Use the Oopbuy workflow notes when the saved record needs a current platform-specific next step.
Review FAQ