Differences

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

--- import_and_export:import_items_and_stock [2022/02/08 14:46] – Gary Willetts
+++ import_and_export:import_items_and_stock [2023/04/04 14:24] – Gary Willetts
@@ Line 54: / Line 54: @@
 | 12 (L)  | [[items:item_locations|Shelf Location]]   | **Optional**, Text, Up to 60 characters. The code for the shelf location of this stock line.  |
 | 13 (M)  | Donor | **Optional**, Text, Up to 60 characters. The name of the donor of this stock line. If the donor doesn't exist, it will be created.  |
+| 14 (N)  | [[receiving_goods:custom_stock_fields#custom_stock_fields|Custom stock field 5]] | **Optional**, Text. The value to be entered in custom stock field 5 for this batch. If the value doesn't already exist as an option for custom stock field 5 then it will be added. See the [[receiving_goods:custom_stock_fields]] page for details of custom stock fields. |
+| 15 (O)  | Outer pack size | **Optional**, Integer. The number of packs that fit in a carton (NOT the number of units in a carton!). |
+| 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. |
+<WRAP important center round 90%>
+**Please note:** It is not part of the import file but, if an item's default Volume per pack is set (see the **Volume per pack** field on the [[items:item_basics:tab_storage]] page for details) then this will be applied to the stock line's volume per pack. The value will be proportionately increased or decreased if the stock line's pack size differs from the item's default pack size (**Preferred pack size** field on the [[items:item_basics:tab_storage]] page).
+</WRAP>
 Here is a blank spreadsheet you can use with the right columns: {{ :import_and_export:msupply_stock_import.xlsx |}}