For the integration of orders into your RES3700 POS, you need to build online menus with categories, products, and modifiers. To start building menus, it is necessary to load product information from your RES3700 into Deliverect. This article describes the process to do so.
In short, you'll need to:
- Run a set of database queries that generate text files containing your product info.
- Compress those files into a ZIP file.
- Upload this ZIP file onto Deliverect.
If you're an existing client and you used to manually recreate combos in Deliverect then contact us first to measure the impact of automatically importing them (a feature introduced on July 2021). If you prefer to keep doing it the old way then you just need to leave out the last 4 (newly requested) tables—relating to combos—from the export. Also, improvements were made during this same period on the way we import modifier/condiment groups; you'll likely only see benefits out of this, but if you were using modifier groups from the POS on your menus, and unsure how this will affect you, just let us know and we'll look at your setup to clarify it.
Generating the export files
To get started, open the database software of your preference; the dbisqlc.exeapplication installed by default with RES3700 is suitable. Run the following queries:
Note: in these queries we're using "c:\micros" as the base export path, but you may want or need a different one depending on your setup. Feel free to change that part; the filename on the other hand should not be altered.
-- ------------------
-- MENU_ITEMS
-- ------------------
SELECT mi_seq,
obj_num,
name_1,
name_2,
maj_grp_seq,
fam_grp_seq,
price_grp_seq,
cond_grp_mem_seq,
cond_req,
cond_allowed,
mi_type_seq
FROM micros.mi_def;
OUTPUT TO 'c:\micros\mi_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- MENU_ITEM_PRICES
-- ------------------
SELECT mi_seq,
mi_price_seq,
preset_amt_1,
preset_amt_2,
preset_amt_3,
preset_amt_4,
preset_amt_5,
preset_amt_6,
preset_amt_7,
preset_amt_8,
preset_amt_9,
preset_amt_10
FROM micros.mi_price_def;
OUTPUT TO 'c:\micros\mi_price_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- *
-- ------------------
SELECT mi_type_seq,
name,
tax_class_seq
FROM micros.mi_type_class_def;
OUTPUT TO 'c:\micros\mi_type_class_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- GROUP_FAMILIES
-- ------------------
SELECT fam_grp_seq,
obj_num,
name
FROM micros.fam_grp_def;
OUTPUT TO 'c:\micros\fam_grp_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- TAX_RATES
-- ------------------
SELECT tax_rate_seq,
name,
percentage
FROM micros.tax_rate_def;
OUTPUT TO 'c:\micros\tax_rate_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- TAX_CLASSES
-- ------------------
SELECT tax_class_seq,
obj_num,
name,
ob_tax_1_active,
ob_tax_2_active,
ob_tax_3_active,
ob_tax_4_active,
ob_tax_5_active,
ob_tax_6_active,
ob_tax_7_active,
ob_tax_8_active
FROM micros.tax_class_def;
OUTPUT TO 'c:\micros\tax_class_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- CONDIMENT_GROUPS
-- ------------------
SELECT cond_grp_seq,
name
FROM micros.cond_grp_def;
OUTPUT TO 'c:\micros\cond_grp_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- CONDIMENT_GROUPS_MEMBER
-- ------------------
SELECT cond_grp_mem_seq,
obj_num,
name
FROM micros.cond_grp_mem_def;
OUTPUT TO 'c:\micros\cond_grp_mem_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- *
-- ------------------
SELECT cond_grp_sel_seq,
obj_num
FROM micros.cond_grp_sel_def;
OUTPUT TO 'c:\micros\cond_grp_sel_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- CONDIMENT_GROUP_SELECTION_EXT
-- ------------------
SELECT cond_grp_sel_seq,
cond_grp_seq,
min_val,
max_val
FROM micros.cond_grp_sel_ext_def;
OUTPUT TO 'c:\micros\cond_grp_sel_ext_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- COMBO_ITEMS
-- ------------------
SELECT combo_seq,
combo_grp_seq,
mi_seq,
obj_num,
name,
priority,
ob_rsvd01,
ob_rsvd02,
ob_rsvd03,
ob_rsvd04,
ob_rsvd05,
ob_rsvd06,
ob_rsvd07,
ob_rsvd08,
ob_ac_size,
ob_allow_prev_rnd_acr,
override_level,
mlvl_mask,
scan_placeholder_immed,
ob_force_default_item_confirm,
ob_allow_uncombo
FROM micros.combo_def;
OUTPUT TO 'c:\micros\combo_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- COMBO_MENU_ITEM
-- ------------------
SELECT combo_menu_item_seq,
combo_grp_seq,
mi_seq,
quantity,
ob_default,
preset_amt_1,
preset_amt_2,
preset_amt_3,
preset_amt_4,
preset_amt_5,
preset_amt_6,
preset_amt_7,
preset_amt_8,
preset_amt_9,
preset_amt_10,
vat_txbl_1,
vat_txbl_2,
vat_txbl_3,
vat_txbl_4,
vat_txbl_5,
vat_txbl_6,
vat_txbl_7,
vat_txbl_8,
vat_txbl_9,
vat_txbl_10,
ob_ot01_default,
ob_ot02_default,
ob_ot03_default,
ob_ot04_default,
ob_ot05_default,
ob_ot06_default,
ob_rsvd01,
ob_rsvd02,
ob_rsvd03,
ob_rsvd04,
ob_rsvd05,
ob_rsvd06,
ob_rsvd07,
effective_from,
effective_to,
size_1,
size_2,
size_3,
size_4,
size_1_price_lvl,
size_2_price_lvl,
size_3_price_lvl,
size_4_price_lvl,
print_class_seq,
ob_ot07_default,
ob_ot08_default,
ob_ot09_default,
ob_ot10_default,
ob_ot11_default,
ob_ot12_default
FROM micros.combo_menu_item_def;
OUTPUT TO 'c:\micros\combo_menu_item_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- COMBO_GROUP
-- ------------------
SELECT combo_grp_seq,
ts_style_seq,
name,
obj_num,
hht_ts_style_seq,
ob_combo_dsc_override,
default_color,
com_ts_style_seq,
com_hht_ts_style_seq,
combo_grp_ext_seq
FROM micros.combo_grp_def;
OUTPUT TO 'c:\micros\combo_grp_def.txt' FORMAT ASCII DELIMITED BY ',';
-- ------------------
-- COMBO_SIDE
-- ------------------
SELECT combo_side_seq,
combo_grp_seq,
combo_seq,
side_num,
override_level,
mlvl_mask
FROM micros.combo_side_def;
OUTPUT TO 'c:\micros\combo_side_def.txt' FORMAT ASCII DELIMITED BY ',';
Bundling the files into a ZIP archive
After exporting the files with the queries above, navigate to the output directory and bundle the files into a ZIP archive with the software of your choice (Windows 8.1 and higher support this natively as described here). Do not bundle the folder containing the files, instead bundle the files directly.
Importing the ZIP archive into Deliverect
Step 1. Log in to your Deliverect account and click on Locations in the sidebar.
Step 2. For your master location, click on the Sync products button. If you want to preview the products that will be changed, click on the dropdown arrow and choose Sync preview. To replace all products with those in your POS, choose the Force sync option.
Step 3. Click on the products.zip button and choose the file on your computer or drag and drop it into the dotted area.
Step 4. Click on the Upload button. Your products are now available in your Deliverect account and can be added to menus.
Streamline the export
If you need to do this regularly it may pay off to have a script facilitating the export from the database. You can find attached a working example, but please note it's provided without any warranty, obligation, or instruction on our part. If you cannot have it work and deem it necessary, please contact an IT specialist to adapt it to your setup.