Sales reports fail to reveal 0 sales items. Any solution?

How can i get a sales report that includes items with 0 sales? This is the most important item to notice in a sales report as it reveals stock obviously in need of attention yet these items are non-existent in all sales reports! i have made requests ever since we started using Lightspeed and it has never been fixed as far as i know. Is there a solution to this problem?
10 comments
Within Retail, there is a History Report that may help you find the 0 sales items. Within that report, you can select a date to be your start date, and your secondary date would always be the day you are running the report. Once selected, it will run a report and show you the changes in your item since that time.
QTY. ON HAND is the quantity you had on hand on the date selected
- QIN would be the the quantity received since that date
+ QOUT would show how many have sold since the date selected
QOH NOW would show you how much you have on hand now.
If you click on the QOUT column, you can sort it shortest to highest and see the 0 sales items at the top. If you wanted, you could export it as well to add formulas to get other data if you are looking for more information.
This would be the best bet to get that information.
Please contact support if you would like to go over this report with anyone here.
Jordan L-C
Lightspeed Retail Support
Lightspeed HQ
While I haven't delved into the details in this LS Retail report to tick and tie some items, one thing I noticed that that there isn't an option to exclude archived items. Not sure if this archived flag appears in the exported data or not. If so then I suppose I could just sort by that column and remove those rows...