URL Redirect for product from all collections

So when someone on our team changes a product URL and checks “Create a URL redirect for…” one is created, but it is only from /products/product-name… so anything that is /collections/collection-name/products/product-name doesn’t get a redirect.

Is there a way with wildcards or something that a product URL can be redirected from all the collection URLs? Having to input all the collection-specific redirects manually is a very long process.

There might be a way to automate this using something like Arigato or Shopify Flow.

Might be something like for each update/create event, save product handle to db, save list of collections of that product to db, then if handle change run a loop to create redirects from db handle to new handle, overwrite existing. Something I’d like to figure out at some point, but not too sure how myself.

As an another (easier option) you could look at completely removing the /collection/c-handle bit from all internal links to product pages. Flatten them down to just /products/p-name. Then adding those redirects won’t really matter too much eventually if no traffic is going there.