Importing Inventory into Sage 50 US

This task will import inventory information in the Sage 50 US Inventory XML format into Sage 50 US.

Settings

Sage Connection

Required
The connection to Sage 50 US to use. See the Connecting to Sage 50 US article if you require more information on how to create/manage connections.

Note

This task uses the COM interface. You will need to provide a Company Username and Company Password in your Sage 50 US connection, if user security is enabled in Sage.

Fail File

Required
The name of a file for "failed" imports to be sent to. Defaults to sage_50_us_import_inventory_fail.xml.

Input File

Required
The source file that you want to import in XML format. Defaults to (Output from previous task).

Success File

Required
The name of a file for "successful" imports to be sent to. Defaults to sage_50_us_import_inventory_success.xml.

Zynk Settings

See Common Task Settings.

Example

A sample input file is shown below. See Sage 50 US Inventory XML for full documentation of the XML format.

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Inventory>
    <ExternalId>1354155</ExternalId>
    <Id>TEST0001</Id>
    <Description>Bird House-Pole 14 Ft. Stock</Description>
    <Type>StockItem</Type>
    <IsInactive>false</IsInactive>
    <DescriptionForSales>Three-Section pole that will place the bird house 12 ft. above ground</DescriptionForSales>
    <DescriptionForPurchases>Catalog #B11225: Bird House-Pole 14 Ft.</DescriptionForPurchases>
    <StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
    <ItemType>Garden</ItemType>
    <SalesAccountReference>4000</SalesAccountReference>
    <InventoryAccountReference>1200</InventoryAccountReference>
    <COGSAccountReference>5000</COGSAccountReference>
    <CostingMethod>Average</CostingMethod>
    <LastUnitCost>25</LastUnitCost>
    <SalesTaxType>1</SalesTaxType>
    <Location>AISLE 1</Location>
    <SubjectToCommission>false</SubjectToCommission>
    <MinimumStock>6.00</MinimumStock>
    <ReorderQuantity>6.00</ReorderQuantity>
    <VendorReference>ALDRED</VendorReference>
    <IsTaxable>true</IsTaxable>
    <UPC>TEST0001</UPC>
    <Weight>5.60</Weight>
    <BuyerReference>ACA01</BuyerReference>
    <PartNumber>1354155</PartNumber>
    <CustomFields>
      <CustomField>
        <Name>Special Note</Name>
        <Value>Large item</Value>
      </CustomField>
    </CustomFields>
    <SalePrice>49.99</SalePrice>
    <PriceLevels>
      <PriceLevel>
        <Name>Price Level 1</Name>
        <UnitPrice>49.99</UnitPrice>
      </PriceLevel>
      <PriceLevel>
        <Level>2</Level>
        <UnitPrice>48.00</UnitPrice>
      </PriceLevel>
    </PriceLevels>
  </Inventory>
</ArrayOfInventory>