Enhance your products with additional data sources

Enhance your product data with additional data sources in Productsup to add more columns to your product feed and extend the feed horizontally.

Introduction

Besides adding main data sources to Productsup and enriching your product feed with more products, you can add additional data sources to your sites.

Additional data sources contain additional information about the products that are already a part of your main data source, thus extending your product feed horizontally. Productsup links new information from an additional data source to the products in the main data source using a Product Identifier, such as an ID, an SKU, a GTIN, or a combination of different attributes.

The difference between main and additional data sources

Main data sources add new products to the platform, while additional data sources add new columns to existing products.

In Data View, you can see products imported from your main data source:

main_data_source.png

To add more products to your site, you can modify the original main data source and trigger a new import. Alternatively, you can add another main data source to your site.

second_main_data_source.png

If you have a file featuring additional information about these products, for example, their pricing and shipping time, you can import it as an additional data source. The raw data in your file can look similar to this:

An example of a file that can serve as an additional data source

Once you add this file to your site as an additional data source, Productsup uses a Product Identifier to match all the products in your site with the products mentioned in the file. In this case, the id column works as the Product Identifier for both the main and the additional data sources.

additional_data_source_in_Data_View.png

Note

If there are columns with the same names in your main and additional data sources, your site always gets the data from the additional data source that is the last in the import queue. See Set import order for additional data sources for more information.

If there are products in your site that your additional data source leaves out and contains no new data about, Productsup skips them and assigns empty values to such products in the columns imported from the additional data source.

Add an additional data source

  1. Go to Data Sources from your site's main menu.

  2. Select ADD DATA SOURCE.

  3. Search for the needed data source in the Search bar and select Add or find a relevant data source in the proposed options and select Add. Give your data source a custom name if desired, then select Continue.

  4. Set up your data source. The data source option you chose defines the specific steps you should take to set it up.

    1. See Import data from internal systems for information on importing data from internal systems and using various types of files for data import.

    2. See Import data from third-party external systems for information on importing data from external systems.

    3. See Import your data in Productsup and Import your data in Productsup - advanced settings for detailed information on the Data Sources feature within the Productsup platform.

  5. Select Save.

  6. If the platform redirects you to Data Sources, select the cogwheel icon next to your newly added data source. If you are still on the data source setup page after saving the data source, move to the next step.

    Accessing the settings of an added data source to make it additional
  7. In the Content Mode panel on the data source setup page, select Additional Data Feed.

  8. In ID Column In This Feed, enter the name of the column within your additional data source that Productsup should use as a Product Identifier. This field is case-sensitive.

    Making a data source an additional data source on the data source setup page
  9. In the ID Column From Your Main Feed drop-down menu, select a column in your main data source that Productsup should use as a Product Identifier.

  10. Select Save all settings.

Set import order for additional data sources

Using the same names for columns in your main and additional data sources creates a conflict during data import.

Productsup imports data from your data sources according to the import queue you see in Data Sources and overwrites column values each time it finds a column with the same name as it progresses along the queue. At the end of an import process involving columns with the same names, the platform always shows the data originating from the data source last in the import queue.

Setting a specific order for importing each additional data source helps solve this issue.

Note

Main data sources are always the first to import data.

Arrange import order for your additional data sources

  1. Go to Data Sources from your site's main menu.

  2. Select the grip icon next to one of your additional data sources and drag and drop your data source to a position suitable for the desired import order.

    drag_and_drop.png

    Note

    If you have only one additional data source, you can't customize your import order. In this case, Productsup always imports data from your main data sources first and then proceeds to import data from your additional data source.

  3. A notification appears in the bottom right corner of your view confirming the platform has saved the new order successfully.