Master Your Purchases: How to Manage Yearly Order Summaries with the Sugargoo Spreadsheet
Staying organized is key to a smooth and successful haul-building experience. With multiple orders, quality checks, and shipments throughout the year, details can easily become scattered. This is where the Sugargoo Spreadsheet
Keeping a dedicated log for your yearly orders transforms how you track and analyze your spending and shipments. The primary benefits include: Create a new spreadsheet in your preferred tool (like Google Sheets or Microsoft Excel) with the following dedicated columns. This structure is your foundation for clarity. Make your spreadsheet a living document by updating it at each stage of the process: The Sugargoo Spreadsheet method is more than just record-keeping; it's about gaining insight and efficiency. By dedicating a few minutes to log each order, you build a comprehensive, personalized database. This empowers you to make smarter buying decisions, accurately forecast shipping costs, and ultimately, enjoy a more streamlined and stress-free shopping experience with Sugargoo throughout the entire year. Start your spreadsheet today and transform how you manage your hauls!Why Use a Centralized Spreadsheet?
Setting Up Your Sugargoo Master Spreadsheet
Column Header
Purpose & Data to Log
Order Date
The date you placed the order on Sugargoo.
Sugargoo Order #
The unique order number from your Sugargoo "My Orders" page.
Item / Product Name
A brief description (e.g., "Nike Dunk Low Grey Fog").
Original Link
Paste the URL of the product page. This is crucial for re-orders or issues.
Item Price (¥)
The cost of the item in Chinese Yuan.
Domestic Shipping (¥)
Any fee paid for shipping within China to the Sugargoo warehouse.
QC Status & Link
Note "Approved," "Exchanged," or "Returned." Paste the link to your QC photos.
Warehouse Storage Weight (g)
The item's weight as shown in your Sugargoo warehouse.
Parcel # (If Shipped)
The shipment number once you submit a parcel for international delivery.
International Shipping Cost (¥)
The final cost to ship the parcel to your country.
Total Item Cost (¥)
A calculated column: Item Price + Domestic Shipping.
Notes
Seller name, size, color, or any special reminders for that order.
The Efficient Logging Workflow
Pro-Tips for Power Users
Take Control of Your Haul Journey