Learn how to merge quality control inspections, warehouse activities, and shipping confirmations into a single, powerful dashboard view.
Managing overseas purchases often means juggling multiple data points: QC photoscheck datesshipping confirmations
The Hoobuy Spreadsheet
Ensure your Hoobuy account is linked to your sourcing platforms and warehouse feeds. The spreadsheet automatically pulls data from:
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. |
Use the dashboard's filter tools to view exactly what you need:
From the spreadsheet, you can often trigger actions directly, such as approving QC results or requesting shipping labels for filtered batches.
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.
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.
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.
