Request for feature – New Report

The functionality your product provides is core to our websites operations, so I want to say thank you for providing it and doing such a great job. It does everything we need it to do to run our business. With that said, I do have a request:

I run the plugin on wordpress. We have products with variants (i.e ‘Product X’ 1 day key / ‘Product X’ 7 day key). The normal wordpress stock report does not give us accurate counts, even after manually syncing inventory in the License key > Settings.

Currently we run a script in Phpmyadmin which gives us on-hand keys for each product variant:
SELECT wp_posts.post_title, COUNT(*) FROM wp_lmfwc_licenses LEFT JOIN wp_posts ON wp_lmfwc_licenses.product_id = wp_posts.id WHERE wp_lmfwc_licenses.status = ‘3’ GROUP BY wp_posts.post_title;

We have limitations and are unable to use the API because we use Cloudflare. Is there a way we can get an ‘active key count by product variant’ in a report? The way we are managing inventory now is a challenge to sustain.