Skip to content

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
ordersOrders with lines, discounts, shipping, taxes, payment and fulfilment status.
order_refundsRefunds and returned items per order.
productsProducts, type, vendor, tags.
product_variantsVariants (SKU), price and compare-at price.
customersCustomers (personal columns hashed on load) to count new and returning buyers.
transactionsPayment transactions per order, gateway and status.
inventory_levelsInventory per location.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inShopify Store
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

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.

MetricDefinitionUnit
Net revenueLine 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 ordersOrders that were not cancelled (standard status other than cancelled).Count
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Units soldTotal quantity of products in the order lines of valid orders.Count
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Cost of goods soldQuantity 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 marginNet 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 costCurrency
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency

Connect Shopify in 4 steps

  1. 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. 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. 3

    Choose streams

    Pick the streams you need; orders and most other streams load incrementally by update time.

  4. 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

Ask Si about your Shopify data →Shopify + QuickBooks →Shopify + Facebook Marketing →Shopify + Google Ads →Shopify + Google Analytics 4 (GA4) →Shopify + Zendesk Support →All data sources →

Connect Shopify and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes