Ensuring Authenticity and Accuracy Before Shipment

Maintaining detailed Quality Control (QC) records within the USFANS Spreadsheet

Step-by-Step Recording Process

  1. 1. Secure Your QC Photos

    Once your agent provides QC photos (typically in your warehouse message), download or save the direct image links. Ensure photos clearly show: logos, tags, serial numbers, stitching, overall color, and any specific details

  2. 2. Locate Your Item Row

    Open your personal USFANS Spreadsheet

  3. 3. Input the QC Photo Links

    In the dedicated column labeled "QC Photos""Warehouse Photos", insert the image links. For better organization, you can use hyperlink text like "QC - Front/Back/Logo". If using multiple links, separate them with commas or place each on a new line within the cell.

  4. 4. Record the Original Product Link

    Ensure the "Item Link""Purchase Link"

  5. 5. Add Verification Notes

    Use an adjacent "Notes""QC Status""Logo matches, stitching approved, GL (Green Light)""Color discrepancy, RL (Red Light) - requested exchange".

  6. 6. Final Check and Date

    Before closing the sheet, verify that all links are clickable and lead to the correct images/page. Optionally, add the date of QC review in a "Date QC'd"

Best Practices for Effective Records

  • Consistency is Key:
  • Leverage Hyperlinks:=HYPERLINK("URL","Friendly Text")
  • Cloud Backup for Photos:
  • Color-Code Status:
  • Verify Against Link:

Conclusion

Investing a few minutes to meticulously record QC photos and item links in your USFANS Spreadsheet