17.14. Importing tenders

This function allows you to import a tender into the store you are currently logged into. To access it, choose Supplier > Import tender from the menus. A window will open for you to select the import file (details given below). Browse to the file and double-click on it or click on it to select it then click on the Open button to carry out the import.

mSupply will then read the import file and create a suggested status (sg) tender with a default, system-generated description (which you should change later) and add the lines in the spreadsheet to the tender. The tender will then be automatically opened for you to continue editing.

Import file format

Column Column heading Description
1 (A) Item code Mandatory, Text. The code of the item this tender line is for.
2 (B) Item name Optional, Text. The name of the item. Ignored during import but useful for you when reading the file.
3 (C) Unit/Pack Optional, Text. The unit of the item. Ignored during import but useful for you when reading the file.
4 (D) Pack size Mandatory, Integer. The number of units in a pack.
5 (E) Total quantity Mandatory, Integer. The total number of units for this tender line.

Here is a blank spreadsheet you can download with the right columns: tenderimporttemplate.xlsx