Skip to content

From the blog

Filtering adidas Jackets: Spreadsheet vs Google Sheets

The adidas Fall/Winter Jacket Filtering Problem This Article Solves If your goal is to narrow down a batch of adidas fall/winter outerwear to a few reviewable c...

The adidas Fall/Winter Jacket Filtering Problem This Article Solves

If your goal is to narrow down a batch of adidas fall/winter outerwear to a few reviewable candidates, the most practical division of labor is: first use the fashion-reps website-style product catalog to discover styles, view images, and enter product pages, then use Google Sheets to record filtering reasons, size information, link status, and items to verify. This avoids mistaking browsing impressions for confirmed purchase facts. 🧥

This article targets a specific task: finding adidas fall/winter jackets worth further verification from the website catalog and building a candidate list that can be reviewed later. After completing this, you should be able to:

  • Narrow down the website catalog by brand, price, and sorting criteria
  • Copy candidate styles to Google Sheets
  • Distinguish between information already displayed on the page and information not yet confirmed
  • Record size, color, link, and next verification actions

This method is not suitable for directly confirming real-time inventory, final transaction price, shipping costs, or destination country taxes and fees. Page-visible information can change, and you should still open the product page and shopping agent page for re-verification before actually placing an order. 📌

First Confirm the Catalog and Visible Fields of the fashion-reps Website-Style Spreadsheet

Based on the provided adidas category page snapshot, the page includes brand entry, category navigation, product cards, price filtering, sorting options, and product detail entry points. The page displayed 5 adidas product candidates at the time, with visible fields on the cards including product name, reference price, previous reference price, and QC badge.

Visible candidates include:

  • adidas x Audi F1 Team padded stand-collar jacket with race badge graphics
  • Adidas dice-graphic black collegiate varsity jacket with a reversible padded build
  • Adidas Originals Black Padded Vest with a Water-Repellent Shell
  • Adidas Reversible Padded Jacket: Collegiate Cream Face, Navy Reverse
  • Adidas x Audi Motorsport F1 Padded Jacket in Gray, Cut With an Oversized Drop-Shoulder

These fields are suitable for discovery and initial screening, but they cannot directly prove that the product is still in stock, that the page price is the final payment amount, or that the QC badge means you have completed personal inspection. The page also notes that purchases go through a user-selected shopping agent, and orders, payments, and shipping are handled by the agent's website. Therefore, the website catalog and the shopping agent should be treated as two separate stages.

Examples of visible reference prices on the page include $41.64, $49.70, and $67.16; some cards also show previous reference prices, such as $44.30, $53.48, and $80.59. These prices can only be used as comparison fields in the page snapshot and cannot replace real-time verification on the product page, agent checkout page, or shipping quote.

How to Design Brand, Category, and Status Columns in Google Sheets

The role of Google Sheets is not to replace website browsing, but to turn scattered candidates into sortable and reviewable records. The first row should use fixed fields to avoid writing key information into free text that is hard to filter.

FieldSuggested ContentPurpose
BrandAdidasLater filter by brand
Product NameKeep the website display namePrevent confusion between different styles
CategoryJacket, vest, varsity jacket, etc.Distinguish types of fall/winter outerwear
Fit or FeaturesReversible, stand collar, oversized shoulders, racing graphics, etc.Quickly compare design differences
Page Reference PriceRecord the dollar amount shown on the pagePreserve price basis at time of filtering
Previous Reference PriceFill in only when shown on the pageOnly for observing page comparison fields
Product PagePaste the product detail page URLReturn to original evidence
Image StatusViewed, needs re-view, not openedPrevent judging by title alone
Size StatusSize chart found, to be confirmed, no infoClarify next action
ColorColors explicitly stated on the pageFacilitate filtering outfit options
QC StatusBadge present, no badge, needs openingDo not treat badge as inspection conclusion
Inventory StatusUnverified, page selectable, agent page to confirmAvoid assuming stock availability
Last Verified Datee.g., 2026-10-13Judge whether record is outdated
Next StepOpen size chart, confirm link, ask agent, etc.Make the list actionable

"Category" and "Fit or Features" should be recorded separately. Category answers "what kind of product is it?", while fit or features answers "why is it worth comparing?". For example, the Adidas Originals black padded vest can be categorized as "vest", and its "water-repellent shell" should only be recorded if the page clearly states it, not inferred from images.

Step-by-Step Comparison of Website Browsing, Image Viewing, and Spreadsheet Filtering

The website is suited for visual discovery and page navigation, while Google Sheets is suited for long-term organization. Avoid repeatedly manually copying the same content between the two, as it can lead to inconsistencies in product names, prices, and links.

Recommended order of operations:

  1. On the adidas category page, first confirm the brand and number of products, and record the filter start date.
  2. Use price filtering or sorting to narrow down, but do not automatically equate lower price with better value.
  3. Open candidate product pages one by one to check product name, images, visible description, size information, and QC-related content.
  4. Copy only the fields already seen on the page into Google Sheets.
  5. Fill in "Next Step" for each candidate, such as "Confirm size chart" or "Check if agent page allows purchase".
  6. After the first round, use the spreadsheet's filter to hide eliminated styles and keep only candidates to verify and compare.

Images on the website are good for answering questions about appearance, color scheme, and design direction, but images alone usually cannot prove filling, fabric weight, warmth rating, or actual dimensions. Words like "padded", "water-repellent", or "oversized" in product names should also be treated as page descriptions; do not expand them into quality conclusions unless more detailed specifications or measurements are available.

How to Record Size, Color, Links, and Items to Verify

Size records should preserve original units and page context as much as possible. For example, the spreadsheet can say "Size chart found, unit to be confirmed" instead of directly converting a letter size to a chest measurement conclusion. Different sellers, fits, and measurement methods may vary, especially for oversized or loose styles.

Color should also distinguish between page statements and personal observation:

  • Colors explicitly stated in the page name can be recorded directly
  • Tones seen in images should be recorded only as "image observation, to be confirmed"
  • For reversible items, record both sides' page descriptions
  • Do not judge precise differences between black, dark gray, or navy based on compressed images

For link records, it is recommended to keep at least two types: the product detail page URL and the shopping agent URL used later. If a button redirects based on the user's selected agent, the spreadsheet should record the actual destination after opening, not just the agent name. When links are broken, redirect, or require login, mark the status as "to be rechecked" and do not continue to use old price or stock judgments.

An actionable "Next Step" should be specific to an action, for example:

  • Open the product page to confirm whether a complete size chart is available
  • Check whether the page still displays product images and name
  • Enter the selected shopping agent to confirm whether it can be added to cart
  • Record the product price shown on the agent page, not the category page reference price
  • Confirm whether color options match the color scheme in images
  • Record measurement data for loose fits separately, not mixed with regular fits

Mobile Browsing, Link Copying, and Navigation Boundaries

Mobile is suitable for quickly bookmarking and viewing images, but not for entering a large number of fields at once. With a narrow screen, product names, prices, filter conditions, and links may be scattered in different positions, making it easier to miss old reference prices, colors, or page status during copying.

When browsing on mobile, a two-step "bookmark first, organize later" approach can be used:

  1. Open the website category page and confirm candidate products.
  2. Copy the product page URL to a temporary note or the Google Sheets link column.
  3. Fill in product name and date for each record immediately.
  4. Return to desktop to complete category, size status, image status, and next step.

If filter conditions are lost after navigating back, do not assume the list is still the same result. Re-confirm brand, price range, and sorting method before continuing. If the page has redirected to an agent site, also confirm the address bar and page identity to avoid writing agent page fields into fashion-reps category page fields. 📱

When to Use the Website for Product Discovery vs. the Spreadsheet for In-Depth Organization

When you don't yet know what styles exist, the website catalog has an advantage. It places brand, product cards, images, and product page links in the same browsing path, suitable for quickly building a candidate set.

When candidates exceed two or three, or when you need to compare sizes, colors, and verification status across multiple sellers, Google Sheets is more suitable. It can filter by price, category, status, and date, and it also helps retain eliminated records and reasons for elimination.

Current TaskBetter with Website CatalogBetter with Google Sheets
Discover adidas fall/winter outerwearBrowse brand category and product cardsSave discovery date and source page
Compare page display pricesView reference and previous pricesSort by price and mark unverified
View appearance and color schemeOpen product images and detail pagesRecord image status and color notes
Check sizeGo to specific product page for size infoSave size status and measurement to-dos
Track link changesReopen page to confirm validityRecord link status and last verified date
Collaborative organizingSuitable for single-person browsing discoverySuitable for filtering, comments, and task division

Do not design the website catalog and Google Sheets as two competing product libraries. The website preserves the original discovery path, and the spreadsheet preserves your judgment process; if the page updates, old records in the spreadsheet should still retain verification dates to help determine which fields need re-confirmation.

Do Not Infer Inventory, Price, or Update Time Without Evidence

The following conclusions cannot be drawn from the category page snapshot alone:

  • The product is definitely in stock now
  • The page reference price is the checkout price
  • The previous reference price represents actual historical transaction price
  • The QC badge means you have seen complete inspection photos
  • Thickness, hand feel, warmth, or water resistance in images have been verified
  • The product page update time is the inventory update time
  • The shopping agent definitely supports this product, color, or size
  • Shipping, taxes, and after-sales conditions are included in the reference price

The correct approach is to mark these fields as "unverified" and write the next step. Issues involving orders, payments, warehouse inspection, consolidation, logistics, and customs should be confirmed on the actual shopping agent page and applicable destination country rules. The role of the fashion-reps category page is to help discover products and enter the subsequent process, not to replace the agent's order or logistics sy

Continue reading

More from this site