System Settings & Utilities

Customize contact hotline links, reset order logs, or restore product values.

Developer Utilities

Shortcuts to configure storage states for testing the system.

Seed Sample Orders

Creates 5 mock sales logs in your history to populate dashboard charts and tables immediately.

Reset Billing Logs

Completely clears the history arrays, resetting all customer invoice orders back to empty.

Factory Reset Catalog

Clears custom pricing and stock states to return the catalog immediately to original values.

Supabase SQL Schema

Copy and run this SQL script in your Supabase SQL Editor to initialize all necessary tables and RLS bypasses.

-- Create orders table
CREATE TABLE IF NOT EXISTS orders (
  order_id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  phone TEXT NOT NULL,
  email TEXT,
  address TEXT NOT NULL,
  total NUMERIC NOT NULL,
  status TEXT DEFAULT 'Pending',
  items JSONB NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Create custom_products table
CREATE TABLE IF NOT EXISTS custom_products (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  name_bn TEXT NOT NULL,
  price NUMERIC NOT NULL,
  original_price NUMERIC,
  discount NUMERIC,
  category TEXT,
  brand TEXT,
  image TEXT,
  description TEXT,
  description_bn TEXT,
  thickness TEXT,
  size TEXT,
  features JSONB,
  features_bn JSONB,
  out_of_stock BOOLEAN DEFAULT FALSE,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Create product_overrides table
CREATE TABLE IF NOT EXISTS product_overrides (
  id TEXT PRIMARY KEY,
  price NUMERIC NOT NULL,
  out_of_stock BOOLEAN DEFAULT FALSE,
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

-- Create store_settings table
CREATE TABLE IF NOT EXISTS store_settings (
  key TEXT PRIMARY KEY,
  value JSONB,
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

-- Disable RLS for standard public access
ALTER TABLE orders DISABLE ROW LEVEL SECURITY;
ALTER TABLE custom_products DISABLE ROW LEVEL SECURITY;
ALTER TABLE product_overrides DISABLE ROW LEVEL SECURITY;
ALTER TABLE store_settings DISABLE ROW LEVEL SECURITY;

-- Storage Bucket Setup: Initialize 'assets' public storage bucket
INSERT INTO storage.buckets (id, name, public)
VALUES ('assets', 'assets', true)
ON CONFLICT (id) DO NOTHING;

-- Storage Policies Setup: Enable full public select, insert & update on 'assets' bucket
CREATE POLICY "Allow public read access" ON storage.objects FOR SELECT TO public USING (bucket_id = 'assets');
CREATE POLICY "Allow public upload access" ON storage.objects FOR INSERT TO public WITH CHECK (bucket_id = 'assets');
CREATE POLICY "Allow public update access" ON storage.objects FOR UPDATE TO public USING (bucket_id = 'assets');

Homepage Hero Slider Editor

Add, update, or remove active slides on your homepage hero carousel. Changes show up immediately.

No slides found. Click "Add New Slide" to begin.