Managing orders from multiple sellers across various Chinese e-commerce platforms can be a logistical challenge. The EastMallBuy Spreadsheet Method
When ordering from sellers on platforms like Taobao, 1688, or Tmall, information becomes fragmented. You have links in your browser history, QC photos in chat apps, and tracking numbers in your email. This disorganization leads to errors, missed shipments, and confusion. A unified spreadsheet acts as a single source of truth for your entire EastMallBuy operation. Create a new spreadsheet with the following core columns. This structure ensures every critical piece of information is captured. By adopting the EastMallBuy Spreadsheet method, you gain:Why a Centralized Spreadsheet is Essential
Setting Up Your EastMallBuy Master Spreadsheet
Column Header
Purpose & Data to Include
Store Name/Link
The seller's shop name and hyperlink. This is your primary reference point.
Product Link & Description
The exact URL for the product item, plus a brief description (size, color, SKU).
Quantity & Unit Price
Number of items ordered and the price per unit in CNY.
Order Date & Status
Date placed and current status (e.g., Ordered, Shipped, Arrived at Warehouse).
QC Photos & Notes
Links to or embedded images of QC checks from your agent. Add notes on approvals or issues.
Domestic Tracking #
The tracking number for the parcel's journey within China to the consolidation warehouse.
Warehouse Arrival Date
Date the item was checked into the warehouse. Crucial for planning consolidation.
Consolidated Shipment ID
Tracking number for the final international parcel containing multiple items.
Final Destination Tracking
The tracking number for your local postal/courier service after international dispatch.
Best Practices for Management
The Workflow in Action
Benefits of This System
EastMallBuy: How to Manage Multi-Seller Orders with the EastMallBuy Spreadsheet
2025-12-04