Accessories - a faster way of linking them to products (instead of manually one by one)

[noesac]

Are there any mods or modules that can help me with this?

The first time is ok, but when we begin introducing new accessories...having to go through every product is becoming quite a drain!

[Dave Angel]

Hi,

do you have access to the mysql database?

have a look at the ps_accessory table (where ps is your database prefix). All of your linked products should be in there.

Next Step...

if you export your products from the prestashop admin you will get a list of all the product_id. You can then use this table to build a file to import back into phpmyadmin.

it doesnt look like the ps_accessory table is linked to any other tables but i may be wrong.

i have tried it once and it worked ok. i havent gone live on a site where i have done this though.

hope it helps,

Rob.