SimplyWise is an inventory management software/web app that centralizes customer records, transactions, inventory, and billing. It helps business owners efficiently manage operations, monitor sales, and track inventory for small to medium-sized stores.
Technologies used:
- Python
- SQL
- Eel (Python web framework)
- HTML, CSS, JavaScript
- Customer & Transaction Management: Manage customer details and track transaction history.
- Inventory Control: Monitor stock levels and get low-stock alerts.
- Analytics & Reporting: Visualize sales trends and analyze customer behavior.
- Billing & Invoicing: Generate invoices and manage payment records.
- Task Management: Organize daily tasks and set reminders.
- User Access Control: Define roles and permissions for team members.
- Dashboard: Overview of sales, recent activity, and inventory alerts.
- My Store: Add/edit products, monitor inventory, and organize categories.
- Analytics: Track sales trends, product performance, and customer demographics.
- To-Do: Create and manage tasks and reminders.
- Users: Manage roles, permissions, and user activity.
- Billing: Generate and track invoices.
- Python 3.7 or higher
- MySQL Server
- Required Python packages:
pip install eel mysql-connector-python
- Install MySQL Server.
- Create a root user with password
root. - The application will automatically create the required database and tables.
- Clone or download all project files.
- Ensure the following directory structure:
SimplyWise/
├── main_sql.py
├── main_web.py
├── web/
│ ├── login.html
│ ├── main.html
│ ├── inventory.html
│ ├── transactions.html
│ ├── todo.html
│ ├── users.html
│ ├── billing.html
│ ├── mainstyle.css
│ ├── mainscript.js
│ ├── Simply.svg
│ └── others/
│ ├── intro.html
│ ├── loginfailed.html
│ ├── style.css
│ ├── script.js
│ └── images/
-
Start the application:
python main_sql.py
This will launch the web interface in your default browser.
-
Default Login Credentials:
- Username:
admin - Password:
root
- Username:
- View key metrics: Sales, Profits, Customers.
- Add custom metrics via the "+" card.
- Edit values by clicking on respective cards.
- View all products with details.
- Add new items using the "+" button.
- Edit quantities and costs by clicking values.
- Delete items using the trash icon or clicking item names.
- Track all customer transactions.
- Add new transactions via the "+" button.
- Update transaction status by clicking status indicator.
- View transaction history with customer details.
- Create and manage tasks.
- Toggle task status by clicking.
- Delete completed tasks using the trash icon.
- Add new tasks with the "+" button.
- Manage user accounts and permissions.
- Add new users with the "+" button.
- Edit passwords and access levels.
- Delete users via the trash icon.
- Create and manage bills.
- Track item prices and quantities.
- Add new billing entries.
- Update prices automatically from inventory.
- Password-protected login system.
- Access level control for users.
- Secure database connections.
- Session management.
- Verify MySQL is running.
- Check credentials in
main_sql.py. - Ensure port 3306 is available.
- Verify if port 8080 is available.
- Clear your browser cache.
- Ensure all web files are in correct locations.
- Reset to default admin credentials.
- Check database connectivity.
- Verify the user table exists.
For additional support or feature requests, please create an issue in the project repository.
This project is licensed under the MIT License - see the LICENSE file for details.
SimplyWise simplifies shop management, allowing business owners to focus on growth and customer satisfaction.
Instructions in PDF
Screenshots:
