RES3700: Sync Products
Updated over a week ago

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.

In short, you'll need to:

Generate the export files

To get started, open the database software of your preference; the dbisqlc.exe application 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 (

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,

ROW_NUMBER() OVER (PARTITION BY mi_seq ORDER BY effective_from DESC) AS row_num

FROM micros.mi_price_def

) AS price_data

WHERE row_num = 1;

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 ',';

For legacy customers who have used Deliverect's manual v1 combo builder, contact us when you are importing your POS combos for the first time. We will be on hand to review your combos in Deliverect, as you will need to remove the old manually attached combo groups to operate completely with the POS versions.

Bundle 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.

Import the ZIP file into Deliverect

Step 1. Log in to your Deliverect account and select Locations in the sidebar.


Step 2. For your master location, select the Sync products button. If you want to preview the products that will be changed, select the dropdown arrow and choose Sync preview. To replace all products with those in your POS, choose the Force sync option.


Step 3. Select the products.zip button and choose the file on your computer or drag and drop it into the dotted area.


Step 4. Select 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.

Did this answer your question?