How the heck do you import your products WITH pictures?

I’ve read and re-read the “manual”, I’ve searched the boards, I"ve tried every combo I can think of, but for the life of me I can not get my products to import with their pictures.



Can someone who has gotten this to work please tell me exactly, in idiot’s terms and steps, how you got it to work.



I’ve tried putting the image under the “thumbnail” and “detailed_image” categories, I’ve used the image file names w/ and w/out absolute paths, I’ve put the complete paths and addresses in my import file and I’ve even tried w/ and w/out complete addresses like [url]http://mysite/pictures/[/url]



Wtf am I doing wrong? Please help! Thank you,

j

Update: If I use the path /var/www/html/pictures/filename.jpg it looks like it is going to work and then CS-Cart just hangs and nothing gets imported. Does it really matter that my pictures are not in the CS-Cart directory? Thanks,

j

Never mind… I’m an idiot… I made such a stooopid mistake I don’t even wanna say what I did. :slight_smile:

j

Could you please say how you did it? Because I am in the same situation.

karoshoes,

I honestly don’t remember what the error was that I was doing, but I can tell you how I get it to work now.



In my .csv file I use the filed name thumbnail, and in that filed goes the name of the picture I want to use. Then on the import catalog page of cs-cart in the box you specify the path name you use /my_path/to_pictures/folder_name/. I do know you need that last / to get it to work right.



Hope that helps,

j

I personally wrote my own PHP script to make sure I imported everything that was needed from our old custom shopping cart solution. It took me a while to write the script, but was well worth it considering everything we imported.

PLEASE PLEASE PLEASE!!



can someone just tell me what i am doing wrong before i throw my computer out of the window, this is so frustrating!!



Ive tried everything to get my csv INCLUDING images onto the shop, if i try to specify my images when importing it just stops on the first product and doesnt do anything.



If i delete all entries in the detailed_image field all my products are successfully uploaded, but if there is any reference to any images at all nothing happens.



Here is what i am doing…



I set the delimiter to Comma, i change the category path delimiter to → instead of /// then i set the path to my images as,



/mounted-storage/home17a/sub002/sc18953-EAQI/www/images/detailed_images/



i have automatic thumbnail creation turned on so i leave the thumbnail field blank in the csv file



sorry for the long post but i am just getting nowhere at all,

I could really do with your help :frowning:



By the way, as the image folder has been uploaded to my server do i select File System or Database as Images Location as

Have you tried manually adding two or three products, then exporting the CSV. Check the syntax used from the exported file to see how the detailed_image field should be.

Use the file system. Your cart will be much faster than if you use the db to store your images.

I have manually added products then exported to check all that, and it seems i am doing everything right, i just can not get past the first item when importing with the images, its got me baffled.



OK heres one… ive just exported the file again, the export images box is ticked, but the only thing it exports is the fields, thumbnaal and detailed_images, there isnt actually anything in the columns to specify the image!



is this because im now uisng file system rather than the database?

I was having the same problems and just said “screw it” and am manually uploading images and assigning multiple categories to each product (since the initial import only transferred the main category). I think the trick is moving the images into the database of the old store before the export. Import into the new store and then move the images from the db to the file system. I really wish CS would design a simple import tool for existing products and customers at a minimum.

[quote name=‘disneyana’]I was having the same problems and just said “screw it” and am manually uploading images and assigning multiple categories to each product (since the initial import only transferred the main category). I think the trick is moving the images into the database of the old store before the export. Import into the new store and then move the images from the db to the file system. I really wish CS would design a simple import tool for existing products and customers at a minimum.[/QUOTE]



I’m agree with you.

To get your images to import along with your CSV file you need to have the absolute path in the detailed_image field, it actually tells you this where it says…



[B]Directory where images are located.

This will be used if image file is specified without path; this must be an absolute path, e.g.

/mounted-storage/home17a/sub002/sc18953-EAQI/www/images/images_backup/product_images/:


(i just left this blank)



ok this is how every cell in your detailed_image field of your CSV file should look… (this is the path to my images)



/mounted-storage/home17a/sub002/sc18953-EAQI/www/images/images_backup/product_images/product1.jpg



/mounted-storage/home17a/sub002/sc18953-EAQI/www/images/images_backup/product_images/product2.jpg



and so on and so on… i had to copy and paste this for over 2500 products, it took me ages!!



Ok, now once you have finished editing your CSV file and have this in every row you need to create some new folders for your image files. In your images directory eg, www.yoursite.com/images/ create a new folder and name it images_backup, inside this one create another folder and call it product_images (only follow these steps if you dont already have these folders, i didnt) so you will have end up with the following path www.yoursite.com/images/images_backup/product_images/



NOW, you need to upload all of your images to the new product_images folder you created and voila, when you upload it should work fine. PROVIDING YOU HAVE MADE SURE ALL YOUR CSV FILE NAMES ARE THE EXACT SAME AS THE ACTUAL IMAGE FILE NAME



PS, if you have your own thumbnail files too you can add these in the thumbnail field of your CSV file, im not sure why but mine worked fine just having the thumbnail file eg, thumbnail1.jpg i didnt have to type in the absolute path for this field. If you choose to do this you need to upload all of your thumbnail images to the same folder as your detailed images, make sure they have a different name, mine all have a letter s at the end…eg product1s.jpg) or you could just turn on generate thumbnail.



Hope this helps some of you, i know how difficult this can be, it took me days to figure it out, with the help of a couple of you, Thanks.

CSV’s are actually quite simple if you consider these steps (pauly78’s as well:P)



Create a product, add everything that you can think of including images etc etc.

Export the catalogue then adject the varaibles as it suits. Much easier then attempting to ‘potluck’ import as it seems what most of people are doing nowdays.

[quote name=‘JesseLeeStringer’]CSV’s are actually quite simple if you consider these steps (pauly78’s as well:P)



Create a product, add everything that you can think of including images etc etc.

Export the catalogue then adject the varaibles as it suits. Much easier then attempting to ‘potluck’ import as it seems what most of people are doing nowdays.[/QUOTE]



do you have a sample csv file showing how you did this?

[quote name=‘StrangeRanger’]I’ve read and re-read the “manual”, I’ve searched the boards, I"ve tried every combo I can think of, but for the life of me I can not get my products to import with their pictures.



Can someone who has gotten this to work please tell me exactly, in idiot’s terms and steps, how you got it to work.



I’ve tried putting the image under the “thumbnail” and “detailed_image” categories, I’ve used the image file names w/ and w/out absolute paths, I’ve put the complete paths and addresses in my import file and I’ve even tried w/ and w/out complete addresses like [url]http://mysite/pictures/[/url]



Wtf am I doing wrong? Please help! Thank you,

j[/QUOTE]



[url]http://forum.cs-cart.com/showthread.php?t=6148[/url] :wink:

The images are there however they do not fully come up. When I manually import them they come up fine, My CSV files are correct that I know of, I uploaded them to the right folders via filezilla. can someone help me thank you.