Exporting Price Lists from Sage 50 UK
This task will export price lists from Sage 50 in Zynk XML format.
Settings
Sage 50 Connection
Required
The connection to Sage 50 UK to use. See the Connecting to Sage 50 UK article if you require more information on how to create/manage connections.
Export All
Required
Set this to False to export records modified since the last export, or set to True to export all records every time it runs.
Recalculate Prices
Required
Set this to True to recalculate the prices written to the export file, or False to export the stored price directly from Sage.
Output File
Required
The name of the file to export to. Data is exported in Zynk XML format.
Zynk Settings
Examples
Sample output file:
<?xml version="1.0"?>
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<PriceLists>
<PriceList AllRecords="false">
<Name>Public Price List</Name>
<Reference>PUBLIC</Reference>
<Currency>GBP</Currency>
<Type>PriceList</Type>
<Prices>
<Price Action="Upsert">
<DiscountType>DecreasePercent</DiscountType>
<StockCode>BOARD001</StockCode>
<StoredPrice>0</StoredPrice>
<Value>2</Value>
<ExternalReference>PUBLIC BOARD001</ExternalReference>
<BaseQty xsi:nil="true" />
<QtyBreak xsi:nil="true" />
<DiscountAmountValue xsi:nil="true" />
<DiscountPercentValue xsi:nil="true" />
</Price>
<Price Action="Upsert">
<DiscountType>DecreasePercent</DiscountType>
<StockCode>BOARD002</StockCode>
<StoredPrice>0</StoredPrice>
<Value>2</Value>
<ExternalReference>PUBLIC BOARD002</ExternalReference>
<BaseQty xsi:nil="true" />
<QtyBreak xsi:nil="true" />
<DiscountAmountValue xsi:nil="true" />
<DiscountPercentValue xsi:nil="true" />
</Price>
<Price Action="Upsert">
<DiscountType>DecreasePercent</DiscountType>
<StockCode>BOOKS001</StockCode>
<StoredPrice>0</StoredPrice>
<Value>2</Value>
<ExternalReference>PUBLIC BOOKS001</ExternalReference>
<BaseQty xsi:nil="true" />
<QtyBreak xsi:nil="true" />
<DiscountAmountValue xsi:nil="true" />
<DiscountPercentValue xsi:nil="true" />
</Price>
<Price Action="Upsert">
<DiscountType>DecreasePercent</DiscountType>
<StockCode>BOOKS002</StockCode>
<StoredPrice>0</StoredPrice>
<Value>2</Value>
<ExternalReference>PUBLIC BOOKS002</ExternalReference>
<BaseQty xsi:nil="true" />
<QtyBreak xsi:nil="true" />
<DiscountAmountValue xsi:nil="true" />
<DiscountPercentValue xsi:nil="true" />
</Price>
<Price Action="Upsert">
<DiscountType>DecreasePercent</DiscountType>
<StockCode>BOOKS003</StockCode>
<StoredPrice>0</StoredPrice>
<Value>2</Value>
<ExternalReference>PUBLIC BOOKS003</ExternalReference>
<BaseQty xsi:nil="true" />
<QtyBreak xsi:nil="true" />
<DiscountAmountValue xsi:nil="true" />
<DiscountPercentValue xsi:nil="true" />
</Price>
</Prices>
</PriceList>
</PriceLists>
</Company>