Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
import_and_export:import_items_and_stock [2022/02/08 13:10] – Gary Willetts | import_and_export:import_items_and_stock [2023/04/21 02:53] – [Import file format] Mark Glover | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{indexmenu_n> | {{indexmenu_n> | ||
====== 17.02. Importing stock ====== | ====== 17.02. Importing stock ====== | ||
- | <WRAP center round tip 60%> | + | <WRAP center round important |
**We strongly recommend: \\ | **We strongly recommend: \\ | ||
\\ | \\ | ||
Line 38: | Line 38: | ||
==== Import file format ==== | ==== Import file format ==== | ||
- | The import file must be a tab delimited text file. The first row can contain the column titles but all other rows in the file should contain data to be imported. | + | * The import file must be a tab delimited text file. |
+ | * The first row can contain the column titles but all other rows in the file should contain data to be imported. | ||
+ | * The table below details | ||
^ Column | ^ Column | ||
Line 54: | Line 56: | ||
| 12 (L) | [[items: | | 12 (L) | [[items: | ||
| 13 (M) | Donor | **Optional**, | | 13 (M) | Donor | **Optional**, | ||
+ | | 14 (N) | [[receiving_goods: | ||
+ | | 15 (O) | Outer pack size | **Optional**, | ||
+ | | 16 (P) | Volume per pack | **Optional**, | ||
+ | | 17 (Q) | Weight per pack | **Optional**, | ||
+ | |||
+ | <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: | ||
+ | </ | ||
Here is a blank spreadsheet you can use with the right columns: {{ : | Here is a blank spreadsheet you can use with the right columns: {{ : |