# Etsy Shop Manager

## Dashboard
A quick‑glance hub that pulls together key metrics and links to the core pages.

| Metric | Today | This Week | This Month |
|--------|-------|-----------|------------|
| Orders Received | 3 | 17 | 68 |
| Revenue (USD) | $210 | $1,420 | $5,860 |
| Items Sold | 5 | 22 | 89 |
| Pending Shipments | 2 | 8 | 28 |
| Restock Alerts | 1 | 3 | 5 |

> 💡 Tip: Pin this Dashboard to your Notion sidebar for instant access every time you open the workspace.

## Orders Database
Track every order from purchase to delivery. Use the **Status** select to move items through the workflow.

| Order # | Buyer | Item(s) | Order Date | Shipping Method | Status | Tracking # | Revenue |
|---------|-------|---------|------------|-----------------|--------|------------|---------|
| 1024 | alice@example.com | Lavender Soap (2), Beeswax Candle (1) | 2024‑06-20 | USPS Priority | ✅ Shipped | 9405US123456 | $48 |
| 1025 | bob@example.com | Hand‑Stitched Tote | 2024‑06-21 | Canada Post | 📦 Ready to Ship | — | $32 |
| 1026 | carol@example.com | Custom Portrait (1) | 2024‑06-22 | FedEx International | 🛒 Paid | — | $120 |

> 💡 Tip: Add a **Formula** property `Days Since Order = dateBetween(now(), prop("Order Date"), "days")` to flag overdue orders (e.g., filter where >7).

## Inventory Tracker
Maintain stock levels, cost, and supplier info for each SKU.

| SKU | Product Name | Category | Stock Qty | Cost per Unit | Retail Price | Supplier | Restock Threshold |
|-----|--------------|----------|-----------|---------------|--------------|----------|--------------------|
| LAV‑SOAP‑01 | Lavender Soap | Bath & Body | 48 | $2.00 | $8.00 | SoapCo Ltd. | 12 |
| BEE‑CANDLE‑02 | Beeswax Candle | Home Décor | 15 | $4.50 | $15.00 | CandleWorks | 5 |
| TOTE‑STITCH‑03 | Hand‑Stitched Tote | Accessories | 7 | $12.00 | $32.00 | ArtisanSupply | 3 |

> 💡 Tip: Create a **Rollup** in the Orders DB that sums “Quantity” per SKU to automatically deduct sold items from this table.

## Financial Overview
A simple profit & loss snapshot that updates via linked databases.

| Category | Amount (USD) |
|----------|--------------|
| **Revenue** | $5,860 |
| **Cost of Goods Sold** | $1,720 |
| **Shipping Expenses** | $210 |
| **Marketplace Fees (5%)** | $293 |
| **Net Profit** | $3,637 |

> 💡 Tip: Use a **Formula** for Net Profit: `prop("Revenue") - prop("Cost of Goods Sold") - prop("Shipping Expenses") - prop("Marketplace Fees (5%)")`.

## Marketing & SEO Planner
Plan listings, promotions, and SEO keywords to boost visibility.

| Campaign | Listing(s) Affected | Start Date | End Date | Budget | Primary Keyword | Status |
|----------|--------------------|------------|----------|--------|----------------|--------|
| Summer Sale 2024 | All items | 2024‑07‑01 | 2024‑07‑15 | $150 | “handmade summer gifts” | 📅 Scheduled |
| Instagram Reel | Lavender Soap | 2024‑06‑25 | 2024‑06‑25 | $30 | “lavender soap benefits” | ✅ Completed |
| Etsy Ads Boost | Beeswax Candle | 2024‑07‑10 | 2024‑07‑31 | $80 | “organic beeswax candle” | ⏳ In Progress |

> 💡 Tip: Add a **Relation** to the Orders DB to see which campaigns generated the most sales.

## SOP & Resources
Standard operating procedures and quick links for repeatable tasks.

| SOP | Description | Link |
|-----|-------------|------|
| Order Fulfillment | Step‑by‑step packing, labeling, and carrier drop‑off | https://www.notion.so/Order‑Fulfillment‑SOP |
| Photo Editing Guide | Consistent product photography workflow | https://www.notion.so/Photo‑Editing‑Guide |
| Customer Service Scripts | Templates for messages & dispute handling | https://www.notion.so/Customer‑Service‑Scripts |

> 💡 Tip: Duplicate this page for each new product line to keep SOPs organized.

## How to import into Notion
1. In Notion, click **Import** → **Markdown & CSV**.  
2. Select this `.md` file and upload it.  
3. Notion will create pages for each H2 heading automatically.  
4. For every table, click **Convert to Database** (choose Table view).  
5. Adjust property types (e.g., set **Date**, **Select**, **Number**, **Formula**, **Relation**, **Rollup** as described in the tips).  
6. Link related databases (e.g., connect **Orders** → **Inventory Tracker** via SKU).  
7. Save the template as a **Template Button** or duplicate the workspace to start using it for your own Etsy shop.