Skip to content

Export Products from Brightpearl

This task will download products from Brightpearl in XML format.

Settings

Connection

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

Export Custom Fields

Required
Set to true to download the values of any custom fields that have been set up on the records.

Export Details

Required
Set to true to export related data for each record.

This will include the brand, product type, tax code and seasons.

Export Price List Prices

Optional
Set to true to export the price list prices for each product.

Export Product Availability

Optional
Set to true to export stock availability information for each product that has stock tracking enabled.

Export Settings -> Date Created

Required
When the 'Export Modified, New or All Records' setting is set to 'New', only records created after this date will be exported. This date will update automatically each time the task runs.

Export Settings -> Date Modified

Required
When the 'Export Modified, New or All Records' setting is set to 'Modified', only records updated after this date will be exported. This date will update automatically each time the task runs.

Export Settings -> Export Modified, New or All

Required
Choose which records should be included in the export. The available options are:

  • New - Only records created since the date specified in the 'Date Created' setting will be exported.
  • Modified - Only records modified since the date specified in the 'Date Modified' setting will be exported.
  • All - Records will not be filtered based on date created or modified.

Filter

Optional
Specify criteria to filter the results returned e.g. firstName=John&lastName=Smith.

ID Set

Optional
Specify the record ID numbers and/or ranges to export. The ID numbers must be provided in numerical order. For example, the ID set 1,3,5-8,10 would download the records with ID 1, 3, 5, 6, 7, 8 and 10. Please note that this setting overrides the Filter and Export Settings.

Product Status

Optional
Enter a product status to filer the export on.

Output File

Required
The XML file to save the downloaded records to. A sample of the XML format is shown below.

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0"?>
<ArrayOfProduct>
  <Product>
    <externalId />
    <createdOn>2016-11-18T16:06:12Z</createdOn>
    <updatedOn>2016-11-18T16:36:34Z</updatedOn>
    <id>1007</id>
    <brand>
      <id>74</id>
      <name>Other</name>
      <description />
    </brand>
    <productType>
      <id>1</id>
      <name>Default</name>
      <associations>
        <options>
          <Option>
            <id>1</id>
            <name>Colour</name>
          </Option>
          <Option>
            <id>2</id>
            <name>Size</name>
          </Option>
        </options>
      </associations>
    </productType>
    <seasons />
    <productGroupId xsi:nil="true" />
    <nominalCodeStock>1001</nominalCodeStock>
    <identity>
      <sku>IPHONE</sku>
      <barcode />
    </identity>
    <stock>
      <stockTracked>true</stockTracked>
      <weight>
        <magnitude>0</magnitude>
      </weight>
    </stock>
    <financialDetails>
      <taxable>false</taxable>
      <taxCode>
        <id>7</id>
        <code>T20</code>
        <description>VAT</description>
        <rate>20</rate>
      </taxCode>
    </financialDetails>
    <salesChannels>
      <salesChannel>
        <id xsi:nil="true" />
        <salesChannelName>Brightpearl</salesChannelName>
        <productName>iPhone</productName>
        <productCondition>new</productCondition>
        <categories>
          <Category>
            <categoryCode>276</categoryCode>
          </Category>
        </categories>
        <description>
          <languageCode>en</languageCode>
          <text />
          <format>HTML_FRAGMENT</format>
        </description>
        <shortDescription>
          <languageCode>en</languageCode>
          <text>
            <p>An iphone</p>
          </text>
          <format>HTML_FRAGMENT</format>
        </shortDescription>
        <availableToSellOnChannel xsi:nil="true" />
        <sellwhenNoStock xsi:nil="true" />
      </salesChannel>
    </salesChannels>
    <composition>
      <bundle>false</bundle>
    </composition>
    <variations>
      <variation>
        <optionId>1</optionId>
        <optionName>Colour</optionName>
        <optionValueId>2</optionValueId>
        <optionValue>White</optionValue>
      </variation>
    </variations>
    <warehouses>
      <item>
        <key>2</key>
        <value>
          <defaultLocationId>0</defaultLocationId>
          <reorderLevel>0</reorderLevel>
          <reorderQuantity>5</reorderQuantity>
        </value>
      </item>
    </warehouses>
    <productAvailability>
      <productId>1007</productId>
      <total>
        <inStock>10</inStock>
        <onHand>10</onHand>
        <allocated>0</allocated>
        <inTransit>0</inTransit>
      </total>
      <warehouses>
        <item>
          <key>2</key>
          <value>
            <inStock>10</inStock>
            <onHand>10</onHand>
            <allocated>0</allocated>
            <inTransit>0</inTransit>
          </value>
        </item>
      </warehouses>
    </productAvailability>
    <productPrices>
      <productPrice>
        <priceListId>1</priceListId>
        <priceListCode>COST</priceListCode>
        <priceListTypeCode>BUY</priceListTypeCode>
        <currencyCode>GBP</currencyCode>
        <currencyId>1</currencyId>
        <quantityPrice>
          <item>
            <key>1</key>
            <value>400.0000</value>
          </item>
        </quantityPrice>
      </productPrice>
      <productPrice>
        <priceListId>2</priceListId>
        <priceListCode>RETAIL</priceListCode>
        <priceListTypeCode>SELL</priceListTypeCode>
        <currencyCode>GBP</currencyCode>
        <currencyId>1</currencyId>
        <quantityPrice>
          <item>
            <key>1</key>
            <value>600.0000</value>
          </item>
          <item>
            <key>5</key>
            <value>550.0000</value>
          </item>
        </quantityPrice>
      </productPrice>
    </productPrices>
    <customFields />
  </Product>
</ArrayOfProduct>