| Both sides previous revision Previous revision Next revision | Previous revision |
| import_and_export:importing_stores [2026/01/28 00:11] – [Import file format] Mark Glover | import_and_export:importing_stores [2026/02/03 22:23] (current) – Adam Dewey |
|---|
| | 4 (D) | site_code | **Optional**, Integer. The synchronisation site the store belongs to. Leave empty if this is not part of a synchronisation setup. Will be set to 1 by default if not provided. | | | 4 (D) | site_code | **Optional**, Integer. The synchronisation site the store belongs to. Leave empty if this is not part of a synchronisation setup. Will be set to 1 by default if not provided. | |
| | 5 (E) | organisation_name | **Optional**, Text. The name of the organisation this store belongs to. No functional value but can be included in reports etc. | | | 5 (E) | organisation_name | **Optional**, Text. The name of the organisation this store belongs to. No functional value but can be included in reports etc. | |
| | 6 (F) | address_1 | **Optional**, Text. The number of packs (containing the number of units in column 4) in this stock line. Equal to the total quantity if the Pack size is ''1''. | | | 6 (F) | address_1 | **Optional**, Text. The first line of this store's address. | |
| | 7 (G) | address_2 | **Optional**, Text. The first line of this store's address. | | | 7 (G) | address_2 | **Optional**, Text. The second line of this store's address. | |
| | 8 (H) | address_3 | **Optional**, Text. The first line of this store's address. | | | 8 (H) | address_3 | **Optional**, Text. The third line of this store's address. | |
| | 9 (I) | address_4 | **Optional**, Text. The first line of this store's address. | | | 9 (I) | address_4 | **Optional**, Text. The fourth line of this store's address. | |
| | 10 (J) | address_5 | **Optional**, Text. The first line of this store's address. | | | 10 (J) | address_5 | **Optional**, Text. The fifth line of this store's address. | |
| | 11 (K) | postal_zip_code | **Optional**. Text. The store's postal or ZIP code. | | | 11 (K) | postal_zip_code | **Optional**. Text. The store's postal or ZIP code. | |
| | 12 (L) | phone | **Optional**, Text. The phone number of the store in no particular format. | | | 12 (L) | phone | **Optional**, Text. The phone number of the store in no particular format. | |
| | 13 (M) | tags | **Optional**, Text. The tags belonging to the store. Separate individual tags with a space. | | | 13 (M) | tags | **Optional**, Text. The tags belonging to the store. Separate individual tags with a space. | |
| | 14 (N) | copyStorePrefFromStoreCode | **Optional**, Text. The code of the store to copy store preferences, custom data, master list associations and user permissions from (for the user in column 19 (S)). If none is provided the store is given a default set of preferences, empty custom data, no master list associations and no user permissions. | | | 14 (N) | copyStorePrefFromStoreCode | **Optional**, Text. The code of the store to copy the following store properties from: preferences, custom data, master list associations and user permissions (for the user in column 19 (S)). If none is provided the store is given a default set of preferences, empty custom data, no master list associations and no user permissions. | |
| | 15 (O) | Type | **Optional**, Text. . | | | 15 (O) | Type | **Optional**, Text. . | |
| | 16 (P) | Create Date | **Optional**, . | | | 16 (P) | Create Date | **Optional**, . | |