I've just gotten a new color (NUT BROWN) to add to my vinyl decal attributes, but I only want to add (not replace) to products that currently have the color attribute of ORANGE.
Can someone let me know if the following SQL patch work?
73=NUT BROWNCode:ADD products attributes options_values_id = 73 WHERE options_id = X AND options_values_id = Y
X=color
Y=ORANGE
Thank you.


Reply With Quote
