Price Change Report

Price Change Report

Price Change Report Overview

The Price Change Report will display the changes in the price of the product(s) with a date and time stamp. The only difference is that this particular report type will display the changes in the price of each product, and NOT the changes in the cost of each product. The system will display the records of price changes for products only for the specifically selected date range. The system will also display the UPC, product name, pricebook zone name, old price value, new price value, date, and time stamp when the old price was changed to the new, and the employee’s name who changed the price for a particular product.

Reaching the Price Change Report

To reach the Price Change 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 Inventory Reports
  5. Step 5: Choose Price Change Report
See (Figure A). You will see many types of inventory reports that will be useful to any retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of inventory reports.

                                                                          Figure A

By clicking on "Price Change Report," you will be redirected to the "Price Change Report" page, where you can see relevant filtering and sorting options.

                                                                                Figure B

1. Generating a Price Change Report

To generate the "Price Change Report," follow the steps below. (See Figure B above)
  1. From the "Inventory Report" page, you will see the "Choose Report" drop-down selection.
  2. By clicking the drop-down selection, you will see different types of inventory reports in alphabetical order.
  3. Search for  "Price Change Report" 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 Price Change Report will be displayed as highlighted in Figure C.

                                                                                    Figure C

The following sales data in tabular format when you generate the price change report:

1. Product Name: This column displays the name of the product.

2. 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 in the "Price Change Report."
3. Pricebook Zone: It is a set of costs and prices assigned to the item(s) existing in your inventory. Select the applicable pricebook zone for which you wish to generate "Price Change Report."
4. Change Type: This column displays the Price Change Type, which is a filter and filters the records as per the need in the report, i.e., cost, price, or both.  
5. Change From: This column displays the previous cost/price. 
  1.  Cost: This column displays the previous cost of the item's cost (buying price of an item).
  2.  Price: This column displays the previous cost of the item's price (selling price).
6. Change To: This column displays the current cost/price. 
  1.  Cost: This column displays the current cost of the item's cost (buying price of an item).
  2.  Price: This column displays the current cost of the item's price (selling price).
7. Changed By: This column displays the name of the person who changed the cost/price of the items in the inventory.
8. Change Date: This column displays the date when the cost/price of the listed item is changed.

2. Report Filter Options

This part is focused on understanding the custom filter options to generate the "Price Change Report" by setting up specific criteria.

2.1 Save Filter and Custom Filters for "Price Change" Items 

You can generate the "Price Change Reportfor all store locations with the "Show All" option or a customized report with "Custom Filter." 

                                                                                                Figure C

You will find the two options from the "Filter Items" drop-down selection:
  1. Show All: It considers all the data (criteria) to generate the report. The "Manage" button will be disabled for this option. By default, this option will be pre-selected.
  2. Custom Filter: To customize the items for the report, you need to select the "Custom Filter" option. Once you select it, the "Manage" button will be enabled to set up the filters.

2.2 Manage Filter

By clicking the "Manage" button, a "Manage Filters" window will pop up. You will see the following details:
(See Figure D)

                                                                                         Figure D

                                                                                                   Figure E
  1. You will see the different tabs to filter the items for the "Price Change Report." You can choose the required filter categories, which are described below:
  1. Manufacturer: If you select "Manufacturer," you will see the manufacturer-specific inventory data in the report of the items whose price has been changed.
  1. Department: If you select "Departments," you will see a report of items that are out-of-stock department-wise. The items with the same department will be displayed under the specific department when you generate the "Price Change Report."
  1. Category: If you select "Category," you will see the product's category-wise inventory data in the report. You can check the inventory data in the report at the category level. You need to select the level from the "Category" drop-down selection. 
  1. Tag: If you select "Tag," you will get the tags-wise inventory data for the group that is entered in the product details. When you select "Tag," the specific tag group will be enabled. 
  1. Vendor: If you select "Vendor," you will get the vendor-wise inventory data for the group that is entered in the product details. 
  1. You can select the saved custom filter from the drop-down selection.
  2. The "Manage Filters" button will open the list of the saved custom filters, as you can see in "TEST1" adjacent to the "Manage Filter" button.
  1. Select Filter: You can select any filter from the list to generate the desired report. Select the filter from the list, and then click on the "Select Filter" button.

                                                                               Figure F
  1. Select "Manage Filter Category," say, "UPC" and you will see many options listed below. See (Figure E) above.                                                       
Selected List: See Figure F You will have one flag to decide whether you want to "Include" or "Exclude" the selected records when the "Price Change Report" is generated.

See (Figure E and Figure F)
  1. Include (Option 2: If the flag is selected as "Include," it means the "Price Change Report" will be generated by applying the selected records. (See Figure F above)
  1. Exclude (See Figure): If the flag is selected to "Exclude," it means the "Price Change Report" will be generated without including the selected records. (See Figure G above)

                                                                                Figure G

3. Clear Selection: You can remove any record from the list by clicking the "Remove" (x) icon. If you want to remove the whole selection, click the "Clear Selection" button.

2.2.1 Save Custom Filter

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 H
  1. Click on OK to save the filter, once saved click on Apply to apply the filters on the report.

2.2.2 Date Range

  1. You can filter your sales data in the report between the dates and select a specific time from the Start Date and End Date drop-down calendars.
  1. By clicking the edit box, you will get the tiny calendar to select the specific date range. You can also enter the date manually in mm/dd/yyyy format.
  1. You can also generate a report with a specific time duration (till morning/evening), you can select the particular time (hour and minutes) from the date selection. See Figure I.

                                                                         Figure I

                                                                                    Figure I1

2.3 Presets

Presets label is provided to select the specific duration/interval to generate the Price Change Report according to the selected time period.

                                                                                         Figure I3

3. Order By:

This is a sorting method to sort the "Price Change Report" as the oldest and newest depending on the selection. 

                                                                      Figure J
  1. Order By Oldest First:

                                                                   Figure K
  1. Order By Newest First:

                                                                      Figure L

Pricebook Zone:

Select the applicable pricebook zone for a store location. A price book zone is a set of costs and prices assigned to the item(s). 
A pricebook can simply be defined as a list of all the items, including their related details (UPC, Name, Description, Cost, Price, etc.) that exist in your inventory. Whereas, the term "Pricebook Zone" can only be referred to the “Costs and Prices” assigned to the item(s) existing in your inventory.

                                                                    Figure M

4. Generating "Price Change Report" After Applying Filters

  1. Once you apply the desired filter, it will take you back to the "Price Change Report" main page.
  2. Then click on "Generate Report" to generate the filtered report.  

                                                                                 Figure N
The report highlights the list of items whose price has been changed, and the Price Change Report is displayed according to the various filters applied.

    • Related Articles

    • Daily Sales Report

      Daily Sales Report Overview Reports -> Sales Reports -> "Daily Sales" The most critical and important statistics for running a business efficiently are various types of sales reports. A daily sales report provides a summary of all sales made during ...
    • Out-of-Stock Report

      Out-of-Stock Report Overview Out-of-Stock Report report type will display the list of those products, which are currently not in stock, as per the database records of the inventory management system. The system will display the records of ...
    • Hourly Sales Report

      What's the Purpose of the Hourly Sales Report in the System? This report type will display the sum total of sales data for each working hour. The system will calculate the sales data for each working hour of all the days that fall within a ...
    • E-Journal (Sales Report)

      What's the Purpose of an E-Journal in the System? This sales report type (e-journal) will display the specific transactions depending on your requirements. Different types of filters can be configured, and the system will display specific transaction ...
    • Buydown Sales Report

      Buydown Sales Report Overview Reports -> Sales Reports -> "Buydown Sales" Tobacco manufacturers and distributors have long made refund/rebate payments to retailers for the retailer’s purchase of cigarettes and other tobacco products. Sometimes ...