SOMA / LAWRENCE
A deliberate move to Soma.
Reconcile the Boulevard operational export, app seed and Soma policy gaps.
Boulevard operational import
Local export → safe app seed; production cutover disabled
1 locations · seed 1
47 services · seed 47
7 memberships · seed 7
42 products · seed 42
22 staffNoContact · seed 22
1 addonMapEntries · seed 1
0 usableAddonMaps · seed 0
Mapping: soma-operational-1 · sha256-canonical-allowlist-v1
Normalized export SHA-256
b2c54048f4184ee35eca43c184c7c7c56d460cf75f37c73828b8db0fbe6e468eApp seed SHA-256
b2c54048f4184ee35eca43c184c7c7c56d460cf75f37c73828b8db0fbe6e468ePrices: integer cents (USD) · 0 missing · 5 zero-price services · 14 inactive services.
Add-on export: 1 source entry, 0 usable maps, 5 query errors. The intake count included an error entry; associations need a corrected, separately authorized extraction.
Unmapped categories: NAD IVs, Add On Service, Vitamin Shots, Soma Sampler, NAD+ Therapy, Peptides, IV Therapy, Add-ons, Add-on Boosters, Contrast Therapy, General Services. Uncategorized products: 30.
Unmapped service review
Inactive rows and variants remain visible; only explicit policy mappings enter booking
| Service | Category | Reason |
|---|---|---|
| NAD+ Therapy 750mg | NAD IVs | No approved booking/resource policy mapping |
| Glow Up IV | Core IVs | No approved booking/resource policy mapping |
| Guest Pass- Contrast 3 Guests | Core Modalities | Inactive source; retained for reconciliation |
| NAD+ Therapy 500mg | NAD IVs | No approved booking/resource policy mapping |
| Glutahione (IV Push) | Add On Service | Add-on association and clinical approval required |
| Shield IV | Core IVs | No approved booking/resource policy mapping |
| Red Light Therapy 1 Guest Pass | Add On Service | Add-on association and clinical approval required |
| Contrast Therapy 1 Guest Pass | Add On Service | Add-on association and clinical approval required |
| Vitamin C | Add On Service | Add-on association and clinical approval required |
| MIC | Add On Service | Add-on association and clinical approval required |
| MIC Shot | Vitamin Shots | No approved booking/resource policy mapping |
| Cryotherapy 1 Guest Pass | Add On Service | Add-on association and clinical approval required |
| NAD+ Therapy 250mg | NAD IVs | No approved booking/resource policy mapping |
| Contrast Therapy 2 Guest Pass | Add On Service | Add-on association and clinical approval required |
| Zinc | Vitamin Shots | No approved booking/resource policy mapping |
| Glutahione Shot | Vitamin Shots | No approved booking/resource policy mapping |
| All modalities | Soma Sampler | Inactive source; retained for reconciliation |
| 750mg | NAD+ Therapy | Inactive source; retained for reconciliation |
| 500mg | NAD+ Therapy | Inactive source; retained for reconciliation |
| Peptide and Longevity Consultation | Peptides | No approved booking/resource policy mapping |
| Workout Warrior IV | Core IVs | No approved booking/resource policy mapping |
| Vitamin D | Vitamin Shots | No approved booking/resource policy mapping |
| Single Session | Core Modalities | Inactive source; retained for reconciliation |
| Magnesium | Add On Service | Add-on association and clinical approval required |
| Contrast Therapy 2 Guest Passes | Add On Service | Add-on association and clinical approval required |
| Hydration IV | IV Therapy | Inactive source; retained for reconciliation |
| NAD+ Therapy 1000mg | NAD IVs | No approved booking/resource policy mapping |
| 1000mg | NAD+ Therapy | Inactive source; retained for reconciliation |
| IV Vitamin Base Blend | Add-ons | Inactive source; retained for reconciliation |
| The Optimizer | Core IVs | Inactive source; retained for reconciliation |
| IV Vitamin Base Blend | Add-on Boosters | Inactive source; retained for reconciliation |
| Contrast Therapy- 60 minutes | Contrast Therapy | Inactive source; retained for reconciliation |
| Contrast Therapy- 30 minutes | Contrast Therapy | Inactive source; retained for reconciliation |
| Contrast Therapy- 30 minutes | Core Modalities | No approved booking/resource policy mapping |
| Single Service | General Services | Inactive source; retained for reconciliation |
| Zinc | Add On Service | Add-on association and clinical approval required |
| Operator IV | Core IVs | No approved booking/resource policy mapping |
| B12 Shot | Vitamin Shots | No approved booking/resource policy mapping |
| 250mg | NAD+ Therapy | Inactive source; retained for reconciliation |
| Hydration IV | Core IVs | No approved booking/resource policy mapping |
| B12 | Add On Service | Add-on association and clinical approval required |
| Contrast Therapy 1 Guest Pass | Add On Service | Add-on association and clinical approval required |
Membership policy gaps
Elite Founding Member
- Included-service quantities and rollover are absent from export
- Reconcile shared guest passes and shareable=false
- Preserve membership IDs, balances and versioned next-renewal fixes
- Membership agreements disabled in source; approved agreement required
- Confirm 40% promotion eligibility, remaining months and renewal price
Unlimited Elite Recovery
- Included-service quantities and rollover are absent from export
- Reconcile shared guest passes and shareable=false
- Preserve membership IDs, balances and versioned next-renewal fixes
- Membership agreements disabled in source; approved agreement required
- Approve daily limits; unlimited guests and medical benefits remain disabled
Essential Recovery
- Included-service quantities and rollover are absent from export
- Reconcile shared guest passes and shareable=false
- Preserve membership IDs, balances and versioned next-renewal fixes
- Membership agreements disabled in source; approved agreement required
Essential Founding Member
- Included-service quantities and rollover are absent from export
- Reconcile shared guest passes and shareable=false
- Preserve membership IDs, balances and versioned next-renewal fixes
- Membership agreements disabled in source; approved agreement required
- Confirm 40% promotion eligibility, remaining months and renewal price
Core Founding Member
- Included-service quantities and rollover are absent from export
- Reconcile shared guest passes and shareable=false
- Preserve membership IDs, balances and versioned next-renewal fixes
- Membership agreements disabled in source; approved agreement required
- Confirm 40% promotion eligibility, remaining months and renewal price
Essential Founding Member 60 min Contrast Only
- Included-service quantities and rollover are absent from export
- Reconcile shared guest passes and shareable=false
- Preserve membership IDs, balances and versioned next-renewal fixes
- Membership agreements disabled in source; approved agreement required
- Confirm 40% promotion eligibility, remaining months and renewal price
Core Recovery
- Included-service quantities and rollover are absent from export
- Reconcile shared guest passes and shareable=false
- Preserve membership IDs, balances and versioned next-renewal fixes
- Membership agreements disabled in source; approved agreement required
Cutover guardrails
No production import, customer data, verified rollback or cutover approval
- Resolve unmapped services, categories, product entity allocations and add-on query errors
- Approve prices, durations, room inventory, medical routing and nurse coverage
- Keep custom memberships and membership fixes as versioned proposals
- Client, appointment, payment and ledger migration needs separately approved scope; none included here
- Verify full pagination and source snapshot freshness before cutover
- Reconcile durable target counts and checksums, rehearse restore, obtain operational sign-off
Synthetic failure and rollback rehearsal
Run a mapping rehearsal
Built-in migration rehearsal rows · real SHA-256 comparison · no file upload or import
Legacy count-only simulation and runbook
Boulevard migration rehearsal
Migration counts and checksum review · no cutover without approval
| Entity | Source → Target | Checksum | Exceptions | Status |
|---|---|---|---|---|
| Fictional clients | 6 → 6 | Match | 0 | Reconciled |
| Memberships | 4 → 4 | Match | 0 | Reconciled |
| Appointments | 11 → 10 | Mismatch | 1 | Review required |
| Waiver references | 20 → 20 | Match | 0 | Reconciled |
Counts, checksums, exceptions and rollback must all pass before review. Cutover is always disabled. No data is imported, exported or deleted.