Step 1: Set Up Your Master Spreadsheet
Create a new Google Sheets or Excel file. Name it something like "CSSBuy Haul Dashboard - [Date]".
CSSBuy: Merging QC and Shipping Data for a Complete Haul Dashboard
2026-02-09
Streamline your CSSBuy experience by combining your Quality Control (QC) photos and shipping logistics into one powerful, unified view. This guide walks you through the process of merging both datasets in your spreadsheet.
Why Merge Your Data?
Keeping QC and shipping information separate leads to constant tab switching and mental tracking. A single dashboard provides:
- End-to-End Tracking:
- Informed Decision Making:
- Efficiency:
- Cost & Weight Overview:
- Informed Decision Making:
Before You Start: Gather Your Data
You will need two primary data sources from your CSSBuy account:
- QC Photo Dataset:Order Number, Item Name, QC Photo Link, Price (¥), Warehouse Status (Received/Stored).
- Shipping Parcel Dataset:Parcel ID, Tracking Number, Shipping Line, Weight, Cost (¥), Status (Submitted/Shipped/Delivered).
Tip: Export these from your CSSBuy 'My Orders' and 'My Parcels' pages or copy them directly from the web interface.
Step-by-Step: Creating Your Unified Dashboard
Step 2: Import or Paste Your QC Data
In the first sheet, paste your complete QC item list. This forms the core of your dashboard. Ensure each item has a unique Order ID. Add a column titled Parcel ID
| Order ID | Item Name | QC Photo Link | Price (¥) | Status | Parcel ID
Step 3: Add Shipping Data with VLOOKUP or XLOOKUP
On a second sheet, paste your Parcel data. Then, return to your main sheet. In the Parcel IDYou must know which items are packed in which parcel.
For example, in cell F2 (under Parcel ID), you could use:
=IFERROR(VLOOKUP(A2, 'ParcelList'!$A$2:$B$10, 2, FALSE), "NOT SHIPPED")
This formula looks for the Order ID (A2) in a range on the 'ParcelList' sheet and returns the corresponding Parcel ID.
Step 4: Enrich with Shipping Details
Now, add new columns next to your item data: Tracking Number, Shipping Line, Parcel Weight, Shipping Cost, Parcel Status.VLOOKUPXLOOKUPParcel ID
| ... | Parcel ID | Tracking Number | Shipping Line | Parcel Weight | ... |
|-----|-----------|------------------|---------------|---------------|-----|
| ... | CSS-12345 | RB123456789CN | SAL | 3.2 kg | ... |
Step 5: Calculate and Format Your Dashboard
Add summary calculations at the top:
- Total Haul Cost:=SUM(Item Price Column) + SUM(Shipping Cost Column)
- Total Weight:=SUM(Parcel Weight Column)
- Cost per Kg:
Use conditional formatting to highlight rows: Blue for shipped, green for delivered, orange for not shipped.
Pro Tips & Best Practices
- Use IMPORTRANGE (Google Sheets):
- Hyperlink QC Photos:=HYPERLINK()
- Freeze the Top Row:
- Update Regularly:
- Hyperlink QC Photos:=HYPERLINK()