Sage Accounting Product XML
Tasks
- Export Products from Sage Business Cloud Accounting
- Import Products to Sage Business Cloud Accounting
XML
Any Sage Accounting fields not documented below are not supported with our import.
A complete example of the XML is shown below. This represents the minimum information required to create a non-stock product record in Sage Accounting:
<?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>
<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>
Product Identification
The following fields are use to identify the product to create/update. At least one of these fields should be provided. If more than one is provided, Zynk will look for a match based on each field in turn, in the order they are listed below.
Sage Field | XML Field | Example | Field Type | Input | Notes |
---|---|---|---|---|---|
Item Information > Item Code | item_code | PENCILS | string | Optional | |
- | id | 0dfbbb5d174611e691e20a5d7cf84c3e | GUID | Optional | Sage's unique product ID. |
- | external_id | PENCILS | string | Optional | The ID of the product from the source data. |
<?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>
<id>0dfbbb5d174611e691e20a5d7cf84c3e</id>
<external_id>PENCILS</external_id>
</product>
</products>
</sage_one_company>
Product Details
The following product fields can be set using Zynk.
Sage Field | XML Field | Example | Field Type | Input | Notes |
---|---|---|---|---|---|
Item Information > Item Code | item_code | PENCILS | string | Optional | |
Item Information > Description | description | 50 Coloured Pencils | string | Required | |
Item Information > Inactive | active | true | string | Optional | Set to true to make the product active, or false to make it inactive |
Sales > Sales Account | sales_ledger_account/nominal_code | 4000 | string | Dependant | At least one of the sales_ledger_account elements must be provided |
Sales > Sales Account | sales_ledger_account/name | Sales Type A | string | Dependant | At least one of the sales_ledger_account elements must be provided |
Sales > Sales Account | sales_ledger_account/display_name | Sales Type A (4000) | string | Dependant | At least one of the sales_ledger_account elements must be provided |
Sales > VAT Rate | sales_tax_rate/id | GB_STANDARD | string | Optional | |
Sales > VAT Rate | sales_tax_rate/name | Standard 20.00% | string | Optional | |
Purchases > Purchase Description | purchase_description | 50 Coloured Pencils | string | Optional | |
Purchases > Cost Price | cost_price | 2.50 | double | Optional | |
Purchases > Purchase Account | purchase_ledger_account/nominal_code | 5000 | string | Optional | |
Purchases > Purchase Account | purchase_ledger_account/name | Cost of sales - goods | string | Optional | |
Purchases > Purchase Account | purchase_ledger_account/display_name | Cost of sales - goods (5000) | string | Optional | |
Purchases > VAT Rate | purchase_tax_rate/id | GB_STANDARD | string | Optional | |
Purchases > VAT Rate | purchase_tax_rate/name | Standard 20.00% | string | Optional | |
Additional Information > Notes | Notes | A pack of 50 coloured pencils | string | Optional |
<?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>
<active>true</active>
<sales_ledger_account>
<nominal_code>4000</nominal_code>
<name>Sales Type A</name>
<display_name>Sales Type A (4000)</display_name>
</sales_ledger_account>
<sales_tax_rate>
<id>GB_STANDARD</id>
<name>Standard 20.00%</name>
</sales_tax_rate>
<purchase_description>50 Coloured Pencils</purchase_description>
<cost_price>2.50</cost_price>
<purchase_ledger_account>
<nominal_code>5000</nominal_code>
<name>Cost of sales - goods</name>
<display_name>Cost of sales - goods (5000)</display_name>
</purchase_ledger_account>
<purchase_tax_rate>
<id>GB_STANDARD</id>
<name>Standard 20.00%</name>
</purchase_tax_rate>
<notes>A pack of 50 coloured pencils</notes>
</product>
</products>
</sage_one_company>
Sales Prices
The following sales price fields can be set using Zynk. The price names must already exist in Sage, this task will not create any that do not already exist.
Sage Field | XML Field | Example | Field Type | Input | Notes |
---|---|---|---|---|---|
Price Name | product_sales_price_type/name | Sales Price | string | Required | |
Price | price | 5.99 | double | Required | |
Includes VAT | price_includes_tax | true | boolean | Optional |
<?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>
<sales_prices>
<sales_price>
<product_sales_price_type>
<name>Sales Price</name>
</product_sales_price_type>
<price>5.99</price>
<price_includes_tax>false</price_includes_tax>
</sales_price>
</sales_prices>
</product>
</products>
</sage_one_company>