Storepoint

Storepoint is a store locator for websites, used to show customers where to find your stores, stockists and retail partners. With Weld you can sync your Storepoint locations into your data warehouse and join them with sales, inventory and marketing data, for example to report on performance by store or region.

Features

Data Schema

Setup Guide - ELT

Step 1 - Get your Storepoint API key

1. Sign in to Storepoint and open the Developer Portal.
2. Generate a secret API key for Weld. It starts with sk_.
3. Copy the key.

Step 2 - Create the connection

1. In the Weld app, navigate to Connections and click + New Connection.
2. Search for Storepoint and select it.
3. Enter the destination schema name of your choice. This name is used to identify the connection in future syncs.
4. Paste your API Key.
5. Click Connect to validate the key and establish the connection.

Step 3 - Data To Sync

Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.

• location, your store locator locations, which brings along:
  • location_tag, one row per tag on a location
  • location_custom_field, one row per custom field value on a location, keyed by custom_field_id
• custom_field, the custom field definitions set up in your Storepoint account. Join its id to custom_field_id on location_custom_field to get each field's name.

Step 4 - Configure sync

1. Select how often you would like the data to sync.
2. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Storepoint account.