Importing multiple images with excel csv file

  • Posts: 18
  • Thank you received: 0
11 years 10 months ago #54334

Hello,

I've read through the documentation and posts.

When I add upload one image to the upload folder, and put the image name in the excel document everything works fin.

However when I tried to add an additional image, I am getting the stock image(the bar code) rather than my own images.
In excel, I tried separating the two image names by , and ; but neither option will work.
I either get the stock image of the bar code, or no images at all when I view the product page.

Is there something I am missing?
Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
11 years 10 months ago #54353

Hi,

That works fine on our end. Separating by a comma or a semi colon should work.
Could you give your CSV so that we can see what you did ?

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 0
11 years 10 months ago #54388

I have no Idea why but now it's working!

Here is what I was entering into my excel sheet under the "images" column,

Samsung-Galaxy-S-Blaze-4G1.jpg,blaze4g.jpg

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 0
11 years 10 months ago #54650

Ok I'm having issues again.
Everything was fine, then I deleted one a category and after I re-uploaded the csv, the images are the standard bar-code picture again.

Here is the link to the page
phonequote.org/index.php/priceguide/sprint

I have attached a screenshot of my csv (ms-dos)

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
11 years 10 months ago #54697

I think that maybe your problem comes from the case of your images. You should try to put your images name in lower case. That might help.

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 0
11 years 9 months ago #58326

For some reason it's still not working.
Windows automatically makes the first letter of the word capital when I edit the name.
In the excel doc, I made the image names all lower case, and no luck.
I also tried making just the first letter capitalized but still no luck.

I shortened all the image names and removed any characters like underscores....

I am so frustrated, especially because it was working before!

I have uploaded the images to the correct place, media-com hikashop/upload

What do think is the issue?

Here is a screen shot of the excel doc and the back end of the product page

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 18
  • Thank you received: 0
11 years 9 months ago #58388

After playing around with this, it seems that hikashop doesn't like to import images when their file names have any capitals or numbers.

I tried renaming all the files with a batch renamer to make all letters lowercase,
and then changed the excel doc to have all lowercase letters but still no luck



This may be because there were still numbers in the image file names, but i am not 100% on that.
Also for anyone reading this, take not that the file that you upload must match the case of the file name in the Excel doc.

So what I did was:

downloaded all the images again, and when saving them, I used all lowercase letters,no numbers or smybols.

Then I uploaded the updated csv file.
All images are displaying properly.

I had to do this the hard way because my original image names were all random.
I had no simple way to determine which image file was associated with each product since there are about 300 products.

Please Log in or Create an account to join the conversation.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
11 years 9 months ago #58428

Thank you for your feedback.

Indeed, we recommend that you use lowercase file names as otherwise it wouldn't display properly the images on some configuration.

Please Log in or Create an account to join the conversation.

  • Posts: 228
  • Thank you received: 8
8 years 3 months ago #225969

Hi Nicolas,

Sorry to bring up such an old post but I've encountered an issue when trying to import a CSV file with over a thousand products. Each image file name is the sku number (product code) of the product. None of the images was imported. I've followed this video tutorial and nothing:
www.youtube.com/watch?v=UAoHFcZ4E-g


Never mind, I see my mistake now. The files were uploaded to the wrong folder.

Any suggestions please?

Thank you in advance,

Guy.

Last edit: 8 years 3 months ago by theguy.

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
8 years 3 months ago #226050

Hi,

So I guess that you no more need suggestions ? ;)

Any suggestions please?

Please Log in or Create an account to join the conversation.

  • Posts: 228
  • Thank you received: 8
8 years 3 months ago #226128

No, thank you. I love Hikashop, I really do :P

Please Log in or Create an account to join the conversation.

Time to create page: 0.102 seconds
Powered by Kunena Forum