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 re-targeting 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

First, select Exports A/B in the site’s main menu. Next, select Add Export to choose an export channel template.

add_exports.png

Browse for export channel

Use the search field to filter the results for an export channel template. By selecting the channel category filters, such as Search Engines, Marketplaces, or Etailers, you can see the available channels that belong to each chosen category.

If the desired export channel is not available, don’t hesitate to send an e-mail with specifics (header, separator, name, etc.) to your account management team at support@productsup.com.

browse.png

My Export Channels

To view the most used channels in your company account, select My Export Channels tab. This tab provides you with a shortlist of the channels used the most. You can further filter your list of mostly used channels by selecting the category filters, Frequently Added and/or Recently Added. These display the most frequently and/or recently added export channels.

my_channels.png

Add and modify export channel name

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 if 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

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 the channel for your colleagues or add 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.

Learn more about destinations, see Feed destinations.

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. If you want to export one file only, use a 0 in the Limit (Products per file) section.

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

  3. If you want 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 in total 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. In case 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 above 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 to accomplish this.

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

Also, you can 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, you can turn on Shorten Tracking URL and select the column containing the respective content. Set to On to use.

Learn more about tracking options, see Setting up Productsup tracking.

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 - Only the account management team can turn on this option. You can use an export plugin if your output requires a specific format, such as JSON, TSV, etc.

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/after Main Header in CSV (optional) - Commonly, some export channels request additional headers before or after the CSV header column’s name. In this situation, 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) feature is not available for all exports. Use it when necessary.

add_header_beforeafter_option.png

Product Uniqueness - You can choose the column in your export feed that you consider being unique. If there are rows with duplicate values, the platform only exports one row. Set to On to choose the product unique 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

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 lets 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 (2) 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.

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 are in full control of 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