ID Interactive agency logo

Setting up synchronisation between SAGE 100 Entreprise i7 and the Prestashop e-commerce solution

Published: 14.01.2016

Last modified: 19.11.2026

Connecting Sage 100 and Prestashop without re-entering data is possible. With Atoo-sync GesCom Pro, your data and e-commerce flows are synchronised automatically for 360° management of your business. Read about our experience.

Mettre en place la synchronisation de SAGE 100 Entreprise i7 avec la solution e-commerce Prestashop

Synchronisation between an ERP such as Sage 100 and an e-commerce solution such as Prestashop makes it possible to automate data flows (products, orders, stock) and improve the overall performance of your business. This type of ERP–e-commerce integration centralises sales management and optimises online sales processes.

Companies using SAGE 100 Entreprise i7 can now set up a fully interfaced e-commerce solution driven from the sales management application, avoiding double data entry and enabling fully integrated management of their sales activity.


Why synchronise Sage 100 with Prestashop?

To ensure perfect synchronisation of data between the Sage 100 software suite and the Prestashop e-commerce solution, an additional "mapping" software must be set up to match the data coming from the two applications. This software is called Atoo-sync GesCom Pro.

The aim of implementing this complete system, i.e. synchronising Sage, Atoo-sync and Prestashop, is to maximise the company's performance through full automation of incoming and outgoing sales flows:

  • from the management system to the e-commerce site (products, prices, customers, stock…)
  • from the e-commerce site to sales management (orders, customers…)

Implementing such an interface can prove difficult given the specific nature of the data coming from the company's information system. This type of solution therefore requires specialists able to work at every level.

The ID Interactive agency was entrusted in 2015 with deploying a Prestashop e-commerce site connected to SAGE 100 Gestion commerciale i7.

Below is our feedback on the project.


Understanding synchronisation between Sage and Prestashop via Atoo-Sync:

interfacer-ses-données-sage-avec-atoo-sync-sur-prestashop (1)


Overview of the solutions

Sage

sage

Sage publishes an integrated management software package (ERP) that brings together all of a company's functional components in a unified database.

In our case, we use Sage 100 Gestion commerciale i7, designed for SMEs.

Main features:

  • Sales management (quotes, orders, invoices)
  • Stock management (receipts, issues, inventories)
  • Purchasing management (suppliers, orders)
  • Dashboards and performance indicators
  • Manufacturing and service management

Atoo-Sync

atoosync

Atoo-sync is a solution for synchronising data between management software and an online store.

We used Atoo-sync GesCom Pro, compatible with Sage 30 and Sage 100.

The solution consists of:

  • a Prestashop module to manage the flows
  • server software connected to Sage to structure the data


Prestashop

prestashop-300x78-300x78
Prestashop is an Open Source solution for e-commerce.

This tool is very popular with French small and medium-sized businesses thanks to its ease of use and low-cost deployment. Modules complement the tool to meet specific needs.

The agency chose to select and offer its client Atoo-sync and Prestashop because these tools have been proven by the web community. The publishers are based in France, which ensures reliable, guaranteed support.

In addition, ID Interactive is a Prestashop partner, and 2 of its team members have completed training at the company's headquarters in Paris.


What are the advantages?

Using this type of synchronisation offers the company many advantages, at several levels.

When building the e-commerce platform:

For an SME wishing to develop an e-commerce business, building a bespoke solution can quickly become expensive and sometimes unsuited to real needs. In our case study, we chose to use existing solutions that simply need to be connected to each other.

It is therefore the "link" between these tools that must be ensured and mastered. Implementation is faster, as the solutions are already proven, configurable and adaptable to the company's needs.

Business perspective:

One of the main benefits is that re-entry tasks are eliminated entirely. All flows are automated and scheduled, enabling continuous data synchronisation between the different systems.

Management of the sales chain is thus optimised, with significant time savings and fewer human errors.


Software perspective:

We use two recognised solutions:

  • Sage, considered one of the most powerful ERPs on the market
  • Prestashop, the e-commerce leader in France

Atoo-Sync plays a key role here as a gateway between these two environments. It allows data flows to circulate while adapting and customising them to the client's specific needs.



Limitations and areas for improvement

The agency found some limitations when interfacing the tools. It is important to note that these limitations do not directly concern the synchronisation itself, but rather the processing and structuring of the data.

Points identified include:

  • Sage does not natively manage product variants. Each variant is treated as a separate product, unlike in Prestashop. Work on the import module's code was needed to integrate these specific features (prices, photos, etc.).
  • If certain data gets stuck, Atoo-Sync's item editor can be used. However, this involves manual intervention, which can limit full automation.
  • Sage only allows one image per item. Additional images must therefore be added directly in Prestashop.
  • Price and product access management may vary between B2B and B2C logic. These specific cases are not always supported natively and require further adjustments.


