Choose the catalog company and the JSON file produced by export-orders-comprehensive. The API records tenant metrics
before and after, runs the importer (with automatic umbrella alignment for Dispatcher visibility), runs the post-import audit, and retries umbrella alignment once if the audit fails.
Requires SUBSCRIPTION_PORTAL_COMPREHENSIVE_IMPORT=1 and a valid IMPORT_DEFAULT_PASSWORD on the API server.
Import running on the server — keep this window open (large bundles may take several minutes).
Completion report
Reverse Imports
Reverses the latest recorded comprehensive JSON import for the selected company: runs the same revert and audit scripts as Rail B operations on the API server.
A time window applies (default 72 hours, TENANT_IMPORT_REVERSAL_MAX_HOURS); after that, or if the tenant gained new orders since the import completed, you must acknowledge risk.
The export file must still exist at the recorded path under the API deployment. Automated checks cover database metrics and a structured surface checklist; full click-through of every Dispatcher and Admin screen is not machine-verified here (use QA or Playwright for that).
Import/Export Zone
Export or import region, zone, and Set Zones skid-rate configuration for a tenant. Use Export to download a bundle from this server, then Import to apply it on another host (or vice versa).
Import applies only what is in the JSON you paste (the first regions[] entry and its zones / zone_cross_skid_rates); to copy 22+ zones from another deployment, paste the full bundle exported from that source—not an older download from this site.
UI settings
Advanced zone pricing (Origin-Dest Matrix, congestion, concentric rings, super-zones) is chosen per tenant from the subscription list Features dropdown. Only one of those models can be active at a time.
Note: Dispatch Regions & Zones only edits map zones (and, when Set Zones is on, the skid matrix). There is no screen yet to edit Origin-Dest Matrix cells, concentric tiers, super-zone maps, or congestion load — those use tenant tables such as dbo.zone_adv_od_matrix (filled via SQL/import tooling). Geocode / order preview can show advanced pricing once zones and matrix rows exist.
Saved.
Import bundle from another host
Paste the JSON from a region-config export (or drop a .json file).
Golden template sync
Copies schema from the master database into the golden tenant DB, refreshes the optional snapshot DB, then overwrites the tenant provisioning .bak. Uses ENABLE_GOLDEN_TEMPLATE_SYNC on the server.
Schema promotion (tenant → master)
Best: migration file on the masterAd hoc: SQL Server Schema Compare
App + schema update (recommended): copies application source to the target, then applies any pending api/scripts/migration-*.sql files that are not yet recorded in schema_migration_history.
Tenant data, passwords, and login_directory on the target are preserved. A files backup is taken on the target first.
FULL OVERWRITE: replaces every ZoneCalc database and all file content on the target with a complete copy of the source server. Use only when you intend to destroy target data and make it an exact clone.
Last sync:••
→
FULL OVERWRITE selected — press Start sync, then you must click the red YES button to proceed.
By using this, you have agreed to overwrite the entire databases and all their content on the target server, click YES to continue
——
Sync logrunning…
Rollback available
Pre-update backups were saved before the sync ran. Click below to restore the target server to its exact pre-sync state.
Recent jobs
Started
Direction
Status
Backup
Backup
Nightly backups to C:\backup\ on this server only (each host runs its own profile after sync deploy).
sbsdispatch.com: SCP, AK (tenant data), Code + SB schema (application code and subscription backend — credentials only in SQL).
fusciadesigns.com: SCP, AK, YLC (code + data), Code + SB schema.
Bundle file names include the server id (e.g. SCP-sbsdispatch.com.bak).
Last result:
Loading…
Calendar: green = last run succeeded, red = failed, outline = scheduled (cron on).