Importing products -- struggling with images...

Hi,

Products load via CSV but no images...

CSV file has a column named images, containing:

media/com_hikashop/upload/Boardgames/Carcassonne-05-Abbey.jpg

Product is created, but when looking at the product there is no image. Look at it through the back end and the image file is listed as:

media/com hikashop/upload/Boardgames/Carcassonne-05-Abbey

There is no underscore in com_hikashop and there is no file extension on the image file.

I would really like to understand how to specify the file location properly. Can you use the full URL to the image? Is the relative file name relative to the public_html folder?

Many thanks for your help.

Regards,

Ian P.
griffingrove.com

Hi,

In order to try and determine what HikaShop expects in the import file -- and why my images weren't appearing -- I deleted the image from one of my products and loaded another manually. Then I used phpmyadmin to check the results in the database.

The image file name used was Carcassonne-05-Abbey.jpg.

The file was loaded into the media/com_hikashop/upload folder -- as expected.

The *hikashop_file table had a new entry where file_name was NULL and file_path = carcassonne-05-abbey.jpg.

What surprised me here was that HikaShop had converted the image file name into lowercase.

I then moved the image file from the upload directory into upload/Boardgames -- and edited the file location. The image could not be located. Then I renamed the folder from Boardgames to boardgames -- and the image was now displayed.

So the solution here appears to be to ensure that all sub-folder and all image file names in the media/com_hikashop/upload must be lowercase. The import CSV file must then reflect this lowercase folder and file naming convention.

Regards,

Ian P.