Differences

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

--- import_and_export:importing_items [2023/01/21 03:49] – [17.01. Importing items] Mark Glover
+++ import_and_export:importing_items [2023/08/14 04:59] – [17.01. Importing items] Mark Glover
@@ Line 1: / Line 1: @@
 {{indexmenu_n>10}}
 ====== 17.01. Importing items ======
-You can import a tab-delimited text file of items by choosing **File > Import > Import items...**.
+You can import a <wrap em>tab-delimited text file</wrap> of items by choosing **File > Import > Import items...**.
 <WRAP center round important 80%>
@@ Line 33: / Line 33: @@
 <WRAP center round important 60%>
-As of v5 (or earlier) it should not be possible to create an item with the same code as another item. Hence, item with duplicate Item code will be ignored.
+As of v5 it should not be possible to create an item with the same code as another item. Hence, item with duplicate Item code will be ignored.
 </WRAP>
@@ Line 110: / Line 110: @@
 | 22             | V              | Category 3                           | 60 alphanumeric characters  |
 | 23             | W              | VEN category                         | The WHO VEN category of the item. One character only, must be V, E or N, will be ignored of it is neither of these. |
-| 23             | X              | Weight                               |   |
+| 23             | X              | Weight                               | The weight per default pack size (column D) in kg  |
 | 24             | Y              | Critical stock                       | "true" or "false" |
 | 25             | Z              | Normal stock                         | "true" or "false" |
@@ Line 116: / Line 116: @@
 | 27             | AB             | User field 6                         | 30 alphanumeric characters                                                                                                                                                                                                                                 |
 | 28             | AC             | User field 7                         | "true" or "false" |
+| 29             | AD             | Default volume per pack              | The volume of a single pack of the default pack size in m<sup>3</sup>. This volume is filled in by default when receiving stock but can simply be overridden. |
+| 30             | AE             | Default outer pack size              | The number of default packs that fit in a carton. Filled in by default when receiving goods but can be simply overridden. |
+| 31             | AF             | Default outer pack volume            | The volume of an outer pack in m<sup>3</sup>, filled in by default when receiving goods but can be simply overridden. |
-All these are in this handy template: {{ :import_and_export:msupply_item_import_template_1_.xlsx |mSupply Item Import template}}
+All these are in this handy template: {{ :import_and_export:msupply_item_import_template.xlsx |mSupply Item Import template}}
 The chances are that you already have a set of codes that you use internally. In this case open up Excel or a similar spreadsheet program, fill in the item description in the order shown above. For a quick solution, you only need to fill in the first four columns, the rest can be ignored.