Skip to content

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.

TaskCatalog pageGoogle Sheets
Find candidate modelsBrowse the brand catalog and product names directlySave each model as an independent record
Verify page descriptionCheck product title and visible descriptionEnter confirmed text into the description field
Check images and linksGo back to the corresponding product page to verifyRecord image status and link recheck status
Manage missing informationDiscover the page doesn't clearly state somethingUse status fields to filter items needing verification
Multi-person organizationRely on page access and verbal communicationShare 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:

ModelPage visible descriptionFields to continue verifyingInitial status
Amoi TW-A01 Ear-Clip EarbudsOpen-Ear Bluetooth 5.3; 4–8 Hour PlaybackColor, left/right ear info, full accessories, image correspondence, product linkMissing specs
Amoi Tour Pro2 wireless earbudsANC; charging caseColor, left/right ear info, full accessories, image correspondence, product linkMissing 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:

  1. Model name exactly matches the catalog page.
  2. Variant, color, and left/right ear info has page evidence.
  3. Accessories are recorded item by item, and any items not shown are clearly marked as missing evidence.
  4. Images indeed correspond to the current model, not other products in the brand catalog.
  5. Links can return to the corresponding product page.
  6. 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

More from this site