Non-Sellers Report

Non-Sellers Report

Non-Sellers Report Overview

The Non-Sellers Report will display sales data for products with no sales during a specifically entered date range. Multiple different types of filters can also be configured, depending on your requirements. The system will display records of non-selling products only according to the selected filter options and several fields with detailed and automatically calculated information on all the non-selling products. 

1. Reaching the Non-Sellers Report

To reach the Non-Sellers Report Overview, follow the below steps (See Figure A):
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Sales Report
  5. Step 5: Choose Non-Sellers Report
See Figure A. You will see many types of inventory reports that will be useful to your retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of sales reports.


                                                                                              Figure A

You will see the "Report Data is Empty" message initially. You need to select the date range to check the "Slow Sellers Report" in the report. See Figure B.


                                                                                         Figure B

2. Generating the Non-Sellers Report

When you navigate to the page, you will see the options pre-selected by default. You can generate the Non-Sellers Report for the selected date range.
Enter the value in the "Days Since Last Sold"  field, and the system will display the report according to that value. If the value entered is 15, then the report that will be generated will have data that suggests that no unit of an item has been sold in 15 days.
To generate it, follow the steps below. (See Figure B above.) 
  1. From the "Non-Sellers Report" page, you will see the "Choose Reports" drop-down selection.
  2. By clicking the drop-down selection, you will see different types of inventory reports in alphabetical order.
  3. Search for "Non-Sellers" from the list and click on it.
The following data gets fetched in tabular format when you click on the "Generate Report" button in the top right corner; the "Non-Sellers Report" report will be displayed as highlighted in Figure C.

                                                                                           Figure C
Fields:
  1. UPC: This column displays the UPC of the non-selling product in the selected date range.
  2. Name: The name of the product is mentioned here in this column.
  3. QOH: Here, the quantity on hand of the product that is present at the store is displayed in this column.
  4. Cost Each: This column displays the cost (the price at which the item is bought) of each non-selling product at the store. 
  5. Retail Each: The retail price (the price at which the item is sold) for the product is mentioned in the "Retail Each" column.
  6. Sold: This column displays the number of items/units sold in the selected date range at the location store.
  7. Last Sold: This column displays the last sold date of the item in this column.
  8. Last Invoice: This column displays the invoice date when the item was purchased from the vendor.
  9. Date Added: The date added is the first time the inventory record existed for that product in the product inventory table.
  10. Days In Inventory: This column displays the calculation of the days in inventory since the "date added."

3. Filter Items

  1. Show All: This option displays the slow-selling items for all the store locations.
  2. Custom Filter (Manage): This button lets you apply some filters and generate filter-specific reports.   

                                                                               Figure D

By clicking the "Manage" button, a "Manage Filters" window will pop up. You will see the following details highlighted in Figure E.


                                                                                            Figure E
  1. UPC: Universal Product Code (UPC), which helps in tracking items at the store. This UPC column displays the UPCs of the items that are listed. 
  2. Department: If you select "Department," you will see a report of items that are displayed department-wise. 
  3. Category: If you select "Category," you will see the product's category-wise sales data in the report. You can check the data in the report at the category level. You need to select the level from the "Category" drop-down selection. 
  4. Manufacturer: If you select "Manufacturer," you will see the manufacturer-specific inventory data in the report of the items that are transferred.
  5. Tag: If you select "Tag," you will get the tags-wise sales data for the group that is entered in the product details. When you select the "Tag," the specific tag group will be enabled. 
  6. Vendor: If you select "Vendor," you will get the vendor-wise sales data for the group that is entered in the product details. 
After selecting and moving the records under the "Selected List." See Figure F.


                                                                                    Figure F

You can decide whether you want to "Include" or "Exclude" when the Non-Sellers is generated. See Figure G.
  1. Include: If the flag is selected to "Include," it means the sales report will be generated by applying the selected records.
  2. Exclude: If the "Exclude" flag is selected, the sales report will be generated, but the selected records will be ignored. It will consider the selected records that need to be excluded and the left-side records for reports.
3.1 Save Filters
You can also save the configured custom filters for future use. By clicking the "Save Filters" button, a pop-up will appear to allow you to enter the name of the custom filter.


                                                                                          Figure G

4. Days Since Last Sold: 

Enter the value in the "Days Since Last Sold" field, and the system will display the report according to that value. If the value entered is 15, then the report that will be generated will have data that suggests that no unit of an item hasn't been sold in 15 days.

5. Group By:

To check the non-sellers items for a specific location, you can select the location by clicking the "No Filter Selected" button on the top-right side, applying which store locations you want, and then choosing "Location" in the "Group by Location" field. See Figure H.


                                                                                 Figure H
  1. None: If any location is not selected, it will display the report for non-seller items for every location by default.
  1. Location: If you select "Location," the data in the non-sellers report will be displayed location-wise (stores) for each store. Once the "Location" specific report is generated, you can check the list of items that are non-selling.
  1. Location Group: You can also check the data in the report as per the location groups that are created in "Manage Location Groups" at Locations. If you select the "Location Group," the non-selling item data will be displayed in the location group.  

6. Sort By:

The "Sort By" filter will sort the slow seller report into four categories:

                                                                                        Figure I

6.1 Product Name: This option when chosen will sort items with respect to the name of products in the report. See Figure J.

                                                                                               Figure J

6.2. Last Sold: If this option is selected, the system will sort items with respect to the item's last sold date in the newest to oldest order.

                                                                                      Figure K

6.3 Total Cost: If this option is selected, the system will sort items with respect to the total cost in descending order.

                                                                                          Figure L

6.4. Days in Inventory: This report is displayed by the descending "Days in Inventory" number.

                                                                                       Figure M

7. Checkbox Filter:

The value for "Exclude Add in Last X Days" and "Exclude Received" is set to "30 days" (one month) by default, although the values are editable.

  1. Exclude Add in Last X Days:

If this option is checked, it will exclude items that were added (the first time the inventory record existed for that product in the product inventory table) within the last 30 days. See Figure C above.

  1. Exclude Received: 

If this option is checked, it will exclude the items that were received at the store from the vendor. See Figure C.

  1. Show Top: 

This checkbox will show the Top "X," with X being some numerical value. See Figure C.

  1. Rollup Separate: 

This checkbox, if checked, will display only the parent items in the QOH column in the report (See Figure N), as opposed to when it is not checked. (See Figure C.)

                                                                                                  Figure N

    • Related Articles

    • Sales / Inventory / Non-Sellers Report

      Sales / Inventory / Non-Sellers Report Overview The Sales / Inventory / Non-Sellers Report will display the sales data and inventory data of non-selling products. All the hybrid data (sales, inventory, and non-selling) will be displayed together in ...

    • Slow Sellers Report

      Slow Sellers Report Overview The Slow Sellers Report will display sales data for products with low sales during a specifically entered date range. Multiple different types of filters can also be configured, depending on your requirements. The system ...

    • Top Sellers Report

      Top Sellers Report Overview Reports -> Sales Reports -> "Top Sellers" Different types of sales reports and analytics of the products help you understand how your business is progressing. You also need to keep the products in stock at your store that ...

    • Non-Tax Sales Report

      Non-Tax Sales Report Overview Non-taxable sales are transactions where no sales tax is collected. The tax rules vary from state to state, and there is a lot of variability in sales tax as sales tax amounts can be different across a state. FTX POS is ...

    • Monthly Sales Report

      Monthly Sales Report Overview Reports -> Sales Reports -> "Monthly Sales Report" As a sales manager with super-admin rights or a business owner, you need to keep an eye on the sales and check the sales analytics periodically on a weekly, quarterly, ...