...
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.
...
These are all technical settings. Now, move to detailed import settings.
Excerpt | ||
---|---|---|
| ||
Detailed SettingsGo 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. |
...
Click Save.
|
...
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 ОК.
|
...
All goods categories can be created and viewed in the r_keeper manager station. Then, if needed, check the following items:
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. |
...
Here you can configure the start time, specify the period for which import shall be performed, and allow automatic and online write-off.
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. |
...
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.
...