Docs: System guides
Read WooCommerce into Maplith
On this page
Best path
Recommended: export files. No WooCommerce connector in Claude or ChatGPT is confirmed, and WooCommerce's own MCP integration is a developer preview that is off by default and also has write tools. The built-in product export and the Analytics report downloads are the safest start; a REST API key with Read permission covers what the exports leave out.
Try the paths in this order:
- Your agent fetches it, with the access you already gave it. No named connector is confirmed: check the tools your agent already has. The agent checks whether it already has a tool that can read this WooCommerce store, read-only, and if so fetches the order, product and customer fields for a few recent months.
- Maplith reads an MCP server you already run. WooCommerce runs WooCommerce MCP integration (WordPress MCP adapter). Its address comes from WooCommerce’s own setup instructions. Documentation: developer.woocommerce.com. A developer turns the server on and creates an Application Password for a WordPress user under Users > Profile, choosing a user with as few rights as possible, because each tool runs with that user's permissions. The user name and that password go into the client you connect to the server, never into a chat. It is a developer preview that must be switched on by a developer, it runs on the store's own WordPress site, and it includes tools that create, update and delete products and change order status, so only the query tools should be used. WooCommerce says not to use a REST API key or the account password for it. Maplith cannot read this server itself, because it offers tools or a personal sign-in to an agent. Connect it to your agent instead, as the first path.
- Export files, the fallback that always works. See the export steps below.
Datasets that make a good map
| Dataset | One row is | Key columns | Joins to |
|---|---|---|---|
| Orders | One order with its status, totals, payment method and billing details. | order id, order number, customer id, billing email (Maplith tries to mask it), payment method, transaction id, status, created date | Stripe or PayPal payments by transaction id; accounting invoices and shipping labels by order number. |
| Order lines | One product line on an order with quantity and line total. | order id, product id, variation id, SKU, quantity | Products by product id or SKU; warehouse and logistics stock by SKU. |
| Products and variations | One product or variation with its SKU, price, stock and categories. | product id, SKU, parent (ID or SKU), type, stock | Order lines by product id or SKU; warehouse stock and ad product feeds by SKU. |
| Customers | One registered customer or guest buyer with order count and total spend. | customer id, customer email (Maplith tries to mask it), order count, total spend, registration date | Email marketing and CRM contacts by customer email; guest orders link only by billing email. |
| Refunds | One refund on an order with amount and reason. | refund id, order id, amount, created date | Payment provider refunds by transaction id of the order; credit notes in accounting by order number. |
Columns are named, never their values. Maplith tries to mask personal data such as email addresses, but that is best effort: you decide what goes in.
The access to give
Who usually has the rights: The site owner or a WordPress administrator.
Choose the narrowest access that covers the data:
- Permissions: Read
Where to click:
- In WordPress, go to WooCommerce > Settings > Advanced > REST API
- Click Create an API key (or Add key)
- Type a description and choose the user the key belongs to
- Under Permissions, choose Read
- Click Generate API Key and copy the Consumer Key and Consumer Secret, which are shown only once
A key or token made here stays in the tool that reads the system, never in a chat. Maplith asks for one only under Data sources › Systems in the app.
Export steps
Format: CSV Date range: The last three months of orders; all products
- Go to Products > All Products and click Export
- Keep Export all columns, then click Generate CSV to download the products file
- Go to WooCommerce > Analytics > Orders and set the date range to the last three months
- Click Download at the top right of the table; a large report is emailed to you as a download link
- If your version shows a Download link on WooCommerce > Customers, download that table the same way
How much data
About 100–2,000 orders a month (an estimate). Estimate for a small company, not a measured figure: a small WordPress shop takes a handful to several dozen orders a day.
An agent that reads rows through a chat reads every one of them, about one token per four characters. Above a few thousand rows a dataset, or for a daily refresh, an MCP server or an export is the better path.
Always
- Read-only, and never a credential sent to Maplith through a chat.
- The same recent period, a few months, from every system.
- You decide what goes in.
Sources
Written from public documentation, last checked 2026-10-08: