We aim to bring the power of cloud computing and analytics to a local shop vendor so as to improve his/her business right through mobile.
Problem Statement
Data is backbone of any successful business, no matter how big or small it is. While big corporate companies rely on mainframe computers for all their data entries and analyze it using complex systems, a shopkeeper on other hand maintains his register with all daily logs in it.
With the advent of Internet revolution and cheap smartphones, a low end shopkeeper can finally afford an efficient system than those registers, which not only are difficult to maintain, but also make analyzing the data nearly impossible.
We, here are maintaining a database for a shopkeeper and providing it as a web service, so that:
- Data entry and maintenance becomes less cumbersome.
- Searching or 'Querying' for particular entries or stock items becomes user friendly and faster.
- Analysis can be done for him by the web service, suggesting him better ways to sell, order, market or invest in his products.
- The shopkeeper can easily maintain his records of items available in his shops, items he sold and the profit or loss earned.
- He can easily analyze the market growth of the products and on the basis of demand and sales from his shops, he can calculate the money to be invested in his shop and many more benefits can be achieved.
- Eventually his business grows and even then the web service can scale up, thanks to presence of efficient database systems.
- Dashboard
- Mobile View
- Future : Compare Prices of products from different vendors
- Future : Auto-fill enteries based on past/filled details
- Future : Predictions, this is bought with this, wallmart-ish!
- Future : Tips to maximize profit
- Future : Edit invoice
- Filter by period
- Add tabs for invoices by shops
- Better filters on analytics, flexible durations
- Better explanation of the tool on front page
- Find more FDs, state them rightly
- Create MySQL Queries for great analytics such as
- Area graph for revenue / profit for give range (weeks, months, years)
- Peak/Crest Points for each Product vs Revenue
- Peak/Crest Points for each Product vs Profit
- Least/Most Sold Product
- Least/Most Profitable Product
- Peak/Crest Points for each Product vs Quantity
- Total Revenue
- Total Profit
- Least/Most Profitable Shop
- Add MySQL Triggers for invoice and item updates
- After insert on invoice_details, update owner_items.quantity for each cart item
- After insert on invoice_details, update invoices.invoice_amount
- Search shops/items/invoices
- Search Engine for products
- Phone numbers
- Edit profile
- Show more of invoice in overview
- Bug with analytics : Shows stuff even when no invoices are there
- Validations at PHP and JS sides
- SQL procedure getOwnerId(invoiceId)
- Refactor SQL analytics queries
- Add From Items Database
- Invoice details
- Use string escaping for mysql queries
- Update operations
- Delete operations
- Profile
- Use knob.js / highcharts etc to show above data
- Working Shops, Invoice and Item addition/display
- Functioning login system
- Deleting an item would affect all the related invoices, which is weird. Although deleting an item would imply that such item was accidently added or is now discontinued.
- Deleting a shop would affect all invoices. Need to give a "backup" feature.