Data Backup & Migration
All core Shopman business data is stored in local SQLite. Shopman currently supports:
- local .db backup
- .db restore
- clearing local data
- cross-device cloud sync
Data Locations
| Type | Path |
|---|---|
| Database | %APPDATA%\com.moyancn.shopman\data\shopman.db |
| Downloaded files | %APPDATA%\com.moyancn.shopman\files\ |
| Window state | %APPDATA%\com.moyancn.shopman\windowState.json |
Backup
Via Shopman (Recommended)
Settings → Data Management → Backup Data → Choose save location → exports a .db snapshot.
Manual File Copy
Close Shopman first, then copy shopman.db to a safe location.
Restore from Backup
Settings → Data Management → Restore from Backup → select the exported .db file
Irreversible
This clears all current data and restores from the file. Cannot be undone.
Migrate to a New Computer
- On old computer: export the .db backup
- Copy the .db file to the new computer (USB / cloud drive)
- Install Shopman on new computer
- Settings → Data Management → Restore from Backup
- All suppliers, SKU bindings, and order history restored
Files Not Included
Downloaded PDFs are not included in the DB backup itself. Copy the files/ directory separately if needed.
Cloud Sync
If you need ongoing multi-device usage rather than one-time migration, use Sync Data.
Entry: Settings → Data Management → Sync Data
Upload to Cloud
- Enter a sync key
- Enter a device label
- Upload the current local snapshot
- Overwrite the cloud version
Download from Cloud
- Enter the same sync key
- Preview added / updated / skipped counts
- Confirm merge into the local database
- The app reloads automatically
Good use cases for cloud sync
- keeping office and home devices aligned
- switching between multiple working devices
- reviewing differences before merging
Clear All Data
Settings → Data Management → Clear All Data → Confirm
This clears all user data such as suppliers, products, orders, and assignments while keeping the database structure intact.