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 |
|---|---|
| orders | Orders with lines, shipping, discounts, payment method and status. |
| refunds | Refunds per order. |
| products | Products, categories, prices. |
| product_variations | Variations (SKU) of variable products. |
| customers | Customers (personal columns hashed on load). |
| coupons | Coupons and their conditions. |
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 | Customer Key, Customer Secret, Shop Name, Start Date |
| 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 (%) |
| 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 WooCommerce in 3 steps
- 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
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
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
Connect WooCommerce and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes