Image import

  • Posts: 279
  • Thank you received: 1
7 years 4 months ago #274151

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.73

Still struggling with the same import. Now totally stuck on variant and image import. Kind of given up on variant import - just way too hard for me.

Thought images would be easy, but no. Do the images have to be in the folder I specify in the CSV BEFORE I do the import via CSV or can they be added after? I specified images in the folder images/hikashop/<filename>, but, even after uploading the images nothing shows up. However, I added the images after uploading the CSV.

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
7 years 4 months ago #274161

Hi,

Both is possible.
Note that the default upload folder for images is not images/hikashop but images/com_hikashop/upload
So if you upload the images in that upload folder and then specify the file name in your CSV in the "images" column, the product will automatically have the image assigned after the import.

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

  • Posts: 279
  • Thank you received: 1
7 years 4 months ago #274293

I moved the images to the upload folder as you mentioned, but no images show on the frontend. However, the CSV I processed did not specify that folder but another (which doesn't work either).

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
7 years 4 months ago #274315

Hi,

Ok, let's do a en example:
- your upload folder is /images/com_hikashop/upload/
- you have an image called myproduct.jpg
- you have a product called myproduct

There are two steps to add the product and the image to the shop with a CSV in no particular order:
- you need to upload the file myproduct.jpg in the /images/com_hikashop/upload/ folder (via FTP for example or the Joomla media manager).
- you need to upload a CSV file like that (simplified version):

product_code;images
myproduct;myproduct.jpg
If you first do the CSV import and not have yet the image uploaded (or if the file is not in the correct location), you should see a image with no icon or with the default image icon when you edit it in the backend. So check on that.

If in your CSV you specified a path like /myotherfolder/myproduct.jpg, then the system will search for the image in /images/com_hikashop/upload/myotherfolder/myproduct.jpg
That's why I said in my previous message that you should use the file name of the file in your CSV.

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

  • Posts: 279
  • Thank you received: 1
7 years 4 months ago #274344

Revisiting the CSV, it is not formatted like your example in that each field is in its own column. This may be where some of the problem is occurring. I figure that, doing it this way, I need EVERY field possible assigned a column in the right order for HS to pick the right info for the right field - is this correct? Do I even need a header row?

I entered a test product (after deleting everything for about the third time), and then exported. Looking at the exported CSV, there seem to be 5 rows in the file per product. I expected to see just 1, so I'm now completely lost how to make this import work. File attached.

Attachments:
Last edit: 7 years 4 months ago by trogladyte.

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
7 years 4 months ago #274352

Hi,

No, there is not 5 rows per product.
There is:
- the header row with the name of the columns
- the rows for the category structure
- the rows for the products, 1 row per product
The category structure rows are in the export CSV but they are optional.

In my example too, each field is in its own column. The ";" character is the column delimiter. That's how CSV works.
If you open your CSV with a text editor like notepad++ you'll see the columns separated by the ";" or the "," character.

In your CSV, I see that you have the text "p0006c_318098340.jpg" in the "images" column for your product.
So you must have the image for that product in the path images/com_hikashop/upload/p0006c_318098340.jpg

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

Time to create page: 0.063 seconds
Powered by Kunena Forum