Step-by-Step Sugargoo Spreadsheet Guide: From Zero to Pro

Published: May 28, 2026 | Reading time: 10 min

Understanding the Spreadsheet Layout

Our sugargoo spreadsheet is organized into clear sections. Each column serves a specific purpose. Understanding the layout is the first step to efficient tracking.

Step 1: Setting Up Your First Haul

A "haul" is a collection of items you buy together. Most buyers group 5-15 items into a single haul to save on shipping. Here is how to set up your first haul in the sugargoo spreadsheet:

1. Create a new tab named "Haul May 2026" for organization.
2. Copy the header row from the template into your new tab.
3. Enter your first item. The formulas auto-populate the shipping and total columns.
4. Continue adding items until your haul is complete.
5. Review the summary box at the top. It shows total items, total cost, and estimated weight.

Step 2: Managing Warehouse Status

Once your items arrive at the agent warehouse, the real tracking begins. The sugargoo spreadsheet has built-in status stages that match every agent platform:

• Purchased: Agent has ordered the item from the seller.
• Arrived at Warehouse: Item is in your agent storage. QC photos should be available.
• Submitted for Shipping: You have requested international delivery.
• Shipped: Item is in transit to your country.
• Customs: Package is clearing customs. This usually takes 1-3 days.
• Delivered: Package arrived at your address.

Step 3: Calculating True Costs

The most powerful feature of our sugargoo spreadsheet is the true cost calculator. Many beginners underestimate total spending because they only look at the item price. The spreadsheet adds:

• Item price (CNY)
• Domestic shipping (if any)
• Agent service fees (usually 3-10%)
• International shipping (based on weight and line)
• Currency conversion fees (if paying by card)

The result is your True Cost — the actual amount you spend per item. This helps you compare prices and decide if a deal is actually worth it.

Step 4: Using the Summary Dashboard

The top section of your sugargoo spreadsheet contains a live dashboard. It updates automatically as you enter data. Here is what it shows: