Importing bulk images

  • Posts: 149
  • Thank you received: 0
12 years 11 months ago #31506

Hello,

If i understand correctly the way images are getting import in hikashop is that i have to upload them all in the upload folder and then use import file like this to match them with the products
product_name,images
My product,"image_front.jpg,image_back.jpg"

I will upload a few thousands of products so im looking your suggestion for something more effective, in order to not start creating manually a file with 10 000 rows. My images have the same name with the product code of each product example product 23456, images, 23456_1, 23456_2. Is there any easy way with a script or maybe a query to upload all images and then "match" them with each product without the need of csv file to do so?

Thanks

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
12 years 11 months ago #31533

Hi,

Well, you could have your CSV generated by a small script which would scan your folder with all the images.
But you would have to make that script...
Then you could just import the generated CSV and that would add the data automatically in the database.

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

  • Posts: 152
  • Thank you received: 0
12 years 11 months ago #31555

I found that the easiest way to do this was to open a DOS command (cmd) window and use a DOS command after navigating to the images folder.

The command I used was

dir /b > files.txt

which outputs the file names to a text file. You can then load the text file into Excel and work with normal Excel functions to build the required import.csv file.

Jim

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
12 years 11 months ago #31574

Thank you for the feedback, that's indeed a simple way to do it.

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

  • Posts: 149
  • Thank you received: 0
12 years 11 months ago #31576

Thanks i will give that a try

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

  • Posts: 634
  • Thank you received: 16
11 years 7 months ago #98947

Thistopic is more than a year older. IS THERE A NEW WAY to bulk import images, or at least to import for each article several images at once and not one by one?

Alternatively, could somebody post a .csv example? I can't figure out what is the structure of this file for an automated import

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 7 months ago #99011

You can bulk import several images at once in HikaShop since version 1.0.0 of HikaShop.
This topic was not about that actually...

And, actually, there is already an example of CSV to bulk import several images per product at once via CSV in the import documentation:

If you have images or files along with your products, first place them in the "upload folder" option of the configuration under the tab files. You can add a column name 'images' or 'files' where you can specify the images name separated by one of the supported separator different from the main separator you're using in your file ( , ; | ) unless you're double quoting the information.
So for example you could have this:
product_name,images
My product,"image_front.jpg,image_back.jpg"

or that:
product_name,images
My product,image_front.jpg;image_back.jpg

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

  • Posts: 634
  • Thank you received: 16
11 years 7 months ago #99025

nicolas wrote: You can bulk import several images at once in HikaShop since version 1.0.0 of HikaShop


Do you mean there is a way apart from the CSV mode?

In my admin area I only see a one by one picking system...

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 7 months ago #99036

No. Not on the backend edition interface.

I'm saying that the CSV import can handle several images per product (it was in the second part of you question).

Also, with HikaMarket you can manage your products from the frontend with a completely redesigned edition interface which is much more user friendly and which handle several images at once drag & drop. So if you manage your products from the frontend with HikaMarket, you can do it.
We implemented that new interface first in HikaMarket to see if everything was working ok and because it is not yet finished (the characteristics are not handled yet). But in the future, once the interface is finished, we will backport it to HikaShop's backend. So you will be able to do it on the backend too in the future.

For now, it's either HikaMarket or the CSV import.

The following user(s) said Thank You: PeterChain

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

  • Posts: 634
  • Thank you received: 16
11 years 7 months ago #99038

Thank you for writing answers so clear and detailed!

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

  • Posts: 43
  • Thank you received: 0
11 years 1 month ago #128712

Hello.
I am starting to create a lot of products, they all have the same price and same information, it is only the images that are different, then I could use the function called import products from folders.?
But I can not get the folder into the real path to my pictures, even so I located the folder into the site via ftp then shows an error.
I have attached 3 screenshots.


Hope there is someone who can tell me what I'm doing wrong in terms of the path to the folder

Regards
Henrik


Thanks

Henrik Ris
Attachments:
Last edit: 11 years 1 month ago by Henrik.

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 1 month ago #128731

Hi,

You need to select a product template so that the products can be created from the images based on that template product.

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

  • Posts: 43
  • Thank you received: 0
11 years 1 month ago #128732

Hey

it still does not work.
Products a template, it is a special one. or is it a previously created product to use as a template (that is what I have done)

I also tried to do it in firefox, no luck ..


Thanks

Henrik Ris
Attachments:

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

  • Posts: 13201
  • Thank you received: 2322
11 years 1 month ago #128826

Hi,

I just tried on my end, and it's working fine.
Do you have the latest version of HikaShop ? 2.2.2 ?

Thanks to check your path, it seems that "images" is missing.

Can you try with another product as template ?
Using a previously created product must work.

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

  • Posts: 43
  • Thank you received: 0
11 years 1 month ago #128936

Hey
thanks for reply
've updated to 2.2.2 it still does not work, I do not understand the error comes, it may be the folder in my ftp is locked, have tried to set it to value 777 without success.

Have also tried in another template without success.

Should folder in ftp be a specific place for it to work.?

I am working on making a CSV file on it but it's a mammoth task with more than 300 products, and the only difference between the product's is the image.


Thanks

Henrik Ris
Attachments:

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

  • Posts: 43
  • Thank you received: 0
11 years 1 month ago #129029

just tried again, but with a complete path all the way to image. no luck :-(
still the same error:
DateTime::__construct(): Failed to parse time string (jerror) at position 0 (j): The timezone could not be found in the database Could it be the server that hosts my side, where there are some restrictions?


Thanks

Henrik Ris

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 1 month ago #129072

That error is a joomla error:
stackoverflow.com/questions/16632546/joo...ed-to-parse-time-str
Please follow the indications there.

The following user(s) said Thank You: Henrik

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

  • Posts: 43
  • Thank you received: 0
11 years 1 month ago #129104

Thanks for the reply, it solved the problem. :-)

I have a new problem when my customers purchase a product at my side, then it is an image that can be downloaded.

but when they get mail after they have made the purchase, there is a link to download, but it just sends them back to the site and a page where they have to login. Instead of allowing them to download the picture

I put my check-out workflow like this:

login
adress
payment
coupon
cart
status
fields

and login and registration:

login: no
all in one page
Registration: Guest
Show email: no

I have attached a picture of my config file to
the adress for my page: www.maalfoto.dk


Thanks

Henrik Ris
Attachments:
Last edit: 11 years 1 month ago by Henrik.

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

  • Posts: 13201
  • Thank you received: 2322
11 years 1 month ago #129393

Hi,

The files can't be downloaded when the customer purchased as guest checkout.
Actually to download files, the customer must register on the website.

Adding the possibility to download as guest is on our TODO list.

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

Time to create page: 0.141 seconds
Powered by Kunena Forum