Supermarket POS Using .NET Framework & VB.NET

The Client

Industry: Retail

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.

The Challenges

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
TatvaSoft's Offerings

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
Tools and Technologies
  • Architecture: Client - Server
  • Technologies: Win forms (Microsoft .Net Framework), VB.Net
  • Database: Microsoft SQL Server, MySQL
  • External Tools or Components: Crystal Report
Business Benefits

Supermarket POS system helped retailers in attaining operational efficiency and profitability as well as provided better picture of product lifecycles, customer buying patterns, seasonal trends, and much more. The client realized the following benefits by using this system:

  • Simple: POS functions laid out in an easily understandable manner
  • Efficient: Know exactly your inventory level and re-order right quantity at right time
  • Convenient: Enabled tracking of sales and inventory data of all branches from central location
  • Customizable: Option to add custom defined fields and user defined captions to be used for printing formats
  • Flexible: Facility to migrate data from offline database to online database and vice-a-versa