E-commerce
Connect Adobe Commerce (Magento) to DataxLand
The Adobe Commerce (Magento) connector reads orders, invoices, credit memos, shipments, products, customers and per-source inventory through your store's REST API. Retailers with a long-running Magento website often sell on marketplaces too; DataxLand brings Magento orders into the same standard retail model as Shopee, TikTok Shop and Lazada, so net revenue, cancellation rate, return rate and contribution margin of the website compare directly with each marketplace.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Adobe Commerce (Magento)
- Measure website net revenue after credit memo refunds, next to marketplace revenue.
- Track cancellation and return rates by product and by store view.
- Put per-source inventory next to sales velocity to spot items about to run out.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| orders | Orders, line items, discounts, shipping fees and status. |
| invoices | Invoices issued for orders. |
| creditmemos | Credit memos (refunds) per order. |
| shipments | Shipments of each order. |
| products | Products, SKUs and prices. |
| customers | Customers (personal columns are hashed on load). |
| inventory_source_items | Inventory per SKU and source. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Integration Access Token, Start Date, Store Host |
| Developer | Airbyte (community), run inside DataxLand |
| License | MIT |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| GMV (gross merchandise value) | Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds). | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| Units sold | Total quantity of products in the order lines of valid orders. | Count |
| Cancellation rate | Cancelled orders divided by total orders.= cancelled_orders / all_orders | Ratio (%) |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid orders | Ratio (%) |
| Contribution margin | Net revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return cost | Currency |
Connect Adobe Commerce (Magento) in 3 steps
- 1
Create an integration
In Magento admin → System → Integrations, create an integration with read-only access to sales, catalog and customers, then activate it to get the access token.
- 2
Add the source
In the workspace choose Add source, find Adobe Commerce (Magento) in the connector library, enter the Store Host, Integration Access Token and start date, then click Test connection.
- 3
Choose streams and review
Pick orders, invoices, credit memos and products; Si proposes a mapping to the retail model, and you approve before the build.
Limits and caveats
- This is a community connector (MIT license) from the Airbyte library, run inside DataxLand; try it on a short date range first.
- The website must allow REST API calls from outside; cost of goods and payment gateway fees usually need to be added via Excel or Google Sheets.
- Requires a paid plan; the Free plan takes Excel only.
Frequently asked questions
Does it support Magento Open Source?
The connector calls the standard Magento 2 REST API, available in both Open Source and Adobe Commerce.
Does it change data on the website?
No. The integration only needs read access and DataxLand never writes to the store.
How is customer information handled?
Personal columns are hashed on load, masked before reaching Si, and never returned through dashboards, the API or MCP.
Dashboard templates that use this source
Connect Adobe Commerce (Magento) and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes