FishGoo: How to Document QC Photos in the FishGoo Spreadsheet
A step-by-step guide to save every inspection photo and date to verify item quality before shipment.
Proper documentation of Quality Control (QC) photos is crucial for maintaining transparency and ensuring product standards. The FishGoo Spreadsheet system provides a structured way to archive visual evidence, creating a reliable audit trail for every shipment.
Step-by-Step Process
Step 1: Capture Consistent QC Photos
Take clear, well-lit photographs of each item or batch from multiple angles. Key shots include:
- Overall product view
- Close-ups of labels, logos, or specific features
- Areas with potential defects or requiring special verification
- Packing materials and method
Step 2: Organize Files with a Clear Naming Convention
Rename each photo file immediately after capture. Use this format:
PO#_ItemCode_Description_Date_Sequence.jpg
Example: PO12345_XYZ789_WidgetBlue_20231027_01.jpg
Step 3: Upload to Designated Cloud Storage
Transfer all photos from the camera or device to the shared FishGoo project folder (e.g., Google Drive, Dropbox). Ensure the folder structure mirrors the Purchase Order numbers for easy retrieval.
Step 4: Log Entries in the FishGoo Master Spreadsheet
Open the shared FishGoo QC Master Spreadsheet. For each inspected item, create a new row and fill in the following columns:
| Column Header | Data to Enter |
|---|---|
| A: Purchase Order # | The unique PO identifier. |
| B: Item SKU / Code | The product's specific code. |
| C: Inspection Date | Date of QC (use DD/MM/YYYY format). |
| D: QC Photo Link | Most Important: |
| E: Inspector Initials | Your identifier. |
| F: Pass/Fail Status | Mark as "PASS" or note specific defects. |
| G: Notes | Any relevant comments about quality or the photos. |
Step 5: Verify and Lock the Record
Double-check that all links are functional and data is accurate. Once the row is complete and before shipment is authorized, protect the row or mark it as "QC FINALIZED" to prevent unauthorized edits.
Best Practices for Success
- Be Immediate:
- Be Thorough:
- Be Consistent:
- Verify Links:
- Be Thorough: