Windsor brings all your WooCommerce data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
WooCommerce Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| coupons___links | TEXT | coupons.links | coupons.links | coupons |
| coupons__amount | NUMERIC | coupons.amount | coupons.amount | coupons |
| coupons__code | TEXT | coupons.code | coupons.code | coupons |
| coupons__date_created | DATE | coupons.date_created | coupons.date_created | coupons |
| coupons__date_created_gmt | DATE | coupons.date_created_gmt | coupons.date_created_gmt | coupons |
| coupons__date_expires | DATE | coupons.date_expires | coupons.date_expires | coupons |
| coupons__date_expires_gmt | DATE | coupons.date_expires_gmt | coupons.date_expires_gmt | coupons |
| coupons__date_modified | DATE | coupons.date_modified | coupons.date_modified | coupons |
| coupons__date_modified_gmt | DATE | coupons.date_modified_gmt | coupons.date_modified_gmt | coupons |
| coupons__description | TEXT | coupons.description | coupons.description | coupons |
| coupons__discount_type | TEXT | coupons.discount_type | coupons.discount_type | coupons |
| coupons__email_restrictions | TEXT | coupons.email_restrictions | coupons.email_restrictions | coupons |
| coupons__exclude_sale_items | BOOLEAN | coupons.exclude_sale_items | coupons.exclude_sale_items | coupons |
| coupons__excluded_product_categories | TEXT | coupons.excluded_product_categories | coupons.excluded_product_categories | coupons |
| coupons__excluded_product_ids | TEXT | coupons.excluded_product_ids | coupons.excluded_product_ids | coupons |
| coupons__free_shipping | BOOLEAN | coupons.free_shipping | coupons.free_shipping | coupons |
| coupons__id | TEXT | coupons.id | coupons.id | coupons |
| coupons__individual_use | BOOLEAN | coupons.individual_use | coupons.individual_use | coupons |
| coupons__limit_usage_to_x_items | NUMERIC | coupons.limit_usage_to_x_items | coupons.limit_usage_to_x_items | coupons |
| coupons__maximum_amount | NUMERIC | coupons.maximum_amount | coupons.maximum_amount | coupons |
| coupons__meta_data | TEXT | coupons.meta_data | coupons.meta_data | coupons |
| coupons__minimum_amount | NUMERIC | coupons.minimum_amount | coupons.minimum_amount | coupons |
| coupons__product_categories | TEXT | coupons.product_categories | coupons.product_categories | coupons |
| coupons__product_ids | TEXT | coupons.product_ids | coupons.product_ids | coupons |
| coupons__shop_url | TEXT | coupons.shop_url | coupons.shop_url | coupons |
| coupons__usage_count | NUMERIC | coupons.usage_count | coupons.usage_count | coupons |
| coupons__usage_limit | NUMERIC | coupons.usage_limit | coupons.usage_limit | coupons |
| coupons__usage_limit_per_user | NUMERIC | coupons.usage_limit_per_user | coupons.usage_limit_per_user | coupons |
| coupons__used_by | TEXT | coupons.used_by | coupons.used_by | coupons |
| customers___links | TEXT | customers.links | customers.links | customers |
| customers__avatar_url | TEXT | customers.avatar_url | customers.avatar_url | customers |
| customers__billing | TEXT | customers.billing | customers.billing | customers |
| customers__date_created | DATE | customers.date_created | customers.date_created | customers |
| customers__date_created_gmt | DATE | customers.date_created_gmt | customers.date_created_gmt | customers |
| customers__date_modified | DATE | customers.date_modified | customers.date_modified | customers |
| customers__date_modified_gmt | DATE | customers.date_modified_gmt | customers.date_modified_gmt | customers |
| customers__email | TEXT | customers.email | customers.email | customers |
| customers__first_name | TEXT | customers.first_name | customers.first_name | customers |
| customers__id | TEXT | customers.id | customers.id | customers |
| customers__is_paying_customer | BOOLEAN | customers.is_paying_customer | customers.is_paying_customer | customers |
| customers__last_name | TEXT | customers.last_name | customers.last_name | customers |
| customers__meta_data | TEXT | customers.meta_data | customers.meta_data | customers |
| customers__role | TEXT | customers.role | customers.role | customers |
| customers__shipping | TEXT | customers.shipping | customers.shipping | customers |
| customers__shop_url | TEXT | customers.shop_url | customers.shop_url | customers |
| customers__username | TEXT | customers.username | customers.username | customers |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| order_notes__added_by_user | BOOLEAN | order_notes.added_by_user | order_notes.added_by_user | order_notes |
| order_notes__author | TEXT | order_notes.author | order_notes.author | order_notes |
| order_notes__custom_note | BOOLEAN | order_notes.custom_note | order_notes.custom_note | order_notes |
| order_notes__date_created | DATE | order_notes.date_created | order_notes.date_created | order_notes |
| order_notes__date_created_gmt | DATE | order_notes.date_created_gmt | order_notes.date_created_gmt | order_notes |
| order_notes__id | TEXT | order_notes.id | order_notes.id | order_notes |
| order_notes__note | TEXT | order_notes.note | order_notes.note | order_notes |
| orders___links | TEXT | orders.links | orders.links | orders |
| orders__billing | TEXT | orders.billing | orders.billing | orders |
| orders__billing__address_1 | TEXT | Orders Billing Address 1 | Orders Billing Address 1 | orders |
| orders__billing__address_2 | TEXT | Orders Billing Address 2 | Orders Billing Address 2 | orders |
| orders__billing__city | TEXT | Orders Billing City | Orders Billing City | orders |
| orders__billing__company | TEXT | Orders Billing Company | Orders Billing Company | orders |
| orders__billing__country | TEXT | Orders Billing Country | Orders Billing Country | orders |
| orders__billing__email | TEXT | Orders Billing Email | Orders Billing Email | orders |
| orders__billing__first_name | TEXT | Orders Billing First Name | Orders Billing First Name | orders |
| orders__billing__last_name | TEXT | Orders Billing Last Name | Orders Billing Last Name | orders |
| orders__billing__phone | TEXT | Orders Billing Phone | Orders Billing Phone | orders |
| orders__billing__postcode | TEXT | Orders Billing Postcode | Orders Billing Postcode | orders |
| orders__billing__state | TEXT | Orders Billing State | Orders Billing State | orders |
| orders__cart_hash | TEXT | orders.cart_hash | orders.cart_hash | orders |
| orders__cart_tax | NUMERIC | orders.cart_tax | orders.cart_tax | orders |
| orders__coupon_lines | TEXT | orders.coupon_lines | orders.coupon_lines | orders |
| orders__coupon_lines__code | TEXT | Order Coupon Lines Code | Order Coupon Lines Code | orders |
| orders__coupon_lines__discount | NUMERIC | Order Coupon Lines Discount | Order Coupon Lines Discount | orders |
| orders__coupon_lines__discount_tax | NUMERIC | Order Coupon Lines Discount Tax | Order Coupon Lines Discount Tax | orders |
| orders__coupon_lines__id | TEXT | Order Coupon Lines ID | Order Coupon Lines ID | orders |
| orders__created_via | TEXT | orders.created_via | orders.created_via | orders |
| orders__currency | TEXT | orders.currency | orders.currency | orders |
| orders__customer_id | NUMERIC | orders.customer_id | orders.customer_id | orders |
| orders__customer_ip_address | TEXT | orders.customer_ip_address | orders.customer_ip_address | orders |
| orders__customer_note | TEXT | orders.customer_note | orders.customer_note | orders |
| orders__customer_user_agent | TEXT | orders.customer_user_agent | orders.customer_user_agent | orders |
| orders__date_completed | DATE | orders.date_completed | orders.date_completed | orders |
| orders__date_completed_gmt | DATE | orders.date_completed_gmt | orders.date_completed_gmt | orders |
| orders__date_created | DATE | orders.date_created | orders.date_created | orders |
| orders__date_created_gmt | DATE | orders.date_created_gmt | orders.date_created_gmt | orders |
| orders__date_modified | DATE | orders.date_modified | orders.date_modified | orders |
| orders__date_modified_gmt | DATE | orders.date_modified_gmt | orders.date_modified_gmt | orders |
| orders__date_paid | DATE | orders.date_paid | orders.date_paid | orders |
| orders__date_paid_gmt | DATE | orders.date_paid_gmt | orders.date_paid_gmt | orders |
| orders__discount_tax | NUMERIC | orders.discount_tax | orders.discount_tax | orders |
| orders__discount_total | NUMERIC | orders.discount_total | orders.discount_total | orders |
| orders__fee_lines | TEXT | orders.fee_lines | orders.fee_lines | orders |
| orders__id | TEXT | orders.id | orders.id | orders |
| orders__line_items | TEXT | orders.line_items | orders.line_items | orders |
| orders__line_items__id | TEXT | Order Line Item ID | Order Line Item ID | orders |
| orders__line_items__image__id | TEXT | Order Line Item Image ID | Order Line Item Image ID | orders |
| orders__line_items__image__src | IMAGE_URL | Order Line Item Image | Order Line Item Image | orders |
| orders__line_items__name | TEXT | Order Line Item Name | Order Line Item Name | orders |
| orders__line_items__parent_name | TEXT | Order Line Item Parent Name | Order Line Item Parent Name | orders |
| orders__line_items__price | NUMERIC | Order Line Item Price | Order Line Item Price | orders |
| orders__line_items__product_id | TEXT | Order Line Item Product ID | Order Line Item Product ID | orders |
| orders__line_items__quantity | NUMERIC | Order Line Item Quantity | Order Line Item Quantity | orders |
| orders__line_items__sku | TEXT | Order Line Item SKU | Order Line Item SKU | orders |
| orders__line_items__subtotal | NUMERIC | Order Line Item Subtotal | Order Line Item Subtotal | orders |
| orders__line_items__subtotal_tax | NUMERIC | Order Line Item Subtotal Tax | Order Line Item Subtotal Tax | orders |
| orders__line_items__tax_class | TEXT | Order Line Item Tax Class | Order Line Item Tax Class | orders |
| orders__line_items__total | NUMERIC | Order Line Item Total | Order Line Item Total | orders |
| orders__line_items__total_tax | NUMERIC | Order Line Item Total Tax | Order Line Item Total Tax | orders |
| orders__line_items__variation_id | TEXT | Order Line Item Variation ID | Order Line Item Variation ID | orders |
| orders__meta_data | TEXT | orders.meta_data | orders.meta_data | orders |
| orders__number | TEXT | orders.number | orders.number | orders |
| orders__order_key | TEXT | orders.order_key | orders.order_key | orders |
| orders__parent_id | NUMERIC | orders.parent_id | orders.parent_id | orders |
| orders__payment_method | TEXT | orders.payment_method | orders.payment_method | orders |
| orders__payment_method_title | TEXT | orders.payment_method_title | orders.payment_method_title | orders |
| orders__prices_include_tax | BOOLEAN | orders.prices_include_tax | orders.prices_include_tax | orders |
| orders__refunds | TEXT | orders.refunds | orders.refunds | orders |
| orders__refunds__id | TEXT | Orders Refunds ID | Order Refunds ID | orders |
| orders__refunds__reason | TEXT | Orders Refunds Reason | Order Refunds Reason | orders |
| orders__refunds__total | NUMERIC | Orders Refunds Total | Order Refunds Total | orders |
| orders__set_paid | BOOLEAN | orders.set_paid | orders.set_paid | orders |
| orders__shipping | TEXT | orders.shipping | orders.shipping | orders |
| orders__shipping__address_1 | TEXT | Orders Shipping Address 1 | Orders Shipping Address 1 | orders |
| orders__shipping__address_2 | TEXT | Orders Shipping Address 2 | Orders Shipping Address 2 | orders |
| orders__shipping__city | TEXT | Orders Shipping City | Orders Shipping City | orders |
| orders__shipping__company | TEXT | Orders Shipping Company | Orders Shipping Company | orders |
| orders__shipping__country | TEXT | Orders Shipping Country | Orders Shipping Country | orders |
| orders__shipping__first_name | TEXT | Orders Shipping First Name | Orders Shipping First Name | orders |
| orders__shipping__last_name | TEXT | Orders Shipping Last Name | Orders Shipping Last Name | orders |
| orders__shipping__phone | TEXT | Orders Shipping Phone | Orders Shipping Phone | orders |
| orders__shipping__postcode | TEXT | Orders Shipping Postcode | Orders Shipping Postcode | orders |
| orders__shipping__state | TEXT | Orders Shipping State | Orders Shipping State | orders |
| orders__shipping_lines | TEXT | orders.shipping_lines | orders.shipping_lines | orders |
| orders__shipping_lines__id | TEXT | Orders Shipping Lines ID | Orders Shipping Lines ID | orders |
| orders__shipping_lines__instance_id | TEXT | Orders Shipping Lines Instance ID | Orders Shipping Lines Instance ID | orders |
| orders__shipping_lines__meta_data | TEXT | Orders Shipping Lines Meta Data | Orders Shipping Lines Meta Data | orders |
| orders__shipping_lines__method_id | TEXT | Orders Shipping Lines Method ID | Orders Shipping Lines Method ID | orders |
| orders__shipping_lines__method_title | TEXT | Orders Shipping Lines Method Title | Orders Shipping Lines Method Title | orders |
| orders__shipping_lines__total | NUMERIC | Orders Shipping Lines Total | Orders Shipping Lines Total | orders |
| orders__shipping_lines__total_tax | NUMERIC | Orders Shipping Lines Total Tax | Orders Shipping Lines Total Tax | orders |
| orders__shipping_tax | NUMERIC | orders.shipping_tax | orders.shipping_tax | orders |
| orders__shipping_total | NUMERIC | orders.shipping_total | orders.shipping_total | orders |
| orders__shop_url | TEXT | orders.shop_url | orders.shop_url | orders |
| orders__status | TEXT | orders.status | orders.status | orders |
| orders__tax_lines | TEXT | orders.tax_lines | orders.tax_lines | orders |
| orders__tax_lines__compound | BOOLEAN | Orders Tax Lines Compound | Orders Tax Lines Compound | orders |
| orders__tax_lines__id | TEXT | Orders Tax Lines ID | Orders Tax Lines ID | orders |
| orders__tax_lines__label | TEXT | Orders Tax Lines Label | Orders Tax Lines Label | orders |
| orders__tax_lines__meta_data | TEXT | Orders Tax Lines Meta Data | Orders Tax Lines Meta Data | orders |
| orders__tax_lines__rate_code | TEXT | Orders Tax Lines Rate Code | Orders Tax Lines Rate Code | orders |
| orders__tax_lines__rate_id | TEXT | Orders Tax Lines Rate ID | Orders Tax Lines Rate ID | orders |
| orders__tax_lines__rate_percent | PERCENT | Orders Tax Lines Rate Percent | Orders Tax Lines Rate Percent | orders |
| orders__tax_lines__shipping_tax_total | NUMERIC | Orders Tax Lines Shipping Tax Total | Orders Tax Lines Shipping Tax Total | orders |
| orders__tax_lines__tax_total | NUMERIC | Orders Tax Lines Tax Total | Orders Tax Lines Tax Total | orders |
| orders__total | NUMERIC | orders.total | orders.total | orders |
| orders__total_tax | NUMERIC | orders.total_tax | orders.total_tax | orders |
| orders__transaction_id | TEXT | orders.transaction_id | orders.transaction_id | orders |
| orders__version | TEXT | orders.version | orders.version | orders |
| payment_gateways__description | TEXT | payment_gateways.description | payment_gateways.description | payment_gateways |
| payment_gateways__enabled | BOOLEAN | payment_gateways.enabled | payment_gateways.enabled | payment_gateways |
| payment_gateways__id | TEXT | payment_gateways.id | payment_gateways.id | payment_gateways |
| payment_gateways__method_description | TEXT | payment_gateways.method_description | payment_gateways.method_description | payment_gateways |
| payment_gateways__method_supports | TEXT | payment_gateways.method_supports | payment_gateways.method_supports | payment_gateways |
| payment_gateways__method_title | TEXT | payment_gateways.method_title | payment_gateways.method_title | payment_gateways |
| payment_gateways__order | NUMERIC | payment_gateways.order | payment_gateways.order | payment_gateways |
| payment_gateways__settings | TEXT | payment_gateways.settings | payment_gateways.settings | payment_gateways |
| payment_gateways__title | TEXT | payment_gateways.title | payment_gateways.title | payment_gateways |
| product_attribute_terms__count | NUMERIC | product_attribute_terms.count | product_attribute_terms.count | product_attribute_terms |
| product_attribute_terms__description | TEXT | product_attribute_terms.description | product_attribute_terms.description | product_attribute_terms |
| product_attribute_terms__id | TEXT | product_attribute_terms.id | product_attribute_terms.id | product_attribute_terms |
| product_attribute_terms__menu_order | NUMERIC | product_attribute_terms.menu_order | product_attribute_terms.menu_order | product_attribute_terms |
| product_attribute_terms__name | TEXT | product_attribute_terms.name | product_attribute_terms.name | product_attribute_terms |
| product_attribute_terms__slug | TEXT | product_attribute_terms.slug | product_attribute_terms.slug | product_attribute_terms |
| product_attributes__has_archives | BOOLEAN | product_attributes.has_archives | product_attributes.has_archives | product_attributes |
| product_attributes__id | TEXT | product_attributes.id | product_attributes.id | product_attributes |
| product_attributes__name | TEXT | product_attributes.name | product_attributes.name | product_attributes |
| product_attributes__order_by | TEXT | product_attributes.order_by | product_attributes.order_by | product_attributes |
| product_attributes__slug | TEXT | product_attributes.slug | product_attributes.slug | product_attributes |
| product_attributes__type | TEXT | product_attributes.type | product_attributes.type | product_attributes |
| product_categories__count | NUMERIC | product_categories.count | product_categories.count | product_categories |
| product_categories__description | TEXT | product_categories.description | product_categories.description | product_categories |
| product_categories__display | TEXT | product_categories.display | product_categories.display | product_categories |
| product_categories__id | TEXT | product_categories.id | product_categories.id | product_categories |
| product_categories__image | TEXT | product_categories.image | product_categories.image | product_categories |
| product_categories__menu_order | NUMERIC | product_categories.menu_order | product_categories.menu_order | product_categories |
| product_categories__name | TEXT | product_categories.name | product_categories.name | product_categories |
| product_categories__parent | NUMERIC | product_categories.parent | product_categories.parent | product_categories |
| product_categories__slug | TEXT | product_categories.slug | product_categories.slug | product_categories |
| product_reviews__date_created | DATE | product_reviews.date_created | product_reviews.date_created | product_reviews |
| product_reviews__date_created_gmt | DATE | product_reviews.date_created_gmt | product_reviews.date_created_gmt | product_reviews |
| product_reviews__id | TEXT | product_reviews.id | product_reviews.id | product_reviews |
| product_reviews__product_id | NUMERIC | product_reviews.product_id | product_reviews.product_id | product_reviews |
| product_reviews__rating | NUMERIC | product_reviews.rating | product_reviews.rating | product_reviews |
| product_reviews__review | TEXT | product_reviews.review | product_reviews.review | product_reviews |
| product_reviews__reviewer | TEXT | product_reviews.reviewer | product_reviews.reviewer | product_reviews |
| product_reviews__reviewer_email | TEXT | product_reviews.reviewer_email | product_reviews.reviewer_email | product_reviews |
| product_reviews__status | TEXT | product_reviews.status | product_reviews.status | product_reviews |
| product_reviews__verified | BOOLEAN | product_reviews.verified | product_reviews.verified | product_reviews |
| product_shipping_classes__count | NUMERIC | product_shipping_classes.count | product_shipping_classes.count | product_shipping_classes |
| product_shipping_classes__description | TEXT | product_shipping_classes.description | product_shipping_classes.description | product_shipping_classes |
| product_shipping_classes__id | TEXT | product_shipping_classes.id | product_shipping_classes.id | product_shipping_classes |
| product_shipping_classes__name | TEXT | product_shipping_classes.name | product_shipping_classes.name | product_shipping_classes |
| product_shipping_classes__slug | TEXT | product_shipping_classes.slug | product_shipping_classes.slug | product_shipping_classes |
| product_tags__count | NUMERIC | product_tags.count | product_tags.count | product_tags |
| product_tags__description | TEXT | product_tags.description | product_tags.description | product_tags |
| product_tags__id | TEXT | product_tags.id | product_tags.id | product_tags |
| product_tags__name | TEXT | product_tags.name | product_tags.name | product_tags |
| product_tags__slug | TEXT | product_tags.slug | product_tags.slug | product_tags |
| product_variations__attributes | TEXT | product_variations.attributes | product_variations.attributes | product_variations |
| product_variations__backordered | BOOLEAN | product_variations.backordered | product_variations.backordered | product_variations |
| product_variations__backorders | TEXT | product_variations.backorders | product_variations.backorders | product_variations |
| product_variations__backorders_allowed | BOOLEAN | product_variations.backorders_allowed | product_variations.backorders_allowed | product_variations |
| product_variations__date_created | DATE | product_variations.date_created | product_variations.date_created | product_variations |
| product_variations__date_created_gmt | DATE | product_variations.date_created_gmt | product_variations.date_created_gmt | product_variations |
| product_variations__date_modified | DATE | product_variations.date_modified | product_variations.date_modified | product_variations |
| product_variations__date_modified_gmt | DATE | product_variations.date_modified_gmt | product_variations.date_modified_gmt | product_variations |
| product_variations__date_on_sale_from | DATE | product_variations.date_on_sale_from | product_variations.date_on_sale_from | product_variations |
| product_variations__date_on_sale_from_gmt | DATE | product_variations.date_on_sale_from_gmt | product_variations.date_on_sale_from_gmt | product_variations |
| product_variations__date_on_sale_to | DATE | product_variations.date_on_sale_to | product_variations.date_on_sale_to | product_variations |
| product_variations__date_on_sale_to_gmt | DATE | product_variations.date_on_sale_to_gmt | product_variations.date_on_sale_to_gmt | product_variations |
| product_variations__description | TEXT | product_variations.description | product_variations.description | product_variations |
| product_variations__dimensions | TEXT | product_variations.dimensions | product_variations.dimensions | product_variations |
| product_variations__download_expiry | NUMERIC | product_variations.download_expiry | product_variations.download_expiry | product_variations |
| product_variations__download_limit | NUMERIC | product_variations.download_limit | product_variations.download_limit | product_variations |
| product_variations__downloadable | BOOLEAN | product_variations.downloadable | product_variations.downloadable | product_variations |
| product_variations__downloads | TEXT | product_variations.downloads | product_variations.downloads | product_variations |
| product_variations__id | TEXT | product_variations.id | product_variations.id | product_variations |
| product_variations__image | TEXT | product_variations.image | product_variations.image | product_variations |
| product_variations__manage_stock | TEXT | product_variations.manage_stock | product_variations.manage_stock | product_variations |
| product_variations__menu_order | NUMERIC | product_variations.menu_order | product_variations.menu_order | product_variations |
| product_variations__meta_data | TEXT | product_variations.meta_data | product_variations.meta_data | product_variations |
| product_variations__on_sale | BOOLEAN | product_variations.on_sale | product_variations.on_sale | product_variations |
| product_variations__permalink | TEXT | product_variations.permalink | product_variations.permalink | product_variations |
| product_variations__price | TEXT | product_variations.price | product_variations.price | product_variations |
| product_variations__purchasable | BOOLEAN | product_variations.purchasable | product_variations.purchasable | product_variations |
| product_variations__regular_price | TEXT | product_variations.regular_price | product_variations.regular_price | product_variations |
| product_variations__sale_price | TEXT | product_variations.sale_price | product_variations.sale_price | product_variations |
| product_variations__shipping_class | TEXT | product_variations.shipping_class | product_variations.shipping_class | product_variations |
| product_variations__shipping_class_id | NUMERIC | product_variations.shipping_class_id | product_variations.shipping_class_id | product_variations |
| product_variations__sku | TEXT | product_variations.sku | product_variations.sku | product_variations |
| product_variations__status | TEXT | product_variations.status | product_variations.status | product_variations |
| product_variations__stock_quantity | NUMERIC | product_variations.stock_quantity | product_variations.stock_quantity | product_variations |
| product_variations__stock_status | TEXT | product_variations.stock_status | product_variations.stock_status | product_variations |
| product_variations__tax_class | TEXT | product_variations.tax_class | product_variations.tax_class | product_variations |
| product_variations__tax_status | TEXT | product_variations.tax_status | product_variations.tax_status | product_variations |
| product_variations__virtual | BOOLEAN | product_variations.virtual | product_variations.virtual | product_variations |
| product_variations__weight | TEXT | product_variations.weight | product_variations.weight | product_variations |
| products__attributes | TEXT | products.attributes | products.attributes | products |
| products__average_rating | TEXT | products.average_rating | products.average_rating | products |
| products__backordered | BOOLEAN | products.backordered | products.backordered | products |
| products__backorders | TEXT | products.backorders | products.backorders | products |
| products__backorders_allowed | BOOLEAN | products.backorders_allowed | products.backorders_allowed | products |
| products__button_text | TEXT | products.button_text | products.button_text | products |
| products__catalog_visibility | TEXT | products.catalog_visibility | products.catalog_visibility | products |
| products__categories | TEXT | products.categories | products.categories | products |
| products__cross_sell_ids | TEXT | products.cross_sell_ids | products.cross_sell_ids | products |
| products__date_created | DATE | products.date_created | products.date_created | products |
| products__date_created_gmt | DATE | products.date_created_gmt | products.date_created_gmt | products |
| products__date_modified | DATE | products.date_modified | products.date_modified | products |
| products__date_modified_gmt | DATE | products.date_modified_gmt | products.date_modified_gmt | products |
| products__date_on_sale_from | DATE | products.date_on_sale_from | products.date_on_sale_from | products |
| products__date_on_sale_from_gmt | DATE | products.date_on_sale_from_gmt | products.date_on_sale_from_gmt | products |
| products__date_on_sale_to | DATE | products.date_on_sale_to | products.date_on_sale_to | products |
| products__date_on_sale_to_gmt | DATE | products.date_on_sale_to_gmt | products.date_on_sale_to_gmt | products |
| products__default_attributes | TEXT | products.default_attributes | products.default_attributes | products |
| products__description | TEXT | products.description | products.description | products |
| products__dimensions | TEXT | products.dimensions | products.dimensions | products |
| products__download_expiry | NUMERIC | products.download_expiry | products.download_expiry | products |
| products__download_limit | NUMERIC | products.download_limit | products.download_limit | products |
| products__downloadable | BOOLEAN | products.downloadable | products.downloadable | products |
| products__downloads | TEXT | products.downloads | products.downloads | products |
| products__external_url | TEXT | products.external_url | products.external_url | products |
| products__features | BOOLEAN | products.features | products.features | products |
| products__grouped_products | TEXT | products.grouped_products | products.grouped_products | products |
| products__id | TEXT | products.id | products.id | products |
| products__images | TEXT | products.images | products.images | products |
| products__jetpack-related-posts | TEXT | products.jetpack-related-posts | products.jetpack-related-posts | products |
| products__manage_stock | BOOLEAN | products.manage_stock | products.manage_stock | products |
| products__menu_order | NUMERIC | products.menu_order | products.menu_order | products |
| products__meta_data | TEXT | products.meta_data | products.meta_data | products |
| products__name | TEXT | products.name | products.name | products |
| products__on_sale | BOOLEAN | products.on_sale | products.on_sale | products |
| products__parent_id | NUMERIC | products.parent_id | products.parent_id | products |
| products__permalink | TEXT | products.permalink | products.permalink | products |
| products__price | TEXT | products.price | products.price | products |
| products__price_html | TEXT | products.price_html | products.price_html | products |
| products__purchasable | BOOLEAN | products.purchasable | products.purchasable | products |
| products__purchase_note | TEXT | products.purchase_note | products.purchase_note | products |
| products__rating_count | NUMERIC | products.rating_count | products.rating_count | products |
| products__regular_price | TEXT | products.regular_price | products.regular_price | products |
| products__related_ids | TEXT | products.related_ids | products.related_ids | products |
| products__reviews_allowed | BOOLEAN | products.reviews_allowed | products.reviews_allowed | products |
| products__sale_price | TEXT | products.sale_price | products.sale_price | products |
| products__shipping_class | TEXT | products.shipping_class | products.shipping_class | products |
| products__shipping_class_id | NUMERIC | products.shipping_class_id | products.shipping_class_id | products |
| products__shipping_required | BOOLEAN | products.shipping_required | products.shipping_required | products |
| products__shipping_taxable | BOOLEAN | products.shipping_taxable | products.shipping_taxable | products |
| products__short_description | TEXT | products.short_description | products.short_description | products |
| products__sku | TEXT | products.sku | products.sku | products |
| products__slug | TEXT | products.slug | products.slug | products |
| products__sold_individually | BOOLEAN | products.sold_individually | products.sold_individually | products |
| products__status | TEXT | products.status | products.status | products |
| products__stock_quantity | NUMERIC | products.stock_quantity | products.stock_quantity | products |
| products__stock_status | TEXT | products.stock_status | products.stock_status | products |
| products__tags | TEXT | products.tags | products.tags | products |
| products__tax_class | TEXT | products.tax_class | products.tax_class | products |
| products__tax_status | TEXT | products.tax_status | products.tax_status | products |
| products__total_sales | NUMERIC | products.total_sales | products.total_sales | products |
| products__type | TEXT | products.type | products.type | products |
| products__upsell_ids | TEXT | products.upsell_ids | products.upsell_ids | products |
| products__variations | TEXT | products.variations | products.variations | products |
| products__virtual | BOOLEAN | products.virtual | products.virtual | products |
| products__weight | TEXT | products.weight | products.weight | products |
| refunds__amount | NUMERIC | refunds.amount | refunds.amount | refunds |
| refunds__api_refund | BOOLEAN | refunds.api_refund | refunds.api_refund | refunds |
| refunds__date_created | DATE | refunds.date_created | refunds.date_created | refunds |
| refunds__date_created_gmt | DATE | refunds.date_created_gmt | refunds.date_created_gmt | refunds |
| refunds__id | TEXT | refunds.id | refunds.id | refunds |
| refunds__line_items | TEXT | refunds.line_items | refunds.line_items | refunds |
| refunds__line_items__id | TEXT | Refunds Line Items ID | Refunds Line Items ID | refunds |
| refunds__line_items__image__id | TEXT | Refunds Line Items Image ID | Refunds Line Items Image ID | refunds |
| refunds__line_items__image__src | IMAGE_URL | Refunds Line Items Image | Refunds Line Items Image | refunds |
| refunds__line_items__name | TEXT | Refunds Line Items Name | Refunds Line Items Name | refunds |
| refunds__line_items__parent_name | TEXT | Refunds Line Items Parent Name | Refunds Line Items Parent Name | refunds |
| refunds__line_items__price | NUMERIC | Refunds Line Items Price | Refunds Line Items Price | refunds |
| refunds__line_items__product_id | TEXT | Refunds Line Items Product ID | Refunds Line Items Product ID | refunds |
| refunds__line_items__quantity | NUMERIC | Refunds Line Items Quantity | Refunds Line Items Quantity | refunds |
| refunds__line_items__sku | TEXT | Refunds Line Items Sku | Refunds Line Items Sku | refunds |
| refunds__line_items__subtotal | NUMERIC | Refunds Line Items Subtotal | Refunds Line Items Subtotal | refunds |
| refunds__line_items__subtotal_tax | NUMERIC | Refunds Line Items Subtotal Tax | Refunds Line Items Subtotal Tax | refunds |
| refunds__line_items__tax_class | TEXT | Refunds Line Items Tax Class | Refunds Line Items Tax Class | refunds |
| refunds__line_items__total | NUMERIC | Refunds Line Items Total | Refunds Line Items Total | refunds |
| refunds__line_items__total_tax | NUMERIC | Refunds Line Items Total Tax | Refunds Line Items Total Tax | refunds |
| refunds__line_items__variation_id | TEXT | Refunds Line Items Variation ID | Refunds Line Items Variation ID | refunds |
| refunds__meta_data | TEXT | refunds.meta_data | refunds.meta_data | refunds |
| refunds__reason | TEXT | refunds.reason | refunds.reason | refunds |
| refunds__refunded_by | NUMERIC | refunds.refunded_by | refunds.refunded_by | refunds |
| refunds__refunded_payment | BOOLEAN | refunds.refunded_payment | refunds.refunded_payment | refunds |
| refunds__shipping_lines__id | TEXT | Refunds Shipping Lines ID | Refunds Shipping Lines ID | refunds |
| refunds__shipping_lines__instance_id | TEXT | Refunds Shipping Lines Instance ID | Refunds Shipping Lines Instance ID | refunds |
| refunds__shipping_lines__meta_data | TEXT | Refunds Shipping Lines Meta Data | Refunds Shipping Lines Meta Data | refunds |
| refunds__shipping_lines__method_id | TEXT | Refunds Shipping Lines Method ID | Refunds Shipping Lines Method ID | refunds |
| refunds__shipping_lines__method_title | TEXT | Refunds Shipping Lines Method Title | Refunds Shipping Lines Method Title | refunds |
| refunds__shipping_lines__total | NUMERIC | Refunds Shipping Lines Total | Refunds Shipping Lines Total | refunds |
| refunds__shipping_lines__total_tax | NUMERIC | Refunds Shipping Lines Total Tax | Refunds Shipping Lines Total Tax | refunds |
| refunds__tax_lines__compound | BOOLEAN | Refunds Tax Lines Compound | Refunds Tax Lines Compound | refunds |
| refunds__tax_lines__id | TEXT | Refunds Tax Lines ID | Refunds Tax Lines ID | refunds |
| refunds__tax_lines__label | TEXT | Refunds Tax Lines Label | Refunds Tax Lines Label | refunds |
| refunds__tax_lines__meta_data | TEXT | Refunds Tax Lines Meta Data | Refunds Tax Lines Meta Data | refunds |
| refunds__tax_lines__rate_code | TEXT | Refunds Tax Lines Rate Code | Refunds Tax Lines Rate Code | refunds |
| refunds__tax_lines__rate_id | TEXT | Refunds Tax Lines Rate ID | Refunds Tax Lines Rate ID | refunds |
| refunds__tax_lines__rate_percent | PERCENT | Refunds Tax Lines Rate Percent | Refunds Tax Lines Rate Percent | refunds |
| refunds__tax_lines__shipping_tax_total | NUMERIC | Refunds Tax Lines Shipping Tax Total | Refunds Tax Lines Shipping Tax Total | refunds |
| refunds__tax_lines__tax_total | NUMERIC | Refunds Tax Lines Tax Total | Refunds Tax Lines Tax Total | refunds |
| shipping_methods__description | TEXT | shipping_methods.description | shipping_methods.description | shipping_methods |
| shipping_methods__id | TEXT | shipping_methods.id | shipping_methods.id | shipping_methods |
| shipping_methods__title | TEXT | shipping_methods.title | shipping_methods.title | shipping_methods |
| 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 |
| shipping_zone_methods__enabled | BOOLEAN | shipping_zone_methods.enabled | shipping_zone_methods.enabled | shipping_zone_methods |
| shipping_zone_methods__instance_id | NUMERIC | shipping_zone_methods.instance_id | shipping_zone_methods.instance_id | shipping_zone_methods |
| shipping_zone_methods__method_description | TEXT | shipping_zone_methods.method_description | shipping_zone_methods.method_description | shipping_zone_methods |
| shipping_zone_methods__method_id | TEXT | shipping_zone_methods.method_id | shipping_zone_methods.method_id | shipping_zone_methods |
| shipping_zone_methods__method_title | TEXT | shipping_zone_methods.method_title | shipping_zone_methods.method_title | shipping_zone_methods |
| shipping_zone_methods__order | NUMERIC | shipping_zone_methods.order | shipping_zone_methods.order | shipping_zone_methods |
| shipping_zone_methods__settings | TEXT | shipping_zone_methods.settings | shipping_zone_methods.settings | shipping_zone_methods |
| shipping_zone_methods__title | TEXT | shipping_zone_methods.title | shipping_zone_methods.title | shipping_zone_methods |
| shipping_zones__id | TEXT | shipping_zones.id | shipping_zones.id | shipping_zones |
| shipping_zones__name | TEXT | shipping_zones.name | shipping_zones.name | shipping_zones |
| shipping_zones__order | NUMERIC | shipping_zones.order | shipping_zones.order | shipping_zones |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| system_status_tools__action | TEXT | system_status_tools.action | system_status_tools.action | system_status_tools |
| system_status_tools__confirm | BOOLEAN | system_status_tools.confirm | system_status_tools.confirm | system_status_tools |
| system_status_tools__description | TEXT | system_status_tools.description | system_status_tools.description | system_status_tools |
| system_status_tools__id | TEXT | system_status_tools.id | system_status_tools.id | system_status_tools |
| system_status_tools__message | TEXT | system_status_tools.message | system_status_tools.message | system_status_tools |
| system_status_tools__name | TEXT | system_status_tools.name | system_status_tools.name | system_status_tools |
| system_status_tools__success | BOOLEAN | system_status_tools.success | system_status_tools.success | system_status_tools |
| tax_classes__name | TEXT | tax_classes.name | tax_classes.name | tax_classes |
| tax_classes__slug | TEXT | tax_classes.slug | tax_classes.slug | tax_classes |
| tax_rates__cities | TEXT | tax_rates.cities | tax_rates.cities | tax_rates |
| tax_rates__city | CITY | tax_rates.city | tax_rates.city | tax_rates |
| tax_rates__class | TEXT | tax_rates.class | tax_rates.class | tax_rates |
| tax_rates__compound | BOOLEAN | tax_rates.compound | tax_rates.compound | tax_rates |
| tax_rates__country | COUNTRY | tax_rates.country | tax_rates.country | tax_rates |
| tax_rates__id | TEXT | tax_rates.id | tax_rates.id | tax_rates |
| tax_rates__name | TEXT | tax_rates.name | tax_rates.name | tax_rates |
| tax_rates__order | NUMERIC | tax_rates.order | tax_rates.order | tax_rates |
| tax_rates__postcode | TEXT | tax_rates.postcode | tax_rates.postcode | tax_rates |
| tax_rates__postcodes | TEXT | tax_rates.postcodes | tax_rates.postcodes | tax_rates |
| tax_rates__priority | NUMERIC | tax_rates.priority | tax_rates.priority | tax_rates |
| tax_rates__rate | TEXT | tax_rates.rate | tax_rates.rate | tax_rates |
| tax_rates__shipping | BOOLEAN | tax_rates.shipping | tax_rates.shipping | tax_rates |
| tax_rates__state | TEXT | tax_rates.state | tax_rates.state | tax_rates |
| today | DATE | Today | Today's date |