import_and_export:importing_stores

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
import_and_export:importing_stores [2026/01/28 00:05] – [17.13. Importing stores] Mark Gloverimport_and_export:importing_stores [2026/02/03 22:23] (current) – Adam Dewey
Line 23: Line 23:
   * The import file must be an ".xlsx" (Excel) type file.   * The import file must be an ".xlsx" (Excel) type file.
   * The first row must contain the column headers shown in the **Column heading** column in the table below.   * The first row must contain the column headers shown in the **Column heading** column in the table below.
-  * The store code is used to check whether a store exists already. If it does not exist in the datafile it will be created with the values in that row of the spreadsheet. If a store with the store code does exist in the datafile already, its values will be updated with the values contained in that row of the spreadsheet (blank cells will be ignored so values will not be updated with empty cells).+  * The store code is used to check whether a store exists already. If it does not exist in the datafile it will be created with the values in that row of the spreadsheet. If a store with the store code does exist in the datafile already, its values will be updated with the values contained in that row of the spreadsheet. <WRAP center round important 60%> 
 +Blank cells will be ignored so values will not be updated with empty cells. 
 +</WRAP>
   * The currently logged in user (the one doing the import) is given login permission to the store.   * The currently logged in user (the one doing the import) is given login permission to the store.
   * The table below details the fields you should have in each row of the file.   * The table below details the fields you should have in each row of the file.
Line 33: Line 35:
 | 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**, . |
  • Last modified: 2026/01/28 00:05
  • by Mark Glover