Sage 50 CA Item XML
The following tasks use the Sage 50 CA Item XML format.
Tasks
XML Overview
Any Sage fields not documented below are not supported with our imports/exports. Examples of where in the XML the fields should appear are shown in the samples below.
Minimal Item File
<?xml version="1.0" encoding="utf-8"?>
<Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Item>
<Number>TEST0001</Number>
<Type>Inventory</Type>
<Accounts>
<Asset>15300</Asset>
<Cogs>50200</Cogs>
</Accounts>
</Item>
</Items>
Complete Item File
<?xml version="1.0" encoding="utf-8"?>
<Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Item>
<ExternalId>1234</ExternalId>
<Number>TEST0001</Number>
<Description>Test Item</Description>
<DescriptionAlt>Tester le produit</DescriptionAlt>
<Type>Inventory</Type>
<Units>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<StockingUnitOfMeasureAlt>Chaque</StockingUnitOfMeasureAlt>
</Units>
<Prices>
<Price>
<PriceList>Regular</PriceList>
<Price>10.99</Price>
</Price>
<Price>
<PriceList>Preferred</PriceList>
<Price>9.99</Price>
</Price>
</Prices>
<Accounts>
<Asset>15300</Asset>
<Revenue>42200</Revenue>
<Cogs>50200</Cogs>
<Variance>50200</Variance>
</Accounts>
</Item>
</Items>
In each of the following sections most of the XML has been omitted to make the samples easier to read. The whole structure of the Items schema is used below as a reference of where fields should be in the object model.
Header Information
The following fields can be populated at the header level of the item record.
The item number field acts as the unique identifier for items in Sage. So you must either provide an item number within the XML, or look up the value. You can look up the value if the item has been imported into Sage by Zynk before, and an ExternalId value was provided at the time.Pproviding the same ExternalId value again will allow Zynk to determine the item number via our truth table.
| Sage Field | XML Field | Field Type | Input | Notes |
| --- | --- | --- | --- | --- | --- | --- |
| - | ExternalId | string(255) | Optional | Provide the ID of the item from the source system |
| Number | Number | string(52) | Required | The value can be looked up in Zynk's truth table via the ExternalId |
| Type | Type | enum | Required | Valid values: Inventory, Service |
| Description (En) | Description | string(75) | Optional | The English description of the item |
| Description (Fr/Es) | DescriptionAlt | string(75) | Optional | The French (Canada)/Spanish (US) description of the item |
<?xml version="1.0"?>
<Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Item>
<ExternalId>1234</ExternalId>
<Number>TEST0001</Number>
<Type>Inventory</Type>
<Description>Test Item</Description>
<DescriptionAlt>Tester le produit</DescriptionAlt>
</Item>
</Items>
Units Tab
The following fields can be populated on the Units tab of the item record.
| Sage Field | XML Field | Field Type | Input | Notes | | --- | --- | --- | --- | --- | --- | --- | | Stocking Unit of Measure (En) | Units/StockingUnitOfMeasure | string(15) | Optional | The English unit of measure | | Stocking Unit of Measure (Fr/Es) | Units/StockingUnitOfMeasureAlt | string(15) | Optional | The French (Canada)/Spanish (US) unit of measure |
<?xml version="1.0" encoding="utf-8"?>
<Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Item>
<Units>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<StockingUnitOfMeasureAlt>Chaque</StockingUnitOfMeasureAlt>
</Units>
</Item>
</Items>
Pricing Tab
The following fields can be populated on the Pricing tab of the item record.
| Sage Field | XML Field | Field Type | Input | Notes | | --- | --- | --- | --- | --- | --- | --- | | Regular > Price per Selling Unit | Prices/Price[PriceList = 'Regular']/Price | decimal | Optional | | | Preferred > Price per Selling Unit | Prices/Price[PriceList = 'Preferred']/Price | decimal | Optional | |
<?xml version="1.0" encoding="utf-8"?>
<Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Item>
<Prices>
<Price>
<PriceList>Regular</PriceList>
<Price>10.99</Price>
</Price>
<Price>
<PriceList>Preferred</PriceList>
<Price>9.99</Price>
</Price>
</Prices>
</Item>
</Items>
Linked Tab
The following fields can be populated on the Linked tab of the item record.
| Sage Field | XML Field | Field Type | Input | Notes | | --- | --- | --- | --- | --- | --- | --- | | Asset | Asset | string | Dependant | Specify the account number. This field is required when the item type is 'Inventory' | | Revenue | Revenue | string | Optional | Specify the account number | | COGS | Cogs | string | Dependant | Specify the account number. This field is required when the item type is 'Inventory' | | Variance | Variance | string | Optional | Specify the account number |