Export Products from Visualsoft

This task will export products from Visualsoft in an XML format. The results can be filtered if required. See below for a sample output file.

Settings

Connection

Required
The Visualsoft connection to use. See the Connecting to Visualsoft article if you require more information on how to create/manage connections.

Date Modified

Required
When the 'Export Type' setting is set to 'Modified', only products updated after this date will be exported. This date will update automatically each time the task runs.

Export Type

Required
Choose which records should be exported. The available options are:

• Modified - Only products created/updated after the date shown in the 'Date Modified' setting will be exported.
• All - Products will be exported regardless of when they were created/updated. Select this option if you want to export all products from Visualsoft, or specific products (via the 'Product References' setting).

Page Size

Required
The number of records to download per page. Defaults to 50.

Product References

Optional
Enter a list of references to export specific products from Visualsoft. This setting only takes effect when the 'Export Type' setting is set to 'All'.

Timeout

Required
The amount of time (in seconds) to wait for the Visualsoft API to respond to each request. Defaults to 100.

Output File

Required
The name of the file to export the products to.

Zynk Settings

See Common Task Settings.

Examples

A sample output file is shown below.

<?xml version="1.0" encoding="utf-8"?>
<PRODUCTS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <PRODUCT>
    <PARENT_PRODUCT_ID>123</PARENT_PRODUCT_ID>
    <REFERENCE>1090761</REFERENCE>
    <TITLE>A4 Notepad</TITLE>
    <BRAND>Celexon</BRAND>
    <MANUFACTURER_ORIGIN />
    <COMMODITY_CODE />
    <SUBTITLE>100 Page A4 Notepad 80g/sm</SUBTITLE>
    <SUMMARY />
    <DESCRIPTION>Standard A4 Notepad, 100 Pages, 80g/sm</DESCRIPTION>
    <SEO_TITLE />
    <SEO_DESCRIPTION />
    <SEO_KEYWORDS />
    <SEO_NAME />
    <ACTIVE>1</ACTIVE>
    <LAST_DATE_MADE_ACTIVE>2018-07-08 10:01:04</LAST_DATE_MADE_ACTIVE>
    <DELETE>N</DELETE>
    <DEPARTMENTS>
      <DEPARTMENT default="true">
        <DEPART_LEVEL>Stationary</DEPART_LEVEL>
        <DEPART_LEVEL>Paper</DEPART_LEVEL>
      </DEPARTMENT>
    </DEPARTMENTS>
    <TAGS />
    <IMAGES />
    <PRODUCT_OPTION>100 Pages</PRODUCT_OPTION>
    <ALLOW_SAMPLES>N</ALLOW_SAMPLES>
    <SAMPLE_PARENT_ID>123</SAMPLE_PARENT_ID>
    <QTY_LABEL>Each</QTY_LABEL>
    <SUBPRODUCTS>
      <SUBPRODUCT>
        <PRODUCT_ID>123</PRODUCT_ID>
        <REFERENCE>1090761</REFERENCE>
        <ATTRIBUTES />
        <TITLE>A4 Notepad</TITLE>
        <ACTIVE>1</ACTIVE>
        <DELETE>0</DELETE>
        <STOCK>58</STOCK>
        <STOCK_LOCATIONS>
          <STOCK_LOCATION>
            <STOCK_LOCATION_ID>1</STOCK_LOCATION_ID>
            <NAME>LONDON</NAME>
            <LEVEL>58</LEVEL>
            <CHILD_STOCK_LOCATIONS>
              <STOCK_LOCATION>
                <STOCK_LOCATION_ID>2</STOCK_LOCATION_ID>
                <NAME>LONDON-KENSINGTON</NAME>
                <LEVEL>58</LEVEL>
                <CHILD_STOCK_LOCATIONS />
              </STOCK_LOCATION>
            </CHILD_STOCK_LOCATIONS>
          </STOCK_LOCATION>
        </STOCK_LOCATIONS>
        <SUPPLIER>John Smith &amp; Co</SUPPLIER>
        <WEIGHT>0.10</WEIGHT>
        <MODEL>1090761</MODEL>
        <EAN>4260094733550</EAN>
        <MPN />
        <ISBN />
        <UNIT_OF_MEASURE>EACH</UNIT_OF_MEASURE>
        <RELEASE_DATE>2018-07-08 10:01:04</RELEASE_DATE>
        <DEPOSIT_AVAILABLE_NOW>N</DEPOSIT_AVAILABLE_NOW>
        <UPC />
        <PRICE>1.50</PRICE>
        <SALE_PRICE>1.50</SALE_PRICE>
        <DEPOSIT_PRICE>1.00</DEPOSIT_PRICE>
        <RRP_PRICE>0.000</RRP_PRICE>
        <BUY_PRICE>0.75</BUY_PRICE>
        <COST_PRICE>0.75</COST_PRICE>
        <BUY_LIST_PRICE>0.75</BUY_LIST_PRICE>
        <VAT_RATE>20.00</VAT_RATE>
        <DISPLAY_ON_SALE_PAGE>1</DISPLAY_ON_SALE_PAGE>
        <MAXIMUM_QUANTITY>10</MAXIMUM_QUANTITY>
        <HIDE_PRICE>N</HIDE_PRICE>
        <VAT_RELIEF>N</VAT_RELIEF>
        <IMAGES>
          <IMAGE>https://example.com/images/products/1090761.jpg</IMAGE>
        </IMAGES>
        <PRODUCT_DIMENSIONS>
          <PRODUCT_HEIGHT>1</PRODUCT_HEIGHT>
          <PRODUCT_WIDTH>1</PRODUCT_WIDTH>
          <PRODUCT_LENGTH>1</PRODUCT_LENGTH>
        </PRODUCT_DIMENSIONS>
        <PACK_DIMENSIONS>
          <PACK_HEIGHT>1</PACK_HEIGHT>
          <PACK_WIDTH>1</PACK_WIDTH>
          <PACK_LENGTH>1</PACK_WIDTH>
        </PACK_DIMENSIONS>
        <PACK_QUANTITY />
        <SHIPPING_VOLUME />
        <PICK_LOCATION />
        <STOCK_MESSAGE />
        <STOCK_STATUS />
        <ZERO_LEVEL_STOCK_MESSAGE>Out of Stock</ZERO_LEVEL_STOCK_MESSAGE>
        <PRODUCT_OPTION />
        <COMMODITY_CODE />
        <COUNTRY_OF_ORIGIN />
        <CUSTOMS_DESCRIPTION>Standard A4 Notepad, 100 Pages, 80g/sm</CUSTOMS_DESCRIPTION>
      </SUBPRODUCT>
    </SUBPRODUCTS>
    <UPSELLING />
  </PRODUCT>
</PRODUCTS>