EZ Exporter: Shopify Draft Order Fields Reference

You can also reference the Field IDs below in a Custom Field or Calculated Field by enclosing them in double curly braces (e.g. {{ updated_at }}).

Field ID	Description
`applied_discount.amount`	Applied Discount Amount (type: number). The applied amount of the discount.
`applied_discount.description`	Applied Discount Description (type: text). Reason for the discount.
`applied_discount.value`	Applied Discount Value (type: text). The value of the discount. If the type of the discount is fixed_amount, then this is a fixed dollar amount. If the type is percentage, then this is the percentage.
`applied_discount.value_type`	Applied Discount Value Type (type: text). The type of discount (percentage or fixed_amount).
`billing_address.address1`	Billing Address1 (type: text).
`billing_address.address2`	Billing Address2 (type: text).
`billing_address.city`	Billing City (type: text).
`billing_address.company`	Billing Company (type: text).
`billing_address.country`	Billing Country (type: text).
`billing_address.country_code`	Billing Country Code (type: text).
`billing_address.first_name`	Billing First Name (type: text).
`billing_address.last_name`	Billing Last Name (type: text).
`billing_address.name`	Billing Name (type: text).
`billing_address.phone`	Billing Phone (type: text).
`billing_address.province`	Billing Province (type: text).
`billing_address.province_code`	Billing Province Code (type: text).
`billing_address.zip`	Billing Zip (type: text).
`completed_at`	Completed At (type: datetime). The date and time at which order is created and the draft order changes to completed status.
`created_at`	Created At (type: datetime).
`currency`	Currency (type: text).
`customer.created_at`	Customer Created At (type: datetime).
`customer.default_address.address1`	Customer Default Address - Address 1 (type: text).
`customer.default_address.address2`	Customer Default Address - Address 2 (type: text).
`customer.default_address.city`	Customer Default Address - City (type: text).
`customer.default_address.company`	Customer Default Address - Company (type: text).
`customer.default_address.country`	Customer Default Address - Country (type: text).
`customer.default_address.country_code`	Customer Default Address - Country Code (type: text).
`customer.default_address.first_name`	Customer Default Address - First Name (type: text).
`customer.default_address.last_name`	Customer Default Address - Last Name (type: text).
`customer.default_address.name`	Customer Default Address - Name (type: text).
`customer.default_address.phone`	Customer Default Address - Phone (type: text).
`customer.default_address.province`	Customer Default Address - Province (type: text).
`customer.default_address.province_code`	Customer Default Address - Province Code (type: text).
`customer.default_address.zip`	Customer Default Address - Zip (type: text).
`customer.email`	Customer Email (type: text).
`customer.first_name`	Customer First Name (type: text).
`customer.id`	Customer ID (type: number).
`customer.last_name`	Customer Last Name (type: text).
`customer.last_order_id`	Customer Last Order ID (type: number).
`customer.last_order_name`	Customer Last Order Name (type: text).
`customer.note`	Customer Note (type: text).
`customer.orders_count`	Customer Orders Count (type: number). The number of orders placed by this customer to a shop.
`customer.phone`	Customer Phone (type: text).
`customer.state`	Customer State (type: text).
`customer.tags`	Customer Tags (type: text).
`customer.tax_exempt`	Customer Tax Exempt (type: text).
`customer.total_spent`	Customer Total Spent (type: number).
`customer.updated_at`	Customer Updated At (type: datetime).
`email`	Email (type: text).
`id`	Draft Order ID (type: number). The unique numeric identifier for the draft order.
`invoice_sent_at`	Invoice Sent At (type: datetime). The date and time when the invoice was emailed to the customer
`invoice_url`	Invoice URL (type: text).
`line_items.applied_discount.amount`	Lineitem Applied Discount Amount (type: number).
`line_items.applied_discount.description`	Lineitem Applied Discount Description (type: text).
`line_items.applied_discount.title`	Lineitem Applied Discount Title (type: text).
`line_items.applied_discount.value`	Lineitem Applied Discount Value (type: text).
`line_items.applied_discount.value_type`	Lineitem Applied Discount Value Type (type: text).
`line_items.custom`	Lineitem Is Custom (type: text).
`line_items.fulfillment_service`	Lineitem Fulfillment Service (type: text). Service provider who is doing the fulfillment. Valid values are either `manual` or the name of the provider. eg: `amazon`, `shipwire`, etc.
`line_items.gift_card`	Lineitem Gift Card (type: text). States whether or not the line_item is a gift card. If so, the item is not taxed or considered for shipping charges. Value is either `True` or `False`.
`line_items.grams`	Lineitem Grams (type: number).
`line_items.name`	Lineitem Name (type: text). The name of the product variant.
`line_items.price`	Lineitem Price (type: number). The unit price of the item before discounts have been applied.
`line_items.product.handle`	Lineitem Product Handle (type: text). A human-friendly unique string for the Product automatically generated from its title.
`line_items.product.image_src`	Lineitem Product Image URL (type: text). The image URL for the product.
`line_items.product.product_type`	Lineitem Product Type (type: text).
`line_items.product.tags`	Lineitem Product Tags (type: text).
`line_items.product_id`	Lineitem Product ID (type: number).
`line_items.properties`	Lineitem Properties (type: text). An array of custom information for an item that has been added to the cart. Often used to provide product customization options. To place a specific line item property into its own column, you can use a Calculated Field with the formula: `search_attributes({{ line_items.properties }}, "Name of the Property")`
`line_items.properties.name`	Lineitem Properties Names (type: text).
`line_items.properties.value`	Lineitem Properties Values (type: text).
`line_items.quantity`	Lineitem Quantity (type: number). The number of products that were purchased.
`line_items.requires_shipping`	Lineitem Requires Shipping (type: text).
`line_items.sku`	Lineitem SKU (type: text).
`line_items.tax_lines`	Lineitem Tax Lines (type: text).
`line_items.tax_lines.price`	Lineitem Tax Lines Prices (type: text).
`line_items.tax_lines.rate`	Lineitem Tax Lines Rates (type: text).
`line_items.tax_lines.title`	Lineitem Tax Lines Titles (type: text).
`line_items.tax_lines.total_price`	Lineitem Tax Lines Total Price (type: number).
`line_items.taxable`	Lineitem Taxable (type: text).
`line_items.title`	Lineitem Title (type: text).
`line_items.total_price`	Lineitem Total Price (type: number). The total price of the line item before discounts have been applied (price x quantity).
`line_items.variant.barcode`	Lineitem Variant Barcode (type: text).
`line_items.variant.compare_at_price`	Lineitem Variant Compare At Price (type: number). The competitors price for the same item.
`line_items.variant.grams`	Lineitem Variant Grams (type: number).
`line_items.variant.image_id`	Lineitem Variant Image ID (type: number).
`line_items.variant.image_src`	Lineitem Variant Image URL (type: text). The image URL for the variant.
`line_items.variant.inventory_item.cost`	Lineitem Variant Inventory Item Cost (type: number). The current unit cost of the inventory item.
`line_items.variant.inventory_item.country_code_of_origin`	Lineitem Variant Inventory Item Country Code of Origin (type: text). The two-digit code for the country where the inventory item was made.
`line_items.variant.inventory_item.harmonized_system_code`	Lineitem Variant Inventory Item Harmonized System Code (type: text). The general Harmonized System (HS) code for the inventory item. Used by border officers to classify this product.
`line_items.variant.inventory_item.province_code_of_origin`	Lineitem Variant Inventory Item Province Code of Origin (type: text). The two-digit code for the province where the inventory item was made. Used only if the shipping provider for the inventory item is Canada Post.
`line_items.variant.inventory_item.tracked`	Lineitem Variant Inventory Item Tracked (type: text). Whether the inventory item is tracked. If true, then inventory quantity changes are tracked by Shopify.
`line_items.variant.inventory_item_id`	Lineitem Variant Inventory Item ID (type: text).
`line_items.variant.inventory_levels.available`	Lineitem Variant Inventory Levels - Available Quantities (type: text). A comma-separated list of quantity values at the locations that stock this variant.
`line_items.variant.inventory_levels.location_id`	Lineitem Variant Inventory Levels - Location IDs (type: text). A comma-separated list of location IDs that stock this variant.
`line_items.variant.inventory_levels.location_name`	Lineitem Variant Inventory Levels - Location Names (type: text). A comma-separated list of location names that stock this variant.
`line_items.variant.inventory_management`	Lineitem Variant Inventory Management (type: text). Specifies whether or not Shopify tracks the number of items in stock for this product variant.
`line_items.variant.inventory_policy`	Lineitem Variant Inventory Policy (type: text). Specifies whether or not customers are allowed to place an order for a product variant when it's out of stock.
`line_items.variant.inventory_quantity`	Lineitem Variant Inventory Quantity (type: number).
`line_items.variant.option1`	Lineitem Variant Option 1 (type: text).
`line_items.variant.option2`	Lineitem Variant Option 2 (type: text).
`line_items.variant.option3`	Lineitem Variant Option 3 (type: text).
`line_items.variant.position`	Lineitem Variant Position (type: number). The order of the product variant in the list of product variants. 1 is the first position. To reorder variants, update the product with the variants in the desired order.
`line_items.variant.weight`	Lineitem Variant Weight (type: number).
`line_items.variant.weight_unit`	Lineitem Variant Weight Unit (type: text).
`line_items.variant_id`	Lineitem Variant ID (type: number).
`line_items.variant_title`	Lineitem Variant Title (type: text).
`line_items.vendor`	Lineitem Vendor (type: text). The name of the supplier of the item.
`line_items_count`	Number of Line Items (type: number). The number of line items in the order.
`name`	Draft Order Name (type: text). Name of the draft order.
`note`	Notes (type: text). The text of an optional note that a shop owner can attach to the draft order.
`note_attributes`	Note Attributes (type: text). Extra information that is added to the order. Also referred to as cart attributes. To place a specific note attribute into its own column, you can use a Calculated Field with the formula: `search_attributes({{ note_attributes }}, "Name of the Attribute")`
`note_attributes.name`	Note Attributes Names (type: text).
`note_attributes.value`	Note Attributes Values (type: text).
`order_id`	Order ID (type: number). The unique numeric identifier for the order associated to the draft order, once created.
`payment_terms.due_in_days`	Payment Terms Due In Days (type: number). The number of days between the invoice date and due date that is defined in the selected payment terms template.
`payment_terms.payment_schedules`	Payment Terms Schedules (type: text). An array of schedules associated to the payment terms.
`payment_terms.payment_terms_name`	Payment Terms Name (type: text). The name of the selected payment terms template for the draft order.
`payment_terms.payment_terms_type`	Payment Terms Type (type: text). The type of selected payment terms template for the draft order.
`products_count`	Number of Products (type: number). The number of unique products in the order.
`shipping_address.address1`	Shipping Address1 (type: text).
`shipping_address.address2`	Shipping Address2 (type: text).
`shipping_address.city`	Shipping City (type: text).
`shipping_address.company`	Shipping Company (type: text).
`shipping_address.country`	Shipping Country (type: text).
`shipping_address.country_code`	Shipping Country Code (type: text).
`shipping_address.first_name`	Shipping First Name (type: text).
`shipping_address.last_name`	Shipping Last Name (type: text).
`shipping_address.latitude`	Shipping Latitude (type: text).
`shipping_address.longitude`	Shipping Longitude (type: text).
`shipping_address.name`	Shipping Name (type: text).
`shipping_address.phone`	Shipping Phone (type: text).
`shipping_address.province`	Shipping Province (type: text).
`shipping_address.province_code`	Shipping Province Code (type: text).
`shipping_address.zip`	Shipping Zip (type: text).
`shipping_line.custom`	Shipping Line Custom (type: text). Indicates if this is a regular shipping line or custom shipping line.
`shipping_line.handle`	Shipping Line Handle (type: text). The handle of the shipping rate which was selected and applied.
`shipping_line.price`	Shipping Line Price (type: number). The price of this shipping method.
`shipping_line.title`	Shipping Line Title (type: text). The title of the shipping method.
`status`	Draft Order Status (type: text).
`subtotal_price`	Subtotal (type: number). The price of the order after discounts but before shipping, taxes, and tips.
`tags`	Tags (type: text).
`tax_exempt`	Tax Exempt (type: text). Sets whether or not taxes are exempt for the draft order.
`taxes_included`	Taxes Included (type: text).
`total_price`	Total (type: number). The sum of all line item prices, discounts, shipping, taxes, and tips.
`total_tax`	Taxes (type: number). The sum of all the taxes applied to the order.
`total_weight`	Total Weight (Grams) (type: number).
`updated_at`	Updated At (type: datetime). The date and time when the draft order was last modified.

Related Articles:

App: EZ Exporter

Tags: shopify, field reference, shopify fields