# Etsy Seller Success Hub — The "Ultimate Operator" Edition

## 🏠 1. Shop Dashboard (Command Center)
**Icon:** 🏠 | **Cover:** Abstract geometric pastel (clean, professional).

This is your live cockpit. All data is automated via relations and rollups.

### Layout Structure (3 Columns)
*   **Column 1 (Wide):** Financial Pulse (KPIs).
*   **Column 2 (Narrow):** Operational Health (Alerts).
*   **Column 3 (Wide):** Growth & Actions (Marketing/Tasks).

### Column 1: Financial Pulse
**[Callout Icon: 💵] Monthly Revenue**
*   *Content:* `Rollup: Finance & Profit (Amount) | Filter: Type = "Income" | This Month`

**[Callout Icon: 📈] Net Profit (After COGS)**
*   *Content:* `Rollup: Sales & Orders (Net Profit) | This Month`
*   *Note:* This automatically deducts material costs from your revenue.

**[Callout Icon: 🎯] Goal Progress**
*   *Content:* `Formula: (Current Revenue / Monthly Goal) * 100`

---

### Column 2: Operational Health
**[Callout Icon: 🔴] Low Stock Alert**
*   *View:* Linked View of *Inventory Management*.
*   *Filter:* Status is "🔴 Reorder Now".
*   *Format:* List view (compact).

**[Callout Icon: 📦] Pending Orders**
*   *View:* Linked View of *Sales & Orders*.
*   *Filter:* Status is "📦 Processing".
*   *Format:* List view.

**[Callout Icon: 💬] Unanswered Reviews**
*   *View:* Linked View of *Review Management*.
*   *Filter:* Response Status is "No".
*   *Format:* List view.

---

### Column 3: Growth & Actions
**[Heading] Content Calendar**
*   *View:* Linked View of *Marketing & Content Calendar*.
*   *Format:* Calendar View (Upcoming 2 weeks).
*   *Properties:* Post Title, Platform, Status.

**[Heading] Production Queue**
*   *View:* Linked View of *Shop Tasks*.
*   *Filter:* Status is not "Done".
*   *Format:* Board View (Grouped by Status).

---

## 👥 2. Customers CRM (Lifetime Value)
**Icon:** 👥 | **Database Type:** Table

Dedicated database to track buyer behavior, LTV, and retention.

### Property Schema
1.  **Title** (Title): Customer Name.
2.  **Email** (Email): Contact info.
3.  **Orders** (Relation): Links to *Sales & Orders*.
4.  **Total Orders** (Rollup):
    *   Relation: `Orders` -> Property: `Order Total`.
    *   Calculate: Count.
5.  **Total Spent** (Rollup):
    *   Relation: `Orders` -> Property: `Order Total`.
    *   Calculate: Sum.
6.  **LTV Tier** (Formula): Categorizes customer value.
    *   *Formula:* `if(prop("Total Spent") > 500, "🌟 VIP", if(prop("Total Spent") > 100, "🔥 Repeat", "👤 New"))`
7.  **Last Purchase** (Rollup):
    *   Relation: `Orders` -> Property: `Date`.
    *   Calculate: Latest (Date).

### Views to Create
*   **Table View:** Sorted by `Total Spent` (High to Low).
*   **List View:** Filter `LTV Tier` is "🌟 VIP" (for special outreach).

---

## 📦 3. Listings Database (The Core)
**Icon:** 📦 | **Database Type:** Table

Tracks every product listing with automated COGS logic.

### Property Schema
1.  **Title** (Title): Product Name.
2.  **Status** (Select): `🟢 Active`, `🔴 Draft`, `⚪ Inactive`.
3.  **Price** (Number): `$` format.
4.  **SKU** (Text): Unique identifier.
5.  **Material Item** (Relation): Links to *Inventory Management* (The primary raw material).
6.  **Material Cost** (Rollup):
    *   Relation: `Material Item` -> Property: `Cost Per Unit`.
    *   Calculate: Sum.
7.  **Qty Used** (Number): How many units of the material are used per listing (e.g., 2 skeins of yarn).
8.  **Total COGS** (Formula): Calculates true cost per unit.
    *   *Formula:* `prop("Material Cost") * prop("Qty Used")`
9.  **Gross Profit** (Formula): `prop("Price") - prop("Total COGS")`
10. **Profit Margin** (Formula): `if(prop("Price") > 0, (prop("Gross Profit") / prop("Price")) * 100, 0)`
11. **Stock Level** (Rollup):
    *   Relation: `Material Item` -> Property: `Quantity On Hand`.
    *   Calculate: Sum.
12. **SEO Keywords** (Relation): Links to *SEO & Keyword Bank`.

### Views to Create
*   **Gallery View:** Cover = Main Product Image. Properties = Price, Profit Margin.
*   **Table View:** Group by `Status`.

---

## 🧶 4. Inventory Management (Supply Chain)
**Icon:** 🧶 | **Database Type:** Table

Tracks raw materials and costs.

### Property Schema
1.  **Title** (Title): Material/Item Name.
2.  **Supplier** (Text): Vendor name.
3.  **Cost Per Unit** (Number): `$` format.
4.  **Quantity On Hand** (Number): Integer.
5.  **Reorder Level** (Number): Integer.
6.  **Status** (Formula):
    *   *Formula:* `if(prop("Quantity On Hand") <= prop("Reorder Level"), "🔴 Reorder Now", "✅ In Stock")`
7.  **Used In Listings** (Relation): Links back to *Listings Database*.

### Views to Create
*   **Kanban Board:** Group by `Status`.
*   **List View:** Sorted by `Quantity On Hand` (Ascending).

---

## 🧾 5. Sales & Orders (Transaction Hub)
**Icon:** 🧾 | **Database Type:** Table

Records transactions, links to Customers, and auto-calculates profit.

### Property Schema
1.  **Title** (Title): Customer Name (or Order ID).
2.  **Order #** (Text): Etsy Order ID.
3.  **Date** (Date): Purchase date.
4.  **Customer** (Relation): Links to *Customers CRM*.
5.  **Items Bought** (Relation): Link to *Listings Database*.
6.  **Order Total** (Number): `$` format.
7.  **Order COGS** (Rollup):
    *   Relation: `Items Bought` -> Property: `Total COGS`.
    *   Calculate: Sum.
8.  **Net Profit** (Formula): `prop("Order Total") - prop("Order COGS")`
9.  **Status** (Select): `📦 Processing`, `✅ Shipped`, `🚚 In Transit`, `✅ Delivered`.
10. **Tracking Number** (URL): Link to carrier tracking.
11. **Linked Finance** (Relation): Link to *Finance & Profit*.

### Views to Create
*   **Calendar View:** By `Date`.
*   **Board View:** Group by `Status`.

---

## 💰 6. Finance & Profit (The Money)
**Icon:** 💰 | **Database Type:** Table

Tracks all cash flow.

### Property Schema
1.  **Title** (Title): Description.
2.  **Date** (Date): Transaction date.
3.  **Type** (Select): `💵 Income`, `💸 Expense`, `🏦 Etsy Fee`, `📣 Marketing`.
4.  **Amount** (Number): `$` format.
5.  **Signed Amount** (Formula): `if(contains(prop("Type"), "Income"), prop("Amount"), -prop("Amount"))`
6.  **Related Order** (Relation): Link to *Sales & Orders*.

### Views to Create
*   **Table View:** Group by `Type`.
*   **Timeline View:** By `Date`.

---

## 📅 7. Marketing & Content Calendar
**Icon:** 📅 | **Database Type:** Table

Integrated workflow for social media promotion.

### Property Schema
1.  **Title** (Title): Post Concept / Caption.
2.  **Platform** (Select): `📸 Instagram`, `📌 Pinterest`, `🎵 TikTok`.
3.  **Status** (Select): `📝 Idea`, `📷 Drafted`, `✅ Scheduled`, `📢 Posted`.
4.  **Publish Date** (Date): When it goes live.
5.  **Linked Listing** (Relation): Links to *Listings Database* (to track which product is being pushed).
6.  **Asset URL** (Files): Image/Video file.

### Views to Create
*   **Calendar View:** By `Publish Date`.
*   **Board View:** Group by `Status`.

---

## 💬 8. Review Management (Reputation)
**Icon:** 💬 | **Database Type:** Table

Tracks sentiment and response workflow.

### Property Schema
1.  **Title** (Title): "Review for [Listing Name]".
2.  **Customer** (Relation): Links to *Customers CRM*.
3.  **Rating** (Number): 1-5 stars.
4.  **Sentiment** (Select): `🥰 Positive`, `😐 Neutral`, `😡 Negative`.
5.  **Review Text** (Text): Copy/paste the review.
6.  **Response Status** (Select): `❌ No`, `⏳ Pending`, `✅ Yes`.
7.  **Response Draft** (Text): Write your reply here.

### Views to Create
*   **List View:** Group by `Sentiment`.
*   **Board View:** Group by `Response Status`.

---

## 🔍 9. SEO & Keyword Bank
**Icon:** 🔍 | **Database Type:** Table

Searchable library for ranking terms.

### Property Schema
1.  **Title** (Title): Keyword Phrase.
2.  **Search Volume** (Select): `🔥 High`, `🔥 Medium`, `❄️ Low`.
3.  **Competition** (Select): `😈 High`, `😐 Medium`, `🙂 Low`.
4.  **Used In** (Relation): Links to *Listings Database*.

### Views to Create
*   **Table View:** Sorted by `Search Volume`.

---

## ✅ 10. Shop Tasks (Operations)
**Icon:** ✅ | **Database Type:** Table

Operational task management.

### Property Schema
1.  **Title** (Title): Task Name.
2.  **Priority** (Select): `🔥 High`, `🔵 Medium`, `⚪ Low`.
3.  **Due Date** (Date).
4.  **Status** (Select): `📅 Not Started`, `👷 In Progress`, `✅ Done`.

### Views to Create
*   **Board View:** Group by `Status`.

---

## 🔗 System Architecture (Setup Guide)

### Phase 1: Database Creation
Create the following 10 databases inside the main page:
1.  Customers CRM
2.  Listings Database
3.  Inventory Management
4.  Sales & Orders
5.  Finance & Profit
6.  Marketing & Content Calendar
7.  Review Management
8.  SEO & Keyword Bank
9.  Shop Tasks

### Phase 2: Core Relations
1.  **Customers ↔ Sales:** Connect `Customers` (Orders) to `Sales` (Customer).
2.  **Listings ↔ Inventory:** Connect `Listings` (Material Item) to `Inventory` (Used In Listings).
3.  **Sales ↔ Listings:** Connect `Sales` (Items Bought) to `Listings`.
4.  **Sales ↔ Finance:** Connect `Sales` (Linked Finance) to `Finance` (Related Order).
5.  **Marketing ↔ Listings:** Connect `Marketing` (Linked Listing) to `Listings`.
6.  **Reviews ↔ Customers:** Connect `Reviews` (Customer) to `Customers`.

### Phase 3: Automation Logic (Rollups)
1.  **Listings > Material Cost:** Rollup `Inventory` > `Cost Per Unit`.
2.  **Listings > Total COGS:** Formula: `Material Cost * Qty Used`.
3.  **Sales > Order COGS:** Rollup `Listings` > `Total COGS`.
4.  **Sales > Net Profit:** Formula: `Order Total - Order COGS`.
5.  **Customers > Total Spent:** Rollup `Sales` > `Order Total` (Sum).

### Phase 4: Dashboard Construction
1.  On the main page, create a 3-column layout.
2.  **Column 1:** Create a Relation to `Finance`. Add a Rollup property named "Revenue" (Sum of Amount, filtered by Income). Create a Relation to `Sales`. Add a Rollup named "Profit" (Sum of Net Profit).
3.  **Column 2:** Drag and drop "Linked Views" for Inventory, Sales, and Reviews. Apply the specific filters listed in Section 1.
4.  **Column 3:** Drag and drop "Linked Views" for Marketing and Tasks.