Sage 50 CA XML

Note

This is a preview of the Sage 50 Canada connector.

The Zynk connector for Sage 50 Canada v2023.2 will be released in the coming months.

To integrate with Sage 50 CA using Zynk you will need to import and export data using the appropriate XML format. The format for each of our imports into Sage CA is documented on the pages listed below. For exports, please refer to the samples provided on the documentation for the task.

Note

If you are using the UK version of Sage 50 please see Sage 50 UK XML. If you are using the US version of Sage 50 please see Sage 50 US XML.

External Id

The ExternalId field is used when importing data, and should be the unique id of the record from the third party system you are importing from. For example if you are downloading orders from a website this should be the id of the order from the websites database. This field is used to track which records have been imported by Zynk to prevent duplicate data entry.

Errors

The fail file produced by our import tasks will contain details of the error that caused the record to fail to import into Sage. The following is an example of errors will appear in the XML.

<?xml version="1.0" encoding="utf-8"?>
<Customers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Customer>
    <ExternalId>1234</ExternalId>
    <Errors>
      <Error>
        <Name>Pre-validation</Name>
        <Description>Name is a required field for customers, and it couldn't be determined based on ExternalId or the Match Fields task setting.</Description>
      </Error>
    </Errors>
  </Customer>
</Customers>