How can we help?

Import Product Data - import product data

You are here:

In order for the user to receive a product recommendation at the end of the completed questionnaire, all products must be uploaded under the menu item "Products". If no interface is defined, you can upload a CSV file here.


Process of the Product Data Import

The upload takes place via the button Import Product Data.

First select the in the left corner of the dialog language for which you want to upload product data if you use multiple languages.

IMPORTANT: In order not to overwrite existing product data, before uploading at "Product Data Language" language can be selected in the top left corner of the page or during the upload dialog.

Language selection for product upload

After selecting your file, you will see a preview with an overview of the data to be imported in the subsequent dialog. You can also filter these based on the columns contained in the data.

Clicking on Import completes the process. The following dialog provides information on how many data records have been newly imported or updated.

A NOTICE: If you want to update existing products, you should take particular care not to change the ID of the products, as the matching is done via the corresponding product data column (id). The product data is updated while the matrix values remain unchanged.

My CSV file cannot be imported. Where is the mistake?

Possible sources of error can be:

  • The CSV file contains incorrect column titles such as spaces, umlauts or special characters. Also, check that each column has a title, as well empty titles lead to import errors.
  • The column titles are longer than 64 characters. Titles with 64 characters or more result in a loading error during import.
  • A product ID has been assigned more than once. Notice that each product row in the id column has a individual ID receives.
  • There may be one or more above the column titles blank lines. Make sure the first row of your CSV file starts with the column titles.
  • The CSV file contains the rightmost part of the document empty columns and/or at the very bottom blank lines. Background and solution: When creating your product file, one or more columns to the right of your collected data may be saved as empty untitled columns. Mark the last 5 - 10 empty columns in your file, delete them and save the file again. The same applies to the empty lines below your products: mark 5 - 10 lines, delete them and save the file again.

The columns in the CSV can be given any name, but the first column must contain the id (Product ID). In addition, the field product name (Product name) must be filled in so that the products are displayed in the matrix.

Allocation CSV Rarely in matrix

The Results page can be freely configured up to a certain degree. The respective columns with the corresponding content that have been named in the CSV file can be selected and assigned in the selector under Questionnaire> Result Page Product Sections in the "DataSource Column" line. For more information, see the next chapter.

Chaining CSV, digitizer backend, selector frontend

Download product data templates

You can either create a CSV file directly or use our Excel template with which you can validate the column names and then save the file as a CSV export. How to work with the CSV file can be found in the next chapter .

Excel template for validating and creating a CSV file: DOWNLOAD HERE

CSV template for direct use: DOWNLOAD HERE

Was this article helpful?
How can we improve this article?
How Can We Improve This Article?
Table of Contents

Contact

We look forward to every inquiry about the Digital Product Selector. Let's digitize B2B sales sustainably together!

info

mailkontakt@foxbase.de
phone+49 211 1586 4066
addressOststrasse 10, 40211 Düsseldorf