Skip to content

SERVICES_SETUP.md

Latest commit

 

History

History
85 lines (64 loc) · 2.22 KB

SERVICES_SETUP.md

File metadata and controls

85 lines (64 loc) · 2.22 KB

Services Setup Guide

Problem

If you see "No services available. Please add services to the database" when creating a contract, you need to populate the services table.

Solution

Option 1: Using Supabase Dashboard (Recommended)

  1. Open Supabase Dashboard

  2. Open SQL Editor

    • Click "SQL Editor" in the left sidebar
    • Click "New query"

  3. Run the Seed Script

    • Open the file: lib/supabase/seed-services.sql
    • Copy and paste the entire SQL into the editor
    • Click "Run" or press Ctrl+Enter (Windows) / Cmd+Enter (Mac)

Option 2: Using Command Line

psql $DATABASE_URL -f lib/supabase/seed-services.sql

What Services Will Be Added

The seed script adds:

Property Management Services (8 services)

  • Full Property Management (Featured)
  • Self-management Support
  • Co-hosting Services (Featured)
  • Short-term Rental Management (Featured)
  • Long-term Property Management
  • Hybrid Management
  • On-demand Services
  • Automated Management

Maintenance Services (4 services)

  • Regular Maintenance (Featured)
  • Emergency Repairs
  • Preventive Maintenance
  • Handyman Services

Leasing Services (4 services)

  • Tenant Screening (Featured)
  • Lease Preparation
  • Property Marketing
  • Tenant Placement (Featured)

Verify Services Were Added

After running the script, verify in Supabase Dashboard:

  1. Go to Table Editor → services table
  2. You should see 16 services total

Or run this query:

SELECT COUNT(*) FROM public.services;
-- Should return 16

Customizing Services

You can add, modify, or delete services directly in Supabase:

  1. Go to Table Editor → services table
  2. Click "Insert row" to add new services
  3. Or edit existing services

Service Categories:

  • property_management - For property management contracts
  • maintenance - For maintenance service contracts
  • leasing - For leasing service contracts
  • financial - Not used for contracts (filtered out)

After Adding Services

Once services are added:

  1. Refresh the contract creation page
  2. The "Contract Type (Service)" dropdown will show all available services
  3. You can select a service to create a contract for that service type