Skip to content

Import Price Lists into SparkLayer

This task will create new or update existing price lists in SparkLayer, based on data provided via an XML file. Price lists are matched based on slug.

Note

The task doesn't support creating or updating the prices associated with a price list. If you would like to do that, please use the Import Product Pricing task.

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.

Operation

Required
Select the kind of operation you would like to perform against SparkLayer. The following options are available:

  • Upsert - This option will create new and update existing price lists in SparkLayer. Any existing price lists in SparkLayer that aren't present in the XML file won't be affected. This is the default value for this setting.
  • Replace - In addition to creating new and update existing price lists, this option will also remove any existing price lists from SparkLayer where the source is 'integration', and they aren't present in the XML. Use this option if you need to ensure that any price lists that are deleted from the source system are also deleted from SparkLayer. But please note that you will need to ensure all price lists are exported from the source system each time your workflow runs.

Zynk Settings

See Common Task Settings

Examples

A sample input file is shown below. For full documentation see SparkLayer Price List XML.

<?xml version="1.0"?>
<PriceLists>
    <PriceList>
        <ExternalId>123</ExternalId>
        <Slug>trade-prices</Slug>
        <Name>Trade Prices</Name>
        <CurrencyCode>GBP</CurrencyCode>
        <Source>integration</Source>
        <Rules>
            <Rule>
                <SourcePriceListSlug>retail-prices</SourcePriceListSlug>
                <AdjustmentPercentage>0.10</AdjustmentPercentage>
                <AdjustmentDirection>minus</AdjustmentDirection>
                <CurrencyExchangeRate>1.254324</CurrencyExchangeRate>
            </Rule>
        </Rules>
    </PriceList>
    <PriceList>
        <ExternalId>456</ExternalId>
        <Slug>web-prices</Slug>
        <Name>Web Prices</Name>
        <CurrencyCode>GBP</CurrencyCode>
        <Source>integration</Source>
        <Rules>
            <Rule>
                <SourcePriceListSlug>retail-prices</SourcePriceListSlug>
                <AdjustmentPercentage>0.05</AdjustmentPercentage>
                <AdjustmentDirection>minus</AdjustmentDirection>
                <CurrencyExchangeRate>1.254324</CurrencyExchangeRate>
            </Rule>
        </Rules>
    </PriceList>
</PriceLists>