Integration with R_keeper 7 via PostgreSQL

StoreHouse 5 supports importing data from PostgreSQL.

Setting up Connection with R_keeper 7

Install and configure PostgreSQL before configuring import from r_keeper 7.

To integrate with StoreHouse 5, make additional settings in the PostgreSQL driver:

1. Download x32/86-bit ODBC driver from the official site

   

   Do not use the x64 bit ODBC driver.

2. Run odbcad32.exe

3. On the User DSN tab, click Add. In the window that opens, configure a new data source:
   
   

   

   1. Select PostgreSQL Unicode and click Finish
      

      

      
      

   2. In the connection settings window, specify:

      • Data Source — any name of the created source

      • Database — the name of the created database in PostqreSQL

      • Server — the IP address of the PosgreSQL server

      • User Name — the name of the created database user

      • SSL Mode — allow encryption, leave Allow

      • Port — the connection port

      • Password — the password of the database user.
        

        

   3. Click Test to test the created connection
      

      

   4. Click OK, then Save.

4. Go to the System DSN tab and repeat the steps from step 3

5. Set up connection between r_keeper 7 and PostgreSQL. Export data to SQL
6. Check that the settings are correct and the connection is established. After a successful import into the database, the GLOBALSHITS table should contain all closed shifts.
   

   

7. After that, go to the QushMan app. Create and configure connection with r_keeper 7.
   Select Postgres database as data source. Fill in the required parameters:
   

   

   
   Now data from r_keeper 7 will be uploaded to StoreHouse 5.
8. Make a primary import. Click Start on the Jobs tab.
   

   

9. In StoreHouse, go to Documents > Requests > Apply. You will see all imported orders.
   

   

10. The technical settings for communication with r_keeper are now complete. You can move to the detailed import settings.

Detailed Settings

Go to Restaurants tab, and click Refresh. After that, the list of your restaurants from the r_keeper database will appear.

You can select either all restaurants or restaurants with the same franchise or concept. Or just select the required ones, if you choose the Selected only item.

Click Save and move to Order categories tab.
Select all the categories or only the required ones. Find the order categories and their settings in the r_keeper manager station.

Click Save.
On the Correspondents tab, select desired way of data downloading:

• by currency groups
• by currencies
• by reasons for deleting
  

  

Click Save and move to Directories tab.

Select restaurant menu groups. If there are none, they can be created directly in QUSH. To do so, click the square button with dots.

The Create group window will appear. Specify the group name and modifiers group name. Press ОК.
If needed, you may choose by which goods category the data download shall be performed. Here is the standard set of categories:

1. Not specified — default value

2. Service print — orders grouping by printers for cooks.

3. Classification — orders grouping (cold, hot, etc.)

4. Cashiers ratings — orders grouping in accordance with amounts rating per employee

5. Groups for KPI-analytic — orders grouping in accordance with KPI analytics groups. Groups are specified manually.

All goods categories can be created and viewed in the r_keeper manager station.

Then, if needed, check the following items:

• Export dishes with an unspecified price
• Export of pre-payment to requests
• Tax calculation using r_keeper.

Then, choose if to take into consideration VAT and sales tax, specified in the r_keeper manager station.

Click Save and go to Autorun tab.
Configure the criteria and time of automatic data import from r_keeper.

Here you can configure the start time, specify the period for which import shall be performed, and allow automatic and online write-off.

• Automatic write-off: the system automatically generates delivery notes based on an imported request in accordance with preset rules. Thus, not only the request will be loaded automatically according to the schedule, but all delivery notes for its processing will also be generated. If sets are reconciled and necessary goods quantity is entered into books, the delivery notes will be generated correctly. If there is a lack of goods, delivery notes will be created with compensation records which can be changed later. If the request cannot be processed, an error record will be generated.

• Online write-off: when the box is checked, data import from r_keeper 7 will be performed online — when the bill is paid at the cash register, sold items writing off takes place in StoreHouse in a few minutes. If delivery notes need to be generated based on imported requests, the Automatic write-off box should be checked. The request for r_keeper data is performed every 5 minutes.

Check the Notify by e-mail with errors box to receive notifications in case of import errors.

Click Save and move to the Notifications tab.

On the Notifications tab, configure e-mail notifications. In the left window, enter the parameters of the e-mail from which mailing will be performed. On the right side, specify the recipients.

Press Check to send a test email. Then, click Save.