Every delivery app’s permission surfaces (tenant ops, billing, drivers/couriers, kitchen levels, partners, customers).
Loads from stored credentials (fast). Use Refresh / repair only if a role is missing.
Loading...
DATA IMPORT
Select an operation below.
Company Imports
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
Region & zone configuration is managed in the main Subscription Portal.
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
Confirm app + schema update
Sync progressStarting...-
-
Sync log
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
Live SQL backup of Xpeedite and SBSDispatch on the Hyper-V host, then zip and upload to gdrive:HyperV-Host-Backups/SQL. Always latest for that day. Standby restore is separate (2:00 AM).
Status:-
Loading...
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).
sbsdispatch.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).