Import Products to Sage Business Cloud Accounting
The Import Products task will create new and update existing non-stock items in Sage Business Cloud Accounting. The product data must be provided in the Sage Accounting Product XML format.
See Import Stock Items to Sage Accounting for importing stock items into Sage Business Cloud Accounting.
Settings
Sage Business Cloud Accounting Connection
Required
The connection to Sage Business Cloud Accounting to use. See Connecting To Sage Business Cloud Accounting if you require more information on how to create/manage connections.
Fail File
Required
The name of a file for "failed" imports to be sent to.
Input File
Required
The source file that you want to import in Sage Business Cloud Accounting XML format.
Success File
Required
The name of a file for "successful" imports to be sent to.
Prevent Reprocessing
Required
Set to true to prevent the same record being processed more than once. This will only work where an external_id
is provided for a record in the input XML file.
Zynk Settings
Example
A sample input file is shown below. See Sage Accounting Product XML for full documentation of the XML.
<?xml version="1.0" encoding="utf-8"?>
<sage_one_company xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<products>
<product>
<item_code>PENCILS</item_code>
<description>50 Coloured Pencils</description>
<sales_ledger_account>
<nominal_code>4000</nominal_code>
</sales_ledger_account>
<purchase_ledger_account>
<nominal_code>5000</nominal_code>
</purchase_ledger_account>
</product>
</products>
</sage_one_company>