Sharifah Food is a food processing company that specialises in the ready meals market. Over the years, Sharifah Food had to manually take orders from its customer through WhatsApp and record the sales data in Excel sheets. Nevertheless, it was discovered that it became difficult to keep track of all sales, orders, and inventory as the company grew. Therefore, this project aims to implement a web-based computerised inventory management system that helps the company streamline the inventory management process.
Sharifah Food applies Multi-level Marketing (MLM) system to sell its products. The customers can apply as agents or dropshippers to promote and sell the company's products by purchasing the products at discounts. For instance, an agent and a dropshipper can receive 30 percent and 20 percent discounts, respectively, if they order a large quantity of products.
NOTE: This project is only for demonstration purposes. Please do not enter any sensitive information on the website.
https://fyp-shrf.herokuapp.com/
Username: uattester
Password: Testing@123
-
Login
The admin is able to log in to the inventory management system by entering their username and password. -
Profile Management
The admins can manage their profiles and change their current password, phone number, email, gender, etc. -
Product Stock Management
The admin can manage the product inventory, such as add new products, add new stocks to the products, modify the product information, remove the existing product, and check the products’ information. -
Promotional Packages Management
The admin can manage the promotions by adding new promotional packages as well as modifying and deleting the existing promotional packages. -
Order Management
The admin can view all orders from direct customers, agents and dropshippers. In addition, the admin can update the status of each order or even cancel the customers’ orders. -
Agent and Dropshipper Management
The admin can view the lists of agents and dropshippers and their respective orders to confirm their sales performance. In addition, the admin can also view, accept and reject the applications of the agents and dropshippers. -
Shipping Fee Management
The admin can add, edit, delete and view the shipping fee in different states. Besides, the admin can customize the shipping fee for different weight ranges. The shipping fees added will be applied to the total order amount when the customers place an order. -
Pickup Location Management
The admin can add the pickup location for the placed orders. This allows the customers to choose whether to ship their orders to their addresses or pick up the order at the pickup location. -
Discount Management
The admin can manage and create discount codes that can be applied while making payments on the e-commerce platform. The discount can be specified either as a percentage or a fixed amount and is customizable for various criteria such as minimum order spend, a maximum discount, customer eligibility, etc. -
Business Insights
The admin can view the sales analysis to gain more insight into the company's business performance. Sales and inventory analyses are crucial for the business as they help cut unnecessary costs and predict the demand for products. There are many inventory analyses such as ABC analysis, HML analysis, SS analysis, EOQ analysis, etc. This system uses these analyses to provide the information for better inventory control on Sharifah Food. -
Invoice Generator
The admin can generate an invoice for each order placed by a customer. -
Sales Report Generator
The system can generate a sales reports in Excel format at the admin’s request. -
Email Notification
Email notifications automatically alert the admin when new orders are placed,products are in low stock, or pending approvals for the registrations for agent and dropshipper.
- Django (Python)
- React TypeScript
- PostgreSQL (with Heroku)
- Redis (with Heroku)
- Cloudinary
- Gmail SMTP
- Ant Design
- LESS
- Heroku
- Figma
https://tinyurl.com/FYPInvMgmtSysPrototype
- SQL Database
- Cloudinary Account
- SMTP Account
- Redis
- Python 3.10.2
- Yarn
- Install the frontend packages using yarn.
yarn install - Install the backend packages using pip from requirements.txt.
pip install -r requirements.txt - Create .env to configure environment variables as follows:
ALLOWED_HOSTS=<any hosts seperated by ","> ('127.0.0.1,localhost') CORS_ORIGIN_WHITELIST=<any origin seperated by ","> ('http://localhost:3000,http://127.0.0.1:3000') CSRF_TRUSTED_ORIGINS=<any origin seperated by ","> CLOUDINARY_NAME=<your cloudinary name> CLOUDINARY_API_KEY=<your cloudinary api key> CLOUDINARY_API_SECRET=<your cloudinary api secret> DATABASE_NAME=<your database name> DATABASE_USER=<your database user> DATABASE_PASSWORD=<your database password> DATABASE_HOST=<your database host> DATABASE_PORT=<your database port>' DEBUG=True EMAIL_HOST_USER=<your email to send notification> EMAIL_HOST_PASSWORD=<your email SMTP password> REDIS_TLS_URL=<your Redis TLS url> REDIS_URL=<your Redis url> SECRET_KEY=<django app secret key> WKHTMLTOPDF_BINARY='wkhtmltopdf-pack' - Migrate your database.
python manage.py migrate - Build the React App using yarn.
yarn build - Run the server.
python manage.py runserver
- Login
- Dashboard
- Product Management
- Promotional Packages Management
- Order Management
- Customer Management
- Agent/Dropshipper Registration Management
- Shipping Fee Management
- Pickup Location Management
- Voucher Management
- Business Insights - Statistics
- Business Insights - Inventory Analysis
- Profile Management
- Account Settings
- Invoice Generated
- Notification
https://tinyurl.com/YJFYPPOSTER
Thanks goes to these wonderful people (emoji key):
 Tan Yuan Jie ️️️️♿️ 💬 🐛 💻 🔣 🎨 📖 📋 🤔 🚇 🚧 🧑🏫 📦 🔌 📆 🔬 👀 🛡️ 📢 |
This project follows the all-contributors specification. Contributions of any kind welcome!