Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your WooCommerce data to
WooCommerce Connector Reference
73 metrics340 dimensions
The WooCommerce connector exposes 413 fields (73 metrics, 340 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
WooCommerce Fields
WooCommerce common fields
The common report of the WooCommerce connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. |
| account_name | TEXT | Account Name | Account name. |
| date | DATE | Date | Date. |
WooCommerce coupons fields
The coupons report of the WooCommerce connector includes 29 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| coupons___links | TEXT | coupons.links | coupons.links |
| coupons__amount | NUMERIC | coupons.amount | coupons.amount |
| coupons__code | TEXT | coupons.code | coupons.code |
| coupons__date_created | DATE | coupons.date_created | coupons.date_created |
| coupons__date_created_gmt | DATE | coupons.date_created_gmt | coupons.date_created_gmt |
| coupons__date_expires | DATE | coupons.date_expires | coupons.date_expires |
| coupons__date_expires_gmt | DATE | coupons.date_expires_gmt | coupons.date_expires_gmt |
| coupons__date_modified | DATE | coupons.date_modified | coupons.date_modified |
| coupons__date_modified_gmt | DATE | coupons.date_modified_gmt | coupons.date_modified_gmt |
| coupons__description | TEXT | coupons.description | coupons.description |
| coupons__discount_type | TEXT | coupons.discount_type | coupons.discount_type |
| coupons__email_restrictions | TEXT | coupons.email_restrictions | coupons.email_restrictions |
| coupons__exclude_sale_items | BOOLEAN | coupons.exclude_sale_items | coupons.exclude_sale_items |
| coupons__excluded_product_categories | TEXT | coupons.excluded_product_categories | coupons.excluded_product_categories |
| coupons__excluded_product_ids | TEXT | coupons.excluded_product_ids | coupons.excluded_product_ids |
| coupons__free_shipping | BOOLEAN | coupons.free_shipping | coupons.free_shipping |
| coupons__id | TEXT | coupons.id | coupons.id |
| coupons__individual_use | BOOLEAN | coupons.individual_use | coupons.individual_use |
| coupons__limit_usage_to_x_items | NUMERIC | coupons.limit_usage_to_x_items | coupons.limit_usage_to_x_items |
| coupons__maximum_amount | NUMERIC | coupons.maximum_amount | coupons.maximum_amount |
| coupons__meta_data | TEXT | coupons.meta_data | coupons.meta_data |
| coupons__minimum_amount | NUMERIC | coupons.minimum_amount | coupons.minimum_amount |
| coupons__product_categories | TEXT | coupons.product_categories | coupons.product_categories |
| coupons__product_ids | TEXT | coupons.product_ids | coupons.product_ids |
| coupons__shop_url | TEXT | coupons.shop_url | coupons.shop_url |
| coupons__usage_count | NUMERIC | coupons.usage_count | coupons.usage_count |
| coupons__usage_limit | NUMERIC | coupons.usage_limit | coupons.usage_limit |
| coupons__usage_limit_per_user | NUMERIC | coupons.usage_limit_per_user | coupons.usage_limit_per_user |
| coupons__used_by | TEXT | coupons.used_by | coupons.used_by |
WooCommerce customers fields
The customers report of the WooCommerce connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customers___links | TEXT | customers.links | customers.links |
| customers__avatar_url | TEXT | customers.avatar_url | customers.avatar_url |
| customers__billing | TEXT | customers.billing | customers.billing |
| customers__date_created | DATE | customers.date_created | customers.date_created |
| customers__date_created_gmt | DATE | customers.date_created_gmt | customers.date_created_gmt |
| customers__date_modified | DATE | customers.date_modified | customers.date_modified |
| customers__date_modified_gmt | DATE | customers.date_modified_gmt | customers.date_modified_gmt |
| customers__email | TEXT | customers.email | customers.email |
| customers__first_name | TEXT | customers.first_name | customers.first_name |
| customers__id | TEXT | customers.id | customers.id |
| customers__is_paying_customer | BOOLEAN | customers.is_paying_customer | customers.is_paying_customer |
| customers__last_name | TEXT | customers.last_name | customers.last_name |
| customers__meta_data | TEXT | customers.meta_data | customers.meta_data |
| customers__role | TEXT | customers.role | customers.role |
| customers__shipping | TEXT | customers.shipping | customers.shipping |
| customers__shop_url | TEXT | customers.shop_url | customers.shop_url |
| customers__username | TEXT | customers.username | customers.username |
WooCommerce order_coupon_lines fields
The order_coupon_lines report of the WooCommerce connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| orders__coupon_lines__code | TEXT | Order Coupon Lines Code | Order Coupon Lines Code |
| orders__coupon_lines__discount | NUMERIC | Order Coupon Lines Discount | Order Coupon Lines Discount |
| orders__coupon_lines__discount_tax | NUMERIC | Order Coupon Lines Discount Tax | Order Coupon Lines Discount Tax |
| orders__coupon_lines__id | TEXT | Order Coupon Lines ID | Order Coupon Lines ID |
WooCommerce order_line_items fields
The order_line_items report of the WooCommerce connector includes 18 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| orders__line_items__extended__order_count | NUMERIC | Extended Order Line Item Order Count | Total Count of Orders |
| orders__line_items__extended__product_name | TEXT | Extended Order Line Item Product Name | Extended Order Line Item Product Name |
| orders__line_items__extended__product_sku | TEXT | Extended Order Line Item Product SKU | Extended Order Line Item Product SKU |
| orders__line_items__id | TEXT | Order Line Item ID | Order Line Item ID |
| orders__line_items__image__id | TEXT | Order Line Item Image ID | Order Line Item Image ID |
| orders__line_items__image__src | IMAGE_URL | Order Line Item Image | Order Line Item Image |
| orders__line_items__name | TEXT | Order Line Item Name | Order Line Item Name |
| orders__line_items__parent_name | TEXT | Order Line Item Parent Name | Order Line Item Parent Name |
| orders__line_items__price | NUMERIC | Order Line Item Price | Order Line Item Price |
| orders__line_items__product_id | TEXT | Order Line Item Product ID | Order Line Item Product ID |
| orders__line_items__quantity | NUMERIC | Order Line Item Quantity | Order Line Item Quantity |
| orders__line_items__sku | TEXT | Order Line Item SKU | Order Line Item SKU |
| orders__line_items__subtotal | NUMERIC | Order Line Item Subtotal | Order Line Item Subtotal |
| orders__line_items__subtotal_tax | NUMERIC | Order Line Item Subtotal Tax | Order Line Item Subtotal Tax |
| orders__line_items__tax_class | TEXT | Order Line Item Tax Class | Order Line Item Tax Class |
| orders__line_items__total | NUMERIC | Order Line Item Total | Order Line Item Total |
| orders__line_items__total_tax | NUMERIC | Order Line Item Total Tax | Order Line Item Total Tax |
| orders__line_items__variation_id | TEXT | Order Line Item Variation ID | Order Line Item Variation ID |
WooCommerce order_meta fields
The order_meta report of the WooCommerce connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| order_meta__id | TEXT | Order Meta ID | Order Meta ID |
| order_meta__key | TEXT | Order Meta Key | Order Meta Key |
| order_meta__value | TEXT | Order Meta Value | Order Meta Value |
WooCommerce order_notes fields
The order_notes report of the WooCommerce connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| order_notes__added_by_user | BOOLEAN | order_notes.added_by_user | order_notes.added_by_user |
| order_notes__author | TEXT | order_notes.author | order_notes.author |
| order_notes__custom_note | BOOLEAN | order_notes.custom_note | order_notes.custom_note |
| order_notes__date_created | DATE | order_notes.date_created | order_notes.date_created |
| order_notes__date_created_gmt | DATE | order_notes.date_created_gmt | order_notes.date_created_gmt |
| order_notes__id | TEXT | order_notes.id | order_notes.id |
| order_notes__note | TEXT | order_notes.note | order_notes.note |
WooCommerce order_refunds fields
The order_refunds report of the WooCommerce connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| orders__refunds__id | TEXT | Orders Refunds ID | Order Refunds ID |
| orders__refunds__reason | TEXT | Orders Refunds Reason | Order Refunds Reason |
| orders__refunds__total | NUMERIC | Orders Refunds Total | Order Refunds Total |
WooCommerce order_shipping_lines fields
The order_shipping_lines report of the WooCommerce connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| orders__shipping_lines__id | TEXT | Orders Shipping Lines ID | Orders Shipping Lines ID |
| orders__shipping_lines__instance_id | TEXT | Orders Shipping Lines Instance ID | Orders Shipping Lines Instance ID |
| orders__shipping_lines__meta_data | TEXT | Orders Shipping Lines Meta Data | Orders Shipping Lines Meta Data |
| orders__shipping_lines__method_id | TEXT | Orders Shipping Lines Method ID | Orders Shipping Lines Method ID |
| orders__shipping_lines__method_title | TEXT | Orders Shipping Lines Method Title | Orders Shipping Lines Method Title |
| orders__shipping_lines__total | NUMERIC | Orders Shipping Lines Total | Orders Shipping Lines Total |
| orders__shipping_lines__total_tax | NUMERIC | Orders Shipping Lines Total Tax | Orders Shipping Lines Total Tax |
WooCommerce order_tax_lines fields
The order_tax_lines report of the WooCommerce connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| orders__tax_lines__compound | BOOLEAN | Orders Tax Lines Compound | Orders Tax Lines Compound |
| orders__tax_lines__id | TEXT | Orders Tax Lines ID | Orders Tax Lines ID |
| orders__tax_lines__label | TEXT | Orders Tax Lines Label | Orders Tax Lines Label |
| orders__tax_lines__meta_data | TEXT | Orders Tax Lines Meta Data | Orders Tax Lines Meta Data |
| orders__tax_lines__rate_code | TEXT | Orders Tax Lines Rate Code | Orders Tax Lines Rate Code |
| orders__tax_lines__rate_id | TEXT | Orders Tax Lines Rate ID | Orders Tax Lines Rate ID |
| orders__tax_lines__rate_percent | PERCENT | Orders Tax Lines Rate Percent | Orders Tax Lines Rate Percent |
| orders__tax_lines__shipping_tax_total | NUMERIC | Orders Tax Lines Shipping Tax Total | Orders Tax Lines Shipping Tax Total |
| orders__tax_lines__tax_total | NUMERIC | Orders Tax Lines Tax Total | Orders Tax Lines Tax Total |
WooCommerce orders fields
The orders report of the WooCommerce connector includes 72 fields.
WooCommerce orders fields (orders___links to orders__order_attribution_referrer)
| ID | Type | Name | Description |
|---|---|---|---|
| orders___links | TEXT | orders.links | orders.links |
| orders__billing | TEXT | orders.billing | orders.billing |
| orders__billing__address_1 | TEXT | Orders Billing Address 1 | Orders Billing Address 1 |
| orders__billing__address_2 | TEXT | Orders Billing Address 2 | Orders Billing Address 2 |
| orders__billing__city | CITY | Orders Billing City | Orders Billing City |
| orders__billing__company | TEXT | Orders Billing Company | Orders Billing Company |
| orders__billing__country | COUNTRY | Orders Billing Country | Orders Billing Country |
| orders__billing__email | TEXT | Orders Billing Email | Orders Billing Email |
| orders__billing__first_name | TEXT | Orders Billing First Name | Orders Billing First Name |
| orders__billing__last_name | TEXT | Orders Billing Last Name | Orders Billing Last Name |
| orders__billing__phone | TEXT | Orders Billing Phone | Orders Billing Phone |
| orders__billing__postcode | TEXT | Orders Billing Postcode | Orders Billing Postcode |
| orders__billing__state | TEXT | Orders Billing State | Orders Billing State |
| orders__cart_hash | TEXT | orders.cart_hash | orders.cart_hash |
| orders__cart_tax | NUMERIC | orders.cart_tax | orders.cart_tax |
| orders__coupon_lines | TEXT | orders.coupon_lines | orders.coupon_lines |
| orders__created_via | TEXT | orders.created_via | orders.created_via |
| orders__currency | TEXT | orders.currency | orders.currency |
| orders__customer_id | NUMERIC | orders.customer_id | orders.customer_id |
| orders__customer_ip_address | TEXT | orders.customer_ip_address | orders.customer_ip_address |
| orders__customer_note | TEXT | orders.customer_note | orders.customer_note |
| orders__customer_user_agent | TEXT | orders.customer_user_agent | orders.customer_user_agent |
| orders__date_completed | DATE | orders.date_completed | orders.date_completed |
| orders__date_completed_gmt | DATE | orders.date_completed_gmt | orders.date_completed_gmt |
| orders__date_created | DATE | orders.date_created | orders.date_created |
| orders__date_created_gmt | DATE | orders.date_created_gmt | orders.date_created_gmt |
| orders__date_modified | DATE | orders.date_modified | orders.date_modified |
| orders__date_modified_gmt | DATE | orders.date_modified_gmt | orders.date_modified_gmt |
| orders__date_paid | DATE | orders.date_paid | orders.date_paid |
| orders__date_paid_gmt | DATE | orders.date_paid_gmt | orders.date_paid_gmt |
| orders__discount_tax | NUMERIC | orders.discount_tax | orders.discount_tax |
| orders__discount_total | NUMERIC | orders.discount_total | orders.discount_total |
| orders__fee_lines | TEXT | orders.fee_lines | orders.fee_lines |
| orders__id | TEXT | orders.id | orders.id |
| orders__line_items | TEXT | orders.line_items | orders.line_items |
| orders__meta_data | TEXT | orders.meta_data | orders.meta_data |
| orders__net_sales | NUMERIC | orders.net_sales | Order Net Sales |
| orders__number | TEXT | orders.number | orders.number |
| orders__order_attribution_device_type | TEXT | orders.order_attribution_device_type | Device type recorded by WooCommerce Order Attribution. |
| orders__order_attribution_referrer | TEXT | orders.order_attribution_referrer | Referring URL recorded by WooCommerce Order Attribution. |
WooCommerce orders fields (orders__order_attribution_source_type to orders__version)
| ID | Type | Name | Description |
|---|---|---|---|
| orders__order_attribution_source_type | TEXT | orders.order_attribution_source_type | Order Attribution origin type (e.g. Direct, Organic, Referral, Utm). |
| orders__order_attribution_utm_campaign | TEXT | orders.order_attribution_utm_campaign | UTM campaign recorded by WooCommerce Order Attribution. |
| orders__order_attribution_utm_medium | TEXT | orders.order_attribution_utm_medium | UTM medium recorded by WooCommerce Order Attribution. |
| orders__order_attribution_utm_source | TEXT | orders.order_attribution_utm_source | UTM source recorded by WooCommerce Order Attribution. |
| orders__order_key | TEXT | orders.order_key | orders.order_key |
| orders__parent_id | NUMERIC | orders.parent_id | orders.parent_id |
| orders__payment_method | TEXT | orders.payment_method | orders.payment_method |
| orders__payment_method_title | TEXT | orders.payment_method_title | orders.payment_method_title |
| orders__prices_include_tax | BOOLEAN | orders.prices_include_tax | orders.prices_include_tax |
| orders__refunds | TEXT | orders.refunds | orders.refunds |
| orders__set_paid | BOOLEAN | orders.set_paid | orders.set_paid |
| orders__shipping | TEXT | orders.shipping | orders.shipping |
| orders__shipping__address_1 | TEXT | Orders Shipping Address 1 | Orders Shipping Address 1 |
| orders__shipping__address_2 | TEXT | Orders Shipping Address 2 | Orders Shipping Address 2 |
| orders__shipping__city | CITY | Orders Shipping City | Orders Shipping City |
| orders__shipping__company | TEXT | Orders Shipping Company | Orders Shipping Company |
| orders__shipping__country | COUNTRY | Orders Shipping Country | Orders Shipping Country |
| orders__shipping__first_name | TEXT | Orders Shipping First Name | Orders Shipping First Name |
| orders__shipping__last_name | TEXT | Orders Shipping Last Name | Orders Shipping Last Name |
| orders__shipping__phone | TEXT | Orders Shipping Phone | Orders Shipping Phone |
| orders__shipping__postcode | TEXT | Orders Shipping Postcode | Orders Shipping Postcode |
| orders__shipping__state | TEXT | Orders Shipping State | Orders Shipping State |
| orders__shipping_lines | TEXT | orders.shipping_lines | orders.shipping_lines |
| orders__shipping_tax | NUMERIC | orders.shipping_tax | orders.shipping_tax |
| orders__shipping_total | NUMERIC | orders.shipping_total | orders.shipping_total |
| orders__shop_url | TEXT | orders.shop_url | orders.shop_url |
| orders__status | TEXT | orders.status | orders.status |
| orders__tax_lines | TEXT | orders.tax_lines | orders.tax_lines |
| orders__total | NUMERIC | orders.total | orders.total |
| orders__total_tax | NUMERIC | orders.total_tax | orders.total_tax |
| orders__transaction_id | TEXT | orders.transaction_id | orders.transaction_id |
| orders__version | TEXT | orders.version | orders.version |
WooCommerce payment_gateways fields
The payment_gateways report of the WooCommerce connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| payment_gateways__description | TEXT | payment_gateways.description | payment_gateways.description |
| payment_gateways__enabled | BOOLEAN | payment_gateways.enabled | payment_gateways.enabled |
| payment_gateways__id | TEXT | payment_gateways.id | payment_gateways.id |
| payment_gateways__method_description | TEXT | payment_gateways.method_description | payment_gateways.method_description |
| payment_gateways__method_supports | TEXT | payment_gateways.method_supports | payment_gateways.method_supports |
| payment_gateways__method_title | TEXT | payment_gateways.method_title | payment_gateways.method_title |
| payment_gateways__order | NUMERIC | payment_gateways.order | payment_gateways.order |
| payment_gateways__settings | TEXT | payment_gateways.settings | payment_gateways.settings |
| payment_gateways__title | TEXT | payment_gateways.title | payment_gateways.title |
WooCommerce product_attribute_terms fields
The product_attribute_terms report of the WooCommerce connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_attribute_terms__count | NUMERIC | product_attribute_terms.count | product_attribute_terms.count |
| product_attribute_terms__description | TEXT | product_attribute_terms.description | product_attribute_terms.description |
| product_attribute_terms__id | TEXT | product_attribute_terms.id | product_attribute_terms.id |
| product_attribute_terms__menu_order | NUMERIC | product_attribute_terms.menu_order | product_attribute_terms.menu_order |
| product_attribute_terms__name | TEXT | product_attribute_terms.name | product_attribute_terms.name |
| product_attribute_terms__slug | TEXT | product_attribute_terms.slug | product_attribute_terms.slug |
WooCommerce product_attributes fields
The product_attributes report of the WooCommerce connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_attributes__has_archives | BOOLEAN | product_attributes.has_archives | product_attributes.has_archives |
| product_attributes__id | TEXT | product_attributes.id | product_attributes.id |
| product_attributes__name | TEXT | product_attributes.name | product_attributes.name |
| product_attributes__order_by | TEXT | product_attributes.order_by | product_attributes.order_by |
| product_attributes__slug | TEXT | product_attributes.slug | product_attributes.slug |
| product_attributes__type | TEXT | product_attributes.type | product_attributes.type |
WooCommerce product_categories fields
The product_categories report of the WooCommerce connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_categories__count | NUMERIC | product_categories.count | product_categories.count |
| product_categories__description | TEXT | product_categories.description | product_categories.description |
| product_categories__display | TEXT | product_categories.display | product_categories.display |
| product_categories__id | TEXT | product_categories.id | product_categories.id |
| product_categories__image | TEXT | product_categories.image | product_categories.image |
| product_categories__menu_order | NUMERIC | product_categories.menu_order | product_categories.menu_order |
| product_categories__name | TEXT | product_categories.name | product_categories.name |
| product_categories__parent | NUMERIC | product_categories.parent | product_categories.parent |
| product_categories__slug | TEXT | product_categories.slug | product_categories.slug |
WooCommerce product_reviews fields
The product_reviews report of the WooCommerce connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_reviews__date_created | DATE | product_reviews.date_created | product_reviews.date_created |
| product_reviews__date_created_gmt | DATE | product_reviews.date_created_gmt | product_reviews.date_created_gmt |
| product_reviews__id | TEXT | product_reviews.id | product_reviews.id |
| product_reviews__product_id | NUMERIC | product_reviews.product_id | product_reviews.product_id |
| product_reviews__rating | NUMERIC | product_reviews.rating | product_reviews.rating |
| product_reviews__review | TEXT | product_reviews.review | product_reviews.review |
| product_reviews__reviewer | TEXT | product_reviews.reviewer | product_reviews.reviewer |
| product_reviews__reviewer_email | TEXT | product_reviews.reviewer_email | product_reviews.reviewer_email |
| product_reviews__status | TEXT | product_reviews.status | product_reviews.status |
| product_reviews__verified | BOOLEAN | product_reviews.verified | product_reviews.verified |
WooCommerce product_shipping_classes fields
The product_shipping_classes report of the WooCommerce connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_shipping_classes__count | NUMERIC | product_shipping_classes.count | product_shipping_classes.count |
| product_shipping_classes__description | TEXT | product_shipping_classes.description | product_shipping_classes.description |
| product_shipping_classes__id | TEXT | product_shipping_classes.id | product_shipping_classes.id |
| product_shipping_classes__name | TEXT | product_shipping_classes.name | product_shipping_classes.name |
| product_shipping_classes__slug | TEXT | product_shipping_classes.slug | product_shipping_classes.slug |
WooCommerce product_tags fields
The product_tags report of the WooCommerce connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_tags__count | NUMERIC | product_tags.count | product_tags.count |
| product_tags__description | TEXT | product_tags.description | product_tags.description |
| product_tags__id | TEXT | product_tags.id | product_tags.id |
| product_tags__name | TEXT | product_tags.name | product_tags.name |
| product_tags__slug | TEXT | product_tags.slug | product_tags.slug |
WooCommerce product_variations fields
The product_variations report of the WooCommerce connector includes 39 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| product_variations__attributes | TEXT | product_variations.attributes | product_variations.attributes |
| product_variations__backordered | BOOLEAN | product_variations.backordered | product_variations.backordered |
| product_variations__backorders | TEXT | product_variations.backorders | product_variations.backorders |
| product_variations__backorders_allowed | BOOLEAN | product_variations.backorders_allowed | product_variations.backorders_allowed |
| product_variations__date_created | DATE | product_variations.date_created | product_variations.date_created |
| product_variations__date_created_gmt | DATE | product_variations.date_created_gmt | product_variations.date_created_gmt |
| product_variations__date_modified | DATE | product_variations.date_modified | product_variations.date_modified |
| product_variations__date_modified_gmt | DATE | product_variations.date_modified_gmt | product_variations.date_modified_gmt |
| product_variations__date_on_sale_from | DATE | product_variations.date_on_sale_from | product_variations.date_on_sale_from |
| product_variations__date_on_sale_from_gmt | DATE | product_variations.date_on_sale_from_gmt | product_variations.date_on_sale_from_gmt |
| product_variations__date_on_sale_to | DATE | product_variations.date_on_sale_to | product_variations.date_on_sale_to |
| product_variations__date_on_sale_to_gmt | DATE | product_variations.date_on_sale_to_gmt | product_variations.date_on_sale_to_gmt |
| product_variations__description | TEXT | product_variations.description | product_variations.description |
| product_variations__dimensions | TEXT | product_variations.dimensions | product_variations.dimensions |
| product_variations__download_expiry | NUMERIC | product_variations.download_expiry | product_variations.download_expiry |
| product_variations__download_limit | NUMERIC | product_variations.download_limit | product_variations.download_limit |
| product_variations__downloadable | BOOLEAN | product_variations.downloadable | product_variations.downloadable |
| product_variations__downloads | TEXT | product_variations.downloads | product_variations.downloads |
| product_variations__id | TEXT | product_variations.id | product_variations.id |
| product_variations__image | TEXT | product_variations.image | product_variations.image |
| product_variations__manage_stock | TEXT | product_variations.manage_stock | product_variations.manage_stock |
| product_variations__menu_order | NUMERIC | product_variations.menu_order | product_variations.menu_order |
| product_variations__meta_data | TEXT | product_variations.meta_data | product_variations.meta_data |
| product_variations__on_sale | BOOLEAN | product_variations.on_sale | product_variations.on_sale |
| product_variations__permalink | TEXT | product_variations.permalink | product_variations.permalink |
| product_variations__price | TEXT | product_variations.price | product_variations.price |
| product_variations__purchasable | BOOLEAN | product_variations.purchasable | product_variations.purchasable |
| product_variations__regular_price | TEXT | product_variations.regular_price | product_variations.regular_price |
| product_variations__sale_price | TEXT | product_variations.sale_price | product_variations.sale_price |
| product_variations__shipping_class | TEXT | product_variations.shipping_class | product_variations.shipping_class |
| product_variations__shipping_class_id | NUMERIC | product_variations.shipping_class_id | product_variations.shipping_class_id |
| product_variations__sku | TEXT | product_variations.sku | product_variations.sku |
| product_variations__status | TEXT | product_variations.status | product_variations.status |
| product_variations__stock_quantity | NUMERIC | product_variations.stock_quantity | product_variations.stock_quantity |
| product_variations__stock_status | TEXT | product_variations.stock_status | product_variations.stock_status |
| product_variations__tax_class | TEXT | product_variations.tax_class | product_variations.tax_class |
| product_variations__tax_status | TEXT | product_variations.tax_status | product_variations.tax_status |
| product_variations__virtual | BOOLEAN | product_variations.virtual | product_variations.virtual |
| product_variations__weight | TEXT | product_variations.weight | product_variations.weight |
WooCommerce products fields
The products report of the WooCommerce connector includes 66 fields.
WooCommerce products fields (products__attributes to products__purchasable)
| ID | Type | Name | Description |
|---|---|---|---|
| products__attributes | TEXT | products.attributes | products.attributes |
| products__average_rating | TEXT | products.average_rating | products.average_rating |
| products__backordered | BOOLEAN | products.backordered | products.backordered |
| products__backorders | TEXT | products.backorders | products.backorders |
| products__backorders_allowed | BOOLEAN | products.backorders_allowed | products.backorders_allowed |
| products__button_text | TEXT | products.button_text | products.button_text |
| products__catalog_visibility | TEXT | products.catalog_visibility | products.catalog_visibility |
| products__categories | TEXT | products.categories | products.categories |
| products__cross_sell_ids | TEXT | products.cross_sell_ids | products.cross_sell_ids |
| products__date_created | DATE | products.date_created | products.date_created |
| products__date_created_gmt | DATE | products.date_created_gmt | products.date_created_gmt |
| products__date_modified | DATE | products.date_modified | products.date_modified |
| products__date_modified_gmt | DATE | products.date_modified_gmt | products.date_modified_gmt |
| products__date_on_sale_from | DATE | products.date_on_sale_from | products.date_on_sale_from |
| products__date_on_sale_from_gmt | DATE | products.date_on_sale_from_gmt | products.date_on_sale_from_gmt |
| products__date_on_sale_to | DATE | products.date_on_sale_to | products.date_on_sale_to |
| products__date_on_sale_to_gmt | DATE | products.date_on_sale_to_gmt | products.date_on_sale_to_gmt |
| products__default_attributes | TEXT | products.default_attributes | products.default_attributes |
| products__description | TEXT | products.description | products.description |
| products__dimensions | TEXT | products.dimensions | products.dimensions |
| products__download_expiry | NUMERIC | products.download_expiry | products.download_expiry |
| products__download_limit | NUMERIC | products.download_limit | products.download_limit |
| products__downloadable | BOOLEAN | products.downloadable | products.downloadable |
| products__downloads | TEXT | products.downloads | products.downloads |
| products__external_url | TEXT | products.external_url | products.external_url |
| products__features | BOOLEAN | products.features | products.features |
| products__grouped_products | TEXT | products.grouped_products | products.grouped_products |
| products__id | TEXT | products.id | products.id |
| products__images | TEXT | products.images | products.images |
| products__jetpack_related_posts | TEXT | products.jetpack-related-posts | products.jetpack-related-posts |
| products__manage_stock | BOOLEAN | products.manage_stock | products.manage_stock |
| products__menu_order | NUMERIC | products.menu_order | products.menu_order |
| products__meta_data | TEXT | products.meta_data | products.meta_data |
| products__name | TEXT | products.name | products.name |
| products__on_sale | BOOLEAN | products.on_sale | products.on_sale |
| products__parent_id | NUMERIC | products.parent_id | products.parent_id |
| products__permalink | TEXT | products.permalink | products.permalink |
| products__price | TEXT | products.price | products.price |
| products__price_html | TEXT | products.price_html | products.price_html |
| products__purchasable | BOOLEAN | products.purchasable | products.purchasable |
WooCommerce products fields (products__purchase_note to products__weight)
| ID | Type | Name | Description |
|---|---|---|---|
| products__purchase_note | TEXT | products.purchase_note | products.purchase_note |
| products__rating_count | NUMERIC | products.rating_count | products.rating_count |
| products__regular_price | TEXT | products.regular_price | products.regular_price |
| products__related_ids | TEXT | products.related_ids | products.related_ids |
| products__reviews_allowed | BOOLEAN | products.reviews_allowed | products.reviews_allowed |
| products__sale_price | TEXT | products.sale_price | products.sale_price |
| products__shipping_class | TEXT | products.shipping_class | products.shipping_class |
| products__shipping_class_id | NUMERIC | products.shipping_class_id | products.shipping_class_id |
| products__shipping_required | BOOLEAN | products.shipping_required | products.shipping_required |
| products__shipping_taxable | BOOLEAN | products.shipping_taxable | products.shipping_taxable |
| products__short_description | TEXT | products.short_description | products.short_description |
| products__sku | TEXT | products.sku | products.sku |
| products__slug | TEXT | products.slug | products.slug |
| products__sold_individually | BOOLEAN | products.sold_individually | products.sold_individually |
| products__status | TEXT | products.status | products.status |
| products__stock_quantity | NUMERIC | products.stock_quantity | products.stock_quantity |
| products__stock_status | TEXT | products.stock_status | products.stock_status |
| products__tags | TEXT | products.tags | products.tags |
| products__tax_class | TEXT | products.tax_class | products.tax_class |
| products__tax_status | TEXT | products.tax_status | products.tax_status |
| products__total_sales | NUMERIC | products.total_sales | products.total_sales |
| products__type | TEXT | products.type | products.type |
| products__upsell_ids | TEXT | products.upsell_ids | products.upsell_ids |
| products__variations | TEXT | products.variations | products.variations |
| products__virtual | BOOLEAN | products.virtual | products.virtual |
| products__weight | TEXT | products.weight | products.weight |
WooCommerce refund_line_items fields
The refund_line_items report of the WooCommerce connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| refunds__line_items__id | TEXT | Refunds Line Items ID | Refunds Line Items ID |
| refunds__line_items__image__id | TEXT | Refunds Line Items Image ID | Refunds Line Items Image ID |
| refunds__line_items__image__src | IMAGE_URL | Refunds Line Items Image | Refunds Line Items Image |
| refunds__line_items__name | TEXT | Refunds Line Items Name | Refunds Line Items Name |
| refunds__line_items__parent_name | TEXT | Refunds Line Items Parent Name | Refunds Line Items Parent Name |
| refunds__line_items__price | NUMERIC | Refunds Line Items Price | Refunds Line Items Price |
| refunds__line_items__product_id | TEXT | Refunds Line Items Product ID | Refunds Line Items Product ID |
| refunds__line_items__quantity | NUMERIC | Refunds Line Items Quantity | Refunds Line Items Quantity |
| refunds__line_items__sku | TEXT | Refunds Line Items Sku | Refunds Line Items Sku |
| refunds__line_items__subtotal | NUMERIC | Refunds Line Items Subtotal | Refunds Line Items Subtotal |
| refunds__line_items__subtotal_tax | NUMERIC | Refunds Line Items Subtotal Tax | Refunds Line Items Subtotal Tax |
| refunds__line_items__tax_class | TEXT | Refunds Line Items Tax Class | Refunds Line Items Tax Class |
| refunds__line_items__total | NUMERIC | Refunds Line Items Total | Refunds Line Items Total |
| refunds__line_items__total_tax | NUMERIC | Refunds Line Items Total Tax | Refunds Line Items Total Tax |
| refunds__line_items__variation_id | TEXT | Refunds Line Items Variation ID | Refunds Line Items Variation ID |
WooCommerce refund_shipping_lines fields
The refund_shipping_lines report of the WooCommerce connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| refunds__shipping_lines__id | TEXT | Refunds Shipping Lines ID | Refunds Shipping Lines ID |
| refunds__shipping_lines__instance_id | TEXT | Refunds Shipping Lines Instance ID | Refunds Shipping Lines Instance ID |
| refunds__shipping_lines__meta_data | TEXT | Refunds Shipping Lines Meta Data | Refunds Shipping Lines Meta Data |
| refunds__shipping_lines__method_id | TEXT | Refunds Shipping Lines Method ID | Refunds Shipping Lines Method ID |
| refunds__shipping_lines__method_title | TEXT | Refunds Shipping Lines Method Title | Refunds Shipping Lines Method Title |
| refunds__shipping_lines__total | NUMERIC | Refunds Shipping Lines Total | Refunds Shipping Lines Total |
| refunds__shipping_lines__total_tax | NUMERIC | Refunds Shipping Lines Total Tax | Refunds Shipping Lines Total Tax |
WooCommerce refund_tax_lines fields
The refund_tax_lines report of the WooCommerce connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| refunds__tax_lines__compound | BOOLEAN | Refunds Tax Lines Compound | Refunds Tax Lines Compound |
| refunds__tax_lines__id | TEXT | Refunds Tax Lines ID | Refunds Tax Lines ID |
| refunds__tax_lines__label | TEXT | Refunds Tax Lines Label | Refunds Tax Lines Label |
| refunds__tax_lines__meta_data | TEXT | Refunds Tax Lines Meta Data | Refunds Tax Lines Meta Data |
| refunds__tax_lines__rate_code | TEXT | Refunds Tax Lines Rate Code | Refunds Tax Lines Rate Code |
| refunds__tax_lines__rate_id | TEXT | Refunds Tax Lines Rate ID | Refunds Tax Lines Rate ID |
| refunds__tax_lines__rate_percent | PERCENT | Refunds Tax Lines Rate Percent | Refunds Tax Lines Rate Percent |
| refunds__tax_lines__shipping_tax_total | NUMERIC | Refunds Tax Lines Shipping Tax Total | Refunds Tax Lines Shipping Tax Total |
| refunds__tax_lines__tax_total | NUMERIC | Refunds Tax Lines Tax Total | Refunds Tax Lines Tax Total |
WooCommerce refunds fields
The refunds report of the WooCommerce connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| refunds__amount | NUMERIC | refunds.amount | refunds.amount |
| refunds__api_refund | BOOLEAN | refunds.api_refund | refunds.api_refund |
| refunds__date_created | DATE | refunds.date_created | refunds.date_created |
| refunds__date_created_gmt | DATE | refunds.date_created_gmt | refunds.date_created_gmt |
| refunds__id | TEXT | refunds.id | refunds.id |
| refunds__line_items | TEXT | refunds.line_items | refunds.line_items |
| refunds__meta_data | TEXT | refunds.meta_data | refunds.meta_data |
| refunds__reason | TEXT | refunds.reason | refunds.reason |
| refunds__refunded_by | NUMERIC | refunds.refunded_by | refunds.refunded_by |
| refunds__refunded_payment | BOOLEAN | refunds.refunded_payment | refunds.refunded_payment |
WooCommerce shipping_methods fields
The shipping_methods report of the WooCommerce connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| shipping_methods__description | TEXT | shipping_methods.description | shipping_methods.description |
| shipping_methods__id | TEXT | shipping_methods.id | shipping_methods.id |
| shipping_methods__title | TEXT | shipping_methods.title | shipping_methods.title |
WooCommerce shipping_zone_methods fields
The shipping_zone_methods report of the WooCommerce connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| shipping_zone_methods__enabled | BOOLEAN | shipping_zone_methods.enabled | shipping_zone_methods.enabled |
| shipping_zone_methods__instance_id | NUMERIC | shipping_zone_methods.instance_id | shipping_zone_methods.instance_id |
| shipping_zone_methods__method_description | TEXT | shipping_zone_methods.method_description | shipping_zone_methods.method_description |
| shipping_zone_methods__method_id | TEXT | shipping_zone_methods.method_id | shipping_zone_methods.method_id |
| shipping_zone_methods__method_title | TEXT | shipping_zone_methods.method_title | shipping_zone_methods.method_title |
| shipping_zone_methods__order | NUMERIC | shipping_zone_methods.order | shipping_zone_methods.order |
| shipping_zone_methods__settings | TEXT | shipping_zone_methods.settings | shipping_zone_methods.settings |
| shipping_zone_methods__title | TEXT | shipping_zone_methods.title | shipping_zone_methods.title |
WooCommerce shipping_zones fields
The shipping_zones report of the WooCommerce connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| shipping_zones__id | TEXT | shipping_zones.id | shipping_zones.id |
| shipping_zones__name | TEXT | shipping_zones.name | shipping_zones.name |
| shipping_zones__order | NUMERIC | shipping_zones.order | shipping_zones.order |
WooCommerce system_status_tools fields
The system_status_tools report of the WooCommerce connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| system_status_tools__action | TEXT | system_status_tools.action | system_status_tools.action |
| system_status_tools__confirm | BOOLEAN | system_status_tools.confirm | system_status_tools.confirm |
| system_status_tools__description | TEXT | system_status_tools.description | system_status_tools.description |
| system_status_tools__id | TEXT | system_status_tools.id | system_status_tools.id |
| system_status_tools__message | TEXT | system_status_tools.message | system_status_tools.message |
| system_status_tools__name | TEXT | system_status_tools.name | system_status_tools.name |
| system_status_tools__success | BOOLEAN | system_status_tools.success | system_status_tools.success |
WooCommerce tax_rates fields
The tax_rates report of the WooCommerce connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| tax_rates__cities | TEXT | tax_rates.cities | tax_rates.cities |
| tax_rates__city | CITY | tax_rates.city | tax_rates.city |
| tax_rates__class | TEXT | tax_rates.class | tax_rates.class |
| tax_rates__compound | BOOLEAN | tax_rates.compound | tax_rates.compound |
| tax_rates__country | COUNTRY | tax_rates.country | tax_rates.country |
| tax_rates__id | TEXT | tax_rates.id | tax_rates.id |
| tax_rates__name | TEXT | tax_rates.name | tax_rates.name |
| tax_rates__order | NUMERIC | tax_rates.order | tax_rates.order |
| tax_rates__postcode | TEXT | tax_rates.postcode | tax_rates.postcode |
| tax_rates__postcodes | TEXT | tax_rates.postcodes | tax_rates.postcodes |
| tax_rates__priority | NUMERIC | tax_rates.priority | tax_rates.priority |
| tax_rates__rate | TEXT | tax_rates.rate | tax_rates.rate |
| tax_rates__shipping | BOOLEAN | tax_rates.shipping | tax_rates.shipping |
| tax_rates__state | TEXT | tax_rates.state | tax_rates.state |
WooCommerce other fields
The WooCommerce connector has 22 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| shipping_zone_locations__code | TEXT | shipping_zone_locations.code | shipping_zone_locations.code | shipping_zone_locations |
| shipping_zone_locations__type | TEXT | shipping_zone_locations.type | shipping_zone_locations.type | shipping_zone_locations |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| tax_classes__name | TEXT | tax_classes.name | tax_classes.name | tax_classes |
| tax_classes__slug | TEXT | tax_classes.slug | tax_classes.slug | tax_classes |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |