Manage Combinations Multistore

[ebski]

Hello,

 

I have a huge issue.

I recently updated my prestashop and all my combinations are gone from all my stores except the main store (I'm using multi store). I could regenerate the combinations but then I have to enter Article nr. manually for each combination, and having thousands of products, this would take forever.

 

Please, anyone that can help? Any way to copy the combinations to all stores at once including article nr.?

 

I'm running 1.6.1.4

 

 

[vekia]

what about to re-add the shop to multistore (with selected options to copy products etc.) ?

[ebski]

Thank you for your reply!

 

I actually had copy products activated, and all the products are copied, only not the combinations. Re-adding it would reset everything and it would be take a while to fix that.

 

Here is my solution, just in case there is anyone els with this issue, (it might not be the cleanest solution since SQL is not my best area). The issue was with ps_product_attribute_shop where only id_shop=1 was there.

 

1. I started with duplicating my Database, Lets call it DB_temp.

2. In DB_temp I navigated to ps_product_attribute_shop

3. I ran the following query:

 

UPDATE ps_product_attribute_shop

SET id_shop  = REPLACE(id_shop, '1', '2')

WHERE id_shop LIKE '1';

 

4. Then I exported the ps_product_attribute_shop table from DB_temp and imported it to my Database.