Adobe Commerce (Magento)

Adobe Commerce (formerly Magento) is a leading ecommerce platform for building and managing online stores. It powers everything from product catalogs and customer accounts to orders, shipments, and promotions — making it a rich source of operational and transactional data.

Connecting Adobe Commerce to Coupler.io lets you pull that data into your preferred destination automatically, without writing code or maintaining custom scripts.

Why connect Adobe Commerce to Coupler.io?

• Analyze orders, revenue, and refunds in Google Sheets, Excel, or Looker Studio
• Send product and inventory data to BigQuery or Redshift for warehouse-level reporting
• Combine orders with shipments and invoices using Join transformations for end-to-end fulfillment visibility
• Route customer or sales data to AI tools like ChatGPT, Claude, or Gemini for trend analysis and forecasting
• Append data from multiple store views or websites into a single dataset

Prerequisites

Before connecting, make sure you have:

• An active Adobe Commerce (Magento) instance with REST API access enabled
• An API access token or integration credentials with read permissions for the entities you want to export
• The base URL of your Magento store (e.g., https://yourstore.com)
• The API version your store is running (check under System > Web API)

Start with the Orders entity — it's usually the most valuable for revenue reporting and connects quickly with a single API token.

Quick start

1

Create a new data flow in Coupler.io. From your Coupler.io dashboard, click Add data flow and search for Adobe Commerce as the source.

2

Enter your API credentials. Provide your store's base URL and your API access token. You can generate an integration token in Magento under System > Integrations > Add New Integration — grant it read access to the resources you need.

3

Set your API version and start date. In the Basic settings, enter the API version your store uses (e.g., V1). Use the date picker to set a start date for how far back you want to pull historical data.

4

Select an entity. Choose the data you want to export — for example, Orders, Products, or Customers.

5

Choose your destination. Pick where you want the data to land — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like ChatGPT or Claude.

6

Run the data flow. Click Run to execute your first manual sync and confirm data is coming through correctly.

Available entities

Entity	Description
Orders	Customer order details and transaction records
Invoices	Invoice records for completed orders
Shipments	Shipping information and tracking details
Creditmemos	Credit memos for refunds and returns
Transactions	Payment transaction records
Carts	Active and abandoned shopping carts
Customers	Customer accounts and profile data
Customer groups	Group classifications and pricing tiers
Products	Product catalog including variants and specs
Coupons	Discount codes and promotional offers
Sales rules	Promotional pricing rules and conditions
Inventory stocks	Stock levels and warehouse info
Inventory sources	Source locations and configurations
Inventory source items	Product inventory per source location
Tax rates	Tax configurations by location/product type
Tax classes	Tax class definitions
Store websites	Multi-store website configurations
Store views	Language and locale settings
Store groups	Store group hierarchies
Directory countries	Supported countries and regions
Directory currencies	Currency configs and exchange rates