Skip to main content

Add export channel

Add and set up an export channel to distribute your data to popular channels in Productsup.

Introduction

Add and set up an export channel to distribute your data to some popular channels or get a custom channel added. You can select an export channel template from several online marketplaces and marketing destinations, including comparison shopping websites, affiliate, search, and retargeting engines, to include real-time bidding (RTB) and social media platforms.

You can also set up a blank export for customization as needed. If there’s a channel you want to use and don’t see it in the channel list, contact your account manager to add it for you.

Add export channel template

  1. First, select Exports A/B in the site’s main menu.

  2. Next, select Add Export to choose an export channel template.

    add_exports.png

Browse for an export channel using export category filters

  1. Use the search field or filter the export category for an export channel template by selecting the export channel category filters. Setting the filter lets you see the available channels in your chosen category. The export channel categories are as follows:

    • Search engines

    • Comparison shopping

    • Marketing and advertising

    • Marketplaces

    • Social media

    • Retailers and distributors

    • Shop systems

    • Order Sync

    • Other

    • Classification standards

    • Data pools and product databases

  2. If the desired export channel is unavailable, contact support@productsup.com with some specifics, such as the header, separator, name, etc.

    browse.png

My Export Channels

  1. To view the most used channels in your company account, select the My Export Channels tab. This tab provides you with a shortlist of the channels used the most.

  2. You can further filter your list of mainly used channels by selecting the Frequently Added and or Recently Added category filters. These tabs display the most frequently and or recently added export channels.

my_channels.png

Add and modify an export channel name

  1. Select Add for your new export channel. A window appears, allowing you to modify the export channel name and hide unconnected attributes in the intermediate column, which you can find in Dataflow.

    add_export_w_name_change.png

    Modifying the export channel name is helpful when you use the same export channel for different exports; for example, Google Merchant Center main data flow, Google Merchant Center clothes only data flow, etc. Adding a channel more than once is only necessary if you want to create multiple data flows for A/B testing or need variations of the same template. For more information on export A/B testing, see A/B testing FAQ.

    multiple_export_names.png
  2. Select Add to continue with the export channel setup.

Edit export channel settings

Overview tab

View the Channel Dashboard to get an overview of the:

Last Export - Previously-run export

Next Export - If you set up a schedule for this specific channel

Products - Quantity of products for export

Channel - Name of the used template

dashboard.png

Edit name and description

You can, again, modify the newly created export channel name and add a description by selecting the Edit icon next to the channel name. Either add an explanation describing your colleagues' channel or a link to the feed file.

Duplicate a channel

Create a copy of a pre-existing channel by selecting Duplicate on the top-right. Duplicate a channel if you plan to use a template multiple times without starting from scratch.

After duplicating your channel, decide if you want to copy the channel with or without destination settings.

Add destination

Select Add Destination to add a feed destination.

To learn more about destinations, see Feed Destinations (legacy document).

destination.png

Change the filename or add a product per file limit

You can edit the filename and the file format. Use a valid feed format, such as XML, CSV, TXT, and add a zip extension if necessary, for example, .bz2, .zip, or .gz.

  1. Enter the number of products you want to export per file in Limit (Products per File). For example, if you're going to export one product only, enter a 0 in the input field. This setting begins with the first row containing product data, skipping the header.

  2. If you wish to limit the number of products in your feed, enter the desired value by selecting Setup.

  3. To split your feed into multiple files, select Add File. Then set a limit for the number of rows in each file.

For example, if your feed contains 1000 products and you set up three (3) feeds with a 200 product limit, the platform only exports 600 products. The remaining 400 products are not present in any file. To avoid this situation, set a limit of 0 in your last file to make sure you export all products. If the amount of products is less than the sum of all file limits, the platform does not update unnecessary files. If you want to receive empty files instead, turn on the Allow empty files option in the Settings tab.

Note

If you add a second feed, you are not exporting to the channel twice. Instead, you are splitting the export into two (2) feeds. If you want to export your channel once as a CSV and once as an XML file, you need to use separate channels.

Dynamic filename with Twig

To use the site and export names as dynamic placeholders in the filename, give the export file the following name:

{{ Site.id ~ "" ~ Export.name | replace({ "/":"" }) }}.txt

You can also use other Twigs to add the export name and date:

{{ Export.name | replace({ " ":"" }) ~ "" ~ "now" | date("Ymd") }}.csv

Select Setup to edit the file name using the desired format.

twig.png

Settings tab

CSV Separator - Set to On to select the separator type.

CSV Enclosure - Set to On (default) to export as CSV. Otherwise, if you turn off CSV Enclosure, the export is TXT.

Enable Pixel Tracking - A tracking pixel is a small piece of code in the form of a pixel that you implement in your website code. Set to On to use.

Enable Redirect Tracking - Redirect tracking collects your site ID, the export ID, and the product ID. It sets a cookie for the conversion pixel. Set to On to use.

Shorten Tracking URL - If your export channel only accepts a limited number of characters in the tracking URL, turn on Shorten Tracking URL and select the respective content column. Set to On to use.

To learn more about tracking options, see Productsup tracking options (legacy document).

Export as XML - Set to On to send your file as XML. Remember to change the filename extension to .xml.

XSL Template for XML Export - Use an XSL template, as a style sheet, for your XML export.

Export Plugin - You can use an export plugin if your output requires a specific format, such as JSON, XLSX, etc. Contact support@productsup.com if you need help with a non-JSON or Excel XLSX plugin. Otherwise, see the following JSON and XLSX plugins.

  1. For a JSON plugin, enter the following value in the Export-Plugin field on the export channel's Settings page:

    • \Export\Json

    Note

    Use the \Export\Json plugin name for the standard JSON structure only.

    export_json_plugin.png
  2. For an Excel XLSX plugin, enter the following value in the Export-Plugin field on the export channel's Settings page:

    • \Export\Xlsx

    add_excel_plugin.png

Allow empty files (0 products) - Set to On if you allow Productsup to export empty files. By default, this option is set to Off but can be helpful if you create internal reports. For example, you can export a file that reports image URLs that lead to a 404 page. In this case, having an empty file with headers is suitable.

Add Header before Main Header in CSV (optional) and Add Header after Main Header in CSV (optional) - Some export channels request additional headers before or after the CSV header column’s name. Add the header information as static values in Add Header before/after Main Header in CSV (optional), and Productsup adds them with the next export.

Note

The Add Header before/after Main Header in CSV (optional) features are unavailable for all exports. Use as necessary.

add_header_beforeafter_option.png

Product Uniqueness - You can choose the column in your export feed that you consider unique. If there are rows with duplicate values, the platform only exports one row. Set to On to choose the unique product column, then select Add.

Hide un-mapped attributes - In the Intermediate stage, you can hide or un-hide unconnected intermediate attributes. These are attributes that you created when you added the export channel. Set to On to hide un-mapped attributes.

settings.png

Fields available on demand

If your export channel outputs a CSV file, you can use the Replace Main Header in CSV (optional) field in the Settings tab of your export setup to replace the header row of your CSV export file with a header that suits your needs.

The Replace Main Header in CSV (optional) field allows changing the header row in your CSV export file to any header row that suits your needs

Note

Replace Main Header in CSV (optional) is available out of the box in one export channel only: Blank Export (with ID).

To use Replace Main Header in CSV (optional) in any other export channel, contact  or your Client Success Manager. This service is free of charge.

To replace the header row in your CSV export file:

  1. Go to Exports A/B from your site's main menu and select the cogwheel icon () next to the export channel you want to modify.

  2. Select the Settings tab.

  3. In Replace Main Header in CSV (optional), enter your new header row and separate the names of the attributes with a comma (,). The platform omits the commas in the output file.

    For example, enter the string product_ID,product_title,price for the CSV export file to contain the header row product_IDproduct_titleprice.

    If you enter the string product_ID, product_title, price, the platform outputs an export file with the header row product_ID product_title price.

    Tip

    You can use empty and dynamic attribute names in Replace Main Header in CSV (optional):

    1. Empty attribute names

      If you need an attribute without a name, you can enter a space character instead of the attribute's name in between commas. For example, enter product_ID, ,price for the CSV export file to contain the header product_ID price.

    2. Dynamic attribute names

      If you need an attribute to contain dynamic data, such as today's date, you can enter a Twig expression instead of the attribute's name in between commas. For example, enter product_ID, {{ "now"|date("m/d/Y") }}, price for the CSV export file to contain the header product_ID 06/22/2022 price.

  4. Once you have entered your new header row, select Save.

Labels, Tags & Sorting tab

Add labels - If needed, add labels to your exports. Labels are helpful if you have many different exports and want to categorize them. You can later use these labels as filters in Exports A/B.

Once you’ve created a label(s), go to Exports A/B, and on the Overview page, you now see a Labels button. Select Labels and choose your desired label(s). You can also see a Labels column containing all labels assigned to each channel on the Exports A/B Overview page.

tracking_label.png

Export Tags - Export tags let you distinguish column titles for each exported product. This option enables you to apply a custom export tag to each row of your export file. In the Add new tag section, enter a Key and Value.

export_tags.png

Here are two examples of Export Tag, Key, and Value entries to get the desired outcome following:

Desired outcome #1: BMEcat without CDATA ( <![CDATA[attribute value]]> ) -

Key: custom_xml_writer_class

Value: ProductsUp_Xml_File_Writer_BMEcatWithoutCDATA

Output result: Here is the value from the attribute

Desired outcome #2: Show CSV output with enclosures ( ‘’ or ““ or || ) -

Key: custom_csv_writer_class

Value: ProductsUp_Csv_File_Writer_AllEnclosured

Output result: ‘row1’;’row2’;’size’;’price’;’product_id’

You can also choose to use pre-existing export tags from another platform in Authentication. See Add OAuth authentication to external systems to set up authentication with another platform.

Sorting - If necessary, you can define the order of exported products based on a specific column. Choose Select Column, then select the specified column. Select Method lets you later sort products in the export feed numerically or alphabetically. You can then sort the products under Select Direction, Ascending, or Descending. Once that’s done, select Add Sorting Rule.

labels_page.png

Pricing tab

Add a pricing model for your channel to calculate costs in the Reporting section.

For calculating cost information, see Set CPC Add Cost in Reporting (legacy document).

pricing.png

Status menu

You can access your channel’s export history from the Status tab in the left main menu. See past exports by scrolling through the entries.

status.png

Order Columns menu

You can control the column order for your final output feed. Select and drag the columns as you wish. If you exported them once in their set order, they appear green. If the order changes and you have not exported them, they appear black.

order_column.png