FWS Created an Automated App to Extract Real-Time Sales Data Into the Client's Reporting System

Case Study on App to Extract Real-Time Sales Data

The Client

The client is a leading pharmacy chain which operates stores from some of the major international airports in the world including the pharmacy and cosmetics duty-free store at the Singapore Changi airport.

The Requirement

The client was looking for a custom application development partner who could help them develop an application which would extract complete sales data into their reporting systems. They wanted an application which would convert the data into the required format and insert into the reporting tool.

The Challenges

Our team of application developers had to face a certain number of challenges during the execution of the project. The challenges faced were -

  • The sales would occur on different applications in multiple Point of Sale (PoS) locations in Singapore and Australia
  • There were two separate applications and making them work simultaneously was a challenge

The Solution

After analyzing the requirements carefully, our team of application developers devised the following solution for the client -

  • Our team came up with an innovative idea of building a bridge between the two apps which would extract data from the PoS and send it to the reporting tool
  • We collaborated with the PoS vendor and requested them to save the data in text format and upload it to the server
  • We developed an app using .NET technology which would be used to login into the SFTP server and extract the information
  • The app will extract the information, convert it into the required format, and insert it into the reporting tool
  • The reporting tool will read the data and generate the required reports

The Results

The client was extremely delighted with the working of the application developed by our team. The app operates on its own even at midnight and there is absolutely no need for any kind of human intervention. They were not only impressed by the quality of the application but also the cost-effectiveness of the entire project.

Outsource Custom Application Development to Flatworld Solutions

Flatworld Solutions has been a pioneer in providing quality custom application development services. We have the expertise, skills, and talent to provide a plethora of other software development services. Our team hails from some of the top institutions and are trained to work on several latest tools and technologies and cater to any of the client's requirements. Are you looking for a cost-effective custom application development service provider? Then, you have come to the right place. Get in touch with us today.

Contact Us


Decide in 24 hours whether outsourcing will work for you.

We respect your privacy. Read our Policy.

Info Email


Flatworld Solutions

116 Village Blvd, Suite 200, Princeton, NJ 08540


Aeon Towers, J.P. Laurel Avenue, Bajada, Davao 8000

KSS Building, Buhangin Road Cor Olive Street, Davao City 8000

PARTNER WITH US Read about Partners & Alliances programs at Flatworld Solutions! Read More

3rd Edition Middle East Banking AI and Analytics Summit Read More