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.
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.
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.
Select the shop that you have created.
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.
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.