Introduction

Bulk Price Update allows you to update your Item Prices individually or in groups without having to open each Product Master Record. This is useful if you have a large product catalogue and need to apply many price updates to a range of products at one time.

 

See:

Add or Edit Service / Non-Stock Items (5.1) - AIQ Academy on Vimeo

Service Non Stock Queries (5.3) - AIQ Academy on Vimeo

 

Performing Stock Takes‍ 

Updating prices in bulk

1. To update product items, go to Items > Product Item > New Bulk Update. To update Services/Non Stock items, go to Items > Services/Non Stock Items > New Bulk Update.

2. In Item Bulk Update click Grid Options > Customize Grid. Select the fields you want to display in the grid. Then drag and drop the fields you wish to view or update onto the grid.  Using this method, you can choose to show multiple price categories that you have created and then apply price updates to a selection of these e.g., set retail price to be trade price plus 10%. Use the filters at the top of each column to refine the items shown in the grid below.  This is useful if you wish to apply price updates to a selected group of items only.

 

3. In the grid, use the filters to refine the Price Catalogue by criteria such as Item Group and Item Sub-Group. 

 

4. To update prices on an individual basis, enter new prices under the appropriate grid column. The new price will be automatically saved as you exit the field.  Prices entered must be positive (i.e >= 0.00) and entered in base currency.

To update prices as a group, go to the dropdowns at the top of the screen. 

• In the Select What to Change drop down, select the price field to update.  
• Use the Select how to Change It drop down to indicate the method by which the selected price should be changed.  For example, you can choose to increase/decrease price by a percentage or fixed amount. Percentages are expressed as decimals, for example 2%. equals 2.00. If you choose to Increase or Decrease by a fixed amount, the ‘by’ field will change from a percentage to an amount field. 
• Use the Based on drop down to indicate which field should be used as the basis for the price update.  For example, you may wish to increase your standard price by the current average cost of the product plus 10%.  
• In by enter the required price change. Depending on the method chosen, this can either be a percentage or flat (i.e. fixed) amount. Values must be positive and recorded in base currency.  

5. Tick Round to set how the new updated prices will round. The options are to round up, round down, or round to the nearest value. If you choose the later, you can choose to round to the nearest number or multiple of a selected value. For example, you could add 30% to 2.00, round to nearest 1.00 and adjust by -.01 to give an end price of 2.99. 

 

6. When you have made your selection, click Bulk Update to apply the price updates to the filtered dataset.  A message will appear confirming the specific changes to be applied and the number of records affected.  Note that all changes are permanent and cannot be undone after processing.