How to configure your export

Specific marketing channels require unique setups and upload procedures. Learn more about what to watch out for in the following sections.

How to upload Facebook Dynamic Ads

This article is about how to create and upload a feed in Facebook Business Manager using either the Facebook Fetch Schedule or the Facebook Marketing API. You can get more detailed insights into this on our Blog.

Prerequisite: Your business is listed in Business Manager.

Submit your product feed aka product catalog to Facebook

This product feed lists all the products you want to advertise on Facebook as well as their unique attributes (title, description, price, image link, etc.). The social media platform supports many existing formats. The attributes required are very similar to the Google Merchant Center feed.

Add a “custom audience” pixel to your website

This is necessary to track which Facebook user has visited which product on your website. Based on the exact product they viewed and based on where they got to in the purchasing process, it allows you to create custom audiences to which you can dynamically serve your ads.

Create a dynamic product ad in Power Editor

In cooperation with one of the Facebook Marketing Partners you need to determine how you want your product information to be displayed in the ad. In creating your ad you need to select ‘Product Catalog Sales’ as your objective.

1. Create a feed in Productup

Activate the export channel Facebook Dynamic Product Ads in Productsup int the Exports A/B tab and set it up according to the channel specific requirements.

  • Export the feed using Productsup Serveras destination if you want to import the feed into the Business Manager using the Facebook Fetch Schedule.

  • Export the feed using the Facebook Marketing API: Product Feed as a destination if you want to define your own schedule for the upload.

3cf1a335f5f8f6cd20d70079322d2445.png

Authentication: Choose your Facebook authentication.

Product Catalog ID: After adding the catalog to the Business Manager in Facebook you need to enter the ID here.

Interval: Here you define the schedule that Facebook uses for importing the feed into the Business Manager.

Feed Name: Enter the name of your feed and make sure that it matches with the feed name in the Business Manager.

Market Country & Default Currency: These options can be made in the Business Manager directly or alternatively directly in the Productsup setup.

Trigger Download: Enable this option if you want Facebook to refresh your feed according to the schedule you set in "Interval".

Active: Set the destination to active as soon as you want to start using it.

2. Create a product catalog in Facebook Business Manager

You need a Business Manager account with at least one Facebook page.

ac1137ab862ba38a0aedb8a89056195e.png

In Settings click on Product Catalogue and Add New Product Catalogue .

ecfed19debaf716b0bbede7c5e6d950e.png

Choose Create new catalog .

37a0bda46d616d117c3281bd6c3f31e8.png

Enter your product catalog name and click on Create Product Catalogue to save the settings.

5c38e6332cdeb4867c81227c5e93e9e9.png

Click on Add Product Feed for the created product catalogue.

e5ebfe80b2410c22cc7d5090e6e87364.png

Enter a feed name.

Select Auto-Upload with URL

Enter the feed URL.

For Encoding choose Auto Detect or UTF-8.

Select the same Delimiter as in Productsup (per default: Tab).

Select Use quoted fields .

Select Daily for Upload Frequency .

Finally, click on Schedule Upload .

ad5a8e905845eed0c13e3fad9738fdfd.png

Facebook will start to upload your feed. It can take a few minutes.

907327162b250f6f6a391a4029377c1f.png

After a few minutes you will see your products:

4330feb45ad380049d415e6b9f5a8903.png

If you get any error message log into Productsup and correct your feed.

How to configure your YouTube.com export

This article will show all the necessary steps to successfully upload your data feed to YouTube.com in order to publish your product videos there and import the Analytics data from YouTube back into your Productsup site.

Upload your feed to YouTube.com

To successfully export your data to YouTube.com the following steps are required:

1. Create a YouTube account

Go to YouTube.com and click on the top right on Sign In. Click on Create Account.

2. Add YouTube authentication in Productsup

Please see Add OAuth authentication to external systems for more information about that.

382014cfaf353de1fc5e66baf0d6ef13.png

3. Add YouTube export and fill in all required information for the destination

The next step is to add YouTube as a channel. Open the Exports A/B tab and click on Add Export in the top navigation.

Add the YouTube channel to your site and choose a custom name if needed.

f2b291073c3bdb2c124b00bab95533eb.jpeg

Click on Setup for the YouTube export.

00338a319bcf288dcfc0cae675df1669.jpeg

Click on Add Destination and choose the YouTube API from the list as the destination.

0f2fd4e13a1343023b93bd0ca046e3b5.jpeg
2edf7fc59242a20e1745b53d69e9ae74.jpeg

In the destination settings it is necessary to use the correct authentication for the YouTube Channel that you have created in the second step. You can select for which video category the video feed is used.

be318c34e4a51946c0c53013946d7c0b.png

Important: When uploading the videos via the YouTube API a tag with the video ID is added to synchronize the YouTube ID with the Productsup internal video ID. This requires no setup from your side but happens automatically during the upload. With this method we make sure that videos get updated and are not uploaded again as duplicates. Productsup will only update or delete videos that have this tag.

Please make sure to never delete this tag within the YouTube interface.

Populate the Export attributes in Dataflow

  • location: This attribute contains the URL to the video you want to upload

  • description: Add the description of your text or relevant marketing copy you want to display on YouTube

  • title: Create a title for your YouTube video within this attribute

Import the YouTube Analytics data into your Productsup account

To import your YouTube.com metrics into Productsup first click on Add Data Source in the Data Sources menu.

Search for YouTube Analytics - Fetch and select it as a data source type. Fill in all the required information.

d4e811c7e190eee8975e9a4415e8c552.png

Authentication: Select the authentication that grants access to your YouTube account.

Channel: Enter the ID of the channel you want to import data from.

Metrics: Enter all the KPIs you want to import into the platform in this input field.

Start Date/End Date: The time range of your analytics data.

Click on Save and on Import at the top of the page in the Data Sources tab to manually import your data or the feed will be imported with the next scheduled import.

How to configure your ebay export

This article will show all the necessary steps to successfully upload your data feed to the eBay Marketplace.

To successfully export your data to the eBay Marketplace, the following steps are required:

  • Create an eBay account

  • Add eBay authentication

  • Add eBay Marketplace export

You can create an eBay accountfollowing this link.

The second step is to add the authentication for ebay. To get more information on how to set up authentication, see Add OAuth authentication to external systems.

1831a0c0bbd7af563555a535d60c3a0c.png

The next step is to add eBay Marketplace as a channel. Open Export A/B and click on "Add Export" in the top navigation.

Add the "eBay Marketplace" channel to your site and choose a custom name if needed.

3097d544f4b6ec967663d7a1572c57e2.png

In the channel setup you need to choose eBay Marketplace as the destination and choose the authentication you created in the step before.

5d1401bb0f87417af9ad740d2c9b9df8.png

After the channel destination setup is done you can optimize your feed in the Dataflow.

Important: The eBay Marketplace export is in the way that eBay has strict regulations about the data.

  • All products need to have a valid eBay category assigned. You can accomplish this by setting up a list as described in Replace attributes with Partner Taxonomy Mapping list following the eBay taxonomy in the language you are advertising in.

  • You have an initial upload limit which will be increased over the time depending on successful sales and positive ratings.

  • This limit is based on the number of "in stock" items you send there. This means sending stock information is critical and you may want to play around with your stock figures in order to get as many different products as possible live.

Example: If your feed has 20.000 products, you can send them all if you give each a stock count of "1". If you give them a stock count of "2", you will only be able to push half the amount of products there, etc.

How to configure your Bing API export

If you want to export your data to Bing via the Bing Content API you should stick to the following steps.

  1. Add the export channel Bing Content API in the Exports A/B tab.

  2. Click on Setup for that channel.

d8941acb119f7abceef40278446cac0d.jpeg

3. Click on Add Destinationwithin the Setup page.

655e03cd52460c3f2f77ab0199dff15b.jpeg

4. Choose the Bing Content API from the dropdown list.

4c8933dab0f32b89c716e19292e4cd84.jpeg

5. Fill in the following form with the relevant information. Merchant Center ID: Fill in the ID for your Bing Merchant Center Shop. Possible values for Target Language: English, german and french Possible values for Target Country: Australia, Germany, France, the United Kingdom and the United States Possible values for Authentication to use: eBay and YouTube Channel

146a3e32604f09f76378d3f41018aad9.jpeg

How to configure your Google Hotel Price Ads Export

Google Hotel Price Ads

Google Hotel Price Ads export enables you to advertise your hotels and vacancies on Google. Please signup for Hotel Ads here

Since Google expects latest availability data here, the setup here is a bit different than usual.

You will need to setup three sites, one that contains your hotel data, one that contains your room information (metadata) and one that contains your availabilities.

Once you are done with the setup, we create an API endpoint for you, where Google can look up your availabilities.

1. Create the Hotel List Feed

Add a new site where you import your hotel data.

Add Google Hotel Ads - Hotel List Feed as an export template in Exports A/B by clicking on the Add Export button in the top right corner and filtering for Google Hotel.

daf0e695467107a729e645fcd9c90a5b.jpeg

Go the export setup and click on Add Destination.Choose Google Hotel Ads API (Hotels) from the dropdown and click on save. You will be forwarded to the API Setup.

b58f823063e23722d642eb5156138c87.jpeg

Placeholder API Setup

When you have finished the API setup, go back to the export setup and add the Productsup Server as a second destination. After exporting at least once, copy the link created and pass it on to Google.

When you have finished the API setup, go to the Dataflow and create all mappings neccessary. Make sure to provide information for all mandatory columns (dark grey). You can provide additional information by mapping the optional columns (light grey).

b479901c4b976ba43f3d71f93b339845.jpeg

2. Create the Hotel List Feed

Add a new site where you import your room availabilities and prices.

Add Google Hotel Ads - Rooms and Vailabilities as an export template in Exports A/B by clicking on the Add Export button in the top right corner and filtering for Google Hotel.

290721bd7a225e46893e640b86c8d9e5.jpeg

Go the export setup and click on Add Destination.Choose Google Hotel Ads API (Rooms and Availabilities) from the dropdown and click on save. You will be forwarded to the API Setup.

bb48ccb5fb1d75bac77a0ed254c54638.jpeg

Enter the site ID of the site you are in.

When you have finished the API setup, go to the Dataflow and create all mappings neccessary. Make sure to provide information for all mandatory columns (dark grey). You can provide additional information by mapping the optional columns (light grey).

9bbe6816858d3fbad93dd0e489dde229.jpeg

3. Create the Hotel Metadata Feed

Add a new site where you import your room availabilities and prices.

Add Google Hotel Ads - Hotel Metadada as an export template in Exports A/B by clicking on the Add Export button in the top right corner and filtering for Google Hotel.

bf549188df78d98429759a2d1dbe5eb8.jpeg

Go the export setup and click on Add Destination.Choose Google Hotel Ads API (Metadata) from the dropdown and click on save. You will be forwarded to the API Setup.

367ccc7e4a00771b4bbc129a0da8f657.jpeg

Enter the site ID of the site you are in.

When you have finished the API setup, go to the Dataflow and create all mappings neccessary. Make sure to provide information for all mandatory columns (dark grey). You can provide additional information by mapping the optional columns (light grey). You have the option to add additional names and descriptions in english and german. If you want to add more languages, you can add additional columns, but need to stick to the given name structure:- description_{language code} - name_{language code}

Examples: - description_fr - description_fi - name_fr - name_fi

c0326d9e5fd2aeed6371507f238fdf15.jpeg

After creating the three exports, please contact your Productsup Support, so we can create an API endpoint for Google.

4. Things to consider

Room Capacity and Occupancy In the room bundle response, the default occupancy of all rooms defined is recognised as 2, by Google. However, if you define the capacity as 1, you need to explicitly set the occupancy as 1, otherwise Google will flag the room bundle as invalid. Though not required, it is strongly recommended that the capacity and occupancy are added to each room bundle for the Room and Availabilities export.

Hotel List Feed It takes Google up to a week to process any new hotels sent via the hotel list feed, after the initial onboarding period.

How to configure your Google Manufacturer Center Export

Google Manufacturer Center is a free tool that helps marketers in brand manufacturing firms leverage how their brand and products are presented on Google Shopping, Search and other Google Services.

To get detailed information about the value Google Manufacturer Center adds for your brand, you can download our Google Manufacturer Center Whitepaper here.

By using the Google Manufactuer Center Export in Productsup, brand manufacturers can easily send feeds containing high quality information about their products to the Google Manufacturer Center. Else the Google Merchant Center Export, this will enrich your product data globally, and for all ads with all retailers selling your product. The export provides columns for various information you'd like to add to your brands products listed in the Google Merchant Center. Just map the columns you want to export to the Google Manufacturer Center in your Dataflow and make sure this information is also provided within your feed.

d228838bf4213075982c7ddcc0cbb85d.jpeg

Add the feed to your Google Manufacturer Center by registering it in the UI.

3b9e49630d7c06c2f7b2a7a18e19eb8a.jpeg

Just provide a feed name, choose the upload method (manual or scheduled) and provide the feed location. You can choose to upload a test feed to review your data in the Google Manufacturer Center first.

How to configure your Meplato export

How to configure your Meplato Export

This article will show you all the necessary steps to export your products to Meplato.

1. Create the Meplato Export

Go to Exports A/B and click on the Green Add Export Button in the top right corner.

Choose the export Meplato and click on Add.

Setup the Meplato Destination by clicking on the setup button of your export, clicking Add Destination and choosing Meplato API from the dropdown.

After clicking save you will be forwarded to the API Setup.

2. Setup the Meplato API

Enter your API User and API Pass as login credentials and the API Key and API Pin to access the desired catalog.

Figure 1. TITLE
TITLE


Audit

  • If you just want to push new products to Meplato set Audit to false.

  • If products that have been removed from your feed should also be removed from your Meplato catalog, set Audit to true.

Publish

  • There are three settings for the Publish option: true, false and only.

  • If you want your products to be published directly, set the option to true.

  • To have them uploaded to Meplato without publishing them, set this option to false.

  • When you have uploaded them without publishing and want to manually publish them later on, you can set this option to only.

How to configure your Google Product Ratings Export

Google Product Ratings Exportenables you to upload product ratings from your own shopping system and 3rd party sources to the Google Merchant Center.

Map the columns you want to export in your Google Ratings channel in your Dataflow and then export it to an FTP or the Productsup Server. Afterwards you can add this export with your product ratings to the Google Merchant Center.

Figure 1. Image
Image


The following columns are mandatory: - reviewer_name - review_url - product_url - ratings_overall_min - rating_overall_max - ratings_overall_average

It is highly recommended to provide the GTIN columns, despite it not being mandatory. It is used by Google to match the ratings with the products:

"The reviews data from a Product Ratings feed is matched to products based on a number of factors, the strongest being globally unique product identifiers such as GTINs. Without GTIN data, Google will attempt to match a review through other metadata information such as SKU, Brand + MPN pairs and product URLs, though these identifiers generally do not offer a good match. In short, without GTINs, matching issues may occur. What this means is that you may not see star ratings appear alongside the products your business offers."

If you can not provide a GTIN, make sure the information in the Google Ratings export correlates with the one in your Google Merchant Center feed, e.g. sku in the Google Ratings export needs to correlate with id in your Google Merchant Center feed.

You can find more information on the preconditions to add your Ratings feed to the GMC here.

How to configure your GDSN Export

1. What is GDSN?

The Global Data Synchronisation Network (GDSN) provides a global registry for product data and makes sure that product data worldwide is accurate and compliant with universal standards. It was launched in 2004 by the European Article Numbering Association (EAN) and the Uniform Code Council (UCC) under authority of GS1. The non-profit organization has the aim to offer one global system of standards for all business communications.

The GDSN is used by manufacturers and suppliers to provide their product data to trading partners worldwide. With every update on the supplier or manufacturer side, the data in the pool gets refreshed. Like this everyone accesses the same continuously updated information.

You can read more about the functionality of the network here.

2. How to synch your data with a GDSN Datapool

You can upload your data to any datapool that has been GDSN certified according to the GS1 standards. If you want to export your product data to one of these, please contact us via k2@productsup.comas it requires some additional custom setup work from Productsup's side.

How to configure your Mirakl Product Prices and Availabilities Export

The Mirakl Product Prices and Availabilities Export enables you to export information about your prices and availabilities to marketplaces based on Mirakl's Marketplace Platform (such as the examples below).

59d7430ab77d5eca2fac8f2a5e522a86.png

These are the attributes you can send - mandatory ones in blue, recommended ones in light grey:

ae95fad1fb1128884d7887d7b6e5a3fb.png

To export the data to Mirakl, you need to choose Mirakl as an export destination in the setup of the channel in Exports A/B.

2059b2744e4be2bbc7e163ae8c6f789e.png

Host: The host of the API

API Key: Required for the authentication

Import Mode: There are three kinds of import modes which you can select for the API: "Normal", "Partial Update" and "Replace". Default is set to Normal. The import history is kept for 60 days, with a maximum of 500 files by seller.

A) Normal: The offer is modified based on the value of the "update-delete" column. Attributes assigned to fields not present in the file are not updated.

Update-delete field is set to “update” or is "blank":

  • if the SKU field does not match any existing offer in the shop, a new offer is created

  • the product-id and product-id-type fields link an offer to a product

  • if the SKU field matches an existing offer in the shop, the offer is updated

Update-delete field is set to “delete”:

  • the offer is deleted

  • only the SKU field is used, the others are ignored

  • if the offer does not exist, an error is returned

B) Partial Update: The update mode allows you to only update fields containing data (not blank). Attributes assigned to fields not present in the file are not updated. Offers are identified by the SKU field. If the offer does not exist, an error is returned.

Important: The update-delete field can exist, but must be blank. If not, an error is returned.

C) Replace: We match the offers contained in the file and these contained in Mirakl.

  • All the seller’s existing offers which are not present in the offer file are deleted and replaced by those defined in the file

  • Seller's existing offers also present in the replacement file are not deleted but only updated.

Important: The update-delete field can exist, but must be blank. If not, an error is returned.

Warning: When creating offers and products at the same time using the back office or API and using any import mode, all the offers from your file get the "Waiting" status, waiting for product creation. However, selecting the replacement mode is risky because your existing offers (if any) are deleted right away, except for the ones which exist in your file. The other offers which exist in your files are put in a "Waiting" status. Then, each time products are created in Mirakl, a check is done on all your offers which are in the "Waiting" status to know if any of these offers can be created. Mirakl keeps offers in the "Waiting" status during 10 days before deleting them. The operator can configure this time period.

Shop: The identifier/ShopId of the shop

How to configure your Google AMP Pages export

Google's accelerated mobile pages are extremely relevant for e-commerce businesses as according to their Developer Advocates "AMP is a natural fit for e-commerce because AMP makes webpages fast, and fast pages help with purchase conversions."

Within Productsup you can export your product data into the AMP HTML template. With this template you can create AMP optimized product pages that can be used for your website.

Activate the channel "Google AMP Pages" in Exports A/B. Map all relevant columns in Dataflow. It is important to include a unique value as the export column "filename", as this is necessary for when writing the export file.

Choose "Google AMP Pages (Productsup Server)" as the export destination in Exports A/B:

Figure 1. destination
destination


Name the file as you wish, making sure that the extension ends in .csv. Your file should look like this: examplefile.csv

It is important to fill out the Google AMP Twig Template (found under Settings in the Google AMP Pages channel), so that the output file can be defined and written. Without including a template, the file cannot be exported.

Figure 2. destination
destination


The Twig Template contains HTML-Code (such as the below), which determines the relations of the variables in the output. For example,

<b>{{ title }}</b>

will be populated with the column named "title" from the export. This is the same for

<b>{{ price }}</b>

, and so on.

Figure 3. destination
destination


More information about Twig can be found under the following external link.

Once you export this channel, a zip-file with one HTML file per product will be generated. You can find the link to this zip file at the very bottom of your channel's setup.

How to configure your Excel export

The Excel Template export allows you to fill an existing Excel spreadsheet (template) with feed data. Either as two-dimensional data tables (Data Table Sheets) or one worksheet per product (Single-Item Sheets). Product images can be included in Single-Item Sheets.

Setup the Export

You will need to add an export specifically configured for use with the Excel Export feature. This example uses an "Excel Export" template where you can add custom attributes.

Figure 1. Export Setup
Export Setup


  1. Go to your Site's export page and add the "Excel Export" template.

  2. Open dataflow and add the attributes needed in your excel spreadsheet to the "Excel Export" template.

  3. Go to the Site's export page and add the destination "Excel Spreadsheet"

Prepare a Template

Requirements

The Excel template file must meet the following criteria:

  • Office Open XML (.xlsx) Excel 2007 and above

Please note that if you are using an Excel Template (.xlt, .xltm, etc.) you will need to convert this into a basic .xlsx file in order to be able to use it.

Placeholder

All contents and styles will be kept unless it's a Productsup placeholder. Placeholders will be replaced by contents from the data feed.

Figure 2. Placeholders
Placeholders


Text Placeholder

Text placeholder is available in Data Table Sheets and Single-Item Sheets.

To insert text from the feed content you have to use the placeholderPRODUCTSUP_VALUE('<attribute>'). It could appear somewhere in a cell content or be the cell content's only value. For example, a cell could contain:

  • Cell A1: "Title:PRODUCTSUP_VALUE('title')"

  • Cell A2: "PRODUCTSUP_VALUE('title')"

In both examples,PRODUCTSUP_VALUE('title')will be replaced by the attributetitlefrom the feed's product. If the title is "A random title", cell A1 would contain "Title: A random title" and cell A2 will contain "A random title"

Image Placeholder

Image placeholder is only available in the Single-Item Sheets.

To insert an image you have to place the placeholderPRODUCTSUP_IMAGE('<attribute>')into a cell without any other contents. The attribute has to contain an URL to an image. By default, the image would be positioned at the upper left corner of the cell and take the size of the cell where the placeholder is in. It is also possible to merge multiple cells vertically to expand the height for the image.

Alternatively, when you want to define the maximum image size, the placeholder takes a second argument, describing the width and height for the image.PRODUCTSUP_IMAGE('<attribute>',100x100)would place the image in a 100 pixel by 100 pixel box at the same location, the upper left corner of the cell. The image will either take full width or full height of the defined box, whatever fits first.

Figure 3. Image Options
Image Options


Number Placeholder

Number placeholder is available in Data Table Sheets and Single-Item Sheets.

To insert numbers in a number format instead of as a string, you have to use the placeholderPRODUCTSUP_NUMBER'('<attribute>').

This does only work with content that consists only of digits and dots, any other content will lead to an empty value here.

Data Table Sheets

A Data Table Sheet contains a table with many attributes horizontally and many items vertically. The template has to define placeholders in one single row. This row and the following will be replaced by the content of the feed.

Figure 4. Data Table Template
Data Table Template


If you need to add styles to the table, all styles will be taken over and if you need to style text, you can style the placeholders and the style will be used for the final data.

Single-Item Sheets

A Single-Item Sheet contains information about one single item. You would need to provide a template worksheet in the Excel spreadsheet. You can freely design the template and place text and image placeholders where ever you want. Productsup will create one worksheet for every item in the feed and remove the template from the final Excel file.

Figure 5. alt text
alt text


Setup the Destination

To use the template you have to upload your Excel template file to an HTTP(s) location of your choice. Go to the setup page for the destination "Excel Spreadsheet" which you've created in the first step and there you have three input fields:

  1. The URL to your Excel template file

  2. The name of the worksheet containing the data table template

  3. The name of the worksheet containing the single item template

After the initial run of the site (when an export is issued), the destination URL will be provided at the bottom of the Settings screen for the specific Excel Export in the Filename area. The destination URL will also populate in the Notifications pop up window at the end of active processing.

Options for the data table template name

If you need multiple data tables in different worksheets, you can provide a comma-separated list of worksheet names for the data table template.

How to configure your Image Exporter export

The Image Exporter enables you to save the visuals available under the image URLs in your feed as physical images hosted on Amazon S3, Microsoft Azure Blob Storage or an FTP/SFTP server, either as single images or zipped.

Precondition: - To successfully upload your images to S3, you need to create an AWS account with Amazon following this link. - To successfully upload your images to Blob Storage, you need to create an Azure account with Microsoft following this link. - To successfully upload your images to an FTP/SFTP, you need to provide FTP/SFTP credentials that have write access.

1. Add the Image Exporter export to your site

Go to the Exports A/B section and click Add Export. Filter for "Image Exporter" and click the "Add" button.

Figure 1. ExportUI
ExportUI


2. Set up the Dataflow

You can export several pictures per product. Each image needs a URL and a filename that it will be saved under on S3. The mandatory columns are:

  • id: Your unique product identifier

  • img_url_ {ascending_number}: The source URL of the image

  • img_name_{ascending_number}: The image's file name incl. file extension

If you want to export only one image per product, map the "id" column and "image_name_1" and "image_url_1".

If your items have more than one picture that you want to upload, map the "id" column and as many "image_name" and "image_url" columns as needed.

Important: Make sure to not use duplicate image names within your feed, as this will cause the images to be overwritten on the server.

Figure 2. DataflowImageExporter
DataflowImageExporter


3. Configuring destinations

