WooCommerce fields list

Fields reference

Id	Name	Type	DataType
date	Date	dimension	string
time	Time	dimension	string
hour	Hour	dimension	string
isoweek	Week (Mon-Sun)	dimension	string
week	Week (Sun-Sat)	dimension	string
nth_isoweek	Nth Week (Mon-Sun)	dimension	string
nth_week	Nth Week (Sun-Sat)	dimension	string
month	Month	dimension	string
month_name	Month name	dimension	string
day_of_month	Day of month	dimension	string
day_of_week	Day of week	dimension	string
day_of_week_name	Day of week (name)	dimension	string
year	Year	dimension	string
quarter	Quarter	dimension	string
date_range	Date range	dimension	string
line_items:product_id	Product id	dimension	string
line_items:variation_id	Product variation id	dimension	string
line_items:name	Product Name	dimension	string
line_items:sku	Product Sku	dimension	string
date_created	Order created date	dimension	string
id	Order id	dimension	string
status	Order status	dimension	string
currency	Order currency	dimension	string
prices_include_tax	Order prices include tax	dimension	string
date_modified	Order modified date	dimension	string
customer_id	Order customer id	dimension	string
order_key	Order key	dimension	string
billing:first_name	Billing first name	dimension	string
billing:last_name	Billing last name	dimension	string
billing:company	Billing company	dimension	string
billing:address_1	Billing address 1	dimension	string
billing:address_2	Billing address 2	dimension	string
billing:city	Billing city	dimension	string
billing:state	Billing state	dimension	string
billing:postcode	Billing postcode	dimension	string
billing:country	Billing country	dimension	string
billing:email	Billing email	dimension	string
billing:phone	Billing phone	dimension	string
shipping:first_name	Shipping first name	dimension	string
shipping:last_name	Shipping last name	dimension	string
shipping:company	Shipping company	dimension	string
shipping:address_1	Shipping address 1	dimension	string
shipping:address_2	Shipping address 2	dimension	string
shipping:city	Shipping city	dimension	string
shipping:state	Shipping state	dimension	string
shipping:postcode	Shipping postcode	dimension	string
shipping:country	Shipping country	dimension	string
shipping:phone	Shipping phone	dimension	string
payment_method	Payment method	dimension	string
payment_method_title	Payment method title	dimension	string
transaction_id	Transaction id	dimension	string
customer_ip_address	Customer ip address	dimension	string
customer_user_agent	Customer user agent	dimension	string
created_via	Order created via	dimension	string
customer_note	Order Customer note	dimension	string
date_completed	Order completed date	dimension	string
date_paid	Order paid date	dimension	string
cart_hash	Order cart hash	dimension	string
number	Order number	dimension	string
payment_url	Payment url	dimension	string
currency_symbol	Order currency symbol	dimension	string
items	Total items	metric	float
unique_items	Unique items	metric	float
orders	Orders	metric	float
line_items:price	Product Price	metric	float
line_items:quantity	Product quantity	metric	float
line_items:subtotal	Product sub total price	metric	float
line_items:subtotal_tax	Product sub total tax	metric	float
line_items:total	Product total price	metric	float
line_items:total_tax	Product total tax	metric	float
discount_total	Order discount total	metric	float
discount_tax	Order discount tax	metric	float
shipping_total	Order shipping total	metric	float
shipping_tax	Order shipping tax	metric	float
cart_tax	Order cart tax	metric	float
total	Order total sale	metric	float
total_tax	Order total tax	metric	float

Fields Reference

WooCommerce fields list

Fields reference

Leave a Reply Cancel reply