Import 330.000+ pictures as products from folder structure (15.500+ folders)

[fiedelio]

Hello, 

 

I am currently trying to import a large number of pictures into prestashop.

(One picture per product)

 

As the CSV import does not run trough while importing this large CSV (even if the PHP.INI is set to irrational high limits), I've tried to import the pictures by PHP code directly into the DB.

-> Read filesystem stepwise and add categories and products in blocks of 100.

 

The products & categories are imported perfectly.

 

But how can I add the correct picture to each product via a script?

Which tables must be affected?

Is there any already existing script I can use?

 

I would highly appreciate if anybody could give me a hint or structure which may help.

Edited January 8, 2015 by fiedelio (see edit history)

[sandipchandela]

Hey,

PS will store images in p directory under img directory.

 

Tables will affect are as follows:

1) ps_image 2) ps_image_lang 3) ps_image_shop

Directory structure will created based on ps_image table primary key id_image from 1 to 10 numbers.

[fiedelio]

Hey Sandip,

 

thank you, that helped a lot.

Do you, by chance, have the filename / location of the standard file upload class/handler?

So I do not need to do all that DB stuff by myself and maybe can use parts of the existing structure.

 

br

[sandipchandela]

It might be not easy to track all the options to handle controller.

Although, i should mentioned the controller file name : 

               AdminImportController will find in controllers/admin directory.

Also see AdminProductsController will find in same directory for public function processImage() method to image handling.