problems importing cvs file

Hi @hfinlay10,

Can you please provide an example CSV file that doesn’t work?

Here’s the contents of a test file I made that throws the error. My original file had many more entries, but even this test file had the problem as described.

Image URL,Name,Categories,Short Description,Long Description
,Setting up a drip irrigation system,Water,,
,Keeping insect pests out of your trees,Pests,,
,Blossom blight,Pests,,

Hi @hfinlay10,

Thank you for the file content.

Please update the catalog plugin to solve this problem.

@ndre and @hfinlay10

Even with the latest version the same problem….

Number of product fields and number of fields in CSV file do not match!

Columns included in file:
0 => Image URL
1 => Name
2 => Categories
3 => Short Description
4 => Long Description

Columns expected in file:
0 => Image URL
1 => Name
2 => Categories
3 => Short Description
4 => Long Description

Please make sure that only the expected columns exist in the import file and the correct CSV separator is set.

The product specifications/Columns are as in the error message, no extra fields

Hi @terry789,

Can you please check which version do you have installed?

@ndre,

Now with version 1.5.8 it works correctly.

I assume you need to reapply the images to the products (?)

@terry789,

Thank you for the confirmation.

The images are assigned automatically if they are located in the media library.

@ndre,

That does not work properly yet.

Do I have to put the images in the media gallery first or will they also be imported? This is not happening now..

@terry789,

With the import tool included in the catalog plugin you have to put the images in the media gallery first.

If you want to import the images from external source I recommend Product CSV.

@ndre,

Okay, I first put the images with the same name in the media library.

Then done the import – 6 products successfully added to the catalog. –

But these are not included in the product pages. (?)

Do you see these products in the admin side? Can you please provide their URL?

@ndre,

Yes, the products have been imported, however the images are not “visible / linked”

https://artsdesign.nl/demo/products/nutricol-4800-ws/

All working now for me, although I didn’t have any images. Thanks.