Start free
Read & reportControlled changes

See your Magento numbers in Amazon Redshift.

Understand ecommerce orders, product catalog inventory and customer accounts with catalog adjustments from Datapipe.

  • Orders created in the report dates with totals, refunds and status
  • Your product catalog with prices and status
  • Registered customers and groups beside your orders
MagentoAmazon RedshiftAmazon Redshift

Start free Connect Magento

Updated November 2026

Magento reportSample data
Order numberOrder dateStatus
860Oct 27Enabled
410Oct 28Pending
155Oct 29Refunded
Refreshes on your schedule in Amazon Redshift

Who uses Datapipe with Magento

Store owners

See yesterday's orders, sales and refunds every morning.

Merchandisers

Catch low stock and messy product data before customers do.

Agencies

Report store results next to ad spend for each client.

What you can do with Magento

Read and report

Read products, order histories and customer accounts through Magento's REST API with your integration token.

  • Orders by creation date
  • Store products
  • Store customers

Explore metrics and dimensions

Controlled changes

  • Update product name or price
  • Add comment to an order

Changes stay off until you allow them. Allowed changes apply to Magento right away, and history keeps the values before and after.

See what you can change

Full read details

Product prices retain store currency and order statuses stay explicit.

Examples for your team

Read & report

Review ecommerce orders and fulfillment status

Refresh order creation dates, billing and shipping totals, and customer details.

  1. Scheduled refresh
  2. Latest Magento data
  3. Updated report

Limit: Order statuses retain native Magento lifecycle codes without artificial aggregation.

Controlled change

Update a product name or price before a seasonal campaign

A teammate sets an updated price or cleaner product title for an existing SKU, and Magento publishes the change.

  1. Allowed
  2. Applied
  3. Recorded

Limit: Price changes can be set to need approval first.

Fix things in Magento without opening it

Spot it, fix it

See the problem in your report, then make the fix in Datapipe instead of opening Magento, finding the record and retyping it.

More people can help

Teammates and AI tools you allow can make changes without getting edit access to Magento.

You decide what can change

Changes stay off until you allow them. Every change is recorded with who made it and the values before and after.

Jobs you can stop doing by hand in Magento

Update product name or price

  • Update catalog promotional price for seasonal campaign launch

    TodayLog into Magento Admin Panel, go to Catalog > Products, search SKU, click edit, enter new special price, and save product.

    With DatapipeSpot margin opportunities or flash sale items in your inventory report and set the new price. Price changes can be set to need approval first.

  • Refine product display title for search and category listings

    TodayOpen product in Magento backend, rewrite title field, and clear Magento cache.

    With DatapipeIdentify low-CTR catalog items in your sales report and update the title copy from Datapipe.

Exactly what this can change

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.

Supported fields: Product name, Price.

Add comment to an order

  • Add fulfillment tracking update to high-value customer order

    TodayLog into Magento Admin, navigate to Sales > Orders, find order ID, scroll to Comments History, write comment, and submit.

    With DatapipeIdentify shipping exceptions in your daily fulfillment report and add the carrier resolution note to the order.

  • Document fraud verification sign-off on flagged transaction

    TodayOpen order in Magento Sales dashboard, add manual audit verification note to history log.

    With DatapipeAdd the verified payment risk review to the order history from Datapipe. The Changes history records who added it and when.

Exactly what this can change

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.

Supported fields: Order comment, Customer notification.

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

You control who can change what

  1. A change is allowed for this data source
  2. A teammate or AI tool makes it
  3. It applies right away, or waits for approval if you set that
  4. Recorded with the values before and after

Source changes are managed on the Changes page in Datapipe. Approval is optional: set it for risky changes, for every change, or for one person. AI tools such as ChatGPT can never widen their own access. Who can turn this on?

Provider rules and limits

Provider permissions still apply, and automations in Magento may react to changes.

Only fields supported by an allowed action can be changed; for some actions the owner, an admin or a project manager also picks the individual writable fields.

Before you connect

What you need

An API key or token from your Magento account.

Read and write

Read access for reports. The 2 change actions need edit access in Magento and stay off until the owner, an admin or a project manager allows them.

Limits and exclusions

Anything your connected account cannot see in Magento.

Full details and limits

Current product catalog inventory, customer profiles, and orders with order line items for your connected Magento store.

Reporting reads catalog and orders. Optional product name, price or order comment updates are off until allowed for this data source, and every change is recorded in history. Order totals and payment transactions cannot be altered.

Reports you can build

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

What each dataset reports
  • Orders by creation date

    Orders created during the selected UTC dates. Amounts are in each order's 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.

Metrics and dimensions

28 report fields across 3 datasets.

Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.

Send Magento data anywhere

Ask AI about your data

Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.

AI tools can also make allowed Magento changes. They can never widen their own access.

Which Magento orders this month were refunded, and what was our total order value?

182 orders totalled $24,310; 6 were refunded for $642, mostly in the last week.

Better than exporting by hand

Start from a goal

How it works

  1. Create a project and choose Magento in Data sources.

  2. Pick where it goes. This one sends the numbers to Amazon Redshift.

  3. Pick where it goes. Choose orders, products or customers and a destination.

Sample report

Magento reportSample data
Order numberOrder dateStatusGrand totalTotal refundedSKUProduct namePrice
860Oct 27Enabled1,2401,240COAT-BLK-MWool coat$180.00
410Oct 28Pending640640640Canvas tote$125.50
155Oct 29Refunded210210210Gift card$42.00

Sample numbers, so you can see the shape. Your report uses your accounts.

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

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.

No. Name a project, add a data source, then choose a report and destination.

OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.

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.

No. Teammates make allowed changes in Datapipe, and Datapipe applies them through the connected Magento account. Nobody else gets a Magento login from this.

Yes, if that change is allowed for them. They work through Datapipe the same way a teammate does, within the same allowed changes and fields, and every change is recorded in the Changes history. AI tools can switch changes off, but they can never widen their own access. Asking for more waits for a person.

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.

Datapipe sends each change once and records the result in the Changes history. If it cannot confirm that Magento received it, the request is marked Uncertain and is never retried automatically, so you can check Magento first.

Yes. Datapipe reads the reports on this page and can make 2 kinds of change: update product name or price; add comment to an order. Each one stays off until the owner, an admin or a project manager allows it for this data source. Allowed changes apply right away and are recorded in the Changes history. Provider permissions still apply.

This page lists 28 report fields across 3 datasets. You pick the columns when you build the report.

Current product catalog inventory, customer profiles, and orders with order line items for your connected Magento store. Account permissions and the records available from the provider determine which rows can be read.

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.

Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.

Try Magento with sample data first

Build the report first, then add Magento when you are ready.

Start free Add data source