DiGiStore: Inventory Management & ledger Control System for Retail Store
Nowadays everyone wants that technology can help them to make them work easily. So as an IT student I made one simple project which can help to maintain the inventory and transactions between Customers, Suppliers, and Shopkeepers without any paperwork.
What is inventory management?
In simple words, Inventory Management comprises the storage and processing of raw materials, components, and completed products, as well as the administration of raw materials, components, and final products.
An inventory system’s main function is to keep track of your products and supplies. When you buy inventory, you need to keep track of when you bought it, when you sold it, and how much you have on hand.
To make a change and provide easiness in these activities, an application of computerized inventory management should be done. Through this, every inventory management would be much easier and will not require a lot of effort.
Purpose:
The main purpose of this project is to make the tasks easy for the shopkeeper as well as for the customer. Customers, Suppliers, and Shopkeepers will manage their activities using this single web application. This will also manage every record and inventory transaction for important purposes.
Requirments
I had used the SQL database for storing data and I made this web app using ASP.NET (C#). My web application is responsive to all devices. First, I have made tables in the database to store specific data.
Database
There are a total 12 Datatables that will store all the data for this Web App. The following diagram will show you how data is stored in the 12 tables.
Functionalities
This Web Application has basically 3 types of users. Customers, Admin, and Shopkeepers. This Web Application provides the following Functionalities according to the type of user.
1. Functionalities of Admin
- Dashboard (Number of Shops registered with this ‘DiGistore’ Web Application)
- Add New Shops
- List of Shops
2. Functionalities of Shopkeeper
- Dashboard (Total Sales, Total Receivable Amount from Customer, Unpaid Amount to Supplier, Total Suppliers, Total Products, Current Stock Value, Out of Stock Products)
- Add New Customer
- Customer Purchases ( invoice generation)
- Product ( Add new Product, Delete any Product, List of Products)
- Supplier ( Add new Supplier, Delete any Supplier, List of Suppliers)
- Stock (Add Stock, Availability of the Stock)
- Balance Sheet ( Excel sheet will be generated with all the transactions between given duration.)
- Email Notification will be sent to the Customer and Supplier.
3. Functionalities of Customers
- Dashboard (Total Purchased Items, Total Amount, Total Remaining Amount)
- Purchase History
Login page
There is a total of 3 login pages.
Admin Login
Shopkeeper Login
When an admin adds any new shop at that time one unique Shop Id will be generated automatically. The shopkeeper will receive that Shop Id via Email.
Customer Login
When Shopkeeper adds any Customer at that time one unique Customer Id will be generated automatically. The Customer will receive that Customer Id via Email.
Admin Panel
As I mentioned above Admin can add any new shop by entering some basic details related to that particular shop and also admin can see the list of shops.
Dashboard
Admin can see the number of shops that are registered with the DiGiStore with details of each shop.
Add New Shop
From the below Page admin can add a new Shop.
List of Shops
From the below Page admin can see the list of shops.
Shopkeeper Panel
Dashboard
Here you can see that This is the dashboard of the Shopkeeper panel. This dashboard is totally dynamic means if you add or remove any Data from the database then change will be reflected into the dashboard card. This Dashboard will show you the following details.
Total Sales, Total Receivable Amount from Customer, Unpaid Amount to Supplier, Total Suppliers, Total Products, Current Stock Value, Out of Stock Products.
Add New Customer
The shopkeeper can add any new customer by entering the basic details of the customer. Here Unique Customer Id will be generated for each customer automatically. They will get their Customer Id and login credentials via Email.
Customer Purchases ( invoice generation)
The main purpose of this page is to generate the invoice by adding purchase details into the Database. Here I use the concept of autofill i.e, If the Shopkeeper selects the customer’s phone number then the remaining details will be fetched from the database automatically.
Once the shopkeeper will select any customer’s phone number the previous remaining amount will be fetched from the database and it will be added to the total amount of the current bill.
Here I also added a dynamic textbox so that shopkeepers can add multiple products at a time.
After entering the purchase details invoice will be generated and the shopkeeper can print it.
An email has been sent to that particular Customer after the generation of an invoice.
Product ( Add new Product, Delete any Product, List of Products)
Shopkeepers can add any new product to the database just by entering the basic details.
Shopkeepers can Remove any new product from the database.
The shopkeeper can see the list of products that is available in the database.
Supplier ( Add new Supplier, Delete any Supplier, List of Suppliers)
Shopkeepers can add any new Supplier to the database just by entering the basic details. Here Unique Supplier Id will be generated for each Supplier automatically.
Shopkeepers can Remove any Supplier from the database.
The shopkeeper can see the list of Suppliers that is available in the database.
Stock (Add Stock, Availability of the Stock)
Shopkeepers can add a stock to the database just by entering the basic details.
The shopkeeper can see the list of products and their stocks that is available in the database.
Balance Sheet
The shopkeeper can generate the balance sheet by selecting the duration. Excel sheet will be generated after clicking the download button. Shopkeepers can generate different sheets for the Customer side as well as the Supplier side.
Email Notification will be sent to the Customer and Supplier.
Customer Panel
Dashboard
The customer dashboard will show the following details.
- Total Purchased Items, Total Amount, Total Remaining Amount.
Purchase History
Customers can see their purchase history from the following page.
Further Enhancements:
I will add one feature to this ERP. Whatsapp support.
- Whatsapp support: When customers purchase anything from a particular shop after the successful invoice generation they will get their invoice by WhatsApp. Also, they get a notification regarding their pending amounts. Similarly, shopkeepers also get notified when they add new stock to their shop.
Conclusion:
So, this ERP will manage the resource and the data of Retail Shops easily. This ERP-suite helps the users to maintain their ledger accounts of their customers digitally so no need to maintain papers and write everything.
