...
Integration of r_keeper 7 and StoreHouse 5 is realized via the QUSH utility. The utility connects to the SQL database and gets the information on r_keeper 7 references and sales from there!. Any database can be used:
- MS SQL
- PostgreSQL
QUSH server service is installed alongside StoreHouse, its port is Upon StoreHouse installation, QUSH server appears on the computer, as a service operational at port 8087.
To integrate StoreHouse _ 5 and r_keeper _ 7 bases, open Qush_Manager utility. Default The default user is Admin, no password is needed.
Enter Go to File > Associations with с Links to R_keeper menu.
Right-click in the left field and select Create.
Then, Specify the name of the connection.
A window will appear to associate connect StoreHouse 5 and your SQL database.
Go to the Databases tab and fill in the fields.If
StoreHouse 5 section:
- Server — specify your local IP if StoreHouse 5 and r_keeper
...
- are installed
...
- on one and the same computer
...
- . Otherwise, specify the IP of the corresponding computer.
- T cp/ip port — specify the port of your SH5 server.
...
- The default one is 7771.
- User — specify the SH5 login. The default one is Admin.
- Password — specify the SH user password. By default, no password is needed.
R_keeper 7 section:
- СУБД (DBMS) — select the database management system connected to r_keeper 7. The article describes connection via MS SQL but PostgreSQL may also be used.
- Server — specify your local IP if StoreHouse 5 and r_keeper are installed on one and the same computer. Otherwise, specify the IP of the corresponding computer.
- Database — specify the name of the MS SQL database
- User — specify the DBMS user login
- Password — specify the DBMS user password.
Click Check In Database, User, Password field, specify your SQL database user credentials. Then, press Check button to make sure you are connected to both DBsdatabases. Press Save. Then, click Save.
These are all technical settings. Now, move to detailed import settings.
Detailed Settings
Go to Restaurants tab, and press Update. Upon update completion, lists click Refresh. After that, the list of your restaurants from the r_keeper database will be accessibleappear.
You can select either all restaurants , or the restaurants with the same franchise or concept, or . Or just select the required by first selecting Selected only item.ones, if you choose the Selected only item.
Click Press Save and move to Sales pointsOrder categories tab.
Either Select all or separate (e. g., bar) sales points can be selected at this tab. Sales points and settings thereof can be viewed in R-Keeper 7 the categories or only the required ones. Find the order categories and their settings in the r_keeper manager station.
Press Save and move to Correspondents tab. The desired way of download can be selected here:
By currency groups
By currencies
By delection reasons
Click Save.
On the Correspondents tab, select desired way of data downloading:
- by currency groups
- by currencies
- by reasons for deleting
Click Press Save and move to ReferencesDirectories tab.
Select restaurant menu groups. If there are none, they can be created directly in QUSH. To do so, press click the square button with dots.
The Create group window will appear. Name it, and name Specify the group name and modifiers group name. Press ОК.
You can decide If needed, you may choose by which product goods category the data download shall be performed. See Here is the standard set of categories below:
Not specified — default value
...
Service
...
print — orders
...
grouping by printers for cooks.
Classification — orders grouping (cold, hot, etc.)
Cashiers
...
ratings — orders grouping in accordance with amounts rating per employee
Groups for KPI
...
-analytic — orders grouping in accordance with KPI analytics groups. Groups are specified manually.
All product goods categories can be created and viewed in the r_keeper manager station.
Then, you can select the way to filter the references:
...
By schedules Schedules are created inside R_Keeper manager station together with time-dependent promotions
if needed, check the following items:
- Export dishes with an unspecified price
- Export of pre-payment to requests
- Tax calculation using r_keeper.
Then, you should choose if to take into consideration VAT and sales tax, specified in the r_keeper manager station.
Click Save.!
...
Then, you can mark with ticks if meals without price shall be downloaded, if pre-payments shall be downloaded to requests, and if taxes shall be calculated in accordance with r_keeper settings or StoreHouse 5 setting.
Then, specify if VAT and Sales Tax specified in r_keeper manager station shall be accounted.
...