How can we help?

Product import using a CSV file

You are here:

CSV file requirements

Text explanation:

Below are the CSV file requirements:

  • The columns in the CSV can be named as you like, but the first column must contain the “id” (ProductID) be set.  
  • In addition, the field must “productName” (the product name) be supplied so that it is displayed in the matrix. 
  • Run a column "picture" (URL to the product picture) on. 
  • In the column names may no spaces and no umlauts turn up. If you want to use multiple words as a column name, they are 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 delimiter must semicolon ( ; ) to be used. 
  • The CSV file comes with the character code UTF-8 saved
  • 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 (e.g. "

  • text1
  • text2
' for bullet points. 

Video explanation:

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

YouTube

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

Load video


Create CSV file

Text Instructions:

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 Instruction:

Explains in a few steps how to create a CSV file.

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 Instructions:

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

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

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

Video Instruction:

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 defined in the CSV file (e.g. productName, shortDescription, etc.) can be selected in the selector in the line DataSourceColumn be selected and assigned. These columns can be displayed 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 SectionsAddSection .

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: frontend (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 your inquiry about the Digital Product Selector. Let's digitize B2B sales together in a sustainable way!
ContactPage

info

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