All destinations share 4 common settings: - Concurrency: This determines how many images will be downloaded at the same time. - Download Progress Notification Interval: This setting determines how often a notification for the download progress will be shown. - Zipfile (optional): When a filename is entered, all images will be zipped before uploading. - Zip Size Limit: Enter a maximum zip file size in bytes, if neccessary. If the size limit is reached, the images will be exported in several zip files.

3.1 Configure the S3 Destination

Go back to Exports A/B and click on the "Setup" button for the Image Exporter export. Click Add Destination and choose Image Exporter (AWS S3).

Figure 3. DestinationSetup
DestinationSetup


Enter your AWS credentials in Access Key IDand Secret Access Key, then choose your S3 Region. Add the name of the Bucket the images should be uploaded to and define the Base Path for the images.

3.2 Configure the Blob Storage Destination

Go back to Exports A/B and click on the "Setup" button for the Image Exporter export. Click Add Destination and choose Image Exporter (Microsoft Azure).

Figure 4. DestinationSetup
DestinationSetup


Enter your Microsoft Azure Credentials in Account Name and Access Key. Add the name of the Blob Container the images should be uploaded to and define the Base Path for the images.

3.3 Configure the FTP/SFTP destination

Go back to Exports A/B and click on the "Setup" button for the Image Exporter export. Click Add Destination and choose Image Exporter (FTP or SFTP)

Figure 5. DestinationSetup
DestinationSetup


Enter the servers address and your credentials, and add the basepath.

How to configure your Sailthru API export

Sailthru is the complete, unified and integrated marketing solution: the platform of choice for today’s modern marketer.

Just add the Sailthru Export and map all the neccessary columns in the Dataflow.

Figure 1. sailthrudataflow
sailthrudataflow


Select the Sailthru API destination to upload the data to Sailthru.

Just enter your API key and API secret and save.

Figure 2. sailthruapiui
sailthruapiui


How to configure your Facebook Dynamic Ads Video export

You can use the Facebook Dynamic Ads Video export to export your ads with video content to Facebook.

The mandatory columns are ID and video_link, title can be provided optionally if desired.

In the channel setup click on Add destination and choose Facebook Marketing API: Product Ads Video.

Figure 1. videoads
videoads


Please choose your Facebook authentication. If you haven't created one already, you can find more information on how to create one in Add OAuth authentication to external systems.

After choosing your authentication, fill in the necessary information to send your videos to the right catalog.

How to configure your Google Analytics Product export

The Google Analytics Product export can be used to enrich your data in Google Analytics with more information about your products. More information can be found here.

To add the export, go to Exports A/B and search for Google Analytics Product Export, click on +Add to add it to your selection of exports.

Figure 1. gaexport
gaexport


In the export setup, click on Add Destinationand choose Google Analytics.

Figure 2. gaproductsdestination
gaproductsdestination


Fill out the necessary IDs and select your Google Analytics authentication. If you have not created an authentication yet, you can find more information on it in Add OAuth authentication to external systems.

How to configure your Real.de marketplace export

The Real.de export allows you to introduce new products to Real.de and supply product data updates to existing.

There are three exports provided: Real.de marketplace (Products by CSV), Real.de marketplace (Products by API), and Real.de marketplace (Units by API).

Setup

Real.de marketplace (Products by CSV): Used for sending new products to Real.de via a CSV file.

Real.de marketplace (Products by API): Used for sending new products to Real.de via the Real API. Extra to the previous export, it allows sending multiple images or additional attributes.

Real.de marketplace (Units by API): Used to provide updates on stock and pricing.

<u>Only one</u>

of the both Products exports

<u>and</u>

the Units export is needed. Map these two channels in Dataflow and make sure you can provide at least the mandatory attributes.

The destination settings for both Products and Units are quite similar. Go the the export channels setup page and click on Add Destination, choose Real.de marketplace (Product API) (in case you have chosen the Products by API), Real.de (products) (in case you have chosen the Products by CSV) and respectively the destination Real.de (units) for the Units by API export.

5018e234eec30e968e5e493ce722e050.png

Client: Set the Username provided by Real.

Secret Key: Set the Secret Key/Password provided by Real.

Feedback import: This can be activated in order to receive feedback from the destination. Our platform will automatically create a new import column containing feedback information in case there was something wrong with sending product information to Real.de.

Main feed connection column:Choose the column to connect the feedback file (most likely your GTIN/EAN columns).

Feedback file connection column: Define the name of the new feedback column created, should the Feedback import option be activated.

Extra field separator: Set the separator you want to use for separating multiple content in the extra pictures and additional multi fields.

Sending multiple images or additional attributes

The Real API offers different solutions for sending additional attributes to Real:

Sending additional images:Please add the columnextra_picturesto your Real export section in Dataflow. The Extra field separator you set up in the export destination under Exports A/B will be used to separate the individual content.

Sending custom, single valued attributes: Please add the columnadditional_single_[attname]to your Real export section in Dataflow. The attribute attnamecan be selected based on a list provided by Real.de

Sending custom, multiple valued attributes: Please add the columnadditional_multi_[attname]to your Real export section in Dataflow. The attribute attnamecan be selected based on a list provided by Real.de. The Extra field separator you set up in the export destination under Exports A/B will be used to separate the individual content.

Example

