Find the fields you need for your next report.
63 fields
| Field | Details |
|---|---|
Customer city Customer city | Field IDcustomer/city |
Customer street address Customer street address | Field IDcustomer/street_address |
Customer country code ISO country code | Field IDcustomer/country_code |
Customer created at UNIX timestamp when the record was created | Field IDcustomer/created_at |
Customer email Customer email address | Field IDcustomer/email |
Customer external ID Customer external reference ID | Field IDcustomer/external_id |
Customer ID | Field IDcustomer/id |
Customer marketing email consent Whether the customer accepts marketing emails | Field IDcustomer/marketing.email |
Customer marketing SMS consent Whether the customer accepts marketing SMS | Field IDcustomer/marketing.sms |
Customer name Customer name | Field IDcustomer/name |
Customer phone number Customer phone number | Field IDcustomer/phone_number |
Customer state Customer state | Field IDcustomer/state |
Customer Updated at UNIX timestamp when the record was last updated | Field IDcustomer/updated_at |
Customer ZIP code Postal ZIP code | Field IDcustomer/zip |
Date Year, month, and day. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY |
Day of the month Day of the year | Field ID_NORMALIZED_DATE_FIELD_DAY |
Day of the week Week of the year | Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK |
Hour of the day Hour of the day | Field ID_NORMALIZED_DATE_FIELD_HOUR |
Month and day Month and day | Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY |
Month of the year Month of the year | Field ID_NORMALIZED_DATE_FIELD_MONTH |
Order Created At UNIX timestamp of order creation | Field IDorder/created_at |
Order Fulfill By Entity or shop fulfilling the order | Field IDorder/fulfill_by |
Order Fulfillment Label URL URL of the shipping label | Field IDorder/fulfillment.v1.label_url |
Order Fulfillment Local Pickup Whether the order is picked up locally | Field IDorder/fulfillment.local_pickup |
Order Fulfillment Picked Up At Timestamp when the order was picked up | Field IDorder/fulfillment.picked_up_at |
Order Fulfillment Shipped Date Date when the order was shipped | Field IDorder/fulfillment.v1.shipped_date |
Order Fulfillment Tracking Number Tracking number for shipment | Field IDorder/fulfillment.v1.tracking_number |
Order Has Redo Return Coverage Indicates if the order has redo/return coverage | Field IDorder/has_redo_return_coverage |
Order ID Unique identifier of the order | Field IDorder/id |
Order Internal Note Internal note for order handling | Field IDorder/note |
Order Note Note attached to the order | Field IDorder/order_note |
Order Payment Coupon Code Coupon code applied to the order | Field IDorder/payment.coupon_code |
Order Payment Date UNIX timestamp of payment date | Field IDorder/payment.payment_date |
Order Payment Reference Reference for the payment transaction | Field IDorder/payment.payment_ref |
Order Payment Transaction ID Unique ID of the payment transaction | Field IDorder/payment.transaction_id |
Order Shipping Apartment Apartment or suite number | Field IDorder/shipping_address.apartment |
Order Shipping City City of the shipping address | Field IDorder/shipping_address.city |
Order Shipping Country Code ISO country code of the shipping address | Field IDorder/shipping_address.country_code |
Order Shipping Email Email of the recipient | Field IDorder/shipping_address.email |
Order Shipping Name Name of the recipient | Field IDorder/shipping_address.name |
Order Shipping Phone Number Phone number of the recipient | Field IDorder/shipping_address.phone_number |
Order Shipping State State or province of the shipping address | Field IDorder/shipping_address.state |
Order Shipping Street Address Street address for shipping | Field IDorder/shipping_address.street_address |
Order Shipping ZIP Postal or ZIP code of the shipping address | Field IDorder/shipping_address.zip |
Order Status Current status of the order | Field IDorder/status |
Order Updated At UNIX timestamp of last order update | Field IDorder/updated_at |
Payment Amount Total amount paid for the order | Field IDorder/payment.amount |
Payment Balance Applied Balance applied from credits or previous payments | Field IDorder/payment.balance_applied |
Payment Coupon Discount Discount from coupon applied | Field IDorder/payment.coupon_discount |
Payment Shipping Shipping cost applied to the order | Field IDorder/payment.shipping |
Payment Subtotal Subtotal before taxes and fees | Field IDorder/payment.subtotal |
Payment Taxes Taxes applied to the order | Field IDorder/payment.taxes |
Payment Total Final total after discounts and taxes | Field IDorder/payment.total |
Quarter of the year Quarter of the year | Field ID_NORMALIZED_DATE_FIELD_QUARTER |
Root Order ID order if the current one is a child order | Field IDorder/root_order_id |
Unique Customer The number of unique people who have purchased in a set time period | Field IDunique_customer |
Week of the year Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK |
Week of the year (start Sunday) Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY |
Year Year such as 2017. | Field ID_NORMALIZED_DATE_FIELD_YEAR |
Year month Year and month. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH |
Year month day hour Year, month, day, and hour. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR |
Year Quarter Year and quarter. | Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER |
Year week Year and week. | Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK |
Try another search or reset your filters.