Scento: a production Medusa 2 store, plus two lessons from raw SQL and migrations

[sebyddd]

Sharing a production Medusa 2 build: Scento (https://www.scento.com), a European online retailer of authentic designer and niche fragrance decants with tracked delivery to 26 European countries. Medusa 2 runs on Render with Supabase Postgres; the storefront is Next.js 16 on Vercel with Tailwind CSS, Sanity for editorial content, Stripe for payments and Cloudflare in front. The storefront is published in ten languages.

Two things we learned that might save someone time:

1. Orders are versioned. order_item and order_summary keep rows per order version, so a raw SQL report that joins them without filtering to the latest version (AND x.version = (SELECT MAX(version) ...)) counts the same line two to four times once orders have been edited. Every raw query we run against those tables now carries that filter.

2. Make custom-module migrations safe to re-run. Postgres has no IF NOT EXISTS for ALTER TABLE ... ADD CONSTRAINT, so a migration that adds one fails the pre-deploy step on a database that already has it. We wrap each one:

DO $do$
BEGIN
  ALTER TABLE "my_table" ADD CONSTRAINT "my_check" CHECK (...);
EXCEPTION
  WHEN duplicate_object OR duplicate_table THEN NULL;
END
$do$;

Happy to share more about the setup if useful.
Sebastian Dobrincu, founder of Scento