This guide contains all permissions and requirements for connecting your PrestaShop 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 a Webservice key and your Webservice URL in order to connect to PrestaShop.
You first need to enable the Webservice API from your PrestaShop back office.
- Log in to the back office of your shop.
- Click Settings from the left-hand side navigation bar.
- Expand the Advanced Parameters menu and click Webservice.
- Scroll down to Configuration.
- Set Enable PrestaShop Webservice to Yes.
- In the PrestaShop backoffice, navigate to Settings → Advanced Parameters → Webservice.
- Click the Add new webservice key button.
- Click Generate to create a new random API key.
- Enter a Key description to help you remember the purpose, for example you can set the description to Supermetrics.
- Set Enable webservice key to Yes.
- For permissions, enable the View (GET)permission for the following resources:
- currencies
- customers
- orders
- order_states
- shops
- Multistore mode only: For Shop association, please select which of your stores your Supermetrics connection should have access to.
- Click Save.
- Record the generated key in a safe and secure place.
- For additional information, see Prestashop's documentation here.
To obtain your webservice URL, navigate to the front page of your Prestashop by clicking View my store in the upper right corner of the Prestashop back office.
If Prestashop is installed at the root of your server (the most common case), the webservice URL is the part of the URL before the first trailing slash /, typically it looks like this:
https://example.com
In case your Prestashop is installed in a subfolder of your server, the URL looks like this: https://example.com/prestashop
In both cases, make sure your webservice URL does not have a trailing slash / at the end.
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 PrestaShop, you need to enter your webservice URL and webservice key when prompted.
- Select the PrestaShop data source on the Supermetrics Hub or in the data destination.
- Insert the webservice URL, webservice key, and give a name for your connection.
- If prompted, choose to make this connection shared or private.
- Click Start.
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to PrestaShop 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