WooCommerce Connector User Guide
Integrate your WooCommerce store with Looker Studio using Data Bloo’s free connector — no plugin installation needed. This guide walks you through the setup in minutes.
Prerequisites
Ensure you have the following ready:
- A Data Bloo account (free to create)
- A Google account with access to Looker Studio
- A WooCommerce store with REST API enabled
- Admin access to your store (to generate API keys)
- Pop-up blockers disabled (for Google authentication)
How to Connect
Step 1: Sign in to Data Bloo
- Go to hub.databloo.com
- Click Sign in and log in with Google or your email/password
Step 2: Add WooCommerce as a Data Source
- In the left menu, click Data Sources
- Select the WooCommerce tile under “Add new data source”
Step 3: Enter WooCommerce API Credentials
On the “Connect WooCommerce Store” screen (as shown in your image):
- Store URL: Enter the full URL of your WooCommerce store (e.g.,
https://yourstore.com) - Consumer Key: Paste the key generated in WooCommerce
- Consumer Secret: Paste the matching secret
💡 How to generate your API credentials:
- Log in to your WooCommerce admin panel
- Navigate to WooCommerce → Settings → Advanced → REST API
- Click Add Key
- Give it a name, set Permissions to Read, and click Generate API Key
- Copy the Consumer Key and Consumer Secret
Click Connect Store to complete the connection.
Step 4: Review Connection
- Your store will now appear in the list under WooCommerce data source
- You may add more stores or remove existing ones as needed
- Click Looker Studio to move on to reporting
Step 5: Authorize the Connector in Looker Studio
- Looker Studio will prompt you to authorize both the connector and access to Google services
- Click “Edit and share” in the top-right corner
- In the modal window, click “Acknowledge and save”
- Wait a few seconds for the dashboard to fully generate — do not interact until redirected to edit mode
Step 6: Explore the WooCommerce Dashboard
Once connected, your Looker Studio dashboard will include metrics such as:
- Revenue Summary: Total Sales, Net Revenue, Refunds
- Order Insights: Order Counts, Status Breakdown, Average Order Value
- Product Performance: Bestsellers by units/revenue, Category summaries
- Customer Data: New vs. Returning Customers, Purchase frequency
- Checkout & Fulfillment: Payment Methods, Shipping Methods, Coupons Used
- Trend Charts: Daily/weekly/monthly snapshots
Step 7 (Optional): Switch Stores or Update Credentials
To manage multiple stores or refresh keys:
- Open your Looker Studio report
- Click Resource > Manage added data sources
- Click Edit next to the WooCommerce source
- Select Edit connection
- Update your Store URL, Consumer Key, or Secret
- Click Reconnect, then Apply
Your dashboard will now reflect the new configuration.
Troubleshooting
| Issue | Solution |
|---|---|
| Connection failed | Ensure the store URL is correct (HTTPS recommended) and that API keys are valid with “Read” access |
| No data in dashboard | Confirm that the store has recent orders/products and the API is enabled |
| OAuth window didn’t appear | Disable pop-up blockers and clear cookies. Ensure one Google session is active |
| Bad Request (400) | Make sure the same Google account is used across Data Bloo and Looker Studio |
| Multiple stores | Add each store separately using unique API keys; use filters in Looker Studio to separate or combine reports |
Notes
- No Plugin Needed: The setup uses only WooCommerce’s built-in REST API
- Data Security: Data is accessed via read-only API and is not stored by Data Bloo
- Free Forever: No user limits or quotas
- Multi-Store Friendly: Aggregate or compare data from several WooCommerce stores in one dashboard
Did this answer your question?