Skip to main content

Add longitude and latitude with the Geolocation service

Enrich your data feed with latitude and longitude data with the Geolocation data service in Productsup.

Introduction

If you have location information in your product feed, you can use the Geolocation data service to enhance it with latitude and longitude data.

Note

The Geolocation data service is available for the import and intermediate stages.

The Geolocation data service scans your address column and creates an additional data source in your Productsup site to add four (4) new columns containing latitude and longitude data:

  1. ___geolocation_title is a duplicate of your address column.

  2. ___geolocation_latitude contains your latitude data.

  3. ___geolocation_longitude contains your longitude data.

  4. ___geolocation_next_try_date determines when the platform should send the next request to the Geolocation API in case an address returned an error in the previous run.

Prerequisites

To use the Geolocation data service, you need:

  1. An API Key for the Google Geolocation API.

  2. Location data in the correct format. Your addresses must use the same format as the national postal service of the country in question. Separate your street address elements with spaces and, if applicable, avoid providing such info as business names and floor numbers. For example, here is a German address using the German postal service format delimited by spaces: Alex-Wedding-Straße 5 10178 Berlin.

    See Geocoding request and response for more information.

  3. A product identifier. See Set a product identifier for more information.

Add the Geolocation data service

  1. Go to Data Services from your site's main menu and select ADD SERVICE.

  2. Search for Geolocation, select Add, and give it a desired name and column prefix.

    By default, ___geolocation is the column prefix.

    geolocation.png

  3. Choose the stage where you have your location data in Service Data Level and select Add.

  4. Add your authentication data for the Google Geolocation API in API Key.

  5. Choose the column in your feed that contains your address data in Address column.

    Note

    If you chose Import in Step 3, the Address column drop-down list displays the columns of your import stage. If you chose Intermediate in that field, the drop-down list contains your intermediate-stage columns.

  6. If you want the platform to run the Geolocation data service every time there is a refresh in Data View, select the checkmark icon (✔) in Trigger during a refresh of the Data View.

  7. Select Save.

  8. For the platform to process a new data service, select Run in the top-right corner of your site's view.

    Note

    If you can't see your new geolocation data in Data View, ensure the platform hasn't hidden it:

    1. Go to Data View from your site's main menu and choose the relevant stage or export in the drop-down list on your left.

    2. Select the menu icon on the right and then select the eye icon.

    3. Find the attributes in the list that use the custom prefix ___geolocation and select the eye icon next to each attribute you want Data View to display.

    4. Close the pop-up menu.

    The naming of the attributes created by the Geolocation data service depends on the column prefix you choose in Step 2. The attribute names the data service generates always start with three underscores (___), which means the platform doesn't send such attributes to your export channels.

Edit the Geolocation data service

  1. Go to Data Services from your site's main menu.

  2. Search for your data service.

  3. Select the cogwheel icon (⚙) next to the desired data service to edit settings.

  4. Select Save.

Delete the Geolocation data service

  1. Go to Data Services from your site's main menu.

  2. Select the cogwheel icon (⚙) next to the desired data service.

  3. In the Danger Area panel, select Remove this service.

  4. Select Yes.

In this section: