Step-by-Step Joyagoo Spreadsheet Tutorial
Follow our hands-on tutorial to build your first joyagoo spreadsheet. Learn sorting, formulas, bulk tracking, and order organization in under 30 minutes.
Theory is nice. But nothing beats doing it yourself. This joyagoo spreadsheet tutorial takes you from a blank Google Sheet to a fully functioning order tracker in exactly 30 minutes. Grab your laptop, open Google Sheets, and follow along.
By the end of this tutorial, you will know how to set up columns, build profit formulas, use filters, and color-code your status columns. Your future self will thank you.
What You Will Build Today
We are building a single-sheet order tracker that handles the entire lifecycle of a resale product: from the moment you purchase it to the moment it ships to your customer.
Purchase Tracker
Log every item you buy with price, supplier, and date.
Status Monitor
Know exactly what is purchased, in transit, listed, sold, or shipped.
Profit Calculator
Auto-calculate profit after all fees and shipping.
Step 1: Create Your Column Headers
Open a new Google Sheet. In row 1, type these exact headers across cells A1 to J1:
Order ID | Product Name | Purchase Price | Selling Price | Platform Fees | Shipping | Profit | Status | Date | NotesFormat row 1 in bold, increase font size to 12, and freeze the row so it stays visible as you scroll. Click View > Freeze > 1 row.
Step 2: Build the Profit Formula
Click cell G2 (the Profit column). Type this formula exactly:
=D2-C2-E2-F2This subtracts Purchase Price, Platform Fees, and Shipping from your Selling Price. Drag the fill handle down to apply it to 50 rows. Now every new row you enter will auto-calculate profit.
Pro Tip: If your platform fees are a percentage (like 10%), use =D2*0.1 in the Fees column instead of typing a fixed number. This scales automatically.
Step 3: Add Data Validation for Status
Data validation means you get a dropdown menu instead of free typing. This prevents typos like Shipped vs shippd that break your filters later.
- 1Select the entire Status column (H2:H1000).
- 2Click Data > Data validation.
- 3Under Criteria, choose Dropdown.
- 4Enter these options: Purchased, In Transit, Listed, Sold, Shipped, Returned.
- 5Check "Reject input" so only these values are allowed.
- 6Click Save.
Step 4: Add Conditional Formatting
Conditional formatting automatically changes cell colors based on values. We will set three rules:
Profit > 0
Format: Green background. You made money.
Profit < 0
Format: Red background. You lost money. Fix the price or skip this supplier next time.
Status = Shipped
Format: Gray text. Shipped orders fade so you focus on active ones.
Step 5: Enable Filters and Sort
Select all your data rows. Click Data > Create a filter. Little filter arrows now appear on every column header. Here is why this is a game-changer:
- Filter by Status = In Transit to see only active orders.
- Sort by Profit descending to see your best-margin items first.
- Filter by Date to see this week's activity only.
- Sort by Product Name to group identical items together.
Tutorial Checklist
Before you call your spreadsheet finished, verify every item on this list.
| Task | Status | Why It Matters |
|---|---|---|
| Headers in Row 1 | Required | Organizes every column purpose. |
| Profit formula in G2 | Required | Auto-calculates margins. |
| Data validation on Status | Required | Prevents typos and broken filters. |
| Conditional formatting | Recommended | Visual profit/loss at a glance. |
| Filters enabled | Required | Sort and slice data instantly. |
| Frozen header row | Recommended | Headers stay visible when scrolling. |
Tutorial Complete. What Is Next?
Your spreadsheet is live. Now learn how to automate data imports, connect tools, and scale your workflow beyond manual entry.
Tutorial FAQ
I broke a formula. How do I fix it?
Click the cell, press Delete, then re-type the formula. Or download the template again and copy the formula from the fresh file.
Can I add more columns later?
Yes. Insert columns anywhere. Just make sure the Profit formula references the correct columns if you insert before it.
My profit shows negative but I know it is wrong.
Double-check that all costs (purchase price, fees, shipping) are entered as positive numbers. The formula subtracts them, so entering negative numbers would add them instead.
How do I share this with my business partner?
Click Share in Google Sheets, enter their email, and set permission to Editor or Commenter. Never use Anyone with the link for customer data.