E-commerce
Connect Shopify to DataxLand
The Shopify connector reads your store's orders, refunds, products and variants, customers, payment transactions and inventory through the Admin API. Data lands in the workspace's own warehouse next to marketplaces, ads and your cost table. Si proposes how to read Shopify orders in the standard retail model, so your website's net revenue, average order value, return rate and profit after fees use the same definitions as Shopee, TikTok Shop and Lazada.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Shopify
- Compare net revenue and profit after fees of your Shopify store with marketplaces in one dashboard.
- See which products are returned most and how returns hit profit.
- Combine with Google Ads or Facebook Ads for true ROAS on net revenue.
- Get an alert when orders or average order value drop unusually.
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 with lines, discounts, shipping, taxes, payment and fulfilment status. |
| order_refunds | Refunds and returned items per order. |
| products | Products, type, vendor, tags. |
| product_variants | Variants (SKU), price and compare-at price. |
| customers | Customers (personal columns hashed on load) to count new and returning buyers. |
| transactions | Payment transactions per order, gateway and status. |
| inventory_levels | Inventory per location. |
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 | Shopify Store |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
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 (%) |
| Cost of goods sold | Quantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS. | Currency |
| 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 |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
Connect Shopify in 4 steps
- 1
Create an access token
In Shopify admin, create a custom app with read access to orders, products, customers and inventory, then install it to get the Admin API access token.
- 2
Add the source
In the workspace choose Add source, find Shopify in the connector library, enter the store name (before .myshopify.com), paste the token in API Password and a start date, click Test connection.
- 3
Choose streams
Pick the streams you need; orders and most other streams load incrementally by update time.
- 4
Review Si's proposal
Si maps orders, lines and refunds to the retail model; you approve and build.
Limits and caveats
- Gateway and app fees are not always complete in order data; add missing fees and product cost from Excel or Google Sheets for full profit after fees.
- DataxLand does not run Shopify's OAuth sign-in; you use a custom app access token (the form also accepts client ID, secret and access token from your own app).
- This is an Airbyte connector (ELv2 license) run inside DataxLand; Shopify rate-limits its API, so a first load of a long history can take a while.
- Requires a paid plan; the Free plan takes Excel only.
Frequently asked questions
Is customer data exposed?
Names, emails, phones and addresses are hashed on load, masked before they reach Si and never returned through dashboards, the API or MCP.
Do I need an app from the Shopify App Store?
No. You create a custom app in your own store admin with read-only scopes.
I sell on both Shopify and Shopee.
Connect both; DataxLand maps them to one model so dashboards compare each channel and the total.
Dashboard templates that use this source
Connect Shopify and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes