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
2. 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)
   • Consumer key: the ck_... key from step 1
   • Consumer secret: the cs_... secret from step 1
2. 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

| Permission level | What you can do in LinkyFlow | |---|---| | Read | Load products, orders, customers, coupons | | Read/Write | Load + update prices, stock, status; create/update/delete items |

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.