Orders
Read each order’s number, date, status, state, grand total, subtotal, amount paid and amount refunded.
Magento connector · Store reports & updates
Bring Magento or Adobe Commerce orders, products and customers into your reports and AI assistants, with totals, payments and refunds. Then change product names and prices or add order comments from Datapipe, with access your team controls.
Start free See what you can change
Updated November 2026
| Order | Status | Grand total |
|---|---|---|
| 000001042 | processing | 184.50 |
| 000001043 | complete | 62.00 |
| 000001044 | closed | 129.90 |
One Magento or Adobe Commerce store is the data source. Orders use their creation date; products and customers are current.
Read each order’s number, date, status, state, grand total, subtotal, amount paid and amount refunded.
List products with SKU, name, price, status and type.
See customer accounts with email, name, customer group and dates.
Works with Magento Open Source and Adobe Commerce stores.
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
Orders created during the selected UTC dates. Amounts keep the store currency; status, state and customer names are reported.
Store product catalog, not filtered by report dates. Standard SKUs, product names, price and status flags.
Registered store customers, not filtered by report dates. Names, customer group ID and creation timestamps.
Change a product’s name or price by its SKU. Stock, categories and images are unchanged.
Add a comment to an order’s history and keep its status. Choose whether the customer gets it by email.
Allow the changes your team needs for this data source. Teammates and AI assistants use that access; they cannot grant themselves more.
Allowed changes apply right away unless you require approval. Set approval for risky changes, every change or a specific person. Changes history records who made each update and its result.
Changes the name or price of one product, found by its SKU, at the store's default (all store views) level. A name or price set for a single store view in Magento stays as it is. Stock, categories and images are unchanged.
Adds a comment to one order's history and keeps its current status. Choosing to notify the customer emails them the comment. Nothing is refunded, invoiced or shipped.
| Field | Before | After |
|---|---|---|
| Price | $110.00 | $80.00 |
27 report fields across 3 datasets.
Search the available fields. Hover or tap a field to see what it means.
No fields match. Try another search or choose All.
Use Datapipe’s MCP access as your Magento AI integration. Ask about orders and refunds, then make an allowed change and check it in Changes history.
Example
How much did we sell last week after refunds, and which orders are still processing?
Total last week’s orders minus refunds, then list orders still processing. Add an internal comment to one, if that change is allowed for you.
Your store’s HTTPS address and an access token from an integration in your Magento admin.
Price and name changes apply at the default level; values set for one store view stay. Notified order comments email the customer.
Create your free account, then choose Magento in Data sources.
Enter your store address and paste the access token from System, Extensions, Integrations in your admin.
Choose a report and destination, or allow product and order changes. Set approvals for price changes or anything you want reviewed first.
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Datapipe reads orders by creation date with status, totals, payments and refunds, plus your current products and customer accounts.
Yes. Connect any Magento Open Source or Adobe Commerce store with an integration access token.
Yes, when the change is allowed for you in Datapipe. You can change product names and prices and add order comments. You can require approval before a change applies.
No. The order keeps its status, and nothing is refunded, invoiced or shipped. The customer is only emailed if you choose to notify them.
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
The workspace owner, workspace admins and project managers. Changes start off. They choose which changes are allowed for each data source and who can make them: project operators and managers, selected teammates, and the AI tools those people connect. They can change this at any time.
Yes, if you want. For each data source, approval can cover risky changes only (deleting, sending, publishing, refunds and price changes) or every change. You can also switch it on for one person, such as an intern. Those changes wait on the Changes page until the owner, an admin or a project manager approves them. Nobody but the owner approves their own change.
One for each Magento account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Start free, add your Magento store and choose how your team reports on and updates it.