Jump to content

HOW-TO import products with IMAGEs

J-works.cz
 Share

Recommended Posts

J-works.cz Newbie

J-works.cz

Posted
Posted

Hello,

  I need few advices. I was trying to import new products via CSV with images. It was not successfull by any way, that I was trying. Products was added to database, but the main problem is with image import. 

 

  I filled the CSV right according to the products_import.csv file By Prestashop. Images was not added, neither copied to my Prestashop server.

 

  PLEASE SEE ATTACHED TXT FILE. It is made from CSV file from Prestashop but I am not allowed to upload CSV files to this topic, so I renamed it with TXT extension.

 

  I was trying it on:

1) localhost - images from My computer

2) localhost - images from internet (http://www.mydomain.com/temp/img1.jpg)

3) Live server on the internet - images from My computer

4) Live server on the internet - images from internet (http://www.mydomain.com/temp/img1.jpg - the live server)

5) Live server on the internet - images from internet (http://www.myANOTHER...m/temp/img1.jpg - my another  live server)

 

  Everything was unsuccessfull. Would you be so kind and tell me what to do. I mean:

1) How should look like the CSV import file for importing product with images

1a) import to localhost Prestashop - images on localhost

1b) import to localhost Prestashop - images on my website (internet)

1c) import to live server Prestashop - images on localhost

1d) import to live server Prestashop - images on my website (internet)

2) What are the necessary setting (php server, apache, etc.) to do import CSV with image - I think, there can be problem also - that I have / do not have the right setting of my server (localhost and live server)

 

  Maybe You could add some CSV import file which is 100% working. Thank you very much. 

 

P.S. I was trying it on version 1.3.x and now I am trying it on version 1.5.6.0 and both versions are not capable to do it properly. 

 

 

Thanky you

products_import_tom4s_01.txt

  • Like 1
Link to comment
Share on other sites
PascalVG Newbie

PascalVG

Posted
Posted (edited)

Hi Tomas,

 

this one worked for me in 1.5.6.0

 

Note there is some error in the copy fiunction in 1.5.5.0:

http://www.prestashop.com/forums/topic/274479-solved-error-copying-image/?view=findpost&p=1384895

 

 

Import files almost like yours, separated by , (comma)

 

post-455771-0-92873100-1383315398_thumb.jpg

 

Image files should start with the whole path: http://www.yourdomain.com/somepath/someimgefile.jpg

Make sure the path folders and the file are readable (permissions folders 755, file 644)

 

 

 

Hope this helps,

pascal


EDIT: Oops, sorry, just see you responded already :-)

 

Anyway, for your info,

pascal

Workbook4.csv.zip

Edited by PascalVG (see edit history)
  • Like 1
Link to comment
Share on other sites
  • 3 months later...
sooroos Newbie

sooroos

Posted
Posted (edited)

the import says it was successfull but still the products are not added. i have lost already one day trying to import products in p.s 1.5.6.2 such a shitty...

 

edit: i managed to import the file that PascalVG provided here but no matter what i change in it it still uploads ipod nano.... wtf ????

Edited by sooroos (see edit history)
Link to comment
Share on other sites
PascalVG Newbie

PascalVG

Posted
Posted

Go sooros,

Did you re-upload the cvs file after editing? You have to re-upload and then select the just uploaded file (there will be more files with the same name, only date and time of upload differs, so choose carefully. I know, stupid system to have to upload again and have more versions then, (as if you would like to use the old one ever again... :( )

 

Tell me if that helps,

Pascal

Link to comment
Share on other sites
  • 3 weeks later...
mtblanche Newbie

mtblanche

Posted
Posted

Hi I have tried uploading Thomas' file in version 1.5.6.2, but it is not working for me?

 

Anyone else?

 

This is the error message

3 errors 
  1. Sluchátka (ID: 1) cannot be saved
  2. Property Product->depth is not valid
  3. Reproduktory (ID: 2) cannot be saved
close.pngThere are 2 warnings. Hide warning
  • Rewrite link for Sluchátka (ID: 1) was re-written as sluchatka.
  • Rewrite link for Reproduktory (ID: 2) was re-written as reproduktory.
Link to comment
Share on other sites
  • 10 months later...
  • 1 month later...
kishan soni Newbie

kishan soni

Posted
Posted

Hello ,

 

Can we import Bulk data into our store through the excel file .xls file in any easy way because while uploading and editing with the .csv file its format gets change and its very much hard to get use to with a person when there is more then 500 products to upload per day for a person.

 

 

i want to do the excel sheet product uploading process like this is it possible

http://sellerhelp.snapdeal.com/?p=826


Hello ,

 

Can we import Bulk data into our store through the excel file .xls file in any easy way because while uploading and editing with the .csv file its format gets change and its very much hard to get use to with a person when there is more then 500 products to upload per day for a person.

 

 

i want to do the excel sheet product uploading process like this is it possible

http://sellerhelp.snapdeal.com/?p=826

Link to comment
Share on other sites
  • 2 months later...
  • 1 year later...
kousi Newbie

kousi

Posted
Posted

Hi,


I am using PS 1.6.1.7. I have trying to upload image through csv import .


When i upload a product using csv import Picture_URL is not getting uploaded and the no  image is showing on the product.


Please note:


  


  •    I am giving full-url (eg. images/gal1.png )
  •    I tried with giving /images/gal1.png , where /imagesis in my root directory.
Link to comment
Share on other sites
  • 2 weeks later...
Dragonheart Newbie

Dragonheart

Posted
Posted (edited)

Kousi i am no expert i have been lucky as far as doing csv imports when images are concerned by using the complete url including the domain... Such as http://www.yourstore.com/img/imagename.jpg

 

The only time the images have not appear is either because i mispelled either tge file or the http address.

 

I did not look exactly where prestashop wants us to placed all images.. I just created a folder for all my images under or inside the folder in prestashop /img folder

 

Maybe the problem lies on the folder name?... You mention /images

 

The version i am using of prestashop has the image folder as /img

 

Hope this helps

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

Dragonheart

Posted
Posted (edited)

Question. As one of my product features i want a link to be displayed.

How am i to write the http address on the csv page?

 

We know the feature syntax is as follows:

 

FeatureName:value:position

 

If i was to add http://www.site.com as value

 

Resulting in something like

 

Research-link: http:www.site.com:5

 

Prestashop will cut anything after the http

 

when i looked at the catalog -product feature menu, "http" is shown as a customization value

 

If i write the value as Research-link:"http://www.site.com":5

on the catalog-product feature menu the value would show as N/A-

 

I could use the value as www.site.com instead of http:

 

But Even if i do that i dont know if it will be recognized as a link

 

Nonetheless i would like to know what's the proper way to include a link in a feature (for csv importing purposes)

Edited by Dragonheart (see edit history)
Link to comment
Share on other sites
  • 9 months later...
JAL Newbie

JAL

Posted
Posted

Hello,

  I need few advices. I was trying to import new products via CSV with images. It was not successfull by any way, that I was trying. Products was added to database, but the main problem is with image import. 

 

  I filled the CSV right according to the products_import.csv file By Prestashop. Images was not added, neither copied to my Prestashop server.

 

  PLEASE SEE ATTACHED TXT FILE. It is made from CSV file from Prestashop but I am not allowed to upload CSV files to this topic, so I renamed it with TXT extension.

 

  I was trying it on:

1) localhost - images from My computer

2) localhost - images from internet (http://www.mydomain.com/temp/img1.jpg)

3) Live server on the internet - images from My computer

4) Live server on the internet - images from internet (http://www.mydomain.com/temp/img1.jpg - the live server)

5) Live server on the internet - images from internet (http://www.myANOTHER...m/temp/img1.jpg - my another  live server)

 

  Everything was unsuccessfull. Would you be so kind and tell me what to do. I mean:

1) How should look like the CSV import file for importing product with images

1a) import to localhost Prestashop - images on localhost

1b) import to localhost Prestashop - images on my website (internet)

1c) import to live server Prestashop - images on localhost

1d) import to live server Prestashop - images on my website (internet)

2) What are the necessary setting (php server, apache, etc.) to do import CSV with image - I think, there can be problem also - that I have / do not have the right setting of my server (localhost and live server)

 

  Maybe You could add some CSV import file which is 100% working. Thank you very much. 

 

P.S. I was trying it on version 1.3.x and now I am trying it on version 1.5.6.0 and both versions are not capable to do it properly. 

 

 

Thanky you

 Great !

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...