Duplicated attributes fix

[Yossefelbaz]

Hi.

 

In our website there were guys that have been working and managing the inventory. Now, they weren't skilled so they messed up a bit.

 

We have now for example 3 attributes of Black under Color group. If we, by mistake, choosing for one item the first in the list (Color > Black) with size combination, let's say 0, and then we accidentally choosing the second black with new size (2), it will result an issue in the front office.

 

The item will have 2 black options under Color. It is confusing the customers.

 

Is there any way to manage it? If i will just erase 2 attributes from the 3 black ones it will cause problems with the old items that they uploaded... I think...

 

Thanks in advance.

[suenda]

Well, I have been through this problem. I fixed it by manually by modifying tables in the database. You need to modify table ps_product_attribute_combination and if you have images for each combination, you may also need to modify ps_product_attribute_image. However be careful to not mess the database. I'd recommend to first test it in local and if it works without any problem, commit to your production copy.

[Yossefelbaz]

Well, I have been through this problem. I fixed it by manually by modifying tables in the database. You need to modify table ps_product_attribute_combination and if you have images for each combination, you may also need to modify ps_product_attribute_image. However be careful to not mess the database. I'd recommend to first test it in local and if it works without any problem, commit to your production copy.

 

Thanks. I made a script to replace values in the ps_product_attribute_combination to one of the values. That way i got all of the black with the same ID. Then i deleted the duplicated attributes from the back office.

 

Now, what is the connection between the attributes and the table ps_product_attribute_image? I couldn't get it so i didn't changed it.

Edited December 31, 2012 by Yossefelbaz (see edit history)