Product Pricing List Report

Product Pricing List Report

Product Pricing List Report Overview

The "Product Pricing List Report" lists products, based on a variety of filters, with their applicable details and pricing from specific pricebook zones.

1. Reaching the "Product Pricing List Report"

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

                                                                                          Figure A

You will see the "Report Data is Empty" message initially. You need to select the date range to check the "Product Pricing List Report." See Figure B.


                                                                                    Figure B

2. Generating the "Product Pricing List Report" 

When you navigate to the page, you will see the options pre-selected by default. You can generate the Product Pricing List Report for the selected fields. See Figure C.


                                                                                                Figure C

Fields:
  1. Product Name: This column lists products based on a variety of filters with their applicable details and pricing from specific pricebook zones.
  2. UPC: The related UPC of the product is mentioned in this column.
  3. Price Zone: In this column, the associated pricebook zone (a set of costs and prices assigned to the product existing in your inventory) is displayed. 
  4. Cost: The cost at which the product is bought from the vendor/manufacturer is mentioned here in this column.
  5. Price: The price at which the product is being sold at the store is mentioned here in this column.
  6. Margin: The value of this column is calculated as Price-Cost.

3. Filter Items

This filter gives you the option to choose whether you wish to display the report for Show All or Custom Filter.

                                                                                                              Figure D 
  1. Show All: This option will display vendor parts, UPCs that they are tied to, and details based on a set of filters that are set to narrow down parts.
  2. Custom Filter: This filter will display the filtered report as per the selection.

Figure E 
  1. UPC: It stands for 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 transferred department-wise. 
  3. Manufacturer: If you select "Manufacturer," you will see the manufacturer-specific inventory data in the report of the items that are transferred.
  4. Category: If you select "Category," you will see the product's category-wise data in the list report. You need to select the level from the "Category" drop-down selection. 
  5. Tag: If you select "Tag," you will get the tag-wise data for the group that is entered in the product details. When you select "Tag," the specific tag group will be enabled. 
  6. Vendor: If you select "Vendor," you will get vendor-specific data for the group that is entered in the product details. 
  7. Department Tag: If you select "Department Tag," you will get the department-tag-wise data for the group that is entered in the product details.

3.1 Resultant Report After Applying Selected UPC Filter


                                                                                          Figure F 

4. Product Status

This field lets you choose the status of the product, as highlighted in Figure G.

                                                                          Figure G
  1. All Products: If this option is chosen, the reports will list all the products with their pricing.
  2. Active Only: Choosing this option will list all the active products that are up for sale.
  3. Inactive Products: If this option is chosen, the report will list the inactive products that the store is not currently selling.

5. Price Filter

This field lets you choose the option to filter the product list as per price wise (greater or lesser than the entered price value), as highlighted in Figure H.


                                                                                        Figure H
  1. Price Greater Than: If this option is selected, the report will display a list of products that have a price greater than the entered amount.

                                                                          Figure I
  1. Price Less Than: If this option is selected, the report will display a list of products that have a price less than the entered amount.                                                                                     
                                                                                                                                                                                                                       Figure J               
  1. Price Equal To: If this option is selected, the report will display a list of products that have a price equal to the entered amount.

                                                                                Figure K                                                          

6. Checkbox Filter

  1. Price Exception: This filter option will let you exclude the selected location and display the report with that price exception.
See Figure L.

                                                                                           Figure L

    • Related Articles

    • Product List Report

      Product List Report Overview The "Product List Report" lists products based on a variety of filters with their applicable details and pricing from specific pricebook zones. 1. Reaching the "Product List Report Report" To reach the "Product List ...

    • Specialty Pricing Report

      Specialty Pricing Report The "Specialty Pricing Report" lists all items with specialty pricing, showing the cost/price/pricing type. 1. Reaching the "Speciality Pricing Report" To reach the "Specialty Pricing Report," follow the below steps: Step 1: ...

    • Tag List Report

      Tag List Report Overview The "Tag List Report" shows a listing of all product tags. 1. Reaching the Tag List Report To reach the "Tag List Report," follow the below steps: Step 1: Log into Control Center Step 2: Choose Point of Sale Step 3: Choose ...

    • Category List Report

      Category List Report Overview The "Category List Report" will list all the categories of the products. 1. Reaching the "Category List Report" To reach the "Category List Report," follow the below steps: Step 1: Log into Control Center Step 2: Choose ...

    • Commission Items List Report

      Commission Items List Report Overview Commissions are a great way of adding a spiff to the specific item(s) and tracking it via reports and on the leaderboards within the point of sale. The "Commission Items List Report" shows all items on commission ...