This guide contains all permissions and requirements for connecting your Squarespace Commerce data to Supermetrics.
You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.
After you connect to the data source on the Hub, you can use the data source connection in all available destinations.
Required permissions
You need an API key in order to connect to Squarespace Commerce.
Follow the steps below to generate an API key:
- Log in to your Squarespace site.
- In the left side navigation, click Settings.
- Select Developer Tools.
- Click Developer API Keys.
- Click the GENERATE KEY button.
- In the dialog, add a key name under "KEY NAME", and enable “Read only” permission on the following: Products, Orders, Profiles
- Click on GENERATE KEY in the top right of the dialog.
- Record the generated key in a safe and secure place.
For security reasons, this is the only time the API key is visible. API keys will never expire as long as the merchant site remains active.
More information on how to authenticate Squarespace Commerce can be found here.
Query types
If prompted, you need to select a query type to pull data.
- Orders: Fetch detailed insights about your shop orders.
Connection instructions
When connecting to Squarespace Commerce, you need to provide your API credentials when prompted.
- Select the Squarespace Commerce data source on the Supermetrics Hub or in the data destination.
- Insert API key.
- If prompted, choose to make this connection shared or private.
- Click Start.
- In your data destination, select if you want to fetch data based on created or modified date.
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Squarespace Commerce from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer
