RizzitGo: How to Manage Multi-Seller Orders with the RizzitGo Spreadsheet
Streamline your multi-sourcing operations by consolidating data into one powerful, structured document.
Juggling orders from multiple sellers across platforms like Amazon, eBay, or AliExpress can quickly become a logistical nightmare. Disparate invoices, scattered tracking numbers, and manual cost calculations eat up valuable time and increase the risk of errors. The RizzitGo Spreadsheet
The Core Concept: Centralization is Key
Instead of navigating dozens of emails, platform dashboards, and spreadsheets, the RizzitGo approach brings everything together. Think of it as your master command centersimplified cost calculationunified shipment tracking.
Structuring Your RizzitGo Spreadsheet
A well-designed structure is crucial. Below is the recommended column layout to capture all essential information.
| Column Section | Column Name | Purpose |
|---|---|---|
| Order Info | Order Date | Date purchase was made. |
| Seller Name/Platform | Identifies the source (e.g., "TechSeller_Amazon"). | |
| Order ID | Unique identifier from the seller's platform. | |
| Item Details | Product Description | Brief name or SKU of the purchased item. |
| Quantity | Number of units ordered. | |
| Item Cost | Price per unit in local currency. | |
| Shipping Cost (to Forwarder) | Domestic shipping fee paid to the seller. | |
| Cost Calculation | Tax/Fees | Any additional charges like sales tax. |
| Total Order Cost | Formula: (Item Cost * Qty) + Shipping + Tax | |
| Consolidated Cost | Allocated international shipping & handling from your forwarder. | |
| Logistics & Tracking | Carrier & Tracking # (Domestic) | Tracking for the parcel to your forwarder's warehouse. |
| Forwarder Receipt Date | Date the forwarder confirms receipt of the item. | |
| International Tracking # | Master tracking number for the consolidated shipment. | |
| Status | Status | Dropdown: Ordered, Shipped, Received at Warehouse, In Transit, Delivered. |
How to Implement & Use the Spreadsheet
Step 1: Template Creation
Create a new spreadsheet (Google Sheets or Excel) with the columns above. Freeze the header row and use data validation for the Status
Step 2: Data Entry Protocol
As soon as you place an order with any seller, immediately create a new row in the RizzitGo sheet. Input all known data: seller, item details, costs, and the domestic tracking number once provided.
Step 3: Automate Calculations
Use a formula in the Total Order Cost= (C2*D2) + E2 + F2. This gives you a real-time view of total spending.
Step 4: Tracking & Consolidation
Update the sheet as parcels move. When your forwarder consolidates packages into one international shipment, add the master International Tracking #
Step 5: Review & Analysis
Use filter views to see all orders from a specific seller or all items in transit. The sheet now provides a single source of truth for your total landed cost per item and the status of every purchase.
Key Benefits of the RizzitGo Method
- Time Efficiency:
- Cost Transparency:
- Proactive Tracking:
- Informed Decision-Making:
- Collaboration Friendly:
- Cost Transparency: