From the blog
Amiri Accessories: Lock Styles, Colors, and Missing Fields
First Clarify What This Candidate List Can Confirm When organizing Amiri accessories, the first step is not to directly judge which item is worth buying, but to...
First Clarify What This Candidate List Can Confirm
When organizing Amiri accessories, the first step is not to directly judge which item is worth buying, but to record the different styles from the same source separately, and then mark which fields still need to be checked. The currently verifiable Fashionreps page is a catalog of multiple Amiri hats, showing 7 styles on 1 page, and requiring you to first view the style name, then enter the corresponding image page.
Amiri accessories candidate catalog illustration
Based on the visible information on the page, the following names and SKUs can be confirmed at this time:
| Product Name | SKU | Fields Initially Sorted from the Name | Missing or Unconfirmed Fields |
|---|---|---|---|
| AMIRI retro-style black hat | SPU-HAW9LODWMK | Brand: Amiri; Category: Hat; Color: Black; Style: Retro | Size, material, price, stock, shipping, variant details |
| AMIRI Classic Retro Style Beige Hat | SPU-ZRFAQKKWLM | Brand: Amiri; Category: Hat; Color: Beige; Style: Retro | Size, material, price, stock, shipping, variant details |
| AMIRI letter-style black cap | SPU-HI7J8HRIPD | Brand: Amiri; Category: Baseball cap; Color: Black; Style: Letter style | Size, material, price, stock, shipping, variant details |
| AMIRI letter-style black cap | SPU-86RFOUKHP7 | Brand: Amiri; Category: Baseball cap; Color: Black; Style: Letter style | Same name but different style, size, material, price, stock, shipping, variant details |
| AMIRI letter embroidery black baseball cap | SPU-AIYUHNLNLW | Brand: Amiri; Category: Baseball cap; Color: Black; Decoration: Letter embroidery | Size, material, price, stock, shipping, variant details |
| AMIRI Retro Brown Hat | SPU-NGAN3KKWFG | Brand: Amiri; Category: Hat; Color: Brown; Style: Retro | Size, material, price, stock, shipping, variant details |
| AMIRI Letter Style White Cap | SPU-PW10S1BZMA | Brand: Amiri; Category: Baseball cap; Color: White; Style: Letter style | Size, material, price, stock, shipping, variant details |
The colors, categories, and styles here are only preliminary fields based on product names, not a completed verification of the actual product or specifications. The page does not provide price, stock, shipping, or size evidence, so no purchase recommendation should be made based on this.
Don't Merge Same-Name Styles
In the list, there are two records both named "AMIRI letter-style black cap", but with different SKUs. They should be kept as two candidates, not merged into one product just because the name is the same. Same name only means the text shown on the page is the same, not that the images, variants, or other product attributes are identical.
It is recommended to use SKU as the stable product number, and the product name as a display field. If you later access the individual style image page, add the checked results to the record with the original SKU, rather than creating a new vague row. This prevents mismatching images, specifications, or links for different styles.
Set Up Filterable Fields in Google Sheets
Google Sheets is suitable for the second layer of organization: it cannot replace the original pages in the product catalog, but it can centralize information scattered across the catalog and individual style pages, and quickly filter missing items. At least these columns are recommended:
- Product Number: Record the SKU directly.
- Product Name: Keep the original page text, and add a Chinese note column if necessary.
- Category: Hat, baseball cap, etc.; if the name cannot confirm, fill in "To be verified".
- Color: Fill in only when the name clearly indicates the color, otherwise "To be verified".
- Style or Decoration: For example, retro, letter style, letter embroidery.
- Image Status: Not viewed, Viewed, Needs recheck.
- Specification Completeness: Complete, Partially missing, Not provided.
- Page Recheck Time: Record the date and time of the last check.
- Link Status: Opens, To be rechecked, Invalid; do not mark unverified pages as usable.
- Processing Conclusion: Can continue verification, Missing specs, Link to recheck, Exclude.
- Notes: Record same name different SKU, image differences, or other issues to confirm.
You can first filter by "Processing Conclusion", then narrow by "Color" or "Category". For example, if you want to see all black items, first filter records where the name clearly indicates black; for records where the name does not give a color, do not fill in a color on your own.
Divide Work Between Catalog Page and Table
The Fashionreps catalog is suitable for confirming the product names, SKUs, and number of styles actually listed on the page, and also for proceeding to individual style image or QC pages to view corresponding content. The page also provides an on-site search entry, but current evidence only supports its existence as a navigation entry, not enough to judge search result quality or speed.
Google Sheets is suitable for saving filter conditions, recheck times, and processing conclusions. It can help you find records with duplicate names, missing SKUs, or unfilled link status, and also facilitate multi-person collaboration to supplement fields. However, "verified" in the table only means that you have completed the prescribed recheck, not that you can add price, stock, or size information that the catalog page does not provide.
When combining the two, it is recommended to follow this order: first confirm the product identity on the catalog page, then enter the SKU and name into the table; then recheck images or individual pages one by one, and finally update specification completeness and link status. Do not copy a batch of names into the table first, and then treat similar names as the same style.
Recommended Processing Conclusions
Currently, these 7 records can all be kept as candidates, but their status should not be directly written as "purchase recommended". A more reliable grouping is as follows:
- Can continue verification: SKU and name are recorded, next step is to view the corresponding style page or image.
- Missing specs: The page name can identify some attributes, but size, material, or other purchase fields are not yet confirmed.
- Link to recheck: Need to reopen the corresponding page to confirm whether it leads back to the correct product or style.
- Exclude: Use only when confirmed that the product identity does not match, the page is invalid, or there are duplicates that cannot be distinguished.
Before placing an order, check three things for each record: whether the product name and SKU correspond; whether the images or variants on the page belong to this record; and whether the page still points to the same product after navigation. If any one cannot be confirmed, keep it as "to recheck" or "missing specs", and do not substitute a similar style.
The value of this list is to separate known and unknown information. The current page can support the record of names and SKUs for 7 Amiri hat candidates; price, stock, shipping, size, and material still need to be further verified on the corresponding pages.
Article Image

Continue reading