What are the prerequisites for synchronising Sage and Prestashop?

Before any implementation, it is essential to check:

At solution level

  • SAGE ODBC driver installed
  • Compatibility of Sage and Prestashop versions

At data level

  • Clean Sage database
  • Complete product records
  • Complete customer records
  • Category structure


How does flow synchronisation work?

From Sage to Prestashop

  • Products
  • Stock
  • Categories
  • Price
  • Documents

From Prestashop to Sage

  • Orders
  • Customers
  • Addresses
  • Payments

Some flows require adjustments via Atoo-sync.



Case study

In this section, we will show how synchronisation between Sage and Prestashop via Atoo-Sync works overall.


Prerequisites:

Certain prerequisites are necessary. Before setting up the interface between the solutions, it is essential to check the following points.

At solution level:

  • SAGE ODBC driver of the same version as your Sage Gestion Commerciale
  • The Sage ODBC driver is MANDATORY, even for Sage SQL Server databases
  • Compatibility with Sage Gestion Commerciale versions from v.16.xxx up to i7.xxx
  • Compatibility with PrestaShop from version 1.3.xx up to 1.6.xx


At database level:

  • Clean, structured Sage database
  • Compliant customer record (email, address, phone number…)
  • Complete product record (prices, stock…)
  • Definition of price categories (according to customer types)
  • Sage families interpreted as categories in Prestashop


Understanding the path between flows:

Here are two lists to help you understand how flows(2) pass between each solution:


From Sage to Atoo-sync then Prestashop:

  • Items
  • Items with bills of materials
  • Items with ranges
  • Item families (catalogue)
  • Item glossaries
  • Item photos
  • Linked documents
  • Stock quantities
  • Free item information
  • Quantity discounts

Please note, some flows require the use of Atoo-sync's item editor.


Prestashop to Atoo-sync then Sage:

  • Orders
  • Customer payments
  • Customers
  • Customer addresses


Flow diagram

Summary diagram of product management after an order is placed on Prestashop:

flux-sage-atoosync-prestashop


The tools:

Database in Sage 100 i7:

sage-base-de-donnée

Retrieval of this data in the Atoo-Sync GesCom pro software. It is this item database that is sent to Prestashop:

atoosync-gescom-pro

It is also possible to schedule automated import tasks in Sage or in Prestashop:

atoosync-cron

In Prestashop, the Atoo-Sync module provides the link between the software and the e-commerce solution:

configuration-atoosync-sur-prestashop


What about this solution?

With our solid experience in synchronisation, we can confirm that this type of project should not be taken lightly. A few fundamental prerequisites are needed to avoid going off the rails from the very first imports.


A healthy item database: the essential starting point

"A healthy item database in a healthy site": a phrase often repeated by our project manager, which makes perfect sense in this type of architecture.

It is the starting point that will — or will not — allow you to deploy your sales management solution effectively, without nasty surprises.

It is therefore essential to work beforehand on:

  • product names
  • descriptions
  • variants
  • product photos
  • pricing policy (B2B, B2C, currencies, VAT…)
  • trade discounts according to customer type

A single poorly structured element can lead to cascading complications during synchronisation.


A reliable, high-performance solution for SMEs

The aim is not to frighten you or put you off adopting this type of solution, but above all to give you, based on our experience, the keys to success so you can avoid certain pitfalls. Rest assured, there is currently no better solution offering an interface as flexible and powerful as the one presented in our study. So you have already made the right choice by choosing Sage software (all that remains is to find the contact details of an experienced web provider… just a few more lines to find out).

Indeed, synchronisation between Sage and Prestashop via Atoo-sync is a truly credible solution for SMEs, at a moderate cost (in most cases Sage has already paid for itself within the company, and Prestashop is an Open Source solution with no licence), offering 360° management of their sales activity. The other good news is that you will gain productivity by automating a very large part of your processes (not to mention customer satisfaction and repeat purchases).


What next?

Our web agency in Brittany first studies the feasibility of your project, analyses the structure of your item database, understands your nomenclature and sales strategy… and then handles interfacing your SAGE software with your Prestashop e-commerce solution.

Setting up effective synchronisation between SAGE 100 and your Prestashop store requires a solid architecture; our digital agency can advise you and provide a website quote tailored to this integration.

See also the site built with Sage–Prestashop synchronisation via Atoo-sync