Order Properties

Name Type Description
id string Order ID
note string Order notes
number string Order number
financial_status string Order payment status: waiting, paying, paid, cancelled, failed, refunding, refund_failed, refunded, partially_refunded
status string Order status: opened, placed, finished, cancelled
cancel_reason string Reason for order cancellation
payment_method string Payment method (cod, online , none)
fulfillment_status string Logistics status: initialled, waiting, partially_shipped, shipped, partially_finished, finished, cancelled, returning, returned
discount_code string Order coupon code
discount_applications string Order discount information of applications
customer_note string Customer note
landing_site string First page the customer landed
buyer_accepts_marketing boolean Whether the customer subscribes to order notifications
currency string Currency type
total_price string Actual price of the order (final price paid by the customer), numeric string, for example: "9.99"
total_discount string Discount price, numeric string, for example: "9.99"
total_tax string Order tax, numeric string, for example: "9.99"
total_shipping string Order logistics fee, numeric string, for example: "9.99"
sub_total string Total price of products, numeric string, for example: "9.99"
code_discount_total number Order discount code discount price
line_item_discount_total string Merchandise discount, numeric string, for example: "9.99"
tags string Order label
created_at date The time this order created, ISO-8601 format
updated_at date The time this order last updated, ISO-8601 format
canceled_at date Order cancellation time, ISO-8601 format
customer_deleted_at date Customer delete order time, ISO-8601 format
deleted_at date Order delete time, ISO-8601 format
placed_at date Order confirmation time, ISO-8601 format
total_refund_price string Total refund amount, numeric string, for example: "9.99"
total_refund_tax string Total tax refunded, numeric string, for example: "9.99"
total_refund_discount string Total discount refunded, numeric string, for example: "9.99"
refund_status string Refund status, possible values are:

none: there's no refund
general: there's refund in this order, and refund for some products
customize: there's refund in this order, and customized by store admin
total_tip_received string Total tips received, numeric string, for example: "9.99"
browser_ip string Browser IP
source string First visit landing page URL
last_landing_url string Last visit landing page URL
email_status string Email send status: send, waiting
recovery_status string Recovery status: waiting, sending, recalling, failed, success
source_name object First interaction source
        source_name: {
          data: string
          created_at: date
        }
        
last_referrer_show object Last interaction source
        last_referrer_show: {
          data: string
          created_at: date
        }
        
shipping_line object
        shipping_line: {
          name: string
        }

        name: Shipping Profile's title
        
customer object
        customer: {
          email: string
          first_name: string
          last_name: string
          phone: string
          created_at: date
          updated_at: date
          orders_count: integer
          total_spent: string
        }
        
shipping_address object
        shipping_address: {
          first_name: string
          last_name: string
          address1: string
          address2: string
          phone: string
          city: string
          zip: string
          province: string
          country: string
          company: string
          latitude: string
          longitude: string
          name: string
          country_code: string
          province_code: string
          phone_area_code: string
          email: string
          area: string
          extra_info: object
        }
        
billing_address object
        billing_address: {
          first_name: string
          last_name: string
          address1: string
          address2: string
          city: string
          zip: string
          province: string
          country: string
          company: string
          latitude: string
          longitude: string
          name: string
          country_code: string
          province_code: string
          email: string
          area: string
        }
        
payment_line object
        payment_line: {
          payment_channel: string
          payment_method: string
          transaction_no: string
          merchant_id: string
          merchant_email: string
        }
        
line_items array of object
        line_items: [{
          id: string
          product_id: string
          variant_id: string
          variant_title: string
          product_title: string
          product_handle: string
          quantity: integer
          note: string
          fulfillment_status: string
          sku: string
          weight_unit: string
          vendor: string
          product_url: string
          compare_at_price: number
          image: string
          price: number
          total: number
          weight: number
          properties: array of object
          custom_properties: object
          refund_quantity: integer
          refund_total: number
        }]
        
fulfillments array of object
        fulfillments: [{
          id: string
          order_id: string
          status: string
          tracking_company: string
          tracking_number: string
          tracking_company_code: string
          created_at: date
          updated_at: date
          line_items: array of object
        }]
        

Here is a formula: total_price = sub_total - total_discount + total_tax + total_shipping + total_tip_received