Step 1 of 4

Set Up Your Database

Set up your database and backend so your store can save products, orders, and customers.

You'll need a free Supabase account and your ShipCommerce project files · Estimated time: 10–15 min

1. Create a Supabase Project

1. Go to supabase.com/dashboard and sign up (or log in)
2. Click the green New Project button
3. Fill in the details:
   • Name: Choose any name (e.g. "my-store")
   • Database Password: Click "Generate a password" and save it somewhere safe
   • Region: Pick the one closest to your customers
4. Click Create new project and wait about 2 minutes for it to finish

2. Copy Your Keys

You need 3 values from your Supabase project. Here's exactly where to find each one:

Project URL

Open your project. The URL is shown right below the project name on the Project Overview page.

API Keys

1. In the left menu, click Project Settings (the gear icon at the bottom)
2. Click API Keys
3. Scroll down to the section called "Legacy anon, service_role API keys"
4. Click the copy icon next to each key and save them:

When you're done, your values should look something like this:

NEXT_PUBLIC_SUPABASE_URL=https://abcdefghijk.supabase.co
NEXT_PUBLIC_SUPABASE_ANON_KEY=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...
SUPABASE_SERVICE_ROLE_KEY=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...

These are example values — use your own keys from Supabase, not these.

3. Create the Database Tables

This creates all the tables your store needs (products, orders, customers, etc.).

1. In the left menu, click SQL Editor
2. Open the file supabase-setup.sql from your ShipCommerce project folder
3. Copy everything from that file
4. Paste it into the SQL Editor
5. Click the green Run button
6. Wait for it to finish — you should see "Success"

4. Set Up File Storage

This lets you upload product images from the admin panel.

1. Still in the SQL Editor
2. Open the file setup-storage.sql from your project
3. Copy everything, paste it, and click Run

5. Set Up Authentication

1. In the left menu, click Authentication
2. Click URL Configuration in the submenu
3. Set Site URL to your store domain (e.g. https://yourstore.com)
4. Under Redirect URLs, click Add URL and add these two:

   https://yourstore.com/
   https://yourstore.com/**

Checklist

• ☐Supabase project created
• ☐3 API keys copied and saved
• ☐supabase-setup.sql — ran successfully
• ☐setup-storage.sql — ran successfully
• ☐Authentication URLs configured