If you have many locations to import to your account, we recommend using our bulk import feature!
The number of configured locations is defined in your Verified Reviews contract. Any additional location may incur additional fees: contact our teams to learn more.
Prerequisites
You must have access to the ✨ New Version of our platform.
If your home page displays this alert, you have a legacy version of Verified Reviews, which does not allow locations to be imported in bulk via CSV:
We strongly recommend that you name your locations using the exact name used "in real life" : storefront, official website, documents, etc. This will subsequently affect how several features work, particularly synchronization with Google reviews.
Example:
- Brand name → Miami Style
- Brand + actual location → Miami Style Marseille Prado
Be sure to avoid the following: marketing keywords, services, hours, slogans, or unofficial cities.
Tip : for multiple stores, use your brand name + the location identifier and put any additional information in the description or attributes, never in the name.
Procedure
- From the left sidebar menu, click
Administration, then Establishments
- Click the Import CSV button:
- You can then download a CSV file that is pre-filled:
- Complete the file with the following information for each row:
- Upload the file to our system again.
All your stores are now available in your list!
If a store already exists in your account: the file will overwrite the old information and automatically update the data for that same store.
Details of the columns to complete
*Required columns
| key_shop* | Store keys are unique identifiers for each location in your Avis Vérifiés account. They are used to display reviews and the average rating of a specific store on your website (for example, via the brand widget). You can find them in the Establishments section. Store keys can only be modified by our teams. |
| name_shop* | The name of your location. Please note: we strongly recommend that you name your stores using the exact name used "in real life" : storefront, official website, documents, etc. This will subsequently affect how several features work! |
| description | Add the description of your choice for the location here. |
| address* | Exact and official address of the location. |
| postal_code* | ZIP code of the location. |
| city* | City where the location is situated. |
| phone | Official phone number of the location. |
| Official email address of the location. | |
| website | URL of the location's website (it may be the same for all locations). |
| representative | Primary contact for the location. |
| siret* | SIRET number of the location. |
| shop_pagesjaunes | If you want to synchronize your reviews with Pages Jaunes: name of the location as it appears on your Pages Jaunes profile. |
| url_gmb | Full URL of the place ID of your Google Business Profile (GBP) account - Instructions available here. |
| url_fblocal | URL link to the location's Facebook account - Synchronization is only available for legacy Verified Reviews accounts. |
| url_yelp | URL link to the location's Yelp account - Synchronization is only available for legacy Verified Reviews accounts. |
| pos_id | If your review collection is configured with Shopify: enter your Shopify point of sale here. |
| region | Region associated with your location - Learn more. |