For savvy online shoppers and resellers using Sugargoo, the built-in spreadsheet is more than just an order list—it's the command center for your entire purchasing operation. While the default view works, its true power unlocks when you tailor it to match your personal workflow. Whether you're tracking personal hauls or managing complex accounting, learn how to transform your Sugargoo spreadsheet into a personalized dashboard.
Why Customize Your Spreadsheet?
A generic list can become chaotic with multiple orders. Customization allows you to:
- Visualize Status Instantly:
- Filter and Find in Seconds:
- Streamline Accounting:
- Reduce Errors:
- Filter and Find in Seconds:
Core Customization Features
Sugargoo's spreadsheet functionality lets you manipulate columns and data in several key ways.
1. Applying Smart Filters
Filters let you display only the rows that meet specific criteria, hiding irrelevant data.
How to Use:
- Locate the filter icon
- Click it to reveal a dropdown menu of values present in that column.
- Select or deselect values to display. For example, filter the "Status""To Pay""Purchased"
- Combine filters across multiple columns for a granular view, like all "Jackets""Warehouse A""To Be Shipped."
Workflow Tip:
2. Utilizing Tags & Custom Columns
Tags are keywords you add, often in a custom column, to categorize items beyond default fields.
How to Use:
- Add a Custom Column:"Season,""Brand,""Priority,""Cost Center").
- Assign Tags:Winter24, Gift, HighPriority, or BusinessExpense.
- You can then filter or sort
Accounting Style Tip:"Estimated Domestic Shipping,""Platform Fees,""Selling Price"
3. Implementing Color Codes
Color coding (or conditional formatting) is the most powerful visual tool. It automatically applies cell or row colors based on rules you set.
How to Use (Conceptual Guide):
- Look for a "Color Code", "Conditional Formatting,"
- Create a Rule:
- Condition:If 'Status' equals "To Pay"
- Action:Highlight row in RED
- Add Multiple Rules:
- GREENStatus = "Shipped"
- YELLOWStatus = "Warehouse"
- BLUETag = "Gift"
- Create a Rule:
Buyer's Style Tip:
Putting It All Together: A Sample Workflow
Imagine you're a reseller. Here’s how your customized Sugargoo sheet might look:
Your Customized Reseller Dashboard
- Columns Added:
- Tags Used:ToPhotograph, Listed, Sold.
- Filters Saved:
- Color Codes:
- Red Fill: Profit margin below target.
- Green Fill: Item has been sold.