Start free

Magento connector · Store reports & updates

Read & reportRead & write

See your Magento orders and catalog in one place.

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.

  • Track orders, payments and refunds by day
  • Review the catalog by SKU, price and status
  • Update prices and comment on orders from ChatGPT or Claude
MagentoSheetsSheetsData StudioData StudioChatGPTChatGPTClaudeClaude

Start free See what you can change

Updated November 2026

Magento reportSample data
OrderStatusGrand total
000001042processing184.50
000001043complete62.00
000001044closed129.90
Refreshes on your schedule in Google Sheets

Magento reporting for orders, products and customers

One Magento or Adobe Commerce store is the data source. Orders use their creation date; products and customers are current.

Orders

Read each order’s number, date, status, state, grand total, subtotal, amount paid and amount refunded.

Products

List products with SKU, name, price, status and type.

Customers

See customer accounts with email, name, customer group and dates.

Adobe Commerce

Works with Magento Open Source and Adobe Commerce stores.

Report datasets and details

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Orders by creation date
  • Store products
  • Store customers
What each dataset reports
  • Orders by creation date

    Orders created during the selected UTC dates. Amounts keep the store currency; status, state and customer names are reported.

  • Store products

    Store product catalog, not filtered by report dates. Standard SKUs, product names, price and status flags.

  • Store customers

    Registered store customers, not filtered by report dates. Names, customer group ID and creation timestamps.

Go from a store report to a Magento update

Update products

Change a product’s name or price by its SKU. Stock, categories and images are unchanged.

Comment on orders

Add a comment to an order’s history and keep its status. Choose whether the customer gets it by email.

You choose who can change what

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.

See every supported change
  • Update product name or price
    What this changes

    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.

  • Add comment to an order
    What this changes

    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.

Recorded changeExample

MagentoUpdate product name or priceProduct SKU · PRD-WTR-8802 · made by Dana Vance

FieldBeforeAfter
Price$110.00$80.00

Applied to MagentoRecorded in Changes history

Metrics and dimensions

27 report fields across 3 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send Magento data anywhere

Connect Magento to ChatGPT or Claude for store questions and updates

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.

Start with Magento

What you need

Your store’s HTTPS address and an access token from an integration in your Magento admin.

What to know

Price and name changes apply at the default level; values set for one store view stay. Notified order comments email the customer.

How it works

  1. Create your free account, then choose Magento in Data sources.

  2. Enter your store address and paste the access token from System, Extensions, Integrations in your admin.

  3. Choose a report and destination, or allow product and order changes. Set approvals for price changes or anything you want reviewed first.

Works well with Magento

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.

Questions

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.

Turn your store review into the next update.

Start free, add your Magento store and choose how your team reports on and updates it.

Start free See setup requirements