How do I import locations in bulk using a CSV file?

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

  1. From the left sidebar menu, click Administration, then Establishments
  2. Click the Import CSV button:
  3. You can then download a CSV file that is pre-filled:
  4. Complete the file with the following information for each row:
  5. 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.
email 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.
Was this article helpful?
6 out of 6 found this helpful