Top Sold SKU Ranking Inquiry

The Top Sold SKU Ranking Inquiry provides the ability to search for your top 50, 100, 150, and 200 ranks of SKU sales for a specified transaction date range, rank by department, or across all departments. You can run the query for quantity sold or retail value ranking, with the ability to print to PDF. The inquiry reports total sales (sold/rented) and on-hand quantities.

1. Click the Top Sold SKU Ranking Inquiry button on the Merchandise Management System (MMS) main screen.
   The Top Sold SKU Ranking Inquiry screen displays.
2. Enter your search criteria.
   • Transaction Date Range (From and To)
   • Department (Select options)
   • Report Order (Quantity Sold or Retail)
   • Top # of rows (50, 100, 150 or 200)

   You can also select/deselect a checkbox for following:

   • Exclude Clearance SKUs?
   • Aggregate style (See below for additional details)
     
     
3. Click Display Results.
   The results display.

Aggregate Style Checkbox

The Aggregate style checkbox provides the ability to aggregate the results grid by SKU style. When the Aggregate style checkbox is selected, the Department search filter is pre-populated with 5 and 6. This feature is only available for departments 5 and 6. The report can also be run for departments 5 or 6 individually. The report can also be run for departments 5 or 6 individually, or any single Department within 5 or 6, e.g., 510, 520.

For each entry in the results grid aggregated by style, a link is listed in the Style column. Click the link and a more detailed list of the SKUs that were aggregated for this style display in a new window.

Note: SKUs that do not have a style listed in MMS are excluded from the results when Aggregate Style is selected.

When the Aggregate Style Option is chosen, the information in the SKU Description column includes the Style description followed by the Vendor Number.