Labmanager General

How to do bulk price adjustments


Heads Up!

Only users with Admin or Accounts privileges can perform this task.

  1. Log in to the system.

  2. From the left menu, click Pricing List.

  3. Select Price Adjustment.

Heads Up!

There are two ways to adjust prices in the system

Method 1: Using Template (Bulk Upload)

NOTE: First, download the template and make the required changes

  1. Click Download Templates

  2. Select Template Type

  3. Click Generate Document to download the template

  4. Open the file and update the values

  5. Return to the system and click Bulk Upload

  6. Select the same Template Type

  7. Click Choose File and upload the edited file

  8. Click Upload Document

  9. Click OK to confirm

Method 2: Calculation-Based Update

NOTE:This method allows you to use system formulas for price adjustment

  1. Click Calculation Based Update

  2. Click and Select Template Type name 

  3. Choose Formula Type (Basic or Advanced)

Heads Up!

 During the upload process, a backup is automatically created. Once the upload is completed, the system will use the uploaded data while retaining the backup for recovery purposes if needed.

How It Works:

Select the source column, choose an operator, and define either a constant value or another column as the operand. The system will then automatically apply the formula and calculate the result for the selected parameter.

  1. Click Finalize

  2. Click OK to confirm