FishGoo: How to Document QC Photos in the FishGoo Spreadsheet
A Standard Operating Procedure for Visual Quality Verification
Effective documentation of Quality Control (QC) photos is essential for maintaining trust and transparency in the supply chain. This guide outlines the standardized process for saving every inspection photo and its corresponding date in the FishGoo Spreadsheet to verify item quality before shipment.
Step-by-Step Procedure
Step 1: Photo Capture During Inspection
- Use a dedicated QC camera or smartphoneenabled.
- Capture clear, well-lit photos of the item from key angles: front, back, sides, top, and any specific detail points (e.g., logos, seams, labels, potential defects).
- Include a QC reference card
Step 2: File Organization & Naming
- Transfer all photos from the camera to the designated "QC_Photos"
- Rename each photo file using this naming convention:
[ItemNumber]_[PO#]_[Date(yyyy-mm-dd)]_[Sequence#].jpg
Example: FG203A_PO88921_2023-10-26_01.jpg - Rename each photo file using this naming convention:
Step 3: Entry in the FishGoo Master Spreadsheet
Open the "FishGoo_QC_Log.xlsx"
Item Code
PO Number
Inspection Date
QC Photo File Name
Inspector Initials
Quality Status
FG203A
PO88921
2023-10-26
FG203A_PO88921_2023-10-26_01.jpg
AL
Approved
FG203A
PO88921
2023-10-26
FG203A_PO88921_2023-10-26_02.jpg (detail: seam)
AL
Approved
Step 4: Hyperlinking & Verification
- In the spreadsheet's "QC Photo File Name"hyperlink
- Double-check that every listed photo
- Fill in all other columns completely (Inspector, Status, any notes).
- Double-check that every listed photo
Step 5: Final Pre-Shipment Review
Before authorizing shipment:
- The QC manager reviews the worksheet for the PO.
- Confirms that photos for all inspection points
- Verifies that the visual evidence supports the "Approved" status.
- Adds a final review comment and locks the worksheet for that shipment batch.
Best Practices & Tips
Consistency is Key
Use the same camera settings and lighting setup for all inspections to maintain photo consistency.
Immediate Documentation
Upload and log photos on the same day as the inspection. Avoid backlog to prevent errors.
Structured Storage
Use sub-folders by month (e.g., QC_Photos/2023-10/) to keep the main folder manageable.
Defect Documentation
For rejected items, take even more detailed photos. Create a separate "Rejects" sub-folder and log them in a dedicated worksheet tab.