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
import_and_export:import_items_and_stock [2023/04/21 02:53] – [Import file format] Mark Gloverimport_and_export:import_items_and_stock [2023/04/21 03:10] (current) – [Import file format] Mark Glover
Line 54: Line 54:
 | 10 (J)  | Description      | **Optional**. Text, Up to 32,000 characters. The full description of the item.  Be careful not to have any carriage return characters in the text though, or the import file will not be valid!  | | 10 (J)  | Description      | **Optional**. Text, Up to 32,000 characters. The full description of the item.  Be careful not to have any carriage return characters in the text though, or the import file will not be valid!  |
 | 11 (K)  | [[items:department_management|Item Department]]  | **Optional**, Text, up to 30 characters. If you import a department name that doesn't exist, the department will be created.  | | 11 (K)  | [[items:department_management|Item Department]]  | **Optional**, Text, up to 30 characters. If you import a department name that doesn't exist, the department will be created.  |
-| 12 (L)  | [[items:item_locations|Shelf Location]]   | **Optional**, Text, Up to 60 characters. The code for the shelf location of this stock line.  |+| 12 (L)  | [[items:item_locations|Shelf Location]]   | **Optional**, Text, Up to 60 characters. The code for the shelf location of this stock line.\\  If the location does not exist, the location will be created as the stock is loaded.  You can then edit the location details after the import.|
 | 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.  | | 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. | | 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. |
  • Last modified: 2023/04/21 03:10
  • by Mark Glover