The first line of your input file must contain the names of your columns. Please use the template of the import file or the export file of your locations as explained in Importing your locations. In that way, it will be sure that the colums in your file will be recognized (the mapping of the columns is not available yet in the V2 Beta version of the import).
The file must be a csv, xls or xlsx file.
If you have a Store Locator which is available in several languages, you can translate your data in the import by specifying the language in the following format : "Column name - language" (E.g : Location name -en) for each data you can translate. If some data are not translated, they will be published in the default language.
Column |
Explanation |
Content |
BridgeID |
Unique identifier of the location, generated by BRIDGE. It is used by BRIDGE to identify each location, to update it with import. |
If it's a new location : empty cell (this column is missing in the import template recommended to create new locations) If it's an update location : Bridge ID |
Location name (- one column for each activated language) |
Name of the location. If you have a Store Locator, your location name shall include the name of your brand and the city of your location. If several languages are available for the Store Locator, each location has a name dedicated for each language in a different column. Only the name in the default language is mandatory, the other names are optional. |
Format : text Example : Merevo Annecy |
Status |
Activation status of the location. If your import data for a location is not complete, import it with DRAFT status, and the data will be complete, set the status to ACTIVE to publish the location. |
Format : a value among ACTIVE, INACTIVE or DRAFT
|
Type |
Type of the location. The available types are defined when BRIDGE is initialized. |
Format : text Example : Official reseller |
Registration number |
Identification number of a location (example : SIRET) |
Format : text |
Custom ID |
Internal identifier of your location. It must be unique. It can be the identifier of your location in your ERP system for instance. |
Example : store_01 |
EPJ Contact |
Identifier of your location for Pages Jaunes (if your location have a page for it). This field can only be updated by a Super administrator (Client support). Otherwise, it will be just ignored. |
Format : 8 numbers
|
Description (- one column for each activated language) |
Description of your location. If you have a Store Locator, this description will be displayed on it. If several languages are available for the Store Locator, each location has a description dedicated for each language in a different column. Only the description in the default language is mandatory, the other descriptions are optional. |
Format : text |
Address 1 (- one column for each activated language) |
Number and name of the street. If several languages are available for a Store Locator, each location has an address dedicated for each language in a different column. Only the address in the default language is mandatory, the other addresses are optional. |
Format : text Example : 10 rue de la paix |
Address 2 (- one column for each activated language) |
Further information for the address (e.g : floor number) This field is optional. |
Format : text Example : ZI les Landiers |
Zip Code |
Zip code of your location |
Format : text Example : 74000 |
City (- one column for each activated language) |
City of your location If several languages are available for a Store Locator, each location has a city dedicated for each language in a different column. Only the address in the default city is mandatory, the other cities are optional. |
Format : text Example : Annecy |
Country code |
Country code must respect the 'ISO 3166-1 alpha 2' format. All available country codes can be found here : https://fr.wikipedia.org/wiki/ISO_3166-1 |
Format : code ISO 3166-1 alpha 2 Example : FR |
Phone |
Phone number of your location Note : it is possible to put some blanks in your phone number. |
Format : texte Example : 04 50 51 52 53 |
Fax |
Fax number of your location Note : it is possible to put some blanks in your fax number. |
Format : texte Example : 04 50 51 52 53 |
|
Contact email for your location. |
Format : email Example : contact@merevo.fr |
URL (- one column for each activated language) |
URL of the website of your location This cannot be updated if you have a Store Locator, as it is generated automatically. |
Format : website URL Example : https://example.com |
Access (- one column for each activated language) |
Text for your customers to explain how they can go to your location. If you have a Store Locator, it is available for each language. |
Format : text Example : Métro 12 arrêt Vaugirard |
Parking (- one column for each activated language) |
Text for your customers to explain the different available parkings next to your location. If you have a Store Locator, it is available for each language. |
Format : text Example : Parking Nation |
Monday Tuesday Wednesday Thursday Friday Saturday Sunday |
Opening hours of your location Note : if there are two time slots of opening in a day, use a comma or a semicolon to separate them |
Standard hours 09:00-17:00 Opening hours with two time slots in a day 11:30-14:00;17:00-22:00 Closure all day Empty cell Closure at midnight 09:00-00:00 24/24 opening 00:00-00:00 Opening hours after midnight (include these hours in the day the opening hours begin) 18:00-02:00 |
Exceptional Hours |
Exceptional hours of your location |
Opening format : AAAA-MM-JJ: HH:MM-HH:MM, AAAA-MM-JJ: HH:MM-HH:MM |
Latitude |
Latitude of your location. The decimal separator is a dot "." If the latitude and the longitude are missing, they will be automatically computed with Google algorithm, based on the address, the city, the zip code and the country of your location. |
Format : latitude Example : 8.23456789 |
Longitude |
Latitude of your location. The decimal separator is a dot "." If the latitude and the longitude are missing, they will be automatically computed with Google algorithm, based on the address, the city, the zip code and the country of your location. |
Format : longitude Example : 42.9876543 |
Geocoding status value |
|
To be ignored (will be removed of the template import) |
Geocoding status code |
|
To be ignored (will be removed of the template import) |
More columns can be available :
- according to the configuration of BRIDGE.
- Ex.g : the available products and services (see Products and services). The file must contain one column for each product and one column for each service. If the cell is checked (x or X), the product or service is available.
- according to the custom data.
- If the custom data is a boolean value, the cell is checked for True.
- If the custom data is a radio button type, each option has a dedicated column.
Comments
0 comments
Please sign in to leave a comment.