Import a Set Price Excel File

The Set Price Excel File Import is intended to allow convenient updating of set prices (Private, Schedule 3, PBS Under-Copayment) as defined in a maintained spreadsheet. The spreadsheet also supports configuration of multipack pricing.

The following documentation will assist you to import set prices into Fred Dispense Plus. The set price Excel file will be provided to you by your head office.

Steps to import a Set Price Excel File

  1. From the wait screen, click on More Options… under the Activities Menu. Select Import Excel Drug File.

    You will be prompted to browse to the Set Price Excel File to import.

  2. After selecting the Set Price Excel File to import, the next screen that displays will show the available pricing groups (if any) to choose from and to set the priority in which to accept the pricing.

    Click on the check box to select which pricing group(s) you wish to import the pricing for.

    Drag the pricing group to set the priority in which to take pricing information from.

    In the example below, the pricing information will be taken from both Group2 and Group1. Group2 has a higher priority than Group1.

    • If both Group1 and Group2 has pricing information for the same drug, then the pricing information from Group2 will be applied.

    • If pricing information for a drug is only specified for Group2, this will be imported given that Group2 has been selected.

    • If pricing information for a drug is only specified for Group1, this will be imported given that Group1 has been selected.

  3. Select the Do not update prices for drugs in Stock Group check box if you wish to skip updating the pricing information for any drugs that you wish to manually manage. By default, this applies to Stock Group number 999. However, the value can be changed to any Stock Group number required.

    : You will need to create the Stock Group in advance and assign any drugs that you wish to manually manage the pricing for into that Stock Group before this check box can be used during the import process

  4. Click on the Import button when you are ready to import the pricing information.

    If the import completely successfully, the following message will display:

  5. Click OK and a report will be generated to summarise the drugs that have been updated by the import.

What happens if the import is unsuccessful?

If the import was unsuccessful, it will likely be caused by issues within the Set Price Excel File. In such scenarios, a Validation Failed message like the one below will appear.

  1. Click OK and select the location where you would like to save results file.

  2. Open the results file and scroll across to the Validation Result column.

    (Click the image to enlarge it).

  3. Review and resolvethe issues reported before reattempting the import of the Set Price Excel File again.