Images import: only first image works

  • Posts: 200
  • Thank you received: 6
11 years 2 months ago #160489

-- url of the page with the problem -- : livelaughlove.com/staging/index.php?opti...ce-hoodie&Itemid=110
To access the site, please use as both username and password this word: llluser
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.3.0
-- PHP version -- : 5.3
-- Browser(s) name and version -- : n/a
-- Error-message(debug-mod must be tuned on) -- : n/a

I did a test import of 5 products. Each product had 3 images and I am using the "Magic Zoom for Hikashop" component to get a zoom effect.

Here are the product pages:

livelaughlove.com/staging/index.php?opti...er-raglan&Itemid=110
livelaughlove.com/staging/index.php?opti...eace-tank&Itemid=110
livelaughlove.com/staging/index.php?opti...odie-grey&Itemid=110
livelaughlove.com/staging/index.php?opti...ce-hoodie&Itemid=110
livelaughlove.com/staging/index.php?opti...on-pocket&Itemid=110


In some of the products only one image is present while in a couple there are multiple images below the main one, but they seem to be all the same image.

For instance, here:
livelaughlove.com/staging/index.php?opti...ce-hoodie&Itemid=110
This is the content of the "images" column for this product:
AAA-20031-17_Bubble_Peace_Hoodie_14500_Front.jpg, 
AAA-20031-17_Bubble_Peace_Hoodie_14500_Back.jpg, 
AAA-20031-17_Bubble_Peace_Hoodie_14500_Side.jpg, 
AAA-20031-17_Bubble_Peace_Hoodie_14500_Detail.jpg

Yet all I have in the front end is what you see on screen and if I go to the backend this is what I see:
Image 	Name 	Order 	Delete 	ID
AAA-20031-17 Bubble Peace Hoodie 14500 Front	110
AAA-20031-17 Bubble Peace Hoodie 14500 Back	111
AAA-20031-17 Bubble Peace Hoodie 14500 Side	112
AAA-20031-17 Bubble Peace Hoodie 14500 Detail	113

1) there is a missing image
2) Only one image is repeated 4 times
3) But the titles are different

In other products is even worse. As you can see 3 products have a single image displaying but 3 were uploaded.

For the record, I looked directly in the database and the contents of the "images" field for each product is identical to my import CSV with the sole exception that the divider in MySql seems to be a ; and I used a comma instead. Otherwise the contents are the same:
Import CSV
AAA-20003-04_Peace_Three_Quarter_Raglan_12262_Back.jpg, 
AAA-20003-04_Peace_Three_Quarter_Raglan_12262_Front.jpg, 
AAA-20003-04_Peace_Three_Quarter_Raglan_12262_Side.jpg

MySQL content
AAA-20003-04_Peace_Three_Quarter_Raglan_12262_Back.jpg; 
AAA-20003-04_Peace_Three_Quarter_Raglan_12262_Front.jpg; 
AAA-20003-04_Peace_Three_Quarter_Raglan_12262_Side.jpg


I am going to alert the developer of the Magic Zoom component and send him the link to this forum post. If anyone has any good ideas, I am all ears.

Thank you

Last edit: 11 years 2 months ago by conticreative.

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

  • Posts: 12953
  • Thank you received: 1778
11 years 2 months ago #160574

Hello,

I did a test import of 5 products. Each product had 3 images and I am using the "Magic Zoom for Hikashop" component to get a zoom effect.

Can you create at least one of your products manually, export it through a CSV file, editing that CSV file and add your 4 other products, and import that CSV file back.

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

  • Posts: 200
  • Thank you received: 6
11 years 2 months ago #160626

I have done that already and there is absolutely no difference between the two ways to add the pictures as far as the database is concerned. The proper filenames are there in both cases, except that in one case (manual upload) the picture works and in the other it doesn't.

I will run more tests today and update this post. Push comes to shove, I will add the pictures manually.

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

  • Posts: 84298
  • Thank you received: 13697
  • MODERATOR
11 years 2 months ago #160668

Hi,

Could you provide the CSV that you're using ?

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

  • Posts: 200
  • Thank you received: 6
11 years 2 months ago #160806

The import file is 5-prod-import-test-00.csv And I am also attaching the CSV from exporting the same products from the shop (after making a few changes but not to the pictures).

Thank you for looking into this.

Attachments:

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

  • Posts: 200
  • Thank you received: 6
11 years 2 months ago #160873

I have just done another import and now the images seem to work fine. I am trying to figure out why.

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

  • Posts: 84298
  • Thank you received: 13697
  • MODERATOR
11 years 2 months ago #160881

I checked your CSVs and they are fine.
It's strange that it didn't work the first time.

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

  • Posts: 200
  • Thank you received: 6
11 years 2 months ago #161025

It is very weird. The only difference I can think of is that in the first instance I received the CSV from a coworker and she had put in the images filenames.

In the one that worked, I did that and I copied the filename from my list of images. I compared the two and I can't see any difference, but as far as implementation that's all I did different.

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

Time to create page: 0.079 seconds
Powered by Kunena Forum