c69cb5c8a5db8c0b04443f4d40bee967.png

How to configure your Cdiscount Offers export

The "Cdiscount Offers" export enables you to send pricing and stock updates for products that are already listed on Cdiscount. It can not be utilised to list new products.

This export requires the following mandatory attributes:

  • Offer/ProductEan

  • Offer/Price

  • Offer/Stock

  • Offer/SellerProductId

  • Offer/EcoPart

  • Offer/ProductCondition

Please make sure to populate each one of these mandatory attributes with values. Offers that are missing any of these attributes will not be sent to Cdiscount.

Setup

In Exports A/B, add the "Cdiscount API Offers" export. Within the export setup, select "Cdiscount API Offer Export Destination" as the destination.

9d1c51b5731796208d58158eca9f944e.png

Feedback import: This can be activated in order to receive feedback from the destination. Our platform will automatically create a new import column containing feedback information if there was something wrong with the product information sent to Cdiscount.

API Username: Username provided by Cdiscount

API Password: Password provided by Cdiscount

Active: Switch to "On" to activate this destination.

ZIP Filename Standard is "offers.zip", but can be changed for debugging reasons.

How to configure your FNAC API Stock Price Export

The "FNAC API Stock & Price Export" export enables you to send stock and price updates for products which are already listed on FNAC. It can not be utilised to list new products.

This export requires the following mandatory attributes:

  • price

  • product_reference

  • offer_reference

  • product_state

Please make sure to populate each one of these mandatory attributes with values. Offers that are missing any of these attributes will not be sent to FNAC.

Setup

In Exports A/B, add the "FNAC API Stock & Price" export. Within the export setup, select "Fnac API" as the destination and fill out the fields (see screenshot and below description).

9e0e9314884348f9576c836d477a781d.png

API Key: API Key provided by Fnac.

Shop Id: Your Fnac Shop Id.

Partner Id: Fnac Partner Id provided by Productsup.

Active: Switch to "On" to activate this destination.

How to configure your Amazon Inventory and Price export

The Amazon Inventory and Price Update (API) export lets you make Inventory and Price updates to your uploaded products on Amazon.

You should fill out the following columns included in the Amazon Inventory and Price Update (API) template:

inventory_price_update.png

This will be enough to update the Inventory (quantity) and Price (StandardPrice) on Amazon.

In order to push to Amazon, you may wish to decide between two different modes of fulfillment: Fulfilment by Amazon (FBA) or Fulfilment by Merchant (FBM).

