Skip to content

Import Product Pricing into SparkLayer

This task will update the pricing associated with a product in SparkLayer, based on data provided via an XML file.

Settings

Connection

Required
The SparkLayer connection to use. See Connecting to SparkLayer.

Fail File

Required
The XML file to save failed records to. The XML format will be the same as the input file.

Input File

Required
The XML file containing records to import into SparkLayer. An example of the XML format is shown below.

Success File

Required
The XML file to save successful records to. The XML format will be the same as the input file.

Prevent Reprocessing

Required
Set to true to prevent the same records being processed more than once, based on the value of the <ExternalId> element in the XML.

Zynk Settings

See Common Task Settings

Examples

A sample input file is shown below. For full documentation see SparkLayer Product Pricing XML.

<?xml version="1.0"?>
<ProductPricings>
    <ProductPricing Operation="Upsert">
        <ExternalId>123</ExternalId>
        <Sku>PROD0001</Sku>
        <Pricing>
            <PriceListPricing>
                <PriceListSlug>trade-prices</PriceListSlug>
                <Prices>
                    <Price>
                        <Quantity>1</Quantity>
                        <Price>10</Price>
                        <TaxType>net</TaxType>
                    </Price>
                    <Price>
                        <Quantity>5</Quantity>
                        <Price>9</Price>
                        <TaxType>net</TaxType>
                    </Price>
                </Prices>
            </PriceListPricing>
            <PriceListPricing>
                <PriceListSlug>web-prices</PriceListSlug>
                <Prices>
                    <Price>
                        <Quantity>1</Quantity>
                        <Price>20</Price>
                        <TaxType>net</TaxType>
                    </Price>
                    <Price>
                        <Quantity>3</Quantity>
                        <Price>18</Price>
                        <TaxType>net</TaxType>
                    </Price>
                </Prices>
            </PriceListPricing>
        </Pricing>
    </ProductPricing>
    <ProductPricing Operation="Replace">
        <ExternalId>456</ExternalId>
        <Sku>PROD0002</Sku>
        <Pricing>
            <PriceListPricing>
                <PriceListSlug>trade-prices</PriceListSlug>
                <Prices>
                    <Price>
                        <Quantity>1</Quantity>
                        <Price>10</Price>
                        <TaxType>net</TaxType>
                    </Price>
                </Prices>
            </PriceListPricing>
            <PriceListPricing>
                <PriceListSlug>web-prices</PriceListSlug>
                <Prices>
                    <Price>
                        <Quantity>1</Quantity>
                        <Price>20</Price>
                        <TaxType>net</TaxType>
                    </Price>
                </Prices>
            </PriceListPricing>
        </Pricing>
    </ProductPricing>
</ProductPricings>