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.
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 |