Skip to content

Magento V2 & Sage 50 solution

This solution enables you to import customers, products, orders and from Magento into Sage, despatch Sage orders one they've been shipped in Magento and update Magento with Sage stock levels.

sequenceDiagram
    Magento ->> Zynk: Export 'Processing' Orders
    Zynk ->> Sage: Import Customers
    Zynk ->> Sage: Import Products
    Zynk ->> Sage: Import Orders

    Zynk ->> Magento: Update Orders

    Magento ->> Zynk: Export 'Complete' Orders
    Zynk ->> Sage: Despatch Orders

    Sage ->> Zynk: Export Stock Levels
    Zynk ->> Magento: Import Stock Levels

Settings

Setting Name Default Description
StoreViewCode default
SourceCode default
BankAccountGBP The Sage bank account to use for GBP payments
BankAccountEUR The Sage bank account to use for EUR payments
BankAccountUSD The Sage bank account to use for USD payments
WebSalesAccountOnly False If False, Zynk will match/create customers based on their email. If True Zynk will use the order currency to match to the Web Sales Accounts below
WebSalesAccountGBP WEBGBP Sage account for GBP orders when WebSalesAccountOnly is set to TRUE
WebSalesAccountEUR WEBEUR Sage account for EUR orders when WebSalesAccountOnly is set to TRUE
WebSalesAccountUSD WEBUSD Sage account for USD orders when WebSalesAccountOnly is set to TRUE
OrderNominalCode When set, all orders will be placed against this nominal

Requirements and Assumptions

  • It is assumed that the standard Magento order statuses are used
  • The solution will only process orders from a single store in Magento
  • The solution will only update the stock levels for a single source. It is assumed that this source is is linked to the Magento store that the orders are being exported from.

Connecting to Sage 50

To connect to Sage 50, Zynk will require a Company DataPath along with a username and password for logging into Sage 50.

Please refer to our Sage 50 article for more information on creating a Sage 50 Connection.