import_and_export:import_items_and_stock

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
import_and_export:import_items_and_stock [2023/04/21 03:10] – [Import file format] Mark Gloverimport_and_export:import_items_and_stock [2026/02/16 12:23] (current) – [17.02. Importing stock] Gary Willetts
Line 36: Line 36:
 If you spot any problems, click on the **Cancel** button, fix them and try again. If all is well, click on the Import button and mSupply will carry out the import. A progress bar will show you how far through the whole process mSupply is. When it gets to the end you will be shown a message telling you how many lines were imported successfully and how many were skipped (because the item could not be identified - because the item code was missing or did not match an item in your datafile). If you spot any problems, click on the **Cancel** button, fix them and try again. If all is well, click on the Import button and mSupply will carry out the import. A progress bar will show you how far through the whole process mSupply is. When it gets to the end you will be shown a message telling you how many lines were imported successfully and how many were skipped (because the item could not be identified - because the item code was missing or did not match an item in your datafile).
  
 +<WRAP center round important 60%> 
 +Any lines in the import file that belong to items that are **invisible** in the current store will be ignored and not imported. An alert message at the end of the import will inform you of any lines that were not imported because of this. For information on item visiobility in stores, see the [[other_stuff:virtual_stores#master_lists_tab_and_visibility_tab_controlling_item_visibility|26.07. Virtual stores]] page. 
 +</WRAP>
 ==== Import file format ==== ==== Import file format ====
   * The import file must be a tab delimited text file.   * The import file must be a tab delimited text file.
Line 60: Line 62:
 | 16 (P)  | Volume per pack | **Optional**, Decimal number. The volume that a single pack of this batch occupies on the shelf in m<sup>3</sup>. | | 16 (P)  | Volume per pack | **Optional**, Decimal number. The volume that a single pack of this batch occupies on the shelf in m<sup>3</sup>. |
 | 17 (Q)  | Weight per pack | **Optional**, Decimal number. The weight of a single pack of this batch in kg. | | 17 (Q)  | Weight per pack | **Optional**, Decimal number. The weight of a single pack of this batch in kg. |
 +| 18 (R)  | Manufacturer | **Optional**, Text. The code of the manufacturer of this batch. If a manufacturer with this code doesn't exist in the datafile then it is created with the Code, Name and Charge to values all set to the contents of this cell.  |
  
 <WRAP important center round 90%> <WRAP important center round 90%>
  • Last modified: 2023/04/21 03:10
  • by Mark Glover