If this is the case, you should add the below columns in the Dataflow. These columns can be added as they are written below (or additionally you can prefix them with “Inventory.” - e.g. you can decide between naming the columnInventory.Available or naming it just Available.

FBA

The following columns should be added if you are choosing FBA:

  • FulfillmentCenterID- supports the values: 'AMAZON_NA', 'AMAZON_EU', 'AMAZON_IN', 'AMAZON_JP'

  • Available- ‘true’ or ‘false’

  • Lookup- assign value 'FulfillmentNetwork' via a Static Box

  • RestockDate

  • FulfillmentLatency- the time frame between a customer placing an order and it being shipped (in days)

  • SwitchFulfillmentTo- supports the value ‘AFN'

FBM

For FBM you should add the following columns:

  • FulfillmentCenterID- for FBM, this should be left empty

  • Available- ‘true’ or ‘false’

  • Lookup- for FBM this should be left empty

  • RestockDate

  • FulfillmentLatency- the time frame between a customer placing an order and it being shipped (in days)

  • SwitchFulfillmentTo- Supported Values: ‘MFN'

Please note that the columns above will need to be added as custom columns on Dataflow.

For more information from Amazon directly, you can check their help section.

How to configure your BOL.com Offers export

With the BOL.com Offers API export, you can quickly list your offers on BOL.com. This export can be utilized to add offers for products that have already been listed on BOL.com.

Setup

Under the Exports A/B section, filter for BOL.com and then click the Add button on the bol.com Offers (API) tile.

6149d6a279bba.png

Add the Destination "BOL API" and enter the Client ID and Client Secret for OAuth that can be found in your BOL.com account..

6149d6a3b71ff.png

Activating "Feedback Import" will add the feedback information from the BOL API to the Data View.

Dataflow Setup

6149d6a4d5764.png

The only attribute marked as mandatory is the EAN, as you can provide information for one attribute only when updating existing offers. When creating new offers, please make sure to provide all the relevant information. When no offerId is provided, a new offer will be created. To update an existing offer, an offerId needs to be provided. Existing offerIds can be imported using the "Bol.com Offers (API)" Data Source.

How to configure your Yotpo API export

The Yotpo - Export Products export can be used to send product information to Yotpo

Adding the Yotpo - Export Products export

In the Exports A/B section, filter for "Yotpo - Export Products" and click on the "Add" button for the Yotpo - Export Products export.

6149d6a6b1c1e.png

How to configure your Walmart Marketplace API export

This export lists product offers on Walmart Marketplace.

To utilize this export, it is necessary to create an authentication first, while being logged in to the Walmart Marketplace. A step-by-step explanation of how to create an authentication can be found in Add OAuth authentication to external systems.

Setup

In the Exports A/B section, click on "Add Export" and filter for "Walmart Marketplace". Click on "Add" in the tile that says "Walmart Marketplace".

6149d6aa8ff69.png

The option to rename the export will show. Click on "Add" to proceed. (Renaming is optional). After being forwarded to the channel setup, click on "Add Destination" and select the Walmart API.

6149d6ab86321.png

Select the authentication created earlier. If no authentication has been created, yet, click on "Add New Authentication" to create one. It is possible to re-import the feedback from the Walmart API by activating "Feedback import".

Click on "Save" and everything is set up.

How to configure your Google Regional Inventory Delivery Zones Export

Delivery Zones are used when working with a regional inventory. This allows to provide different shipping rates and delivery times for different areas.

How to set it up

In case delivery zones are being provided to the GMC from several sources, it is neccessary to also import the existing ones, as the API import is likely to overwrite them and therefore other Delivery Zones than the ones provided via Productsup will be lost.

Find instructions on how to set up the import here.

Setting up the channel

In the Exports A/B section, click on "Add Export" and search for "Google Delivery Zone". Click on "Add" in the tile for the "Google Delivery Zones" export. Navigate to the Dataflow after the channel has been added.

6149d6ace7133.png

Mandatory columns: - country: Populated with the country code - name: Name of the delivery zone - postalCodeRangeBegin: Postal code of the delivery zone or first postal code (numeric order) when the delivery zone covers more than one postal code area

Optional column: - postalCodeRangeEnd: When the delivery zone covers more than one postal code area, the last area (numeric order) needs to be added here

Setting up the destination

Go to Exports A/B and click on the setup icon for the "Google Delivery Zones" channel. The Destination has already been automatically added. Click on the "Setup" button of the destination.

6149d6ae07ce6.png

Select the Authentication to use from the dropdown or click on "Add Authentication" to add a new one. Add the Merchant ID and Account ID, click on "Active" and save the destination.

It is now ready to export.

How to configure your SAP PCM Export

The SAP PCM Export let's the user export data to their SAP PCM, based on the classes created within the PCM. This guarantees a smooth integration with little manual work.

Setup

In the Exports A/B section, click on "Add Export" and filter for "SAP". Click on "Add" in the tile that says "SAP PCM / PCH - Type Class Export".

6149d6af5f7e3.png

The option to rename the export will show. Click on "Add" to proceed. (Renaming is optional). After being forwarded to the channel setup, click on "Add Destination" and select the "SAP oData Integration (PCM / PCH)" destination.

6149d6b0783c0.png

Enter Host and Authentication Token and click on "Check Credentials"."Catalogue Versions", "Type Classes" and "Languages" will be populated with the values found in the SAP PCM instance.

6149d6b1a42ad.png

The classes and languages that should be populated within the export can be selected by holding CMD (Mac)/CTRL(Windows) while clicking on them. Clicking on "Populate Export Attributes" will add all required attributes to the export.

As a last step it is necessary to navigate to the Dataflow and connect the attributes to the respective Intermediate attribute.

How to configure your Facebook Enhanced Product Catalog Export

Facebook Shops allows the user to create a unique shopping experience within the Facebook ecosystem. The Facebook Enhanced Product Catalog export is designed to provide all attributes necessary to set up a Facebook Shop.

Setup

Due to the high number of category-specific attributes, it is necessary (for now) to create one export per category. This will change in the future.

Go to Exports A/B and click on "Add Export". Filter for "Facebook Enhanced Product Catalog" and select the export for the desired category. Click on "Add". The option to rename the export is shown, this can be ignored or the name can be adjusted to the user's needs. Clicking on "Add" will forward the user to the Channel Setup.

6149d6b35b836.png

The next necessary step is to click on "Add Destination" and select the "Facebook Marketing API: Data Feed Delta" destination. Add the Product catalog ID and select Facebook Authentication. See Add OAuth authentication to external systems for more information.

6149d6b4b494e.png

Once this is set up, navigate to the Dataflow and connect all attributes required for the chosen category.

6149d6b5ce67c.png

How to configure your Salesforce Commerce Cloud Export

Productsup offers a selection of exports to push data to the Salesforce Commerce Cloud.

Overview of the Exports

  • Salesforce Commerce Cloud B2C: List Prices

  • Salesforce Commerce Cloud B2C: Sales Prices

  • Salesforce Commerce Cloud B2C: Inventory

  • Salesforce Commerce Cloud B2C: Metadata

  • Salesforce Commerce Cloud B2C: Inventory (Delta)

  • Salesforce Commerce Cloud B2C: Catalog - Category Assignment

  • Salesforce Commerce Cloud B2C: Master Catalog

  • Salesforce Commerce Cloud B2C: Master Catalog - Product Attribute Definitions

  • Salesforce Commerce Cloud B2C: Master Catalog - Product Options

  • Salesforce Commerce Cloud B2C: Master Catalog - Variation Attributes

  • Salesforce Commerce Cloud B2C: Master Catalog - Recommendations

Setup

Depending on what should be updated within the Salesforce Commerce Cloud, one or more exports can be selected. It is recommended to use specific sites for specific exports, to guarantee clean export data.

The Master Catalog exports only work in combination with the Main Master Catalog export