Step 1: Locate the Correct Order Row
Open the LitBuy master spreadsheet and find the row corresponding to the specific Order ID. Use the filter or search function to ensure accuracy.
LitBuy: Recording QC Photos and Order IDs in the Spreadsheet
2026-02-28
Accurate documentation is crucial for verifying the correct processing of every order. This guide details the steps for recording Quality Control (QC) photos, inspection results, weights, and essential item details in the LitBuy master spreadsheet to maintain a clear and reliable audit trail.
Purpose and Importance
Consistently logging this information serves three key purposes:
- Proof of Accurate Processing:
- Quality Assurance Tracking:
- Dispute Resolution:
- Quality Assurance Tracking:
Step-by-Step Recording Procedure
Step 2: Document the Order ID and Key Details
In the designated columns, verify and enter the following core information:
- Order ID:
- Item SKU/Description:
- Quantity:
- Item SKU/Description:
Step 3: Record Inspection Results & Weight
Update the QC-specific columns:
- QC Result:
- Defect Notes (if any):
- Weight (grams/kg):
- Defect Notes (if any):
Step 4: Link or Attach QC Photos
This is a critical step for visual proof.
- Photo Naming Convention:[OrderID]_[ItemSKU]_[Sequence#].jpgLB2024_9876_X1A_01.jpg).
- Spreadsheet Entry:
- Preferred Method (Hyperlink):
- Alternate Method (Comment):
- Preferred Method (Hyperlink):
Ensure photos clearly show the item, any defects, the shipping label, and any relevant serial numbers.
Step 5: Final Verification and Save
Before closing the row:
- Double-check that all entered data matches the physical order and photos.
- Ensure the Order ID
- Save the spreadsheet promptly to ensure data synchronization.
Best Practices and Notes
- Immediate Recording:
- Consistency is Key:
- Clarity Over Speed:
- No Empty Cells:
- Backup Photos:
- Consistency is Key: