DVC Hub

📊 Today's Sales

Loading...

Recent Orders

Time	Ch	SKU	Price	Pay	Seller	Customer

➕ New Sale

Add a new order to the system

Order

Channel *

Seller

Date *

Payment *

Status

Items *

Customer

Name

Facebook

Address + Phone

Tracking

Note

📝 Sales Log

Loading...

🔍

DATE	CH	SKU	PRICE	PAY	STATUS	SELLER	CUSTOMER	TRACK

📦 Stock Check

Search availability by SKU — share with customer in chat

👥 Customers

Search customers, view purchase history

➕ Log Ad Spend

Record today's ad performance for each account

Ad Spend

Date *

Ad Account *

Spend (VND) *

≈ THB (auto)

Performance

Messages

Comments

Orders from Ads

Revenue (VND)

Auto-Calculated

Leads

0

CPL (VND)

—

ROAS

—

Rev ≈ THB

—

📋 Ad Spend Log

Loading...

Date	Account	Spend VND	≈THB	Msgs	Cmts	Leads	Orders	Rev VND	ROAS

📊 My Performance

Your monthly ad performance summary

Monthly Spend vs Revenue

Monthly ROAS

📊 Sales Dashboard

Revenue overview · Sep 2025 – present

Monthly Revenue by Channel

Channel Share

COD vs Transfer

COD % Trend

👥 Team Sales

Loading...

📱 Advertising & ROAS

Ad spend vs sales revenue · Anne's data across 3 ad accounts

Ad Spend vs Sales Revenue by Month (THB)

ROAS by Month

Spend by Ad Account (THB)

Monthly Performance Table

Month	Ad Spend	Sales Rev	ROAS	Leads	Orders (ads)	Ank Lee	Fasai Acct

⚠️ Ad revenue (from FB) and sales revenue (from order sheet) may differ slightly. ROAS here uses actual sales revenue ÷ ad spend for the most accurate picture.

💰 Cash Flow & P&L

Financial overview · Investor capital reset: Sep 1, 2025

⚠️ Ad spend shows DVC 2 only (from Fasai's Krungthai card). Q's spend for DVC 3 + other accounts pending.

📦 Inventory Analysis

Stock levels, dead stock, cash tied up

All Products by Stock Level

SKU	S	M	L	XL	Total	Cost	Value	Material

🗺️ Customers & Geography

Where your buyers are located across Thailand

Top Provinces by Orders

Province	Orders	Revenue	% of Total	COD %

👗 Product Catalogue

Product images, descriptions, and info for AI-powered ads

💡 This catalogue will feed the future AI ad system — it pulls product info + images to auto-generate captions and post on Facebook.

Has Images Only

💾 Data Management

Import CSV data, export backups, restore from backup

📥 Smart Import

Drop any CSV — sales or ads. AI auto-detects columns, skips duplicates, imports only new data.

Drop CSV here

Sales orders or ad spend — we'll figure it out

📤 Export

Complete backup including all product photos

Database only — does not include photos

Product data only. Use Full Backup for photos.

📦 Restore Full Backup

Upload a .zip backup (with photos) or .json backup (database only)

Drop backup file here

.zip (full with photos) or .json (database only)

🎯 Action Plan

Data-driven recommendations from DVC Avengers

To Do

In Progress

Done

Data Insights

AI analysis of why products need posting — stock risk, sales gaps, and content opportunities

Post Composer

Create posts with caption generator, angle selector, and image picker

1. Sales Dashboard

Charts load with real data (revenue, channels, COD vs Transfer) Click "3M" — charts filter to last 3 months Click "All" — shows everything again Numbers look correct (~฿2.3M total)

2. Customer Popup

Click any customer name — popup appears Shows: name, tags (VIP, Loyal, etc.), order count, revenue Click X or outside — popup closes Tags make sense (10+ orders = VIP)

3. Catalogue Gallery

Gallery grid shows product cards Click a card — expanded detail with images Style filter dropdown works Toggle Gallery ↔ Table view works

4. Inventory & Dead Stock

Dead Stock KPI shows count + value Dead stock rows highlighted red with DEAD badge Numbers look realistic

5. Ads & ROAS

Charts show spend vs revenue Date picker works (3M, 6M) Monthly table data is correct

6. Action Plan (Kanban)

Kanban columns: To Do, In Progress, Done Start/Done/Reopen buttons work

7. General

All pages load without errors Role switching works (Admin, Ads, Owner) Tables sort when clicking headers Footer says "v5.0 · Phase 2"

Progress: 0 / 22

Q's Feedback

What works well?

What needs fixing?

What's missing or confusing?

Priority requests for next version

📦 Purchase Orders

Track stock purchases from suppliers

Date	Supplier	Invoice #	Items	Total Cost	Currency	Status	By

📝 Caption Library

Loading from Notion DVC Content Library…

✨ Post Studio

Photo · Caption · Channels — all in one place

📊 Ad Performance

Track ad spend, ROAS, and product-level performance

Campaign	Spend	Impressions	Clicks	CPC	CTR	Reach

⚙️ User Management

Manage team members and their roles

Team Members

Add New User

Name *

PIN * (4-6 digits)

Roles *

Owner Seller Ads

📜 Edit History

Track all changes made to orders and ads

When	Who	Action	Table	Field	Old	New

Recent Orders

Order

Customer

Ad Spend

Performance

Monthly Spend vs Revenue

Monthly ROAS

Monthly Revenue by Channel

Channel Share

COD vs Transfer

COD % Trend

👥 Team Sales

Ad Spend vs Sales Revenue by Month (THB)

ROAS by Month

Spend by Ad Account (THB)

Monthly Performance Table

All Products by Stock Level

Top Provinces by Orders

Add / Edit Product

Catalogue Items

📥 Smart Import

📤 Export

📦 Restore Full Backup

1. Sales Dashboard

2. Customer Popup

3. Catalogue Gallery

4. Inventory & Dead Stock

5. Ads & ROAS

6. Action Plan (Kanban)

7. General

Q's Feedback

Per-Product ROAS

Map Campaign to Product

Team Members

Add New User

Recent Orders

Order

Customer

Ad Spend

Performance

Monthly Spend vs Revenue

Monthly ROAS

Monthly Revenue by Channel

Channel Share

COD vs Transfer

COD % Trend

👥 Team Sales

Ad Spend vs Sales Revenue by Month (THB)

ROAS by Month

Spend by Ad Account (THB)

Monthly Performance Table

All Products by Stock Level

Top Provinces by Orders

Add / Edit Product

Catalogue Items

📥 Smart Import

📤 Export

📦 Restore Full Backup

1. Sales Dashboard

2. Customer Popup

3. Catalogue Gallery

4. Inventory & Dead Stock

5. Ads & ROAS

6. Action Plan (Kanban)

7. General

Q's Feedback

Per-Product ROAS

Map Campaign to Product

Team Members

Add New User

Edit Sale