Dashboard Overview
Real-time tracking of organic media sales and logistics.
Order Activity & Revenue Trends
Visual sales tracking timeline across order batches.
Revenue
Orders
No chart data available. Place some orders first!
Orders Management
Track, filter, and update customer order fulfillment status.
Order History
| Order ID | Date Placed | Customer Info | Order Value | Fulfillment | Status | Action |
|---|
No orders found matching the filter criteria.
Customers will appear here when they check out from the storefront.Inventory Management
Create new products, modify descriptions, and change prices.
| Product Info | Product ID | Base Price | Unit Label | Action |
|---|
Database Settings
Connect your dashboard and storefront to a secure Supabase backend.
Supabase Credentials
Provide your Razorpay test or live Key ID. If left blank, the system defaults to
rzp_test_SyiE1HAylAQAEM.
Disconnected
Currently utilizing LocalStorage.
Database Setup Instructions
To initialize the database, execute the following SQL inside the SQL Editor on your Supabase Console:
-- Create products table
create table public.products (
id text primary key,
title text not null,
price numeric not null,
unit_label text default 'item',
image text,
thumb text,
tag text,
description text,
features jsonb default '[]'::jsonb
);
-- Create orders table
create table public.orders (
id text primary key,
created_at timestamp with time zone default timezone('utc'::text, now()) not null,
status text default 'new'::text,
subtotal numeric not null,
lines jsonb default '[]'::jsonb,
customer jsonb not null
);
-- Enable public read/write
alter table public.products enable row level security;
alter table public.orders enable row level security;
create policy "Allow public read access to products" on public.products for select using (true);
create policy "Allow public write access to products" on public.products for all using (true);
create policy "Allow public read access to orders" on public.orders for select using (true);
create policy "Allow public write access to orders" on public.orders for all using (true);
⚠️ Important: Enabling public read/write policies ensures the client-side storefront and owner console can interact with tables directly without middleware.