WooCommerce is an open-source e-commerce plugin for WordPress that allows you to create and manage an online store with features like inventory management, secure payments, and shipping integration.
Connecting WooCommerce to AgencyAnalytics allows you to pull important analytics directly from your WooCommerce store into client reports and dashboards.
API and Data Access
Data is fetched every 24 hours starting from when it is connected
24 months of historical data available
Click here to view all available WooCommerce metrics and learn what's possible!
Connect WooCommerce
To avoid a failed connection or error when integrating WooCommerce to a Client, the person connecting must have:
API with read access permissions
Wordpress 4.4+ minimum version required
WooCommerce 3.5+ minimum version required
If the above requirements are met, simply follow these steps to connect:
Open the Client where you'd like to connect WooCommerce, then click the Data tab at the top.
Click the blue Connect Data Source button in the upper right corner of the page.
Search for WooCommerce in the search bar at the top, then click the WooCommerce card.
Enter your WooCommerce website's Store URL, API Key, and API Secret (generated from your WooCommerce plugin in WordPress), then click Save.
You can now add WooCommerce widgets to dashboards and reports, or learn to configure the prebuilt WooCommerce dashboard.
WooCommerce FAQ
Which URL do I use when connecting WooCommerce?
You'll need to enter the full root domain as the Store URL, with either http:// or https:// included, depending on which your website uses.
For example, you would enter https://www.mywebsite.com/, rather than www.mywebsite.com/my-store/.
Why am I seeing a "JSON: Syntax error" when connecting WooCommerce?
This error usually means the Store URL entered in the connection wizard includes a store subdirectory path rather than the root domain. The WooCommerce authenticator only accepts the root domain.
For example, enter https://www.mywebsite.com/, not https://www.mywebsite.com/store/.
Update the Store URL to the root domain and try connecting again.
Why am I seeing a "cURL Error: Operation timed out" when connecting WooCommerce?
This error means the WordPress server hosting your WooCommerce store took too long to respond to AgencyAnalytics. It's a server configuration issue, not a problem with the connection credentials.
To resolve it, a developer or server admin will need to adjust the WordPress server's cURL timeout or performance settings. Steps to fix a cURL timeout error in WordPress can usually be found in your hosting provider's documentation.
Which order statuses does AgencyAnalytics show for WooCommerce?
AgencyAnalytics supports the seven core (default) WooCommerce order statuses in your WooCommerce widgets:
Cancelled
Completed
Failed
On Hold
Pending Payment
Processing
Refunded
These statuses display in whichever language the client's report is set to under AgencyAnalytics's localization feature.
If you've set up custom order statuses in WooCommerce, those can be displayed in your widgets too, and you can select them directly in the settings filter. Keep in mind that custom statuses always appear exactly as they're named in WooCommerce, and they can't be translated by AgencyAnalytics.
Can I view historical data?
Yes, 24 months of historical data are available.
Why isn't my data matching what I see in WooCommerce?
We generally see this when the timezone setting in WooCommerce differs from the timezone selected in your client's AgencyAnalytics settings. Depending on the hour difference, orders may be displayed on the next or previous day. To resolve this, simply double-check the time zone on your WooCommerce account, then update the client's time zone to match.
Another possible reason for mismatching data can be due to the way WooCommerce applies refunds to their data within their native platform's UI vs how this is applied within their API (and consequently the WooCommerce integration, as this is where we fetch all our WooCommerce data from.)
Within WooCommerce's native UI, refunds are applied on the day the refund was issued, and the refund amount is discounted from their gross revenue for that day. Within the WooCommerce API, on the other hand, the refund is applied on the day the purchase was made, which can in turn sometimes lead to discrepancies.
Aside from this, if you are using a "Currency Switcher" feature within WooCommerce, this will change the currency within the UI of the WooCommerce App, but it will not change the currency within the WooCommerce API. As such, the currency we display may differ from the currency shown in the WooCommerce "Currency Switcher".
💬 Need additional help?
If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄
