These reports will identify the Worst Selling products within a given category for the specified time period. 

The report can be run for:

  • Department
  • Company
  • I.E.U.
  • Brand
  • Class
  • Location
  • Price Policy
Tip: We recommended that a Dead Stock Report is run in conjunction with a Worst Sellers Report, as products which have not been sold will not be displayed.

From the Reporting module:

1. Click the required menu option, in this example Department will be used, and click 4. Worst Sellers.

The Department Worst Selling Products window is displayed.2. Enter the required category in the Code field. 

3. Enter in the required Starting Date and Ending Date.

4. Click the Content dropdown and select from:

  • 1. Dispensary Sales
  • 2. Retail Sales (this is selected by default)
  • 3. All Sales

5. Ensure the Sort Key selected is Quantity. The content of the department worst selling products report can also be run by Sales, Discounts, net sales, C.O.G.S., Gross Profit and Gross Profit %.

6. Enter in the Number of product results to be generated in the report e.g. 10.

7. Stocked Only

  1. Check this checkbox to display a report with the selected categories worst selling products that have been sold within the selected date range and are marked as stocked (reorder) in the database.
  2. Uncheck this checkbox to display all products for the selected categories worst selling products that have been sold within the selected date range.

8. Click Okay to run the report.