In the installation we select the Eshop connection to SQL Server.

We make the corresponding queries in the following files in the Reports folder:

Receiving species

sync_connect_products.sql

id Code
name Title
price Value
notes Notes
weight Weight
category category
vat VAT rate
supplierid Supplier Code

Receiving orders

sync_connect_orders.sql

id
date
firstname
lastname
phone
mobile
email
company
occupation
address
city
zip
vat
taxoffice
recipient_lastname
recipient_firstname
recipient_address
recipient_zip
recipient_area
recipient_city
recipient_floor
recipient_mobile
recipient_phone
recipient_email
shipping_method
shipping_cost
payment_method
coupon_title
coupon
discount
package_cost
package_title
doc_title
notes Notes

Get order lines

sync_connect_orderlines.sql

pid Order number
description
quantity
price
vat