EuroMusic Sage integration

Web app sample screen shot (click to enlarge)

EuroMusic is a buyer and distributor of professional sound and lighting equipment based in the UK serving numerous retailers.

They wanted to streamline their sales order processing by integrating their inventory and accounts system, Sage Line 50, with a website ordering portal to allow retailers to place orders online and have them fed directly into Sage Line 50.

To achieve this db net solutions developed an online sales ordering web application interfaced with the local Sage Line 50 system using middleware and web services.

The web application incorporates a number of key features:

  • User manager with role based security management.
  • Product management to add categorisation, images and additional product information.
  • Online order submission.
  • Web services to authenticate and receive data from the middleware.

Sage Line 50 MiddleWare (click to enlarge) Sage Line 50 MiddleWare (click to enlarge)

Sage Line 50 allows product data to be accessed via an ODBC interface. The middleware takes this ODBC data and publishes it the remote web application using a secure web service creating a "near live" remote copy of the data.

Sage data flow (click to enlarge) Sage data flow (click to enlarge)

Sales order transactions are handled by the web application which has the ability to export Audit Trail Transactions in a CSV format compatible with Sage Line 50. These are downloaded manually by an administrator and imported into Sage Line 50 using the import Sales Order Transaction function.

If you would like further information on this solution or would like to enquire about your own please contact us.