# Etsy Shop Manager

## Dashboard
A quick‑glance hub that shows your shop’s health at a glance.

| Metric | Today | This Week | This Month |
|--------|-------|-----------|------------|
| Orders Received | 3 | 21 | 87 |
| Revenue (USD) | $210 | $1,540 | $6,720 |
| New Reviews | 1 | 5 | 22 |
| Items Low in Stock | 2 | 5 | 9 |

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

---

## Orders Database
Track every order from purchase to fulfillment.

| Order # | Buyer | Item(s) | Order Date | Shipping Method | Status | Tracking # | Total (USD) |
|---------|-------|---------|------------|------------------|--------|------------|-------------|
| 1024 | Emma L. | Lavender Soap (2), Beeswax Candle | 2024‑06-20 | USPS Priority | Shipped | 9405 1234 5678 | $45.00 |
| 1025 | Marco P. | Ceramic Mug | 2024‑06‑21 | Canada Post | Ready to Ship | — | $22.00 |
| 1026 | Aisha K. | Hand‑stitched Tote (1) | 2024‑06‑22 | UPS Ground | Completed | 1Z999AA10123456784 | $38.00 |
| 1027 | Luis G. | Vintage Print (3) | 2024‑06‑22 | DHL Express | Cancelled | — | $0.00 |

> 💡 Tip: Use Notion’s “Select” property for **Status** (e.g., “Pending”, “Ready to Ship”, “Shipped”, “Completed”, “Cancelled”) and filter views by each stage.

### Views
- **All Orders** – Table, sorted by Order Date descending.
- **Pending Fulfillment** – Filter: Status = “Pending” or “Ready to Ship”.
- **Shipped This Week** – Filter: Status = “Shipped” AND Order Date within last 7 days.
- **Cancelled Orders** – Filter: Status = “Cancelled”.

---

## Inventory Tracker
Keep stock levels, supplier info, and production costs organized.

| SKU | Product Name | Category | Stock Qty | Reorder Point | Supplier | Cost per Unit (USD) | Retail Price (USD) |
|-----|--------------|----------|-----------|---------------|----------|---------------------|--------------------|
| LS‑001 | Lavender Soap | Bath & Body | 34 | 10 | PureScents Co. | 1.20 | 4.50 |
| BC‑010 | Beeswax Candle | Home Décor | 12 | 5 | CandleCraft Ltd. | 2.80 | 9.99 |
| CM‑005 | Ceramic Mug | Kitchen | 58 | 20 | ClayWorks | 3.00 | 12.99 |
| TT‑020 | Hand‑stitched Tote | Accessories | 7 | 3 | StitchStudio | 5.50 | 24.99 |
| VP‑030 | Vintage Print | Art | 15 | 5 | ArtPrints Inc. | 4.00 | 15.00 |

> 💡 Tip: Add a Formula property **Profit Margin** = (`Retail Price`‑`Cost per Unit`)/`Retail Price` to instantly see profitability.

### Views
- **All Products** – Table view.
- **Low Stock** – Filter: Stock Qty ≤ Reorder Point.
- **By Category** – Grouped by Category.

---

## Production & Restock Planner
Schedule making, ordering supplies, and restocking.

| Task | Related SKU | Due Date | Assigned To | Status | Notes |
|------|-------------|----------|-------------|--------|-------|
| Make 20 Lavender Soaps | LS‑001 | 2024‑06‑25 | Maya | Not Started | Use new essential oil batch |
| Order Beeswax (5 lbs) | BC‑010 | 2024‑06‑28 | Carlos | In Progress | Supplier offers 10% bulk discount |
| Print new Vintage Art | VP‑030 | 2024‑07‑02 | Nina | Not Started | New summer theme |
| Restock Tote Fabric | TT‑020 | 2024‑07‑01 | Maya | Completed | Received 2 rolls |

> 💡 Tip: Turn this table into a Calendar view to see production deadlines visually.

---

## Marketing & Promotions
Plan social posts, Etsy ads, and seasonal sales.

| Campaign | Channel | Start Date | End Date | Goal | Status | Link |
|----------|---------|------------|----------|------|--------|------|
| Summer Refresh | Instagram Reels | 2024‑06‑20 | 2024‑07‑05 | 150 new followers | Scheduled | https://instagram.com/yourshop |
| 10% Off First Order | Etsy Ads | 2024‑06‑25 | 2024-07-10 | 30% increase in conversion | Active | — |
| Holiday Gift Guide | Pinterest Board | 2024‑11‑01 | 2024‑12‑15 | Drive 200 sales | Planned | — |
| Free Shipping Over $50 | Email Newsletter | 2024‑08‑01 | 2024‑08‑15 | Boost AOV | Draft | — |

> 💡 Tip: Add a Rollup from **Orders** to this table to automatically count orders that used a specific coupon code.

---

## Finances & Reporting
Summarize revenue, expenses, and profit margins.

| Month | Gross Revenue (USD) | Cost of Goods Sold (USD) | Shipping Expenses (USD) | Net Profit (USD) |
|-------|---------------------|--------------------------|--------------------------|------------------|
| May 2024 | 5,420 | 1,980 | 210 | 3,230 |
| June 2024 | 6,720 | 2,340 | 260 | 4,120 |
| July 2024 (proj.) | 7,150 | 2,500 | 280 | 4,370 |

> 💡 Tip: Use Notion’s Formula property to calculate **Net Profit** = `Gross Revenue` – (`COGS` + `Shipping Expenses`).

---

## How to import into Notion
1. **Create a new page** in your Notion workspace where you want the template.  
2. Click **Import** → **Markdown & CSV** and select this `.md` file.  
3. Notion will create the headings and tables as plain tables.  
4. For each table you want to act as a database:  
   a. Click the three‑dot menu on the table → **Turn into → Database → Table – Full page** (or **Table – Inline** if you prefer it embedded).  
   b. Adjust property types (e.g., change “Status” to **Select**, “Due Date” to **Date**, “Tracking #” to **Text**, “Profit Margin” to **Formula**, etc.).  
5. Rename each database page according to the section titles (Orders, Inventory Tracker, Production Planner, etc.).  
6. Re‑create the suggested **Views** (Table, Board, Calendar, Gallery) using the **Add a view** button and apply the filters/groupings described in each section.  
7. Add any **Relations** or **Rollups** you need (e.g., link Orders → Inventory via SKU, link Marketing → Orders via Coupon Code).  
8. Finally, customize the Dashboard with linked database views or synced blocks for a live overview.

Your Etsy Shop Manager is now ready to use—track orders, keep inventory in check, plan production, run promotions, and see the numbers that matter, all inside Notion. Happy selling!