Data Overview

Coupler.io gives you access to a wide range of WooCommerce data — from transactional records like orders and line items to aggregated reports and store configuration. Here's a breakdown of what's available and how to use it.

Entities and reports

Type	Entities
Transactional	Orders, Orders with line items, Customers, Coupons, Product reviews
Catalog	Products, Product categories, Product attributes, Product tags, Product shipping classes
Aggregated reports	Sales report, Top sellers report, Order totals, Product totals, Customer totals, Coupon totals, Review totals
Reference / Config	Currencies, Countries, Continents, Shipping zones, Tax classes, Tax rates

Metrics and dimensions

Orders

Field	Description
id	Unique order ID
status	Order status (pending, processing, completed, etc.)
currency	Currency code used for the order
date_created	Date and time the order was placed
date_modified	Date and time the order was last updated
total	Order grand total
subtotal	Order subtotal before discounts and tax
total_tax	Total tax amount
discount_total	Total discount applied
shipping_total	Shipping cost
payment_method_title	Payment method label
customer_id	ID of the customer (0 for guests)
billing / shipping	Address fields for billing and shipping

Orders with line items

This entity expands each order into one row per product, making it ideal for product-level sales analysis.

Field	Description
order_id	Parent order ID
line_item_name	Product name in the order
line_item_quantity	Quantity ordered
line_item_total	Line item total price
line_item_sku	Product SKU
line_item_product_id	Product ID

Products

Field	Description
id	Product ID
name	Product name
sku	Stock keeping unit
price / regular_price / sale_price	Pricing fields
stock_quantity	Current stock level
stock_status	In stock, out of stock, or on backorder
categories	Assigned category names
tags	Assigned tag names
date_created / date_modified	Timestamps
status	Published, draft, private, etc.

Customers

Field	Description
id	Customer ID
email	Email address
first_name / last_name	Name fields
date_created	Account creation date
orders_count	Total number of orders placed
total_spent	Lifetime value
billing / shipping	Address details

Coupons

Field	Description
id	Coupon ID
code	Coupon code
discount_type	Percent, fixed cart, or fixed product
amount	Discount value
usage_count	Times the coupon has been used
usage_limit	Maximum allowed uses
date_expires	Expiry date

Report: Sales report

Field	Description
total_sales	Gross sales for the period
net_revenue	Revenue after refunds and discounts
average_sales	Average order value
total_orders	Number of orders
total_items	Total items sold
total_discount	Total discounts applied
total_refunds	Total refunded amount
total_tax	Total tax collected
total_shipping	Total shipping collected

Report: Top sellers report

Field	Description
name	Product name
product_id	Product ID
quantity	Units sold in the period

Common metric combinations

• Orders + Customers (Join on customer_id) — analyze lifetime value and order frequency per customer

• Orders with line items + Products (Join on product_id) — enrich line item data with current stock and pricing

• Report: Sales report filtered by period — track revenue trends week-over-week or month-over-month

• Coupons + Report: Coupon totals — compare coupon configuration against actual usage performance

Use cases by role

Store owners

• Monitor daily and monthly revenue using the Sales report entity in Google Sheets or Looker Studio

• Track which products are driving the most sales with the Top sellers report

• Feed order and revenue data into ChatGPT or Claude to generate automated store performance summaries

Marketing teams

Operations / Finance

Platform-specific notes

• Product variations are not a separate entity — variation-level data is nested within the Products response. Coupler.io does not currently expand variations into individual rows.

• WooCommerce Subscriptions is a separate plugin; subscription-specific data is not available through the standard WooCommerce REST API.

• Custom fields / meta fields added by third-party plugins are not included in standard entity exports.

• The Search filter performs an exact match only — partial or fuzzy searches will not return results.

• Date filters (After date / Before date) apply to date_created on the server side. They are available for Orders, Orders with line items, Products, Product reviews, and Coupons.

• The Sales report and Top sellers report entities support period selection (Today, This Week, This Month, Last Month, This Year, or Custom with a date picker).

• Stores using Cloudflare or other web application firewalls may need to whitelist Coupler.io to allow API requests through.