IQ Retail eCommerce Integration

The eSolve system has been integrated to the IQ Business and IQ Enterprise accounting / ERP software packages. This means that if you have a retail or wholesale outlet and want to integrate your IQ system to a website for online sales or live catalogue, things just got a whole lot easier.




We currently offer two methods of integration to the IQ Retail software platform ( IQ Business, IQ Enterprise ).

1. Simple stock extraction with manual order capturing.

This option utilizes a software application developed in PHP that is installed on your IQ Server. This software in turn extracts data from the IQ database via an ODBC driver. Items are then pushed to the website allowing details such as the stock code, product name and description, stock onhand, pricing and even the stock images. Stock images are updated via FTP service. Updates are scheduled via Windows task scheduler. This integration is ideal for clients that require a simple cost effective integration.

2. Complex integration via the IQ API ( Application Interface )

This option utilizes our Java based eSolve Update Center software that in turn communicates with IQ via the IQ API. This integration has the advantage that you can import the Sales Orders placed online via the eSolve website directly into IQ Retail (Business or Enterprise). The software package has a built in task manager that allows it to run more frequently. It can be configured as a windows service for full automation. This integration method uploads stock images from the IQ database directly to the website via a web service thus eliminating the need for an FTP account and related firewall configurations required on the IQ server.

What data can be synchronized:

  • Stock details such as stock code, stock name, extended description, pricing, stock onhand and images can be placed online.
  • Client accounts can also be synchronized.
  • Stock Images as defined in the IQ system.
  • Sales Orders.

This method required the IQ API that can be purchased directly from IQ Retail. The IQ API has a monthly subscription fee of R 500 p/m payable to IQ by means of debit order.

If you want to take your IQ products online, please contact us for further details or view our eCommerce templates here.

View Our Templates


Advantages of Accounting system integration:

  • Maintain stock inventory in the accounting system only. Reduces the headache of maintaining or synchronizing stock databases in the accounting stock system and an eCommerce website platform. Website management is reduced dramatically.

  • Give website visitors a fairly accurate idea of your product stock levels & availability as well Out of Stock items.

  • Manage eCommerce website orders in the accounting system as Customer Sales Orders. The administration overhead of data capturing website orders is reduced dramatically, especially loading orders line item for line item. It also reduces the chance of data capture errors.

  • Synchronize client (debtor) accounts directly to the website and in turn link web users to their corresponding client accounts. When transactions are then processed on the system, the correct account number is applied allowing purchases on credit for the specified account.