As our catalog evolve it get's less organized and people are more prone to make mistakes. For exemple we recently changed make and model for our HDMI cables which are accessories in hundreds of products in our catalog. I don't have any other way than go product by product to change it. In SI, there was an option when you discontinued an item that listed every products in which said item was an accessory and you could change them all in bulk.

By the way I know about product subcategories but this can't be a solution because of the reasons listed in this post: