Streamline your group buys and complex hauls by centralizing tracking in one powerful tool.
Ordering from multiple sellers on platforms like Taobao, Weidian, or 1688 can quickly become a logistical nightmare. Tracking individual orders, shipping costs, QC (Quality Check) photos, and final consolidation details separately is inefficient and prone to error. The PinguBuy Spreadsheet
Create a new spreadsheet (Google Sheets or Excel) with the following column headers. This forms the backbone of your tracking system:
| Seller Name | Item Name/Description | Item Link (URL) | Size/Color | Price (¥) | Domestic Shipping (¥) | Purchase Status | Warehouse Arrival Date | QC Photo Link | QC Status (Approve/RL) | Notes (Agent SKU #, etc.) |
|---|---|---|---|---|---|---|---|---|---|---|
| Each row will represent one unique item from a seller. | ||||||||||
As you browse and decide on items, immediately add a new row for each. Copy the exact product link, note the price, and record the seller name. Pro Tip:before
Once you've submitted an order through your agent, update the "Purchase Status""Warehouse Arrival Date". This creates a clear visual timeline for your haul.
Most agents provide a link to QC photos. Paste this link into the "QC Photo Link""QC Status"
Use spreadsheet formulas to automatically calculate subtotals per seller and a Grand Total
Filter by "Seller Name" to see all items from one source, or filter by "QC Status" to quickly see which items are pending your review.
Use conditional formatting or manual coloring. For example, highlight rows in yellow for pending QC, green for approved, and red for rejected items.
Paste the unique warehouse identification number (SKU) from your agent into the "Notes" or a dedicated column. This makes identifying items in the warehouse foolproof.
For group buys (Pingus), share the spreadsheet with editing permissions. Each member can add their own rows and mark their QC status, keeping the entire haul organized in one place.
