Streamline your sourcing and purchasing process from Chinese e-commerce platforms with a powerful, centralized organizational tool.
The Challenge of Managing Multiple Orders
When sourcing products directly from platforms like 1688, Taobao, or Tmall, orders and their associated details quickly become fragmented. Key information gets buried in chat history, different album folders, or scattered notes, leading to confusion, delays, and potential cost overruns.
The EastMallBuy Spreadsheet
Core Benefits: All Critical Data, One Place
The primary strength of the EastMallBuy Spreadsheet is consolidation. It is designed to keep every order organized by tracking three essential elements in one unified view:
- Product Links:
- QC Photos:
- Shipping Costs:
- QC Photos:
How to Structure Your Spreadsheet for Maximum Efficiency
A well-organized spreadsheet is key to its usefulness. Here’s a recommended column structure:
| Column | Purpose | Example Entry |
|---|---|---|
| Order ID / Item # | Unique identifier for each product or order line. | EMB-2023-045 |
| Product Description | Brief name, specifications, and color/size variants. | Men's Casual Blazer - Navy - Size L |
| Product Link | Hyperlink to the exact product source. | https://item.taobao.com/example... |
| Quantity & Unit Price (¥) | Order quantity and the negotiated price per unit. | 50 x ¥85.00 |
| QC Photo Status/Link | Status ("Pending", "Approved", "Rejected") or link to album. | Google Drive Link to Photos |
| Domestic Shipping (¥) | Cost to ship from supplier to the agent's warehouse. | ¥25.00 |
| International Shipping ($) | Calculated cost for the final leg of shipping. | $145.50 |
| Total Landed Cost | Automated calculation: (Unit Cost * Qty) + All Shipping. | $450.25 |
| Status | Overall progress (e.g., Ordered, QC, Shipped, Delivered). | In Transit |
Best Practices for Ongoing Management
Pro Tips:
- Update in Real-Time:
- Use Filters and Sorting:
- Maintain a "Notes" Column:
- Color-Code Rows:
- Share with Partners:
- Use Filters and Sorting: