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__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__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__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__set_paid | BOOLEAN | orders.set_paid | orders.set_paid | orders |
| orders__shipping | TEXT | orders.shipping | orders.shipping | orders |
| orders__shipping_lines | TEXT | orders.shipping_lines | orders.shipping_lines | 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__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__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 |
| 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 |