WooCommerce Connector Reference
The WooCommerce connector exposes 425 fields (73 metrics, 352 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available actions
Update Product Update a product in the connected WooCommerce store. product_id is the numeric ID from the Products table. Only the fields provided are changed, with one exception: if regular_price is set at or below the current sale price, WooCommerce clears sale_price and the sale ends. Prices are decimal strings with a dot, for example '19.99'. Send sale_price '' to end a sale. stock_quantity takes effect only when manage_stock is true. Variable products keep their prices and stock on their variations, which this action does not change. To revert, run update_product again with the previous values, including sale_price.
Update a product in the connected WooCommerce store. product_id is the numeric ID from the Products table. Only the fields provided are changed, with one exception: if regular_price is set at or below the current sale price, WooCommerce clears sale_price and the sale ends. Prices are decimal strings with a dot, for example '19.99'. Send sale_price '' to end a sale. stock_quantity takes effect only when manage_stock is true. Variable products keep their prices and stock on their variations, which this action does not change. To revert, run update_product again with the previous values, including sale_price.
Update Order Status Change the status of an order in the connected WooCommerce store. order_id is the numeric ID from the Orders table. WooCommerce sends its usual emails for the new status, for example the 'order completed' email to the customer. Status 'refunded' records a full refund in WooCommerce but does not return money through the payment gateway. A later status change keeps that refund, so delete the refund in the store admin to undo it. For any other status, run update_order_status again with the previous status to revert.
Change the status of an order in the connected WooCommerce store. order_id is the numeric ID from the Orders table. WooCommerce sends its usual emails for the new status, for example the 'order completed' email to the customer. Status 'refunded' records a full refund in WooCommerce but does not return money through the payment gateway. A later status change keeps that refund, so delete the refund in the store admin to undo it. For any other status, run update_order_status again with the previous status to revert.
Add Order Note Add a note to an order in the connected WooCommerce store. order_id is the numeric ID from the Orders table. A note with customer_note false is private to the store staff. With customer_note true, WooCommerce shows the note to the customer and emails it to them. Each call adds a new note. Delete a note in the store admin.
Add a note to an order in the connected WooCommerce store. order_id is the numeric ID from the Orders table. A note with customer_note false is private to the store staff. With customer_note true, WooCommerce shows the note to the customer and emails it to them. Each call adds a new note. Delete a note in the store admin.
Create Coupon Create a coupon in the connected WooCommerce store. Customers can use it at checkout as soon as it exists. discount_type 'percent' takes amount as a percentage, 'fixed_cart' as a sum off the cart, 'fixed_product' as a sum off each product. amount is a decimal string with a dot, for example '10' or '5.50'. The coupon stops working at 00:00 store time on date_expires. WooCommerce refuses a code that already exists. Change or delete the coupon in the store admin.
Create a coupon in the connected WooCommerce store. Customers can use it at checkout as soon as it exists. discount_type 'percent' takes amount as a percentage, 'fixed_cart' as a sum off the cart, 'fixed_product' as a sum off each product. amount is a decimal string with a dot, for example '10' or '5.50'. The coupon stops working at 00:00 store time on date_expires. WooCommerce refuses a code that already exists. Change or delete the coupon in the store admin.
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 |
