This takes a fair amount of work but it can be done ...

Also consider do you need this for all manufacturers or some manufacturers ... and if for some manufactuerers ... do you need it for the "all" products from the manufacturer or "some" products from the manufacturer ...

I have had to write this several ways to accommodate those various configurations ...