From the blog
MLB Jersey Shortlist: Spreadsheet or Sheets?
First, separate the tasks: discovering candidates and managing candidates are not the same step When organizing MLB jersey candidates, it's easy to confuse "fin...
First, separate the tasks: discovering candidates and managing candidates are not the same step
When organizing MLB jersey candidates, it's easy to confuse "finding products" with "making selection decisions." fashionreps' currently visible MLB category page is better suited for browsing candidates: the page displays product cards with names, some color or pattern information, and provides filter and sort options. Google Sheets, on the other hand, is better for turning candidates into a continuously updatable record, centrally managing numbers, sizes, link status, and reasons for exclusion.
Therefore, a more reliable process is: first discover and open candidates in the website-style Spreadsheet, then copy the fields you need to compare into Google Sheets, and finally return to the product page to verify missing information.
Step 1: Start by recording the fields actually displayed on the page
The MLB category page examined this time shows 9 candidate entries, and the names include different patterns, fabrics, fits, and size ranges. For example, the page shows the following types:
- Multicolor cotton patterned T-shirts, some entries marked S–XXL
- Navy blue cotton loose fit, some marked S–XXL
- Embroidered crewneck cotton
- 100% cotton double-yarn crewneck
- Black printed polyester street style
- Rose pattern or black pattern, some marked up to 4XL or 5XL
This information can serve as initial screening criteria, but it cannot be directly equated with complete product specifications. The category page names can help you judge pattern, color, fabric, or approximate size range, but the currently visible text does not prove that each candidate provides specific team names, player numbers, or all color variants.
Recommend starting with the following fields:
| Field | Recording method | Verification focus |
|---|---|---|
| Candidate name | Copy the page name exactly | Prevent different styles from being mixed up as the same product |
| Pattern or team clues | Record what is explicitly stated in the name | Don't fill in teams that are not explicitly written |
| Number options | Fill in the options actually displayed on the product page | Mark as pending verification if not shown on category page |
| Size | Record ranges like S–XXL, S–4XL as they are | Don't merge size ranges from different products |
| Color or variant | Record colors, numbers, or variants explicitly listed on the page | Color codes do not equal teams or numbers |
| Product link | Save a link that still corresponds to the candidate after opening | Reopen to confirm it hasn't jumped to another style |
| Status | Use consistent status labels | For later filtering and review |
Step 2: Use four status categories to control candidate quality
Don't mark all candidates as "purchasable" from the start. A more practical approach is to use four status categories:
- Verified: Name, product page, size, and desired pattern all match; numbers or other variants have clear evidence.
- Pending verification: The candidate seems to meet requirements, but one of the fields—number, team, size, or color—has not been confirmed on the product page.
- Link issue: Link doesn't open, product name differs after redirect, or cannot confirm the link still corresponds to the original candidate.
- Excluded: Size inappropriate, pattern doesn't meet needs, or product page cannot provide information needed for decision.
"Pending verification" is not a weaker version of "verified"; it reminds you not to place an order based on this yet. Especially for MLB-related patterns, the presence of MLB or team color clues in the name does not automatically prove the existence of a specific team, player number, or particular season version.
Step 3: Clarify the boundary between website-style Spreadsheet and Google Sheets
The advantage of the website-style Spreadsheet is candidate discovery. The current category page provides product cards, filter options, and sorting by popularity, newest, and price, suitable for quickly narrowing browsing. Its core task is to help you find and open candidates, not to maintain a long-term status record for you.
Google Sheets is more suitable for candidate management. You can fix each product as a row and use columns like status, size confirmed, number confirmed, and link valid for filtering. The value is not adding product information, but organizing discovered information into a reviewable decision record.
| Task | Better tool | Reason |
|---|---|---|
| Browse category page and discover candidates | fashionreps website-style Spreadsheet | Page directly presents candidate names and provides category filters and sorting |
| Open product page to verify specific options | fashionreps product page | Numbers, sizes, and colors should be based on the corresponding product page |
| Record four status categories | Google Sheets | Suitable for filtering records by status, size, or missing fields |
| Recheck whether links still correspond to original product | Both together | Need to go from sheet record back to original page to check |
Don't treat "team," "number," or "purchasable" that you fill in Google Sheets as website evidence. The sheet is just a management layer; facts still need to be verified on the corresponding product page.
Step 4: Filter by missing fields, not just by price
If the goal is to organize candidates for further comparison, prioritizing screening for missing fields is often more effective than simply sorting by price. Check in order:
- Does the number have explicit options? If no evidence, keep as "pending verification."
- Is the size range within target? S–XXL, S–4XL, or S–5XL from different entries should not be substituted for each other.
- Are color or pattern clear? Multicolor, numbers, and print descriptions need to match product page.
- After opening the link, does it still show the same name or style?
- Does the page only provide category-level description without details needed for purchase decision?
The current source can support recording the category page visible names, some size ranges, color or pattern descriptions, and filter/sort options; it cannot support all candidates' number inventory, real-time stock, shipping, final price, or purchase availability judgments. Therefore, these fields should be left blank, marked pending verification, or updated after review.
Final review: Make every row point back to a specific page
After initial screening, open each link row by row and check whether the name, pattern clues, size, color, and number in the sheet still refer to the same product. If a field can only be inferred from the category page, don't rewrite inference as confirmed fact. If the link is broken or page content has changed, change status to "link issue" or "pending verification" instead of keeping it in the verified list.
After organizing this way, fashionreps handles discovery and locating candidates, and Google Sheets handles recording status and missing information. The result is not automatically generated purchase conclusions, but an MLB jersey candidate list that can explain "which ones are verified and which still need to go back to the product page for confirmation."
Continue reading