This is how you create your own CSV list to easily manage manual products

We are often asked: How can I create the shop name and shop logos for a manual product? There is no standard function in the plugin, but this is possible via a separate CSV list.

1. Create CSV file

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

Create with Excel

Enter the column headers in the first line. Required fields are the product number and product title. You can simply increase the product number continuously.

1. Column headers in the first line

So you can easily link the columns later in the plugin. Otherwise the plugin would only display “column 1”, “column 2”, etc.

2. Create one line per product.

You can create as many products as you want, important is the consecutive number. This number is used to update the product regularly.

3. Save Excel file

Then save your Excel file but note the following options.

Ignore the following warning:

Create with the Editor

In the simple text editor, the Excel file looks like this:

If you do not have Excel, just put the file with the editor. Pay attention to the separators. If your separator contains the delimiter, the value under quotes.

You can also download the CSV file here.

2. Upload CSV file

Once you have created the file, you can copy the file to your FTP server. Either you use for the Upload Filezilla or the WebFTP access of your Hoster.

Put the file in a subdirectory on your webspace and create your URL. Depending on the website configuration with you the URL is different.

3. Creating the shop

Create a new CSV shop and configure it as shown in the following figure.

1. Select „CSV API“

So you can import any text files and that’s what we want here.

2. Insert CSV-URL (from the previous step)

Here you enter the URL from the previous step. Depending on where you saved the file with you.

3. Set template to manually

This causes the extended fields to be displayed.

4. Set the separator to “;”

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

5. First row is column header

Since we have defined column headers in our CSV example, we set a checkmark here.

4. Link the fields to the CSV file

After saving the new shop you have to link the fields from the CSV file with the standard fields.

1. link the fields with your CSV file

Each field, which you created in your CSV file, you link here with the respective field.

2. Set the checkbox to import the data

This hook will update the data in the product cache. After you make changes to the CSV file, you must set this checkbox again.

Note: If you have updated the CSV with the hook, this does not affect your already imported data. Only after the cronjob update is the product from the CSV database updated.

5. Import the fields

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

1. Select your CSV-Shop

Select the shop that you have created.

2. „Search“

Simply use the search without the search term.

3. Import products as desired

Now you can import your product from the CSV and can immediately use it as a normal product on your website.

Conclusion

The import via the CSV function makes manual work considerably easier. It is important to keep the CSV file in its place. The plugin updates the data from the file regularly. If you change or add something to the CSV file, these changes are also updated in your WP products.

Do you still have questions? No problem :-)
We are happy to answer your questions in our forum.