Right, that puts us in agreement. You can, however, generate a detailed report for all time on a specific product + its variants. There may also be a means of including the inventory changes into this report as well. It is raw and over complicated to generate, but in Analytics/Reports you can create a "New Exploration" which then requires you to essentially enter your own code line by line in order to generate the report desired. Here is an example:
1 FROM sales
2 SHOW net_items_sold, gross_sales, discounts, returns, net_sales, taxes,
3 total_sales
4 WHERE product_title IS NOT NULL AND product_title CONTAINS 'Product Name'
5 GROUP BY product_title, product_vendor, product_type WITH TOTALS,
6 PERCENT_CHANGE, GROUP_TOTALS
7 SINCE 2021-01-01 UNTIL 2025-05-22
8 COMPARE TO previous_period
9 ORDER BY total_sales__product_title_totals DESC,
10 total_sales__product_title_product_vendor_totals DESC, total_sales DESC,
11 product_title ASC, product_vendor ASC, product_type ASC
12 LIMIT 1000
13 VISUALIZE total_sales TYPE horizontal_bar
This will display detailed data in an easily readable format including net items, gross sales, any discounts, returns, net sales and taxes. I can see that we have sold a total of 363 of this particular brand spanning 24 different products + their variants, with the values previously mentioned displayed for each individual item. For managing inventory/ordering the necessary quantities, etc, this works fine once you have it. As for a security flaw, I would think if you have that many people's hands in it as a business, that it may be time to move on to your own storefront/website. We don't need to worry about someone going in and sabotaging anything, though I can see where that might grow to be a concern for some. And of course, the bigger you get the harder it is to transfer all of it over to your own site.
