Home > Sugargoo: Analyzing Product Quality Data with the Spreadsheet Tool

Sugargoo: Analyzing Product Quality Data with the Spreadsheet Tool

2026-04-06

Making informed purchasing decisions is crucial when shopping for replica products. Beyond individual Quality Control (QC) photos, the Sugargoo Spreadsheet

Why the Spreadsheet is a Game-Changer for Quality Analysis

While a single QC post shows one item at one point in time, the aggregated data in your spreadsheet tells a broader story. It transforms isolated data points into actionable intelligence, helping you answer critical questions:

  • Which suppliers consistently produce high-quality items for a specific product category (e.g., Jordan 1s, designer bags)?
  • Are there noticeable fluctuations in a supplier's quality over different batches?
  • What is the general success rate and common flaw trends for the product type I'm interested in?

This macro view allows you to identify reliable suppliers and spot potential red flags

Step-by-Step Guide: Filtering QC Data for Insights

Here’s how to leverage the Sugargoo Spreadsheet to perform your own quality audit.

Step 1: Structure Your Spreadsheet for Tracking

Ensure your spreadsheet includes key columns for analysis. Essential columns are:

Column Name Purpose for Analysis
Product Name/Link Identifies the item type and style.
Supplier/Store The core data point for supplier-based filtering.
Price (¥) Correlates price with quality outcomes.
QC Results (GL/RL) The primary quality metric (Green Light = acceptable, Red Light = rejected).
QC Notes/Common Flaws Records specific issues like "color too dark," "sloppy stitching," etc.

Step 2: Filter by Product Type or Category

To analyze trends for a specific item:

  1. Use the Filter
  2. Select only the rows for, say, "Dunk Low" or "LV Wallet".
  3. Observe the aggregated GL/RL ratio
  4. Scan the "QC Notes" within this filter to identify recurring flaws

This tells you the general risk level and what to look for in QC photos for that particular item.

Step 3: Filter by Supplier or Store

This is the most powerful method for finding the best sources.

  1. Apply a filter to the "Supplier/Store"
  2. Choose one supplier (e.g., "CSJ").
  3. Analyze their dedicated data:
    • Calculate their overall GL Rate.
    • Check if their quality is consistent for the specific product type you want. A supplier great for sneakers might be poor for jackets.
    • Read their QC notes. Do they have consistent flaws (e.g., always wrong sizing), or are flaws random?
  4. Repeat this process for different suppliers selling the same item to compare their performance head-to-head.

Step 4: Identify Long-Term Trends

Add a "Purchase Date" column to your spreadsheet. By sorting data chronologically for a specific supplier or product, you can see:

  • Quality Improvement or Decline:
  • Batch Consistency:

This historical view prevents you from relying on outdated positive reviews if recent data shows a decline.

Making Your Informed Choice

After your analysis, your decision matrix becomes clear:

  • Prioritize suppliersexact product type
  • Balance price with data.
  • Know the common flaws

By treating your Sugargoo Spreadsheet