For e-commerce sellers using BaseTao
Consolidating all orders into one list misses critical regional distinctions. Implementing a multi-tab structure offers immediate advantages:
Start with your standard BaseTao order export. Ensure it includes essential columns: Product Link, Description, Quantity, Price (CNY), Size/Color, Domestic Shipping, Seller Notes, and your chosen Final Destination
Base Columns: [Item #, Product Link, Description, Options, Quantity, Unit Price, Domestic Shipping, Seller, Notes, Destination Region]
Duplicate your master sheet or create new sheets within the same workbook. Name them clearly: "EU Orders," "US Orders," "Asia Orders."
Filter or sort your master list by the Destination Region"EU Orders"
This is where customization unlocks true planning power. Add new columns to each regional tab relevant to its logistics:
| Region Tab | Recommended Additional Columns | Purpose |
|---|---|---|
| EU Orders | IOSS Number, Estimated VAT (€), HS Code, Carrier (e.g., DDP Line) | Manage VAT compliance, preferential duty rates, and DDP (Delivered Duty Paid) shipping. |
| US Orders | Estimated Duties (US$), HTS Code, Carrier (e.g., UPS/FedEx), De Minimis Check | Plan for potential duties (if value exceeds $800), and choose cost-effective express or postal options. |
| Asia Orders | Local Carrier, Estimated In-Region Tax, Delivery Timeframe | Leverage faster, cheaper intra-Asia shipping networks and account for local taxes like GST. |
For every new batch of orders from BaseTao, follow this workflow: 1) Export to your Master tab, 2) Assign a Destination Region
Customizing your BaseTao spreadsheet into a multi-region dashboard
Pro Tip: