From the blog
Longines Watch Shortlist: Directory vs Sheets
First, Define Your Organizing Goal If your task is to build a watch candidate list from the fashionreps Longines catalog, the focus isn't on deciding which piec...
First, Define Your Organizing Goal
If your task is to build a watch candidate list from the fashionreps Longines catalog, the focus isn't on deciding which piece is worth buying first. Instead, it's about separately recording the candidate's identity, page information, and follow-up review items. This avoids mistaking the catalog's reference price for the final purchase condition, and prevents premature conclusions due to incomplete page fields.
The currently visible Longines brand page shows two candidates: Longines Master Collection White-Dial Automatic, with a listed reference price of $65.67 and an original reference price of $76.89; and Longines Spirit-Style 40mm Pilot Watch with Gray Dial and Steel Bracelet, with a listed reference price of $41.79 and an original reference price of $45.02. The source page also displays price sorting options and filtering entry points, but these two prices can only serve as reference fields from the catalog. They cannot be used to infer stock, shipping, final sale price, or whether the link is currently valid.
Step 1: Create Candidate Records from the Catalog Page
First, open the Longines brand catalog page and record, item by item, the information directly visible on the current page. It's recommended to create one row per candidate to avoid duplicating the same watch under different sorting results.
| Field | How to Record | Review Focus |
|---|---|---|
| Brand | Longines | Consistent with brand catalog |
| Page Name | Copy the style name from the catalog exactly | Do not abbreviate or alter product identity |
| Dial Color | Only record colors explicitly stated in the name | Leave blank if not explicitly shown |
| Size Field | Only record sizes explicitly provided on the page or product page | Do not infer size from the name |
| Catalog Reference Price | Record the currently displayed price | Mark as reference price, not final price |
| Original Reference Price | Record separately if shown on the page | Do not infer reasons for discount |
| Product ID | Only fill in if explicitly provided on the page | Leave blank if no evidence |
| Product Link | Save the current page URL | Check later if it still opens |
| Image URL or Image Notes | Record the image corresponding to the candidate | Verify the image indeed matches this row |
The current page provides two candidate names and reference prices, but the given source data does not include product IDs, specific image URLs, stock, shipping, or purchasable status. Therefore, these fields should not be filled in based on name, price, or image appearance.
Step 2: Distinguish Between Information in the Name and Fields Needing Verification
The catalog name can help with initial organization. For example, White-Dial suggests a white dial, Gray Dial and Steel Bracelet suggests a gray dial and steel bracelet, and 40mm indicates a size appearing in the name.
However, a name clue is not the same as a full specification. During organization, split them into two categories:
- Information explicitly present in the catalog name, such as style name, partial color description, and size if stated.
- Information requiring verification from the product page or other verifiable evidence, such as full dimensions, movement, case material, product ID, image correspondence, stock, and shipping.
This distinction prevents expanding name descriptions into full specifications not supported by the catalog. Especially when product details are not visible, do not add water resistance, movement type, weight, packaging contents, or after-sales information on your own.
Step 3: Set Up a Review Sheet in Google Sheets
Google Sheets is suitable for organizing the candidate list. Its role is not to replace the fashionreps catalog, but to put multiple candidates in one sheet for easy filtering, deduplication, and recording review results.
Start with these columns:
- Candidate ID
- Brand
- Catalog Name
- Dial Color Clue
- Size Field
- Catalog Reference Price
- Original Reference Price
- Product ID
- Image Correspondence Status
- Missing Specifications
- Product Link
- Link Recheck Time
- Candidate Status
- Exclusion Reason
- Notes
The Candidate ID should be created by you to distinguish records in the sheet; do not mistake it for the website's product ID. If the product ID is not shown on the page, you can enter "To verify" or leave it blank, but do not fabricate an ID.
Candidate Status can use a limited set of values, such as "To recheck", "Info incomplete", "Keep observing", and "Excluded". The meaning of each status should remain consistent:
- To recheck: Candidate found, but product page or link verification not yet completed.
- Info incomplete: Page still identifiable, but size, image correspondence, or other key fields incomplete.
- Keep observing: Information temporarily sufficient for further review, but stock or purchase eligibility not confirmed.
- Excluded: Based on clearly recorded reasons, no longer included in this round of candidates.
Step 4: Use Sheet Filters to Find Duplicates and Missing Information
After initial entry, first check duplicates by full page name, then by product link. Sorting result changes should not create new candidates, and the same product should not have a second row due to reference price changes.
Then filter for these situations separately:
- Records with same product name but different links: check if they are duplicate pages or different page versions.
- Records with same product link but different names: check if the page title or notes were mistakenly entered as the style name.
- Records with empty size field: mark as "Info incomplete"; do not substitute sizes from similar models.
- Records with unclear image correspondence: go back to the original page to confirm if the image matches the name.
- Records with empty product ID: keep blank and note "To verify", rather than guessing from link or name.
- Records with only reference price and no product detail evidence: keep the catalog source, but do not mark as confirmed purchasable.
If the sheet has only two candidates, you can manually review row by row. As the candidate count increases, use filter conditions to focus on missing specifications and duplicate records. The sheet's value lies in uniformly recording these judgments, not in creating product information absent from the catalog.
Step 5: Go Back to the Catalog Page to Confirm Source Relationships
The fashionreps Longines page serves as an entry point for candidate discovery and returning to the original page. You can view currently listed candidates from the brand page, use the page's sorting or filtering to narrow the view, and bring items needing further confirmation back to your sheet.
The division of labor between the catalog page and Google Sheets can be understood as follows:
| Tool | Suitable Tasks | Judgments Not to Make |
|---|---|---|
| fashionreps Longines catalog | Discover candidates listed on the current page, view names and catalog reference prices, return to original page | Cannot confirm stock, shipping, full specs, or long-term link validity solely from the catalog listing |
| Google Sheets | Uniformly record candidates, filter missing fields, deduplicate, record recheck times and exclusion reasons | Cannot replace product page evidence, nor turn blank fields into confirmed information automatically |
This approach preserves source context: each row can trace back to a candidate name in the catalog, while the subsequent review process is recorded separately.
Minimum Review Checklist Before Ordering
Before passing any candidate to the next purchase decision stage, complete the following checks one by one:
- Does the product name match the recorded candidate?
- Is there page evidence for dial color and strap description?
- Does the size come from a clear field on the current page, not inferred from name or borrowed from other models?
- Has the product ID been explicitly provided by the page?
- Does the image in the sheet correspond to the current candidate, not another model in the same catalog?
- Can the product link be reopened, and does the page content still match the record?
- Is the reference price still correctly marked as a catalog reference price?
- Have stock, shipping, and actual purchase conditions been verified separately?
- If information is insufficient, have you recorded the missing fields and reasons for not confirming yet?
The current given evidence only confirms that the Longines catalog page lists two candidates and their reference prices. It cannot confirm stock, shipping, product IDs, full dimensions, image URLs, or link validity. Therefore, the safest outcome is not to rank candidates directly, but to first complete identity recording, then write missing fields and recheck times into Google Sheets, and finally decide whether to keep them based on the latest page evidence.
Continue reading