Skip to content

E-commerce

Connect WooCommerce to DataxLand

Many shops run a WordPress and WooCommerce website next to marketplaces. The WooCommerce connector reads orders, refunds, products and variations, customers and coupons through the WooCommerce REST API into the workspace's own warehouse. Si proposes how to read website orders in the standard retail model, so the site's net revenue, cancellation rate, return rate and contribution margin compare directly with Shopee, TikTok Shop and Lazada.

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

What you can do with WooCommerce

  • See how much net revenue and profit your website brings compared with marketplaces.
  • Find coupons that drive orders but lower average order value.
  • Track weekly cancellation rate of cash-on-delivery orders on the website.

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, shipping, discounts, payment method and status.
refundsRefunds per order.
productsProducts, categories, prices.
product_variationsVariations (SKU) of variable products.
customersCustomers (personal columns hashed on load).
couponsCoupons and their conditions.

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 inCustomer Key, Customer Secret, Shop Name, Start Date
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 (%)
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

Connect WooCommerce in 3 steps

  1. 1

    Create an API key

    In WooCommerce → Settings → Advanced → REST API, create a key with Read permission and copy the consumer key and secret.

  2. 2

    Add the source

    In the workspace choose Add source, find WooCommerce in the connector library, enter the shop domain, Customer Key, Customer Secret and a start date, click Test connection.

  3. 3

    Choose streams and review

    Pick orders, refunds and products; Si proposes a retail mapping, you approve and build.

Limits and caveats

  • The site must use HTTPS and allow outside REST API calls; some security plugins or firewalls block them.
  • Product cost and gateway fees are usually missing in WooCommerce; add them from Excel or Google Sheets for contribution margin.
  • This is an Airbyte connector (ELv2 license) run inside DataxLand; a paid plan is required.

Frequently asked questions

Is a read-only key enough?

Yes. DataxLand only reads data; it never creates or edits orders on your site.

How are cancelled cash-on-delivery orders counted?

Cancelled orders are excluded from net revenue; cancellation rate is computed over all orders per the retail pack definition.

How often is data refreshed?

On the workspace refresh schedule; orders load incrementally, so later runs only fetch new or changed orders.

Dashboard templates that use this source

Ask Si about your WooCommerce data →WooCommerce + Facebook Marketing →WooCommerce + Paypal Transaction →All data sources →

Connect WooCommerce and get verified dashboards

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