Sandbox Access Token

Get your Sandbox Access Token from the Square Developer Portal. Go to developer.squareup.com → Your App → Sandbox → Access Token.

How to get your Sandbox Token

1. Go to developer.squareup.com and sign in
2. Click + New Application → name it "Workshop Manager"
3. Open the app → click the Sandbox tab
4. Copy the Sandbox Access Token (starts with EAAAlx...)
5. Click Open Sandbox Seller Dashboard to add test catalog items
6. Paste your token above and click Test Connection

Role Permissions

What each role can do in the workshop system.

${[ ['View all inventory','✓','✓','✓'], ['Add / edit items','✓','✓','✓'], ['Delete items','✓','✓','✗'], ['Process sales (POS)','✓','✓','✓'], ['View sales history','✓','✓','✗'], ['CSV import','✓','✓','✗'], ['Manage users','✓','✗','✗'], ['Edit settings / keys','✓','✗','✗'], ].map(([p,o,m,s]) => ``).join('')}

PERMISSION	OWNER	MANAGER	STAFF
${p}	${o}	${m}	${s}

Supabase Connection

Paste your Supabase Project URL and anon key below. Find these in your Supabase dashboard under Project Settings → API.

Database Setup SQL

Run this SQL in your Supabase SQL Editor to create all required tables:

-- WORKSHOP MANAGER DATABASE SETUP -- Run this in Supabase SQL Editor CREATE TABLE IF NOT EXISTS projects ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), name text NOT NULL, scale text, category text, status text DEFAULT 'Planning', notes text, created_at timestamptz DEFAULT now() ); CREATE TABLE IF NOT EXISTS parts ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), name text NOT NULL, project_id uuid REFERENCES projects(id) ON DELETE SET NULL, qty integer DEFAULT 0, location text, supplier text, reorder_point integer DEFAULT 1, created_at timestamptz DEFAULT now() ); CREATE TABLE IF NOT EXISTS paints ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), color_name text NOT NULL, brand text, color_code text, finish text, qty_ml numeric DEFAULT 0, low_stock_ml numeric DEFAULT 5, hex_color text, created_at timestamptz DEFAULT now() ); CREATE TABLE IF NOT EXISTS supplies ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), name text NOT NULL, category text, qty numeric DEFAULT 0, unit text, reorder_point numeric DEFAULT 1, notes text, created_at timestamptz DEFAULT now() ); -- Enable Row Level Security (optional but recommended) ALTER TABLE projects ENABLE ROW LEVEL SECURITY; ALTER TABLE parts ENABLE ROW LEVEL SECURITY; ALTER TABLE paints ENABLE ROW LEVEL SECURITY; ALTER TABLE supplies ENABLE ROW LEVEL SECURITY; -- Allow all access (update these for multi-user setups) CREATE POLICY "allow_all" ON projects FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "allow_all" ON parts FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "allow_all" ON paints FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "allow_all" ON supplies FOR ALL USING (true) WITH CHECK (true); -- USER ROLES TABLE (for multi-user / staff login) CREATE TABLE IF NOT EXISTS user_roles ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), user_id uuid, email text, full_name text, role text DEFAULT 'staff', invited_by uuid, created_at timestamptz DEFAULT now() ); ALTER TABLE user_roles ENABLE ROW LEVEL SECURITY; CREATE POLICY "allow_all" ON user_roles FOR ALL USING (true) WITH CHECK (true); Copy SQL