The location import file allows you to import locations directly from BRIDGE backoffice.
Before importing locations
- If you import locations for the first time, we strongly suggest to download the import template available in BRIDGE
- If you import locations to update your existing location database, we strongly suggest to start from your locations export file.
Import file format
The first lien of your file must contain headers for your columns. We suggest to use the columns names from the location import template.
The import file can be a csv, xls or xlsx file.
| Column name | Column description | Expected content |
| BridgeID |
Unique identifier for the location, generated by BRIDGE. It is used by BRIDGE to individually identify each location during a database update. |
Location creation : empty cell Location update : BridgeID identifier |
| Custom ID |
Unique internal identifier for your location. Used to easily query a location using our API. |
Example : store_01 |
| Location name |
The location name must include your brand name, as well as the location city. |
Format : text, unique. Example : Merevo London |
| Address 1 | Number and name of the street |
Format : text Example : 10 Victoria Street |
| Address 2 | Additional address details (floor, building...). |
Format : text Example : Freedom Tower, 3rd floor |
| Zip Code | Location zip code |
Format : text Example : 74000 |
| City | Location city |
Format : text Example : London |
| Country code |
Country code for the location, respecting the 3166-1 alpha 2 ISO code The full supported country code list is available here : https://en.wikipedia.org/wiki/ISO_3166-1 |
Format : 3166-1 alpha 2 ISO code Example : FR |
| Latitude |
Latitude of the location. Decimals must be separated by a dot "." If the imported points of sale do not have latitude/longitude, they are automatically geolocated by Google's algorithm. |
Format : latitude Example : 8.23456789 |
| Longitude |
Latitude of the location. Decimals must be separated by a dot "." If the imported points of sale do not have latitude/longitude, they are automatically geolocated by Google's algorithm. |
Format : longitude Example : 42.9876543 |
| Type |
Location type. Location types are defined during the initial BRIDGE configuration. |
Format : text Example : Boutique |
| Status |
Defines if the location is currently active. Active locations will be taken into account within BRIDGE modules : store locator, online listing... |
Format : boolean Example : true or false |
| Phone |
Phone number of the location Tips: it is possible to have spaces in the phone number |
Format : text Example : 04 50 51 52 53 |
| Fax |
Fax number of the location Tips: it is possible to have spaces in the fax number |
Format : text Example : 04 50 51 52 53 |
|
Email contact address for the location. This email is only used for the widget. |
Format : email Example : contact@merevo.fr |
|
| Website |
Webpage of the location. Store locator or website users can be redirected to this web page if no local page exists for this location. |
Format : url Example : https://merevo.com |
|
Monday Tuesday Wednesday Thursday Friday Saturday Sunday |
Opening hours for the location Tips: for opening hours with two sets of hours in one day, it is possible to use either a semi-colon or a comma as a separator |
Standard hours 09:00-17:00 Open for two sets of hours in one day 11:30-14:00;17:00-22:00 Closed all day empty cell Open 24 hours 18:00-02:00 |
|
Exceptional Hours |
Exceptional Hours |
Exceptional closure 2019-05-01: x 2019-05-01/2019-05-06: x Exceptional opening 2019-05-08: 08:30-19:00 2019-05-08: 08:30-12:30;14:00-17:00 2019-05-08/2019-06-01: 08:30-19:00 With information message 2019-05-08: x: [exceptional closure of your store] 2019-05-08/2019-06-01: 08:30-12:30;14:00-17:00: fr=[ouverture exceptionnelle de votre magasin];en=[exceptional store opening] Exceptional schedules are separated by one comma and space. 2019-05-01: x, 2019-05-08: 08:30-19:00 |
|
Description |
Location text description. It will be displayed on the store locator local page. |
Format : text |
|
Access |
Short explanation about how to get to your location. |
Format : text Example : Subway line 12, Nation Station. |
|
Parking |
Short explanation about how to park around your location. |
Format : text Example : Nation Parking lot |
|
Registration number |
Administrative identification number for your location. |
Format : text |
|
Products Services |
Products and services available at the location. The file must contain one column per product or service. |
Product available : X Product not available : empty cell |
|
Labels |
Applies a label to the location. The file must contain one column per product or service. |
Label applied to the location : X Label not applied to the location : empty cell |
Comments
0 comments
Article is closed for comments.