Is it possible to list only the UOM relevant to a product on a sales order drop-down list?

I have set the default UOM for purchasing (pallets), and also the default UOM (sales - Boxes). All good.

However, we occasionally sell out at the same UOM as we purchase (pallets).  As it is unrealistic for a salesperson to remember each pallet configuration, it would be good to change the UOM on the sales order to only those that are relevant. At the moment you get a list of ALL units in the category.

I am starting to go down a rabbit hole of creating UOM Categories per product, which only partially solves the issue.

For example the UOM category for envelopes (in a variety of sizes, 10 in total).

Sales UOM

Boxes of 50

Boxes of 100

Boxes of 200

Purchase UOM

Pallet (2,400)

Pallet(2,800)

Pallet (3,600)

Pallet (4,400)

Pallet (6,000)

So for Envelope Size A Sales is Box200, the purchase is Pallet 6000.  However, if a customer asks Sales for a pallet then on the SO they are presented with all of the above.

This same scenario plays out over multiple products and at that point, it becomes even more useful.