Skip to content

Export Goods Movements from Brightpearl

This task will download goods movements from Brightpearl in XML format.

Settings

Connection

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

Export Products

Required
Set to true to if would like the task to output the product associated with each goods movement.

Export Settings -> Date Modified

Required
When the 'Export Modified 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 or All

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

  • 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.

Export Warehouses

Required
Set to true to if would like the task to output the warehouse associated with each goods movement.

Filter

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

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" encoding="utf-8"?>
<ArrayOfGoodsMovement xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <GoodsMovement>
    <externalId />
    <createdOn xsi:nil="true" />
    <updatedOn>2016-11-18T16:06:47+00:00</updatedOn>
    <id>1</id>
    <productId>1007</productId>
    <product>
      <createdOn>2016-11-18T16:06:12Z</createdOn>
      <updatedOn>2016-11-18T16:36:34Z</updatedOn>
      <id>1007</id>
      <brand>
        <id>74</id>
      </brand>
      <productType>
        <id>1</id>
      </productType>
      <seasons />
      <productGroupId xsi:nil="true" />
      <nominalCodeStock>1001</nominalCodeStock>
      <nominalCodePurchases>5000</nominalCodePurchases>
      <nominalCodeSales>4000</nominalCodeSales>
      <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>
          <rate xsi:nil="true" />
        </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>&lt;p&gt;An iphone&lt;/p&gt;</text>
            <format>HTML_FRAGMENT</format>
          </shortDescription>
          <availableToSellOnChannel xsi:nil="true" />
          <sellwhenNoStock xsi:nil="true" />
        </salesChannel>
      </salesChannels>
      <composition>
        <bundle>false</bundle>
      </composition>
      <warehouses>
        <item>
          <key>2</key>
          <value>
            <defaultLocationId>0</defaultLocationId>
            <reorderLevel>0</reorderLevel>
            <reorderQuantity>5</reorderQuantity>
          </value>
        </item>
      </warehouses>
    </product>
    <salesOrderRowId xsi:nil="true" />
    <purchaseOrderRowId xsi:nil="true" />
    <quantity>10</quantity>
    <destinationLocationId>2</destinationLocationId>
    <warehouseId>2</warehouseId>
    <warehouse>
      <id>2</id>
      <name>Main warehouse</name>
      <address>
        <addressId>110</addressId>
        <countryId>222</countryId>
      </address>
    </warehouse>
    <goodsNoteId>1</goodsNoteId>
    <productValue>400.0000</productValue>
    <currencyCode>GBP</currencyCode>
    <orderId xsi:nil="true" />
    <isCleared>false</isCleared>
    <isQuarantine>false</isQuarantine>
    <batchId>1</batchId>
    <goodsNoteTypeCode>SC</goodsNoteTypeCode>
  </GoodsMovement>
</ArrayOfGoodsMovement>