Merchant Smith

Merchant Smith v2

Supabase-connected campaign shops, shared player storefronts, carts, wallet balances, and checkout.

Supabase connection

Not connected
Only the project URL and anon public key are needed for this static build. Do not put your service role key into the browser.

SQL order

  1. Run merchant_smith_supabase_schema_and_seed.sql.
  2. Run merchant_smith_wallet_cart_checkout.sql.
  3. Run merchant_smith_v2_public_setup.sql.
  4. Paste your project URL and anon key here.
  5. Generate a shop and test checkout.
This v2 build talks directly to your Supabase project from the browser. The included public setup SQL is for table testing and should be tightened before production.

Quick checks

Players

Generate shop

Shops

Player session

Cart

0 items
Subtotal0 gp
Total items0

Inventory

0 items

Recent purchases

Diagnostics


          

          

            
What this build uses

            
    
              
  • generate_shop_inventory(...) for GM shop creation
    • 
              
  • create_player_with_wallet(...) for player creation
    • 
              
  • add_item_to_cart(...), update_cart_item_quantity(...), remove_cart_item(...)
    • 
              
  • checkout_cart(...) for stock-safe checkout
    • 
            

            
This is a static browser app wired to Supabase RPCs and tables. It is ideal for testing flow and table use before adding auth and stricter RLS.