System Administration

Database cleanup, maintenance tasks, and system monitoring

Back to Main

System Overview

Loading...
Total Orders
Loading...
Processed Files
Loading...
Database Size
Loading...
Customers
System Status

Database Connection

FTP Connection

Shopify API

Last Cleanup: Never

Next Scheduled: Not configured

Uptime: Loading...

Maintenance Tasks

Run system maintenance and diagnostic tasks.

System Health Check

Verify all system components are working properly

Reset Shipping Confirmations

Reset shipping confirmation generation flags

Monitor Product Lookup

Check product lookup performance and cache status

Reset Processing Queues

Reset processing queues and clear stuck items

Database Cleanup

Clean and manage database data with backup and recovery options.

Warning: These operations will permanently delete data from the database. A backup will be created automatically before cleanup.
Clean PostgreSQL Database

Remove all orders, fulfillments, and related data from PostgreSQL database

System Monitor

Real-time system performance and resource usage.

Memory Usage
Loading...
Database Size

Loading...

Current size
Uptime

Loading...

System running
Recent Activity
Loading recent activity...

Backup & Import Management

Create backups and restore databases from backup files.

Database Backups
Loading backups...
Database Import & Restore
Warning: Database imports will completely replace the current database. A backup will be created automatically before import.
Main Database Import

Replace the current main database (db.json) with a backup file. This contains all orders, fulfillments, and system data.

Billing Database Sync

The billing database automatically syncs from the main database. After importing a main database, run this sync to update billing data.

Status: Not synced

Order Error Tracking

Monitor and manage order upload and confirmation errors with automatic cleanup after 7 days.

Loading...
Upload Errors
Loading...
Confirmation Errors
Recent Order Errors
Loading...
Loading errors...
Error Types in Database
Loading error types...
Error Management Actions
Selective Cleanup
Choose a specific error type to remove from the database
Bulk Actions
Remove errors of currently filtered type older than 7 days
Remove all errors older than 7 days

FTP Directory Management

Manage which customer directories are processed or skipped during FTP scanning.

Loading...
Total Directories
Loading...
Active (Processing)
Loading...
Skipped
Customer Directories
Loading...
Loading directories...

FTP User Management

Manage FTP user accounts, passwords, and directory access. Each user gets their own directory structure automatically.

Loading...
Total FTP Users
Loading...
Active Users
Loading...
Recent Logins
Loading...
With Directories
FTP User Accounts
Loading...
Loading FTP users...