Zynk CSV to Zynk Stock Record XML

The stock record CSV works on the basis of one CSV line representing one stock record.

Sage 50

All fields from our Sage 50 UK Stock Record XML format can be used except for Discounts. Use the XML Field names for the CSV header.

Example

Sku,Name,GroupCode,IntrastatCommodityCode,IntrastatImportDutyCode,CommodityCode,Barcode,IsActive,ItemType,Location,UnitWeight,CountryOfOriginCode,Description,LongDescription,Publish,SpecialOffer,Custom1,Custom2,Custom3
PROD001,Test Product,1,71162019,01,Necklaces,9789862410035,true,Stock,Warehouse,12,UK,,,,,,,
TEE003,Large Blue T-Shirt,1,446658456,01,Clothing,9789862446851,true,Stock,Warehouse,150,UK,A large blue t-shirt,A large blue cotton t-shirt,true,false,Blue,Large,Tee

This will produce the following XML:

<?xml version="1.0" encoding="utf-8"?>
<Company>
    <Products>
        <Product>
            <Sku>PROD001</Sku>
            <Name>Test Product</Name>
            <GroupCode>1</GroupCode>
            <IntrastatCommodityCode>71162019</IntrastatCommodityCode>
            <IntrastatImportDutyCode>01</IntrastatImportDutyCode>
            <CommodityCode>Necklaces</CommodityCode>
            <Barcode>9789862410035</Barcode>
            <IsActive>true</IsActive>
            <ItemType>Stock</ItemType>
            <Location>Warehouse</Location>
            <UnitWeight>12</UnitWeight>
            <CountryOfOriginCode>UK</CountryOfOriginCode>
        </Product>
        <Product>
            <Sku>TEE003</Sku>
            <Name>Large Blue T-Shirt</Name>
            <GroupCode>1</GroupCode>
            <IntrastatCommodityCode>446658456</IntrastatCommodityCode>
            <IntrastatImportDutyCode>01</IntrastatImportDutyCode>
            <CommodityCode>Clothing</CommodityCode>
            <Barcode>9789862446851</Barcode>
            <IsActive>true</IsActive>
            <ItemType>Stock</ItemType>
            <Location>Warehouse</Location>
            <UnitWeight>150</UnitWeight>
            <CountryOfOriginCode>UK</CountryOfOriginCode>
            <Description>A large blue t-shirt</Description>
            <LongDescription>A large blue cotton t-shirt</LongDescription>
            <Publish>true</Publish>
            <SpecialOffer>false</SpecialOffer>
            <Custom1>Blue</Custom1>
            <Custom2>Large</Custom2>
            <Custom3>Tee</Custom3>
        </Product>
    </Products>
</Company>

Sage 200

All fields in the first level of the Sage 200 Stock Record XML format can be used (e.g. at the same level as Sku and Name but not nested further like Locations). Suppliers and Search Categories can be included as shown below.

Example

Sku,Name,GroupCode,GroupName,ItemType,Status,SalePrice,UnitOfSale,TaxCode,Manufacturer,ManufacturerPartNo,StandardCostPrice,Description,UseDescriptionOnDocs,SearchCategory1Name,SearchCategory1Value,SearchCategory2Name,SearchCategory2Value,Supplier1AccountReference,Supplier1SupplierStockCode,Supplier1LeadTime,Supplier1LeadTimeUnit,Supplier1UsualOrderQuantity,Supplier1MinimumOrderQuantity,Supplier1ListPrice,Supplier1DateListPriceChanged,Supplier1ListPriceExpiryDate,Supplier1PricingSource,Supplier1Preferred
PROD001,Test Product,TESTGROUP,Test Group,Stock,1,100,Each,1,Test Company,1234,60,This is a test product,false,Sync with Website,true,Gift wrap item,false,SUP001,S-PROD001,3,EnumTimeUnitDay,1,1,60,2014-01-01T00:00:00,2015-01-01T00:00:00,LastBuyingPrice,true

This will produce the following XML:

<?xml version="1.0" encoding="utf-8"?>
<Company>
    <Products>
        <Product>
            <Sku>PROD001</Sku>
            <Name>Test Product</Name>
            <GroupCode>TESTGROUP</GroupCode>
            <GroupName>Test Group</GroupName>
            <ItemType>Stock</ItemType>
            <Status>1</Status>
            <SalePrice>100</SalePrice>
            <UnitOfSale>Each</UnitOfSale>
            <TaxCode>1</TaxCode>
            <Manufacturer>Test Company</Manufacturer>
            <ManufacturerPartNo>1234</ManufacturerPartNo>
            <StandardCostPrice>60</StandardCostPrice>
            <Description>This is a test product</Description>
            <UseDescriptionOnDocs>false</UseDescriptionOnDocs>
            <SearchCategories>
                <SearchCategory>
                    <Name>Sync with Website</Name>
                    <Value>true</Value>
                </SearchCategory>
                <SearchCategory>
                    <Name>Gift wrap item</Name>
                    <Value>false</Value>
                </SearchCategory>
            </SearchCategories>
            <ProductSuppliers>
                <ProductSupplier>
                    <AccountReference>SUP001</AccountReference>
                    <SupplierStockCode>S-PROD001</SupplierStockCode>
                    <LeadTime>3</LeadTime>
                    <LeadTimeUnit>EnumTimeUnitDay</LeadTimeUnit>
                    <UsualOrderQuantity>1</UsualOrderQuantity>
                    <MinimumOrderQuantity>1</MinimumOrderQuantity>
                    <ListPrice>60</ListPrice>
                    <DateListPriceChanged>2014-01-01T00:00:00</DateListPriceChanged>
                    <ListPriceExpiryDate>2015-01-01T00:00:00</ListPriceExpiryDate>
                    <PricingSource>LastBuyingPrice</PricingSource>
                    <Preferred>true</Preferred>
                </ProductSupplier>
            </ProductSuppliers>
        </Product>
    </Products>
</Company>