Offline point of sale (POS) functionality

This article provides information about offline mode for Modern POS, in which POS devices automatically switch from the channel database to the offline database if the Commerce Scale Unit is unavailable. This article also includes general setup information for offline mode and explains the data synchronization that occurs between the offline database and the channel database.

In Modern POS, a point of sale (POS) device goes into offline mode whenever the Commerce Scale Unit is unavailable. Therefore, if the connection is lost, the POS automatically switches to the offline database.

During a sales transaction, if a data request doesn't succeed within the time-out interval that is configured in the offline profile, the POS automatically switches to the offline database and continues the sales transaction. While the POS device is in offline mode, Rail Modern POS tries to reconnect to the Commerce Scale Unit after the reconnection attempt interval that is configured in the offline profile. This reconnection attempt occurs only at the beginning of a transaction.

Determining the connection mode of Modern POS

The status header in Modern POS indicates the current connection status, and the Connection status window shows the status of the last attempt to sync with the offline database.

Connection status.

Creating a button to manually switch between online and offline modes

You can add a button to Modern POS to manually switch between online and offline modes. Create a button for POS operation 917 – Database connection status. The name of this button is Disconnect when the POS is connected to the Commerce Scale Unit and Connect when it is disconnected. You can use this button to view the connection, and to disconnect from the Commerce Scale Unit or connect to it.

Disconnect button in Retail Modern POS.


To enable offline support for a POS device (register), set the Support offline option to Yes on the Register page. A new channel database entity is created and added to the store's channel data group. Then run all the required distribution schedules to generate the data packages for the offline database. Next, install the offline version of Modern POS. The installation process creates the offline database. Additionally, install a currently supported version of Microsoft SQL Server Express if it is required. (Currently, SQL 2019 is the most up-to-date version available). Offline data synchronization starts after the first sign-in to Modern POS.

Data synchronization

The Commerce scheduler is used to send master data to the offline database. By default, when a distribution schedule is run, data changes are sent to both the channel database and the offline database. Modern POS includes the async sync library, which downloads any available data packages and inserts them into the offline database. If any transactions are created offline, the POS uploads them to the Commerce Scale Unit, so that they can be inserted into the channel database. Offline data synchronization can occur only if Modern POS is running.

Offline synchronization.

Help us understand

We want to learn more about how people use Microsoft's custom Help toolkit. Take the survey (in English) and help us understand: