On further investigation the image, small_image, and thumbnail attributes are being written to the catalog_product_varchar table, but not the flat table. Rebuilding product flat data doesn’t help (they are still set to NULL).
Only thing I can do is go and manually select the image from the gallery, which obviously isn’t an option for 4,000 products.
As far as I know, this did never really work with the import over csv and images. The result with my tests was always exactly the same as you describe it. But I have to add, that I only tried it until Magento 184.108.40.206 and then switched for csv-import to MAGMI, which is much more convenient for me in many aspects.
I’ve been using magmi product for a couple of months now and it has become absolutely essential to my workflow. Up until yesterday it worked perfectly but since then it will import all the products fine, but will not create and move the image files at all. So all the products show in magento front and backend but no images are associated with it. I’m using magento 1.5 and magmi 0.7.16 with the image processor plugin. If there is anything you can suggest to help i would be very appreciative
You can absolutely upload the individual thumbnails but it is a little tricky. From what I understand from my programmers you first upload the images into your image directory on your host server and then note the folders. From there add the appropriate names at your images csv file. You only need the product name and ID/SKU plus the image columns for the csv. This is where it gets tricky, you have enter a specific notation that it is a thumbnail. Of course the other way which I usually do is just go to each individual product and add them in but seems like you have a lot of products to which the csv upload method is much better. Check with a developer or post it as a job on the jobs listings.