Available queries

Associated queryReturns multiple results
SalesOrder
SalesOrders✔️

Available fields

LabelTypeNotesNull
account_managerAccount managerThe account manager associated to this document✔️
bill_toAddressThe billing address✔️
changedDateThe date of the sales order's last modification
createdDateThe date of the sales order's creation
created_fromEstimateThe estimate this document was created from✔️
committeddecimal(17,7)The committed shipment on this sales order
currencyCurrencyThe currency used in this document✔️
customerCustomerThe customer this document is addressed to✔️
delivereddecimal(17,7)The delivered quantity on this sales order
delivery_typestringThe type of delivery used in this document
discountdecimal(10,2)The discount applied in this document✔️
exchange_ratedecimal(12,6)The exchange rate for this document's currency✔️
external_referencestringThe external reference of this document✔️
for_the_attention_ofstringThe person this document is addressed to✔️
global_discountdecimal (12,2)The global discount applied to the document✔️
idintegerThe id of the document
internal_notesstringNotes about this document that only you will see✔️
invoiceddecimal(12,2)The invoiced cost
invoiced_unitsdecimal(17,7)
invoices_createdInvoicesThe invoices created from this document✔️
labelstringThe order number of this specific sales order. Automatically generated
line_itemsLine itemsThe line items of the document
locationLocationThe location used in the document✔️
notesstringNotes about this document that you AND the customer will see✔️
paiddecimal(12,2)How much is already in a paid invoice
payment_statusstringThe status of payment for this sales order ("unpaid", "partially_paid", "paid")
price_levelPrice levelThe price level used in this document
product_returns_createdProduct returnsThe product returns created from this document✔️
published_to_shopifybooleanIndicates if the sales order is published to shopify
purchase_orders_createdPurchase ordersThe purchase orders created from this document✔️
sales_order_statusstringThe status of this document ("active", "completed_automatically", "completed_manually", "pending_validation", "cancelled")
seasonSeasonThe season used int this document✔️
shipping_costdecimal(10,2)The shipping cost✔️
shipping_dateDateNoHourThe date of shipping✔️
shipping_orders_createdShipping OrdersThe shipping orders created from this document✔️
shipping_statusstringThe shipment status (ex : "not_delivered", "partially_delivered", "delivered")✔️
shipping_taxesTaxesThe shipping taxes used in this document✔️
ship_toAddressThe shipping address✔️
stock_movements_createdStock movementsThe stock movements created from this document✔️
subtotaldecimal(12,2)The subtotal of this document
taxesTaxesThe taxes used in this document✔️
tax_typeObjectThe type of taxes in this document✔️
terms_and_conditionsstringThe terms and condition of this document✔️
totaldecimal(12,2)The total of this document
total_taxesTotal taxesThe total taxes of this document
total_unitsdecimal(17,7)The total units of this order
uninvoiced_unitsdecimal(17,7)
unpaiddecimal(12,2)
userUserThe user who created this order

Example of a query

query{
  SalesOrders{
    edges{
      node{
        account_manager{
          id
        }
        bill_to{
          country
        }
        changed
        created
        created_from{
          id
        }
        committed
        currency{
          iso
        }
        customer{
          id
        }
        delivered
        discount
        exchange_rate
        external_reference
        for_the_attention_of
        global_discount
        id
        internal_notes
        invoiced
        label
        line_items{
          edges{
            node{
              id
            }
          }
        }
        location{
          id
        }
        notes
        paid
        payment_status
        price_level{
          id
        }
        product_returns_created{
          edges{
            node{
              id
            }
          }
        }
        purchase_orders_created{
          edges{
            node{
              id
            }
          }
        }
        sales_order_status
        season{
          label
        }
        shipping_cost
        shipping_date
        shipping_orders_created{
          edges{
            node{
              id
            }
          }
        }
        shipping_status
        shipping_taxes{
          edges{
            node{
              id
            }
          }
        }
        ship_to{
          country
        }
        stock_movements_created{
          edges{
            node{
              id
            }
          }
        }
        subtotal
        taxes{
          edges{
            node{
              id
            }
          }
        }
        tax_type
        terms_and_conditions
        total
        total_taxes{
          edges{
            node{
              id
            }
          }
        }
        total_units
        uninvoiced_units
        unpaid
        user{
          display_name
        }
      }
    }
  }
}