Challenge

The client provides end to end IT solutions - Hardware, Software and Networking - to Retail, Hospitality and Security industries. They offer services such as software development, system acquisition, installations, integration and maintenance to 400 reputed customers countrywide.

With the growing Supermarkets and Malls, where an individual shops every day has led to a need to attract and retain customers by promotions, sales, competitive price and effective management of the associated operations. Our client wanted windows based Point of Sale (POS) System that does not only manage cash collection at counters but also offers a complete solution for managing inventory, warehouse, sales and purchase, accounting across multiple chains.

Key challenges of the project were:

  • A POS system which is available offline as well as online
  • Ability to support multiple branch and chaining concept
  • POS system also requires integration of sales, inventory, purchase, accounting and book keeping functions into one application
  • Live transaction monitoring of different tills from Head Office
Solution

TatvaSoft developed "Supermarket POS" system that is highly effective in managing the retail checkouts with following core functionalities:

  • Facility to synchronize data of multiple branches with head office either online using internet or offline using flash disk, CD or any other media
  • Customer loyalty module involving gift voucher and promotional plan facilities
  • Currency management with exchange rate change effects with one base currency
  • Multi company and Multi Till option controlled by licensing system
  • Multi branches and Multi location support
  • Facility to transfer and manage items between all branches
  • Online authorization options for Purchase Order, Goods Received Note, Purchase Invoices, Price Change, Price List, Credit Customer etc.
  • Online Credit Card verification and payment acceptance to be done
  • Facility to manage multiple price change, short expiry price change and item selling price change
  • Full fledge accounting module with Forex gain/loss calculation and report generation
  • Compliant with Wi-Fi enabled data collectors like PDA for physical stock management
  • Mailbox for every user with popup facility when there is any authorization request
  • Stock valuation on basis of FIFO, Last Cost, and Last Price & Average Cost
  • Barcode and Shelf label printing
  • Orders or quotes can be directly sent to supplier or customer via email or can be printed
  • Stand alone as well as clubbed reports generation of all branches.
  • Reporting facility with option to print, email and export to Word, Excel and PDF
Result

Supermarket POS system provided better picture of product lifecycles, customer buying patterns, seasonal trends, and much more. The system offered following benefits to our client:

  • Simple - POS functions are laid out in an easy to understand manner
  • Efficient - Know exactly when you need to re-order inventory and how much you need to order
  • Convenient - Keep track of sales and inventory data of all your stores at a central location
  • Customizable - Facility to add custom fields and user defined captions which can be used in some printing formats
  • Flexible - Facility to migrate data from MySQL to Free Database and from Free Database to MySQL
Technology
  • Server: Microsoft Windows Server
  • Web Server: IIS
  • Programming Language: VB.Net
  • Database: SQL Server and MSSQL
  • Framework: Microsoft .Net Framework
  • Reporting Tool: Crystal Report