Import via CSV Combinations - How to associate pictures to combos?

[redstyles]

Good Day,

I'm trying to use the import tool for my combinations. The procedure i use is that I upload the Product CSV (including referenced pictures) then the Combinations. Besides the other issues I have with combinations which I've previously posted about, the issue I'm having now is how to associate the picture to the combos without having to manually check them all off (as in the attached picture)

Thanks in advance

[forfun]

I have exactly same problem. My product comes in different colors but when I choose from dropdown list specific color it won't show any pictures because none of combinations are associated with images.
Is there any way to do that through import?

Associating each combination with specific image through admin panel would be nightmare.

Thank you for your reply.

[forfun]

What a shame, still no replies :/

[redstyles]

Hi Forfun,

I figured out a way to do it. Open phpMyAdmin and run this command:

TRUNCATE `ps_product_attribute_image`;
INSERT INTO `ps_product_attribute_image` SELECT `id_product_attribute`, `id_image` FROM `ps_product_attribute` pa LEFT JOIN `ps_image` i ON (pa.`id_product` = i.`id_product`);


This will associate all pictures to all combos. If you've manually already done some this will write over any data that
's already in that table.

Hope this helps.

[BobPour]

redstyles, just want to say thank you. Your solution worked perfectly.

[philee]

I need help with the CSV format on how to arrange these combination. Do you have a blank template with one example so I can get a sense of idea how to enter my products? Thanks in advance.

[BobPour]

Actually this command is not assigning individual picture/image to individual combinations.
If you have upload your combinations via csv by running this command you assign all pictures to all the combinations.