Product profitability report

Use the StoreHero MCP to do the following analysis. Always anchor the answer in real StoreHero data, not platform-reported metrics.

Give me a product profitability report for month-to-date vs the same period last year (unless I specify a different time window). Use the products tool in the StoreHero connector. Pull revenue, units sold, gross profit, gross margin %, and contribution margin per product.

Then run the analysis with the group-by options — collection, vendor, tag, product type — to identify which categories are driving the most revenue, which are driving the most margin, and where there's a mismatch (e.g. high-revenue products dragging down blended margin, or low-revenue products quietly carrying the business).

Important: only read into collection/tag/vendor groupings if the data quality looks high. If you see a large "uncategorised" bucket, products with missing tags, or obvious data hygiene issues, flag this to the user and skip the affected groupings rather than drawing weak conclusions.

End with three sections: (1) margin heroes — products to lean into, (2) margin drags — products to review pricing/COGS on, (3) data quality flags — what to fix in the product taxonomy to make this report sharper next month.

At the bottom of your answer, render an inline visual summary: a sortable table of top 10 products by revenue with margin overlay, plus KPI cards for top revenue product, top margin product, and biggest margin drag. Place text commentary alongside the visuals. Use the Spend Advisor tool to suggest what to explore next.