Import your data in Productsup - Advanced Settings

Learn how to handle the deeper technical aspects of setting up data sources in Productsup. Discover the Advanced Settings tab of the data source setup to modify your import data, add labels to data sources, and delete data sources.

Introduction

This section guides you through the advanced technicalities of setting up your data sources in Productsup.

While setting up a data source in Data Sources, you can use the Advanced Settings tab to modify your import data during the import process, add labels to your data sources, and delete data sources.

Such data source options as Feed URL have four (4) settings options in the Advanced Settings tab:

  • Labels

  • Options

  • I/O Settings

  • Delete this Import

Most other data source options, including Google Sheets, Productsup Platform API, and Google Merchant Center, have three (3) settings options in the Advanced Settings tab:

  • Labels

  • Options

  • Delete this Import

Locate the Advanced Settings tab

To access the Advanced Settings tab on the data source setup page:

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

  2. Select the cogwheel icon () next to a chosen data source.

  3. Select Advanced Settings.

    locate_advanced_settings.png

Set up data sources using Advanced Settings

Labels section

To distinguish between different data sources better, you may want to add labels to your data sources.

To add a label to a data source:

  1. Select Labels in the Advanced Settings tab.

  2. Give your label a name in the input field titled Add one or more labels separated by a comma (,).

  3. To add multiple labels to a data source, separate them with a comma (,).

  4. Select Save.

You can see your labels in the Labels column of the chosen data source in Data Sources.

Adding a label to a data source in Advanced Settings

Options section

To access a list of additional settings you can apply to a data source, you can use the Options section in the Advanced Settings tab.

The Options section of the Advanced Settings tab in the data source setup
  1. Select Options in the Advanced Settings tab.

  2. To activate a desired data source setting, check the box next to it and select Save options:

    1. Don't notify if data didn't change - This setting only applies to the option called Number of Imports without a change in Data Sources that you can set up in Monitor. Checking this box deactivates notifications about imports from the chosen data source with no change in the imported data. A data source with turned-off notifications has a crossed-out bell icon in Data Sources.

      Turning off notifications about data imports that have no new data
    2. Website Crawler: Do not remove javascript from body - This setting applies to the Website Crawler data source option. By default, Productsup removes JavaScript from the data it gathers while crawling a website. Checking this box disables removing JavaScript from the collected data in case the structure of the crawled website requires it. See Import data by crawling your website for more information.

    3. Pause Datasource - Checking this box pauses your data source and stops any further imports from it. This is especially helpful when searching for the causes of import errors in case of faulty data sources. Alternatively, you can pause a data source by selecting the pause icon in the State column of the chosen data source in Data Sources.

      Pausing a data source
    4. Force Active FTP mode - This setting only applies to data sources requiring an FTP connection. By default, Productsup uses the passive mode of connecting to an FTP server. Checking this option switches the mode to active, meaning that the FTP server should assign a port for Productsup to connect to.

    5. Allow this datasource to have no products - If you need your site to have a data source that is sometimes empty and has no data to import into Productsup, checking this box allows the data source to be empty, so the platform doesn't display its imports as failed.

I/O Settings section

If you want to modify or backup the data imported via the Feed URL data source option, you can use the I/O Settings section in the Advanced Settings tab.

  1. Select I/O Settings in the Advanced Settings tab.

  2. In the Available I/O Settings panel, select Add to use one of the data transformation or backup settings.

    Use the Available I/O Settings to transform data imported via the Feed URL data source
  3. You can see and edit all added settings in the Existing I/O Settings panel.

    To delete an added setting, choose the bin icon in the panel you want to remove and select Yes.

Transform a data source

To transform an XML, JSON, or XLSX file before importing its data into Productsup, use one of the following options:

  1. Transform XML with XSLT - You can modify your XML file with XSLT code if, for example, the structure of your XML file isn't compatible with the structure of your product feed. Add an XSLT code abstract containing your desired XML file structure in XSL Template and select Save.

    Note

    Currently, the platform supports XSLT versions 3.0 and older.

  2. Transform JSON to CSV - You can transfer your data in a JSON file into a CSV file. If your file has a complex structure, you can help the platform transform it by defining its product path and object-nesting approach.

    1. In Multiline, you can specify whether your file has multiple JSON objects and arrays:

      Note

      One JSON object may contain multiple products inside.

      1. Enter OFF if your file has only one JSON object that contains all your products.

      2. Enter SINGLE if your file has one JSON object per line of code.

      3. Enter MULTI if your file has multiple JSON objects per line of code nested in a JSON array.

    2. In Product Path, you can enter the path to your file's product node in the following format: xxx.product, where xxx is the path to the node containing your products and .product is the mandatory ending of the input string.

      For a JSON file similar to the following, the input in the Product Path field should be items.product. If your file requires mentioning multiple nodes in the product path, separate them using a dot (.).

      1{
      2  "items": [
      3    {
      4      "id": 2744883653,
      5      "title": "Test product 1",
      6      "image": "https://image.com/1"
      7    },
      8    {
      9      "id": 2744886389,
      10     "title": "Test product 2",
      11     "image": "https://image.com/2"
      12   },
      13   {
      14     "id": 2744887310,
      15     "title": "Test product 3",
      16     "image": "https://image.com/3"
      17   }
      18  ]
      19}

      Tip

      You can leave the Product Path field empty to let the platform know that your file has no JSON object or key leading up to the JSON array that contains all your products.

  3. Transform Excel (XSLX) to CSV - You can transfer the data from an XLSX file into a CSV file. Enter the name of the Excel sheet containing the data in Sheet Name or leave the field empty to let the platform detect the sheet automatically. Then, select Save.

    Note

    This setting applies to Excel files having the .xlsx extension only.

Back up a data source

Productsup lets you back up your data sources to third-party cloud service providers to help debug data sources, access archive data, etc.

Productsup offers backups to the following cloud service providers:

  1. Using the Backup Import Data (Amazon S3) setting, you can back up your data source to Amazon S3:

    1. Enter your S3 credentials in S3 Bucket, S3 Region, S3 Access Key, and S3 Access Secret.

    2. Specify the prefix of your remote file's name in Prefix Remote Filename and choose the format of your S3 folders from the S3 Folders Format drop-down menu as needed.

    3. Select Save.

  2. Using the Backup Import Data (Google Cloud Storage) setting, you can back up your data source to Google Cloud Storage:

    1. Enter your Google Cloud Storage bucket in Google Storage Bucket.

    2. If you already have a Google Storage authentication in your Productsup account, choose it from the Google Storage Authentication drop-down menu.

      If not, go to Authentication from your site's main menu, select ADD AUTHENTICATION, choose Google Storage Authentication in Type, give it a custom name as desired, and select Next. Then, choose Connect to let the platform redirect you to a Google Account page, where you can give Productsup access to your Google Storage account. Once finished, Google redirects you back to Productsup. Close the confirmation window to proceed and go back to the I/O Settings section of the Advanced Settings tab in the setup of the data source you want to back up.

    3. Specify the prefix of your remote file's name in Prefix Remote Filename and choose the format of your Google Cloud Storage folders from the Google Storage Folders Format drop-down menu as needed.

    4. Select Save.

Delete this Import section

If you no longer need a data source, you can use the Delete this Import section in the Advanced Settings tab to remove the data source from your site and make sure the site doesn't receive imports from this data source anymore.

  1. Select Delete this Import in the Advanced Settings tab.

  2. Select Delete and then select Yes.