Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Show Table of Contents

Create your own CSV file and import it via CSV

If you want to maintain manual product data for a store manually in one place, CSV import is a good interface. You can create your own list and use it for import.

Create CSV file with Excel

First, create a CSV file on your computer. You can create them either with Excel or with any other editor.

File creation

Enter the column headers in the first row. Required fields are the product number and the product title. You can simply count up the product number consecutively.

1. column headers in the first row

To make it easier to link the columns in the plugin, specify the columns in Excel here. Otherwise the plugin would later display only "Column 1", "Column 2", etc.

Create one line per product.

You can create as many products as you want. The important thing is the consecutive number. The product will later be regularly updated via this number.

Save file

Then we save the Excel file with the following options.

Click on "Save as" and then select UTF-8 (comma separated) for the CSV file.

If you get a warning when saving (some features may be lost) you can simply ignore it.

You can now open the file in the text editor. To do this, simply click "Open with" and then "Notepad".

You can now recognize the text file itself which we need for the import:

If you don't have Microsoft Excel, just create the file with Notepad. Pay attention to the separators. If the separator occurs in your text, put the value under quotation marks.

You can also download the text file here.

Upload CSV file

Once the file is created, you can either FTP it to your web server or simply drag and drop the file into the media library. Simply upload the file using drag and drop.

Then copy the URL to the clipboard.

Create the store

Create a new CSV store and configure it as shown in the image below. Here you can find more information about the CSV interface.

1. select "CSV API

With this you can import any text files and that's what we want in this case.

2. enter the CSV URL (from the previous step)

Here you enter the URL from the clipboard.

3. CSV encoding

This field remains empty because we saved the CSV file as UTF-8 file.

4. set the separator to ";".

We use the semicolon in our example. But you can use any separator for your CSV file.

5. import mode

In this case we use Filestream. The file is located directly on our server.

6. first row is column header

Since we have specified column headers in our CSV example, we put a check here.

7. remove line breaks

Here we do not have to reconfigure anything.

8) Character concatenation

We also leave these settings at default.

Link fields to the CSV file

After saving the new store, you need to link the fields from the CSV file to the fields.

Link the fields to the CSV file here

Each field that you have created in the CSV file, you link here with the respective field.

Check the box to import the data

With this hook, the data in the product cache will be updated. After you have made the changes to the CSV file, you need to check the box again.

Importing the products

From now on you use again the usual functionality from the plugin and you can import the products into the internal product database.

Select your CSV store

Select here the store which we have configured before.

"Search"

Simply use the search without a search term.

Import products as desired

Select an "import option" and then ntu the products on your website.

How to add a product box to your page.

We have written a separate article on this. You can find it here. You can find the explanation for shortcodes here.

Updated: 1. March 2023
Still not using affiliate-toolkit?
Setup takes less than 5 minutes and you can start to import first products!
Learn more about the packagesDownload FREE Version
Still need help?
Submit Your Question
Please give us the details, our support team will get back to you.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram