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
- The import file must be an “.xlsx” (Excel) type file.
- The first row must contain the column headers shown in the Column heading column in the table below.
- The table below details the fields you must have in each row of the file:
| 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
| Previous: 17.13. Importing stores | | Next: 17.15. Exporting items, exporting items and stock |