CSV File Import

File Format

Each field is separated by a comma (,) and enclosed in double quotes (""). Each row in the file denotes a unique store location and each field (column) in the row holds information about that location.

The following are the list of fields needed in each row.

Note

The structuredAddress fields that are present in the API method of Creating a Store are not yet supported for file upload. The file upload also needs to include the store opening times.

Table 3. Fields required for File Import

Column

Field Name

Mandatory?

Length

Example

1

storeId

Yes

36

"01WESTMINSTER"

2

storeName

Yes

128

"Westminster Square"

3

city

No

64

"London"

4

postCode

Yes

16

"SE1 7UW"

5

countryCode

Yes

3

GBR

6

address

Yes

256

"126 Palmerston House, Westminster Square"

7

latitude

Yes

11,8

"51.499240"

8

longitude

Yes

11,8

"-0.113020"

9

telephoneNumber

No

16

"+44 20 7946 0234"

10

logoUrl

No

128

"http://logodomain.com /nicelogo.jpg"

11

photoUrls

No

512

"http://logodomain.com /nicephoto1.jpg, http://logodomain.com /nicephoto2.jpg"

12

hasDisabledAccess

No

boolean

true

13

description

No

512

"Nice Store"

14

mondayOpeningTimes

No

N/A

"09:00-17:00"

15

tuesdayOpeningTimes

No

N/A

"09:00-17:00"

16

wednesdayOpeningTimes

No

N/A

"09:00-17:00"

17

thursdayOpeningTimes

No

N/A

"09:00-17:00"

18

fridayOpeningTimes

No

N/A

"09:00-17:00"

19

saturdayOpeningTimes

No

N/A

"09:00-15:00,16:00-21:00"

20

sundayOpeningTimes

No

N/A

"09:00-12:00"

14

tags

No

N/A

["pharmacy","refrigerated" ,"potato"]


Example Row

An example of a single row in the file, representing one store location with opening hours, might be:

"01WESTMINSTER","Westminster Square","London","SE1 7UW","GBR","126 Palmerston House, Westminster Square","51.499240"","-0.113020","+44 20 7946 0234"","http://logodomain.com/nicelogo.jpg","http://logodomain.com/nicephoto1.jpg,http://logodomain.com/nicephoto2.jpg","true","Nice Store","09:00-17:00","09:00-17:00","09:00-17:00","09:00-17:00","09:00-15:00,16:00-21:00","09:00-12:00","pharmacy,refrigerated,potato"