From the blog
Shortlist Amoi Earbuds: Catalog vs Sheets
First, copy the candidate models from the Amoi catalog into a spreadsheet, then check variants, accessories, images, and links item by item to reduce the risk o...
First, copy the candidate models from the Amoi catalog into a spreadsheet, then check variants, accessories, images, and links item by item to reduce the risk of mixing up different models. The currently visible catalog lists two candidates: Amoi TW-A01 Ear-Clip Earbuds, and Amoi Tour Pro2 wireless earbuds. The page text also mentions Open-Ear Bluetooth 5.3, 4β8 Hour Playback, as well as ANC and charging case, but these fields cannot replace full model and accessory verification.
Step 1: Build the Candidate List First
After opening the Amoi brand catalog, put each model on a separate row; don't merge descriptions from the same page into one candidate. We recommend recording the following fields first:
- Product number: Record it as-is if the page has one; otherwise leave it blank.
- Model name: Copy the full name shown on the page, including model identifiers like TW-A01 and Tour Pro2.
- Page description: Keep the exact text from the page regarding earbud form, connectivity version, battery life description, ANC or charging case.
- Color or variant: If the page doesn't clearly show it, write "To be verified"; don't infer color from product images.
- Left/right ear info: Record whether the page clearly states left ear, right ear, single or dual earbuds; leave blank if there's no evidence.
- Accessory info: Separately record charging case, charging cable, ear tips, or other accessories. Even if only one accessory name appears on the page, don't expand it into a full accessory list.
- Image status: Mark as "Verified", "To be verified", or "Insufficient images".
- Product link: Save a link that goes back to the corresponding product page; if you cannot confirm the correspondence, mark "Link needs recheck".
The catalog page currently provides model names and some descriptions directly. It does not fully list colors, left/right ear configuration, all accessories, image correspondence, or product numbers in the provided page evidence, so these fields should remain as missing evidence.
Step 2: Separate Catalog Browsing from Sheets Records
The website catalog is good for confirming what actually appears on the page, while Google Sheets is good for turning confirmed results into a filterable candidate list. Don't use one to replace the other: the catalog is the verification source, and the spreadsheet is the tool for organizing and rechecking.
| Task | Catalog page | Google Sheets |
|---|---|---|
| Find candidate models | Browse the brand catalog and product names directly | Save each model as an independent record |
| Verify page description | Check product title and visible description | Enter confirmed text into the description field |
| Check images and links | Go back to the corresponding product page to verify | Record image status and link recheck status |
| Manage missing information | Discover the page doesn't clearly state something | Use status fields to filter items needing verification |
| Multi-person organization | Rely on page access and verbal communication | Share the spreadsheet and supplement records field by field |
The value of the spreadsheet is not to add product information to the catalog, but to separate "confirmed" from "not yet confirmed". This way, when you go back to the page later, you can directly handle rows with missing specs, images to verify, and links to recheck.
Step 3: Use Fixed Statuses to Avoid Treating Guesses as Conclusions
We recommend setting up a "Status" column and using only the following five values:
- Confirmed: The model and the page fields required for the current task have been verified.
- Missing specs: The candidate model exists on the page, but key fields like color, left/right ear, or accessories lack sufficient evidence.
- Images to verify: Images exist, but it hasn't been confirmed whether they correspond to the current model or variant.
- Link needs recheck: The link cannot be confirmed to return to the correct product page, or the page needs to be reopened for verification.
- Excluded: Duplicate model, information cannot be matched, or no longer included in this candidate range.
Don't use phrases like "looks like", "should include", or "might have" instead of a status. If the page doesn't clearly state accessories, record "Accessories not confirmed by the current page" rather than expanding the product name's "charging case" into a complete accessory list.
Step 4: Record the Two Amoi Candidates Separately
Based on the current catalog text, you can first create two basic rows:
| Model | Page visible description | Fields to continue verifying | Initial status |
|---|---|---|---|
| Amoi TW-A01 Ear-Clip Earbuds | Open-Ear Bluetooth 5.3; 4β8 Hour Playback | Color, left/right ear info, full accessories, image correspondence, product link | Missing specs |
| Amoi Tour Pro2 wireless earbuds | ANC; charging case | Color, left/right ear info, full accessories, image correspondence, product link | Missing specs |
This table only organizes what the catalog shows and what is still missing; it does not judge performance, actual battery life, stock, or purchasing advantages. In particular, "4β8 Hour Playback" is a page text description and should not be rewritten as tested battery life; "ANC" should not be further inferred for noise cancellation effect.
Step 5: Use Filters to Arrange Recheck Order
In Google Sheets, filter by status and handle "Link needs recheck" and "Images to verify" first, then "Missing specs". The reason is that if the link or image correspondence is not established, other fields may be written under the wrong model.
Each time you return to the catalog page, only modify fields that can be confirmed by the page this time, and fill in the date in the "Last review time" column. If the page has no new information, keep the original status and don't fill in speculative content just to make the table look complete.
For multi-person collaboration, we recommend adding "Reviewer" and "Review notes" columns. Notes should clearly describe what was checked, such as "Product title matches the linked page" or "Page does not show color", avoiding vague records like "looked at it".
Final Check Before Ordering
After completing candidate screening, check each model you plan to keep in the same order:
- Model name exactly matches the catalog page.
- Variant, color, and left/right ear info has page evidence.
- Accessories are recorded item by item, and any items not shown are clearly marked as missing evidence.
- Images indeed correspond to the current model, not other products in the brand catalog.
- Links can return to the corresponding product page.
- Last review time is filled in, and status is still "Confirmed".
As long as any one item cannot be confirmed, keep the corresponding pending verification status. This way you get a reviewable Amoi candidate list, rather than mistaking the short descriptions in the catalog for a complete specification sheet.
Continue reading