Import contract prices
The 
Import contract prices button can be found in the command line in Items/products register under Contract prices panel.
The wizard for importing contract prices has two levels:
-
Download import template – downloads an Excel table to fill in with required data.
- Import contract prices – allows automatic import of contract prices from an Excel table (back) to PANTHEON Web Light.
|
1. Download import template
Download an Excel table that you can fill in with required data.
2. Import contract prices
Clicking on the Import contract prices button, opens a new panel:
Upload the filled-in Excel table into the space with a Drag and drop option or click in the empty space and a File Explorer window will pop up for selecting your Excel file.
After dropping the file or confirming your selection by clicking Open, the program shows imported data. You can then change or add data in this temporary panel.
The following data is mandatory for a successful import of contract prices:
- Item code
- Subject code
- Type
- Price
- Date from.
Command line buttons
|
Repeat import
|
Starts another import process.
|
|
Save
|
Saves the contract prices into the Items register.
|
|
X (Cancel)
|
Cancels the import process.
|
Header
|
Show only errors
|
Enable this toggle button if you want to show only items (lines) with missing data (errors). This function is very useful when importing a large number of items and contract prices.
|
|
No. of updated items
|
Shows the number of contract prices items that are already in the Items register and you only want to update.
|
|
No. of new items
|
Shows the number of contract prices items that are not in the Items register yet and you are importing them for the first time.
|
|
No. of errors in columns
|
Shows the number of all errors in all columns.
Where mandatory data is missing (errors) in the table, the program shows a warning sign !.
After correcting all the errors, the number will change to 0.
|
Columns
|
Status
|
An x sign shows that there is an error in that line. After correcting all the errors in that line, the x sign in the Status column will disappear.
|