...
To integrate StoreHouse 5 and r_keeper 7 bases, open Qush_Manager utility. The default user is Admin, no password is needed.
Go to File > Links to R_keeper.
Right-click in the left field and select Create.
Specify the name of the connection.
A window will appear to connect StoreHouse 5 and your SQL database.
Go to the Databases tab and fill in the fields.
...
- 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.
...
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:
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 goods categories can be created and viewed in the r_keeper manager station.
...
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.
...
Press Check to send a test email. Then, click Save.
Configuring Automatic Write-Off
...
If the import is launched automatically by the system, then, in case of errors during import or write-off, e-mail notifications can be configured. When specially configured, the import server will import data from r_keeper automatically. To do so, specify the settings in Autorun tab.
Run import daily: if this box is checked, data import from r_keeper 7 will be launched automatically every day at a specified time.
Start time: enter the start time of automatic import into this field using the keyboard.
Sales per…: select a day for which sales will be downloaded automatically: Today, Yesterday, or Day Before Yesterday.
...
Select the required period, and press Start.
If all settings are correct, you will see Success in the Result field.
In case of import errors, the import history will look as follows:
To find more about import results or errors, double-click on the required line:
| 
|
If Automatic write-off is configured, logs will contain information on write-off errors.
The list of write-off errors in the log is equivalent to the errors list in the Expected expense generated during manual processing of imported requests.
If necessary, the log can be saved in HTML and XML formats. To do so, open the log, select the Job main menu item, and select the required format.
In the next window, select the place to save the file and change the file name, if needed. Then, press Save.
...