importing 18,000 images

[phantomeye]

Guys, any ideas on how to do this. I have already inserted all 18,000 products including 1,300 categories directly into the database.

cheers

[MrBaseball34]

If you named your images the same name as the product, then just copy them into the img/p directory and based on the version of PS
update the table(s) with the correct image names.

[phantomeye]

No they are named differently. But will try your suggestion
Thanks

[MrBaseball34]

How do you correspond the images to the products?

In the newer versions, it gives them the same name as the id_product and places the value in ps_image.
We did something a little different. We named our images like a feature called "part number" and then added a column called
hack_image to our ps_product table and then modified the code to show that image instead of using the getImageLink function.

[phantomeye]

Exactly like you described. We have our images named as the ps_reference# (part number). Your solution sounds good, will give it a shot. Hopefully it will work. Otherwise i will die trying to rename 18000 images to the id_product

[MrBaseball34]

Yes, I am now modifying our import process to correctly insert the reference as well as update ps_image.
We have an external script to do our imports because the vendor file is rather unique.

[caparuni]

Guys, any ideas on how to do this. I have already inserted all 18,000 products including 1,300 categories directly into the database.

cheers

well before you continue pelase read a this one

[MrBaseball34]

Because we don't use the different image sizes, we only have one image for each product thus only 24,000+.
Our import process and the modifications to our store allow us to do that.