How Do I Update Prices in Bulk?

The Buying Review function allows the set up and review of pending cost and sell price changes.

In System Settings, there is a section on the System 2 tab to allow the configuration of the ‘sells’ to be used when applying price changes.


Select the Buying Review task. (DATAENTRYITEMS.EXE BUYINGREVIEW)


Click the New button.


Amend the Description and/or Review Date as required. If optional Supplier  code is entered then the items selected later will only be for the chosen supplier.


The Buying Review can be used with or without a Supplier import file. A supplier import file allows many prices to be updated together, but is not required to use the functionality. Each field (Order Code, Barcode, Cost exTax and optional Supplier RRP) in the Supplier file should be separated by a comma (CSV format). Follow step 6 if a supplier import file is being used:

For manual entry of prices, click the Items button.

Enter the criteria to filter the items for the selection required. This is a standard search type screen and can be filtered on many item options. Click the Add Items button. Currently only ranged items are brought into the buying review.


Enter new prices as required.

When a new cost is entered, the system will automatically put a new sell amount in the ‘New Sell’ field based on the New Sell Calculation Method configured in System Settings/System 2 tab, using the current margin % for the item.

When a new Sell is entered, the new margin is calculated and put in the ‘New GM1%’ field.

When a new Margin is entered, the sell price is again updated (based on the New Sell Calculation Method configured in system settings.


For a supplier import file, click the Import button and pick the supplier file to import. When done, the screen refreshes and displays the new cost and sell values. The sell value is calculated in the same way as a manual Buying Review, that is it is based on the  New Sell Calculation Method configured in System Settings/System 2 tab.

If the supplier file contains an RRP, this will be imported into the RRP field of the Buying Review.

If any of the items in the supplier file cannot be imported (for example, the item does not exist in the Buying Review) a report is generated at the end, and the items shown.


When all prices are done, click the Accept button.

Any sell price changes are stored in the Sell setting configured in System Settings/System 2 tab.

If a supplier file was imported with RRP values, these will be stored in the Sell setting configured in System Settings

Once these changes have been applied, the affected items will be updated once the overnight RANGE process has completed.


Click the Save button.


Press the Close button. button_range.gif (1480 bytes)

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)