1. Home
  2. Knowledge Base
  3. General
  4. Understanding Hybrid Cloud and Local Databases

POS software: web-based and app-based

There are two forms of cloud POS software: web-based and app-based. A web-based POS relies entirely on the magic of the cloud, and is accessed through a web browser. Nothing is local to your operating system, meaning that everything—your inventory, sales data, employee timekeeping, customer information, etc.—is tied up in a system that needs to be in constant communication with the servers hosting your data through an Internet connection. The front end that displays all the information is basically nothing more than a screen that’s showing you what’s really happening somewhere else. Without an Internet connection, the servers don’t receive the request and so all you see is that little “Unable to connect to the Internet” dinosaur. Very few of web-based POS systems use HTML5 and its offline cache capabilities,  so you can continue to ring up sales during an internet outage. Operating during an outage does leave you with very limited functionality, which does not make web-based POS ideal solution for business operations with unpredictable internet connectivity.

On the other hand, WooPOS is a Windows 10 app-based point of sale system, takes a hybrid approach to the cloud. We use the locally-installed Microsoft SQL Express database to mirror the Cloud database. This means that even when your connection to the cloud kicks it, all of your customer data, inventory, employee accounts, etc. are still accessible locally so you’re not losing valuable data during the outage. All the sales and customer data you entered will sync back up to the cloud as soon as the connection is reestablished and you might not even notice that you lost your Internet in the first place. Because WooPOS has a built-in engine to automatically make mirror copies of the full cloud database on the local network, all functionalities will work perfectly when the internet is down. One exception could be the integration of credit card processing if it depends on the internet. Credit Card Imprinter or Offline Credit Card Processing could still store the card information to be processed when it comes back online, but you take the risk of running a purchase on a card that could be declined later. This will not be a problem if you choose not to integrate your credit card processing, or you have a backup phone line to process credit cards.

Cloud Database With Local Mirror Copies

WooPOS shows you exactly how far cloud-based POS software can be developed. This full-featured Windows POS client is quick and painless to install, powerful yet easy to use, and has minimal hardware requirements allowing you to utilize existing hardware. Internet disruptions are no longer a dilemma. WooPOS software works both online and offline utilizing its best in breed Cloud Hybrid technology. POS registers can function offline, store data locally, and synchronize back to the cloud once the Internet connection is re-established. Currently, over 88% of all POS terminals utilize Windows as their main operating system. This is not a step back in technology, but rather providing the answer to all retailers considering the cloud’s burning question “what if my internet goes down?” Enjoy the benefits of web-based POS software without the worry of Internet dependency.

Mode 1: Online Using Local Database

This is the default mode. In this mode, all tills (computers) are connected to a local SQL Express database inside a local-area network (LAN). The local databases will be automatically synchronized to cloud database as long as you have WooPOS running on the computer. You probably won’t notice any difference if the internet is offline. As long as you have internet for a couple of hours once a week, you are all good.

  • Transactions and changes to be seen by other tills on the same LAN: instant
  • Transactions and changes to be seen by other locations or stores: normally 2 to 5 minutes
  • Quick response. No sluggish on the single click
woocommerce-pos-database-online-using-local-database

Mode 2: Online Using Cloud Database

You don’t have to install a database on the local network. Or sometimes your local database server is down for some reasons, WooPOS will automatically connect to cloud database or another available database.

  • Transactions and changes to be seen by other tills on the same LAN: instant
  • Transactions and changes to be seen by other locations or stores: instant
  • Just like all web-based systems, sometimes you may feel sluggish (normally half second to one second) depends on internet speed and cloud database response

woocommerce-pos-database-online-using-cluud-database

Mode 3: Offline Using Local Database

You have a full mirrored copy of cloud database on your local network, all functionalities will work perfectly when you are offline. All data will be automatically merged to the cloud database and the other local databases once the internet is back on.

  • Transactions and changes to be seen by other tills on the same LAN: instant
  • Transactions and changes to be seen by other locations or stores: 10 minutes to a couple of hours after the internet goes online
  • Quick response. No sluggish on the single click

woocommerce-pos-database-offline-using-local-database

Check Synchronization Status

Database synchronization will automatically run in the background when WooPOS is open or minimized. If you find data is incorrect, please check cloud sync status first. Do a database backup and maintenance when exiting POS will help to fix some issues. The maintenance job will check if any problem in the database, verify stock quantities and average costs, and improve database performance. We recommend you do backup and maintenance once a day.

POS cloud-data-sync-done-no-data-changes

 

Was this article helpful?