How to configure your export (legacy document)

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

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.

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

In Settingsclick on Product Catalogue and Add New Product Catalogue.

Choose Create new catalog.

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

Click on Add Product Feed for the created product catalogue.

Enter a feed name.

Select Auto-Upload with URL

Enter the feed URL.

For Encodingchoose 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.

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

After a few minutes you will see your products:

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

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

2. Add YouTube authentication in Productsup

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

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 tab and click on Add Export in the top navigation.

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

Click on Setup for the YouTube export.

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

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.

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.

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.

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.

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.

Add a new site where you import your hotel data.

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

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.

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

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 by clicking on the Add Export button in the top right corner and filtering for Google Hotel.

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.

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

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

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

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.

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

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

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.

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

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

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.

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.

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.

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

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:

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.

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

Figure 1. ExportUI

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:

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

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.

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

Figure 3. 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.

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

Figure 4. 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.

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

Figure 5. DestinationSetup

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

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.

Only one of the both Products exports and 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.

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.

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 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 will be used to separate the individual content.

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

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.

In Exports, 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).

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.

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

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

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

Dataflow Setup

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.

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

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

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.

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.

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

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

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.

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

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.

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.

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.

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

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.

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

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