Jump to content

[solved] csv import can't add pictures from local folder


Recommended Posts

I tried allot of options to let prestashop display pictures wich are located on my local harddrive.

Also have searched allot in this forum for a solution,but can't find a right one yet..

 

 

Here is the situation:

 

- i try with a .csv file to import producs and pictures who are located on my local hard drive.,

The product are all set in the right place also the prices are set in the right way and categories also are fine.

 

Only the pictures are not displayed in the webshop or in the BackOffice in prestashop.

For example the picture filename is 123456789.jpg and is in the collum IMAGE URL X.Y.Z..) from the .csv file to import

After the .csv import i see in the BackOffice from presta shop, when i hoover with the mouse arrow that the file should be in /imp/p/1/2/3/4/56789.jpg

 

I have manual added all the pictures in the / img and /img/p/folder even in the root of htdocs and also in the /upload directory from prestashop.

 

When after importing the .csv file take a look in the /IMG and imp/p folder from prestashop isee that there is no directory structure like that created.

 

All folder are set in 777

I have the same problem on the local prestashop for testing as the one who is located at the webhoster.

 

What could be wrong here?

 

When i import a .csv file with Images who must be taken from a URL adres like for example www.test.nl/images/123456789.jpg then there is no problem and the picture is imported and displayed.

 

Thanks.

 

With friendly greetings

 

Peter

Link to comment
Share on other sites

But i don't have a option to dload that from a url webserver.

I see allot of people having issues with importing but they are more related to downloading from a URL adres and not the local option i want to use.

 

Maybe the only way indeed is from importing from a URL adres only.

Link to comment
Share on other sites

I suggest you to change /config/config.inc.php @ini_set('display_errors', 'off'); to on and see what it says after csv import

Also, make sure the path to the images in csv is 100% correct (/imagesfolder/ or ../imagesfolder)

 

Edit:

If images are imported fine while using http:// path, use it instead :) Just place your images folder to localhost web and use http://localhost/yourimagefolder/

Link to comment
Share on other sites

Here are the file errors

i have set different category names and positions for the pictures filenames for prestoshop,but all give errors

I also have set the display error to ON now. as advised

====================

  • Rewrite link for volledige-naam (ID ) was re-written as volledige-naam
  • Error copying image:Prijs ( eur
  • Error copying image: excl BTW )
  • Rewrite link for adrienne-vittadini (ID 5403237,) was re-written as adrienne-vittadini
  • Error copying image:/img/p/1579W.jpg
  • Rewrite link for adrienne-vittadini (ID 5483166,) was re-written as adrienne-vittadini
  • Error copying image:img/p/706W.jpg
  • Rewrite link for adrienne-vittadini (ID 5415789,) was re-written as adrienne-vittadini
  • Error copying image:img/p/60288W.jpg
  • Rewrite link for adrienne-vittadini (ID 5403236,) was re-written as adrienne-vittadini
  • Error copying image:img/p/1579W.jpg/
  • Rewrite link for adrienne-vittadini (ID 5483721,) was re-written as adrienne-vittadini
  • Error copying image:avgsw33.jpg
  • Rewrite link for agent-provocateur (ID 5435223,) was re-written as agent-provocateur
  • Error copying image:/61901W.jpg
  • Rewrite link for aladdin-fragrances (ID 5449723,) was re-written as aladdin-fragrances
  • Error copying image:/SFBL17.jpg
  • Rewrite link for dana (ID 5417654,) was re-written as dana
  • Error copying image:/799M.jpg
  • Rewrite link for dana (ID 5448307,) was re-written as dana
  • Error copying image:/957M.jpg
  • Rewrite link for dana (ID 5417650,) was re-written as dana
  • Error copying image:/799M.jpg
  • Rewrite link for dana (ID 5412808,) was re-written as dana
  • Error copying image:/318M.jpg
  • Rewrite link for dana (ID 5418833,) was re-written as dana
  • Error copying image:/977M.jpg
  • Rewrite link for dana (ID 5434901,) was re-written as dana
  • Error copying image:/318M.jpg
  • Rewrite link for dana (ID 5418836,) was re-written as dana
  • Error copying image:/978M.jpg

Link to comment
Share on other sites

Here are the file errors

i have set different category names and positions for the pictures filenames for prestoshop,but all give errors

I also have set the display error to ON now. as advised

====================

...

Error copying image:/318M.jpg

....

It seems you have wrong image path...

Try to use "../imgimportfolder/Imagename.jpg" not "/" root path...

 

And you can always use http://localhost/imgimportfolder/Imagename.jpg as stated in previous post.

  • Like 1
Link to comment
Share on other sites

I have attached a file wich shows the data in the way i recieve feom the supplier.

 

And after the csv file import everything is set just as i like

Except the pictures.

That's because there is no image in "/"

Copy all images for imported products to a folder, place the folder on server and point path in csv file as http://yourserver/folder/imagename. That's it

Link to comment
Share on other sites

Sorry if ido not understand this good, but in the example file i also have linked some images to /img/p/ folder in the htdocs folder from prestashop like this (Error copying image:/img/p/1579W.jpg) and some indeed in the "/"root .

 

And in that /img/p/ folder wich is in htdocs folder from prestashop i have also ftp all the picturs to before importing the .csv file.

 

But if i understand it the i must have a server software launced where prestashop can get the files from? ,which software i use best for that?

 

Thanks.

Link to comment
Share on other sites

Sorry if ido not understand this good, but in the example file i also have linked some images to /img/p/ folder in the htdocs folder from prestashop like this (Error copying image:/img/p/1579W.jpg) and some indeed in the "/"root .

 

And in that /img/p/ folder wich is in htdocs folder from prestashop i have also ftp all the picturs to before importing the .csv file.

 

But if i understand it the i must have a server software launced where prestashop can get the files from? ,which software i use best for that?

 

Thanks.

Nope, you don't need any additional software.

 

If you uploaded images via ftp to /img/p/ folder before csv import, in your csv file change image path from /img/p/ to http://yourwebsite.com/img/p/

  • Like 1
Link to comment
Share on other sites

  • 1 month later...

I´m having the same problem, but couldn´t fix it that way.

 

I have prestashop running on a local server, for testing, but can't "upload" files from the local server. If I put images in a real web server on the internet, there´s no problem at all, but when trying from the localhost there´s no way.

 

I have already activated the debug function to show errors but no explanation at all.

 

This is the message I get:

 

warn2.png

There is 1 warning

If I browse the URL I get the image, so is not wrong.

 

Here´s the link to the CSV, I hope you can help me.

 

http://tintaa.com.ar/products_import%20test.csv

 

there are 2 products, only the one with the image on the internet works.

 

Thank you!

Link to comment
Share on other sites

  • 3 months later...
  • 2 weeks later...

what if i want to upload images through csv file? where should i place all the images before uploading csv??? and what url i've to give in csv file for images???

Put the images where you can access them http://yoursite/imagefolder/

In csv file use a url to the image [i.e. http://yoursite/imagefolder/image.jpg]

Edited by doubleD (see edit history)
Link to comment
Share on other sites

  • 7 months later...

Anyway, I tried to make a full image link of my localhost (because my presta still in local)

I put my picture in "C:\xampp\htdocs\edusarana\img\products\SD\MathematicsSD.jpg" and then in the csv image url field I write http://localhost/edusarana/img/products/SD/MathematicsSD.jpg

It works for me in my local presta, the image showed up.

:)

 

Edited by Defa Hanifta Putra (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...