I use Square Online to manage preorders for potted plants. I know how to find reports that show current stock for each item, and I know how to find reports for items sold over a time period.
I am looking for a report which shows both of these values side by side. For each item in my library, how many have sold (during the specified time period, such as YTD) and how much stock remains in inventory?
Does such a report exist? Thank you in advance!
Have you tried the Inventory Sell-Through report? It's located in Reports -> Inventory Reports -> Inventory Sell-Through. It may be one of those things only included when you upgrade to Square for Retail Plus, but I think it's got the info you're after. (Although based on my first couple of attempts to use it, the sell-through calculation is a little sketchy - it appears to be dividing sales by ending inventory, so if you start with 6 units, sell 4, it's showing a 300% sell-through rather than a 66.7% sell-through.
Square Community
Square Products