How can we help?

Product import using a CSV file

You are here:

Requirements for the CSV file

Text explanation:

The requirements for the CSV file are listed below:

  • The columns in the CSV can be given any name, but the first column must contain the "Id" (ProductID) .  
  • In addition, the field “ProductName” (the product name) must be included to be displayed in the matrix. 
  • Include a "Picture" (URL to the product picture) column. 
  • In the Column names there are not allowed to be no spaces and no umlauts allowed. If you want to use several words as column names, these should be written together and the first letter of the new word starts with a capital letter, such as “productName”. 
  • Text fields must be enclosed in quotation marks (“…”). 
  • As a separator. a Semicolon (;) should be used. 
  • The CSV file has to be saved with the character code UTF-8
  • Avoid untitled columns. If no column has no title, the CSV file cannot be imported.

The descriptions for benefits and shortDescription can be imported with cleanly formatted HTML code (for example "

  • text1
  • text2
“For bullet points. 

Video explanation:

A short list of the requirements for creating, editing and saving a CSV file.

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video


Create a CSV file

Text instruction:

Under the following link you can download an empty CSV template for viewing.

https://cdn.foxbase.de/csv_template/CSV_Template.csv

However, for the purpose of the Getting Started ColorSelector, please use the following ready-made template. Here you can see the correct structure, the column names and product information:

https://cdn.foxbase.de/f/Selector/allyoucaneat/GS_Farbselektor_Template.csv

Video tutorial:

How to create a CSV file explained in a few steps.

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video

Save Excel spreadsheet in CSV format

Here is a brief explanation of how to save an Excel spreadsheet in CSV format.

Text instruction:

The created Excel file must be saved in CSV format before importing. 

A CSV file can be saved in the UTF-8 character code as follows:

    1. Open Excel "empty" 
    2. Under "Data" click on "From Text / CSV" 
    3. Select and open the corresponding Excel spreadsheet with the products 
    4. Click on §Load§ in the import window 
    5. Save as CSV UTF-8 

Video tutorial:

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video


Relationship between the CSV file and the results page

The results page can be freely configured to a certain extent. The respective columns with the corresponding content that have been specified in the CSV file (e.g. productName, shortDescription, etc.) can be found in the selector in the DataSourceColumn and can be selected and assigned there. These columns can be viewed on the results page.

basic principle: All product specific content, (e.g. texts, product images, downloadable PDFs, etc.) that you want to present on the results page must be stored in the CSV file and imported into the digitizer.

To get to the DataSourceColumn option:
First click in the left menu bar Result Page. Then select in the bar above Product SectionsAdd Section out.

In the drop down menu you will see the different elements that you can add to your result page. By clicking Additional data For example, you can display the CSV columns benefits and shortDescription on the results page. Under DataSourceColumn you now access the contents of the columns of the CSV file.

The connection of the CSV file with the Backend to the Frontend looks like this: 

Connection of the CSV file with the backend to the frontend

Info: above: CSV file; left: backend or settings in the digitizer; right: front end (product recommendation for the user)

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