Import Price List

Revision as of 15:32, 21 July 2014

This page contains additional importing features supported by MedITEX.

It is possible to import price lists by providing a spreadsheet with the information described on this section.

An example of this file can be downloaded from the link below.

<a href="/images/Pricelist_MedITEX_Example.xls">Click here</a> to download an example of Insurance information import file.

The structure of this file is described in the table below:

	Column name	Column content
1.	ITEM_NAME	Name of an item.
2.	ITEM_CODE	This code is UNIQUE for each item.
3.	CODE_TYPE	The type of your code. Possible here: CPT HCPCS E/M LOINC GRC
4.	SHORT_CODE	Some characters of your choice. Not necessary.
5.	ITEM_GROUP	Group for items. If the group name is not found in the list of groups, it will be inserted.
6.	ITEM_PRICE	Price for an item.
7.	BILLING_CATEGORY	Billing category name defined exactly like in the billing category list.
8.	INSURANCE_NAME	Name of insurance defined in MedITEX IVF - Insurance administration.
9.	ITEM_DESCRIPTION	Description.

Not all fields are required;
Required fields are:
- ITEM_NAME
- ITEM_CODE
Please pay attention that the import table is the only or at least the first sheet in your excel file.

If price is defined but billing category and insurance name stays empty,
this price will be the default price (always valid). --> if you have only one price for an item,
it is better to leave billing category and insurance name empty.
FOR EACH PRICE there needs to be ONE line.
- Item name, item code, code type, short code, item group and item description should have exactly the same information (this will be saved in one table).
- Item price, billing category insurance name will be saved in a second table.
The importer looks if an item with this specific item code already exists.
If yes, then the other item information (item name, code type, short code, group, description) will be updated and prices will be updated or inserted. If item is not found, the item with all information and all prices will be inserted.


In item tabel "Material XYZ" will be inserted ONCE. But in price table 4 prices for this item "Material XYZ" will be inserted.

<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a>

@@ Line 86: / Line 86: @@
 <ul>
 <li>Not all fields are required;</li>
 <li>Required fields are:
 <ul>
 <li>ITEM_NAME</li>
@@ Line 102: / Line 102: @@
 <tbody>
 <tr>
-<td>NOTE:<br /></td>
+<td><img src="/images/plus129.png" alt="" width="129" height="129" /></td>
 <td>
 <ul>
@@ Line 112: / Line 112: @@
 </ul>
 </li>
-<li>The importer looks if a item with this specific item code exists already. <br />If yes, then the other item information (item name, code type, short code, group, description) will be updated and prices will be updated or inserted. If item is not find, the item with all information and all prices will be inserted.</li>
+<li>The importer looks if an item with this specific item code already exists. <br />If yes, then the other item information (item name, code type, short code, group, description) will be updated and prices will be updated or inserted. If item is not found, the item with all information and all prices will be inserted.</li>
 </ul>
 </td>
@@ Line 119: / Line 119: @@
 </table>
 <p>&nbsp;</p>
-<p>&nbsp;</p>
+<table style="margin-left: auto; margin-right: auto;" border="0">
-<table border="0">
 <tbody>
 <tr>