Multiple stores - Simplified

For whom?

This is a simplified setup of LS One for a multistore company.

Items, prices, discounts and so on are controlled in the Site Manager at either the head office level or the store level but the data is always kept at the head quarters.

The terminals still run offiline and data replication will keep them up to date.

In this type of system, you typically have one head office server, the possibility of connection to the back office from the store, and one device for each of the POS terminals. The installation of each store and LS One POS is identical in every way except for the store/terminal ID's they are defined with.

 

Pros

  • Easier data replication as all backoffice data is edited at the Head office.
  • Offline setup - POS terminals not relying on a connection to a database server to be able to sell

Cons

  • All stores work on the same set of back office data.
  • If the store level should be able to view and edit data the head office database server needs to be open for connection.

Before you start

  • Draw up a topology diagram of your machines and note down all the IP addresses / network names, SQL server names, database users and passwords before you start the installation process.

Make sure to take backups of the back office database to an external drive on a regular basis.

Setup for the head office machine/server

  1. Download the installation files of the LS One suite to your machine. The installs are found on the partner portal (login required).

    Here we recommend a full version SQL Server as collecting data from multiple LS One POS and stores will quickly outgrow the size limitation of SQL Express.

  2. Installation:
  3. Run the Site Manager activate your license
  4. If you do not have a database server on your machine you need to install the SQL Express server that comes with your install.
  5. Connect the Site Manager to a data source
    • If you do not have a database you are instructed in how to create one.
    • If you need assistance with creating all the necessary data see Store setup checklist.
    • Before you can configure the Site Service and data replication for your site / store and terminals you must create one site / store and one terminal for each of the POS terminals to be installed.

  6. Configure the Site Service to connect to the head office database on the store server.

    Make sure to use the network name or local IP address of the server in the Site service profile and do not to use localhost because the POS terminals which are not located on the same machine will be using this information to connect to the Site service.

  7. Configure the Data Director and setup the data replication.

    A general distribution location must be created for the head office location.

    Distribution server:

    • Head office machine for the head office location
    • Store server for each of the stores and its terminals. - Each store has its own data director installed so the store locations and the terminals located at each of store will point to the store back office server as a distribution server.

    Distribution locations to be setup: Store location is the back office store server and each POS terminal has its own distribution location that needs to be setup.

Next step is to setup the POS terminals.

Setup for the back office machine/the store server

  1. Download the installation files of the LS One suite to your machine. The installs are found on the partner portal.

    Is there a SQL server or SQL Express installed on the machine?

    If not make sure to download the Site Manager installs that includes the SQL Express server install you need for your machine.

  2. Installation:
  3. Run the Site Manager activate your license
  4. Connect the Site Manager to a data source
    • Connect the Site Manager remotely to the head office database.

Next step is to setup the POS terminals.

Setup for the POS terminals

For each one of your POS terminals do the following:

  1. Download the installation files of the LS One POS to the POS terminal. The installs are found on the partner portal. You may need an install that contains an SQL Express install that is if the SQL server is not yet installed on the POS terminal.

    Is there a SQL server or SQL Express installed on the POS machine?

    If not make sure to download the LS One POS install that includes the SQL Express server install you need for your machine.

  2. Follow the instructions on how to install the LS One POS
  3. To install the SQL express run the LS One POS application . If no SQL server has been setup on the machine the POS will offer to install it when first opened. The procedure will launch automatically. This might tak e a few minutes but the POS will start when it finishes.
  4. Create a new database for the terminal and connect to the correct store and terminal.
  5. Activate the LS One POS license

 

Data replication

Now all applications are installed but no data exists in the stores or POS terminals. The data you created at the head office needs to be replicated from the head office to the store servers and to the POS terminals.

When the terminal databases are ready the store can replicate data to its terminals.

  1. In the Site Manager on the Head office go to Tools > Replication > Job

    If the list of jobs is still empty you can import the default replication data package.

  2. Select the job Preload POS and press the edit button below the job list.
  3. Select the general distribution location for the head office as a Source location and you can create a general distribution location and add all POS terminals to the group. Select this group as the Destination location as shown in this image:

  4. In the Job panel on the right-hand side, select Run job to send the data to the terminal databases.

    Before you run the replication job for the first time you can open the Data Director debugging windows to see what happens when you run the job. Then it is easier to see if everything is setup correctly and the data flows to the correct destination.

    To learn how to debug the data replication read this.

 

When you have preloaded the POS terminals with the data you can test logging into the terminals with any of your users and you can check the connection to the Site service by running the Inventory lookup operation.

Now you are ready to start running LS One for your store. All items, prices and discounts will be created in the back office and the POS terminals are connecting directly to the same database so no data replication is needed.

Transaction replication

When everything has been set up as described above, items can be sold on the POS terminals. All transactions made on the terminals are pulled to the store database for an inventory update and for end-of-day procedures such as statement posting.

To get the transaction from the terminals:

  1. In the store go to Tools > Replication > Jobs.
  2. Select the job Transactions from POS and press the edit button below the job list.

  3. Now you want to replicate from the terminals to the head office so select the POS terminals group as a Source location, and the head office as a Destination location as shown on this image:

  4. In the Job panel on the right select Run job to get all transaction data from all the terminal databases to the store database.

 

Inserted: June 2018
Version: LS One 2018