Assign a banner to multiple products in bulk

So i have multiple categories and i want a different banner to appear for each category and the products within that category.



eg;



Products in category 1 only see banner 1



Products in category 2 only see banner 2



There does not appear to be an easy way to do this? When creating a banner block for products i have to go into each product individually and enable it and assign the content to my block. That's way too much work and ongoing administration.



Would it not make sense to be able create a banner block for a category and then tell that block to also assign to all products within that category?



I can create a block for all pages and then deactivate for other pages but i still have to go into each individual product to turn off the banners i dont want to appear.



I dont get why this functionality isn't standard. Now i cannot add a banner to categories of products.