Sage connector

Sage has specialized in accounting software from the beginning, and has grown rapidly to become a globally recognized player. Listed on the London Stock Exchange in 1989, the software publisher Sage is establishing itself in many countries by acquiring players in the sector and competitors. Sage produces a suite of business management software from the first takeovers, offering a complete technical solution for companies. In 2010 SAGE is the 3rd European player in software sales. In 2011, it claims more than 6 million customers across 24 countries. The explosion of merchant sites has forced companies to look for solutions to integrate information from these new sales channels into their management tools. Today, Sage solutions are distributed in 160 countries.

The wide distribution of Sage management software packages (Sage 50, Sage 100, Sage X3, Sage 100 UK…) and Prestashop, Magento, Shopify and Woocommerce e-Commerce platforms led us to develop an initial configuration of exchanges between the ERP and E-commerce CMS:

– Sending the Sage item catalog to Prestashop, Magento, Shopify or Woocommerce, the “keystone” of identification of an item being its reference, both in Sage and in Prestashop, Magento, Shopify and Woocommerce. The items extracted from Sage to feed Prestashop, Magento, Shopify and Woocommerce are described by reference, designation, base price, VAT identification (in correspondence between Sage and Prestashop, Magento, Shopify or Woocommerce), weight, available stock (either physical stock or forward stock, on a given deposit or by aggregation of all deposits).

– Recovery of customers who have placed an order on the Prestashop, Magento, Shopify or Woocommerce site, either by linking the different delivery addresses to a single generic web client in Sage, or by creating a customer in Sage for each new customer in Prestashop, Magento, Shopify or Woocommerce (separate identifier in Prestashop, Magento, Shopify and Woocommerce).

– Recovery of orders registered on the Prestashop, Magento, Shopify or Woocommerce site, including header information (customer contact details in particular), details of order lines in association with the reference of the article, information on the amount of shipping costs and the possible use of a voucher. This last information (shipping costs and discount vouchers) is retrieved in the form of a specific item line.

– Sending Prestashop, Magento, Shopify or Woocommerce an acknowledgment of receipt of orders correctly integrated into Sage so that at the next extraction of Sage orders, only those that have not already been integrated into Sage are extracted.

In addition to this initial configuration of the Sage connector <-> Prestashop, Magento, Shopify and Woocommerce, other flows can be made with Open Flux, especially in terms of prices, variations, resource files (images, documents, etc …), taking into account payment methods and integration of regulations, interfaces with other solutions such as logisticians or label publishers, etc …