This guide contains all permissions and requirements for connecting your Ecwid 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 will need your Store ID and Secret app token to connect to Ecwid.
How to retrieve your Store ID
Go to the admin dashboard of your Ecwid store.
The Store ID is visible in the footer section of every page.
It’s also included in the URL of the web page, for example, “https://my.ecwid.com/store/1234567“ where 1234567 is the Store ID.
How to create your Secret app token
Go to the app dashboard of your Ecwid store.
Click Create, next to “Add new app”.
On the app detail page, click Show secret token.
Copy the secret token to a secure place for use later.
Query types
If prompted, you need to select a query type to pull data.
Orders: Fetch data of all the orders made in a certain time range.
Connection instructions
When connecting to Ecwid, you need to enter your Store ID and Secret app token.
Select the Ecwid data source on the Supermetrics Hub or in the data destination.
Insert your Store ID and Secret app token.
If prompted, choose to make this connection shared or private.
Click Start.
In your data destination, choose your desired store(s), date range metrics, and dimensions. For Query options settings, select “Fetch orders by created or updated date.”
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Ecwid from these destinations:
Looker Studio: How to connect data sources to Looker Studio
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