WooCommerce connection setup

This guide walks you through generating WooCommerce API keys and connecting your store to LinkyFlow so you can load and manage your data in Excel.

Requirements

• A self-hosted WordPress site with WooCommerce installed
• Your WordPress admin access (you need to reach WooCommerce settings)
• Your store must be served over HTTPS — the REST API blocks plain HTTP requests
• LinkyFlow Excel add-in installed (download from AppSource)

Step 1 — Generate WooCommerce API keys

1. In your WordPress admin, go to WooCommerce → Settings
2. Click the Advanced tab
3. Click REST API in the sub-menu
4. Click Add key
5. Fill in:
   • Description: LinkyFlow (or any label you recognise)
   • User: select your admin account or a dedicated API user
   • Permissions: choose Read/Write to enable both loading and updating data, or Read for read-only access
6. Click Generate API key
7. Copy the Consumer key (starts with ck_) and Consumer secret (starts with cs_) — they are shown only once

Keep your consumer key and secret safe. Anyone with these credentials can read and modify your store data.

Step 2 — Add your store connection in LinkyFlow

1. Open Excel and launch the LinkyFlow add-in from the taskpane
2. Go to Settings → Connections → Add connection
3. Select WooCommerce
4. Enter:
   • Store URL: the full URL of your store (e.g. https://myshop.com, or https://example.com/shop for a store in a sub-folder) — the store's own address, not its wp-admin page
   • Consumer key: the ck_... key from step 1
   • Consumer secret: the cs_... secret from step 1
5. Click Save — LinkyFlow will verify the credentials against your store
6. Give the connection a name (e.g. My Shop) — this is what you will use as the link parameter in queries

Step 3 — Load data into Excel

Once connected, open the LinkyFlow panel and:

1. Select a template (Sales Dashboard, Product Catalog, Customers, etc.) or build a custom query
2. Pick your WooCommerce connection as the data source
3. Choose the fields you want and apply any filters (status, date range, search)
4. Click Load — the data appears as a structured Excel table

Permissions reference

Troubleshooting

401 Unauthorized — Your consumer key or secret is wrong, or the key has been deleted. Regenerate the key in WooCommerce settings and update the connection in LinkyFlow.

403 Forbidden — The key user does not have sufficient permissions. Assign the key to a WordPress admin.

Connection failed / SSL error — Your store is not on HTTPS. Enable an SSL certificate (Let's Encrypt is free) and retry.

Empty results — Your store has no data matching the current filters. Check the status or date filters in the query panel.