Hello everyone,
We have actually solved this problem by raising markteplace request back in Aug '21 which was completed by Michael from Communiteq 
and released as a plugin open-sourced for public to use it.
It’s been several years now, and it works like a charm without maintenance.
I went ahead an posted a new Plugin topic to host & discuss additional information about this function: