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.

Product Status

Optional
Enter a product status to filer the export on.

Output File

Required
The file to save exported records to.

Export Custom Fields

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

Export Details

Required
Set to true to export related data for each contact. This will include address, currency, price list and tax code information.

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 'New', only records created 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 contact 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, and Contact Type settings.

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>
    <customFields />
  </Product>
</ArrayOfProduct>