Learn how to merge quality control inspections, warehouse activities, and shipping confirmations into a single, powerful dashboard view.
The Challenge of Disconnected Data
Managing overseas purchases often means juggling multiple data points: QC photoscheck datesshipping confirmations
The Hoobuy Spreadsheet
Key Benefits of the Merged Spreadsheet Dashboard
- Single Source of Truth:
- Enhanced Visibility:
- Faster Decision-Making:
- Reduced Errors:
- Enhanced Visibility:
How to Merge and View Data in Hoobuy Spreadsheet
Step 1: Data Source Integration
Ensure your Hoobuy account is linked to your sourcing platforms and warehouse feeds. The spreadsheet automatically pulls data from:
- QC Modules:
- Warehouse Management System (WMS):
- Shipping Gateways:
- Warehouse Management System (WMS):
Step 2: Understanding the Unified Dashboard Columns
Your master spreadsheet will display critical columns merged from the different systems:
| Spreadsheet Column | Data Source | What It Shows You |
|---|---|---|
| QC Photo Result | QC Module | Thumbnail previews and links to full-resolution inspection photos. Look for "Approved", "Rejected", or "Pending" tags. |
| Warehouse Check Date | WMS | The exact date and time the item was received, checked for quantity, and made ready for shipment. |
| Shipping Confirmation & Tracking | Shipping Gateway | Carrier name, tracking number (as a clickable link), and the date the item was handed to the carrier. |
| Item Status | Calculated Field | A holistic status like QC Pending, At Warehouse, or Shipped, based on the merged data. |
Step 3: Filtering and Actioning Your Data
Use the dashboard's filter tools to view exactly what you need:
- Filter by "QC Result":
- Filter by "Warehouse Check Date":
- Filter by "Shipping Confirmation" (Blank):
- Filter by "Warehouse Check Date":
From the spreadsheet, you can often trigger actions directly, such as approving QC results or requesting shipping labels for filtered batches.
Pro Tips for Maximum Efficiency
Use Color Coding
Configure conditional formatting to automatically color-code rows based on the "Item Status" column. Red for QC failed, yellow for in warehouse, green for shipped. Get a visual overview at a glance.
Schedule Data Refresh
Set your Hoobuy Spreadsheet to auto-refresh every few hours. This ensures your dashboard always displays the latest QC photos, warehouse logs, and tracking updates without manual intervention.
Export Views for Teams
Share specific filtered views with different team members. Your QC manager gets a view of pending inspections, while your logistics manager sees only the shipped orders dashboard.