EZ Exporter: Shopify Draft Order Fields Reference

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

Field IDDescription
applied_discount.amountApplied Discount Amount (type: number). The applied amount of the discount.
applied_discount.descriptionApplied Discount Description (type: text). Reason for the discount.
applied_discount.valueApplied 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_typeApplied Discount Value Type (type: text). The type of discount (percentage or fixed_amount).
billing_address.address1Billing Address1 (type: text).
billing_address.address2Billing Address2 (type: text).
billing_address.cityBilling City (type: text).
billing_address.companyBilling Company (type: text).
billing_address.countryBilling Country (type: text).
billing_address.country_codeBilling Country Code (type: text).
billing_address.first_nameBilling First Name (type: text).
billing_address.last_nameBilling Last Name (type: text).
billing_address.nameBilling Name (type: text).
billing_address.phoneBilling Phone (type: text).
billing_address.provinceBilling Province (type: text).
billing_address.province_codeBilling Province Code (type: text).
billing_address.zipBilling Zip (type: text).
completed_atCompleted At (type: datetime). The date and time at which order is created and the draft order changes to completed status.
created_atCreated At (type: datetime).
currencyCurrency (type: text).
customer.accepts_marketingCustomer Accepts Marketing (type: text). Indicates whether or not the customer would like to receive email updates from the shop.
customer.created_atCustomer Created At (type: datetime).
customer.default_address.address1Customer Default Address - Address 1 (type: text).
customer.default_address.address2Customer Default Address - Address 2 (type: text).
customer.default_address.cityCustomer Default Address - City (type: text).
customer.default_address.companyCustomer Default Address - Company (type: text).
customer.default_address.countryCustomer Default Address - Country (type: text).
customer.default_address.country_codeCustomer Default Address - Country Code (type: text).
customer.default_address.first_nameCustomer Default Address - First Name (type: text).
customer.default_address.last_nameCustomer Default Address - Last Name (type: text).
customer.default_address.nameCustomer Default Address - Name (type: text).
customer.default_address.phoneCustomer Default Address - Phone (type: text).
customer.default_address.provinceCustomer Default Address - Province (type: text).
customer.default_address.province_codeCustomer Default Address - Province Code (type: text).
customer.default_address.zipCustomer Default Address - Zip (type: text).
customer.emailCustomer Email (type: text).
customer.first_nameCustomer First Name (type: text).
customer.idCustomer ID (type: number).
customer.last_nameCustomer Last Name (type: text).
customer.noteCustomer Note (type: text).
customer.orders_countCustomer Orders Count (type: number). The number of orders placed by this customer to a shop.
customer.stateCustomer State (type: text).
customer.tagsCustomer Tags (type: text).
customer.tax_exemptCustomer Tax Exempt (type: text).
customer.total_spentCustomer Total Spent (type: number).
customer.updated_atCustomer Updated At (type: datetime).
emailEmail (type: text).
idDraft Order ID (type: number). The unique numeric identifier for the draft order.
invoice_sent_atInvoice Sent At (type: datetime). The date and time when the invoice was emailed to the customer
invoice_urlInvoice URL (type: text).
line_items.applied_discount.amountLineitem Applied Discount Amount (type: number).
line_items.applied_discount.descriptionLineitem Applied Discount Description (type: text).
line_items.applied_discount.titleLineitem Applied Discount Title (type: text).
line_items.applied_discount.valueLineitem Applied Discount Value (type: text).
line_items.applied_discount.value_typeLineitem Applied Discount Value Type (type: text).
line_items.customLineitem Is Custom (type: text).
line_items.fulfillment_serviceLineitem 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_cardLineitem 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.
line_items.gramsLineitem Grams (type: number).
line_items.nameLineitem Name (type: text). The name of the product variant.
line_items.priceLineitem Price (type: number). The unit price of the item before discounts have been applied.
line_items.product.handleLineitem Product Handle (type: text). A human-friendly unique string for the Product automatically generated from its title.
line_items.product.image_srcLineitem Product Image Src (type: text). The image URL for the product.
line_items.product.product_typeLineitem Product Type (type: text).
line_items.product.tagsLineitem Product Tags (type: text).
line_items.product_idLineitem Product ID (type: number).
line_items.propertiesLineitem 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.nameLineitem Properties Names (type: text).
line_items.properties.valueLineitem Properties Values (type: text).
line_items.quantityLineitem Quantity (type: number). The number of products that were purchased.
line_items.requires_shippingLineitem Requires Shipping (type: text).
line_items.skuLineitem SKU (type: text).
line_items.tax_linesLineitem Tax Lines (type: text).
line_items.tax_lines.priceLineitem Tax Lines Prices (type: text).
line_items.tax_lines.rateLineitem Tax Lines Rates (type: text).
line_items.tax_lines.titleLineitem Tax Lines Titles (type: text).
line_items.tax_lines.total_priceLineitem Tax Lines Total Price (type: number).
line_items.taxableLineitem Taxable (type: text).
line_items.titleLineitem Title (type: text).
line_items.total_priceLineitem Total Price (type: number). The total price of the line item before discounts have been applied (price x quantity).
line_items.variant.barcodeLineitem Variant Barcode (type: text).
line_items.variant.compare_at_priceLineitem Variant Compare At Price (type: number). The competitors price for the same item.
line_items.variant.gramsLineitem Variant Grams (type: number).
line_items.variant.image_idLineitem Variant Image ID (type: number).
line_items.variant.image_srcLineitem Variant Image Src (type: text). The image URL for the variant.
line_items.variant.inventory_item.costLineitem Variant Inventory Item Cost (type: number). The current unit cost of the inventory item.
line_items.variant.inventory_item.country_code_of_originLineitem 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_codeLineitem 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_originLineitem 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.trackedLineitem 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_idLineitem Variant Inventory Item ID (type: text).
line_items.variant.inventory_managementLineitem 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_policyLineitem 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_quantityLineitem Variant Inventory Quantity (type: number).
line_items.variant.option1Lineitem Variant Option 1 (type: text).
line_items.variant.option2Lineitem Variant Option 2 (type: text).
line_items.variant.option3Lineitem Variant Option 3 (type: text).
line_items.variant.positionLineitem 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.weightLineitem Variant Weight (type: number).
line_items.variant.weight_unitLineitem Variant Weight Unit (type: text).
line_items.variant_idLineitem Variant ID (type: number).
line_items.variant_titleLineitem Variant Title (type: text).
line_items.vendorLineitem Vendor (type: text). The name of the supplier of the item.
line_items_countNumber of Line Items (type: number). The number of line items in the order.
nameDraft Order Name (type: text). Name of the draft order.
noteNotes (type: text). The text of an optional note that a shop owner can attach to the draft order.
note_attributesNote 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.nameNote Attributes Names (type: text).
note_attributes.valueNote Attributes Values (type: text).
order_idOrder ID (type: number). The unique numeric identifier for the order associated to the draft order, once created.
products_countNumber of Products (type: number). The number of unique products in the order.
shipping_address.address1Shipping Address1 (type: text).
shipping_address.address2Shipping Address2 (type: text).
shipping_address.cityShipping City (type: text).
shipping_address.companyShipping Company (type: text).
shipping_address.countryShipping Country (type: text).
shipping_address.country_codeShipping Country Code (type: text).
shipping_address.first_nameShipping First Name (type: text).
shipping_address.last_nameShipping Last Name (type: text).
shipping_address.latitudeShipping Latitude (type: text).
shipping_address.longitudeShipping Longitude (type: text).
shipping_address.nameShipping Name (type: text).
shipping_address.phoneShipping Phone (type: text).
shipping_address.provinceShipping Province (type: text).
shipping_address.province_codeShipping Province Code (type: text).
shipping_address.zipShipping Zip (type: text).
shipping_line.customShipping Line Custom (type: text). Indicates if this is a regular shipping line or custom shipping line.
shipping_line.handleShipping Line Handle (type: text). The handle of the shipping rate which was selected and applied.
shipping_line.priceShipping Line Price (type: number). The price of this shipping method.
shipping_line.titleShipping Line Title (type: text). The title of the shipping method.
statusDraft Order Status (type: text).
subtotal_priceSubtotal (type: number). The price of the order after discounts but before shipping, taxes, and tips.
tagsTags (type: text).
tax_exemptTax Exempt (type: text). Sets whether or not taxes are exempt for the draft order.
taxes_includedTaxes Included (type: text).
total_priceTotal (type: number). The sum of all line item prices, discounts, shipping, taxes, and tips.
total_taxTaxes (type: number). The sum of all the taxes applied to the order.
total_weightTotal Weight (Grams) (type: number).
updated_atUpdated At (type: datetime). The date and time when the draft order was last modified.

App: EZ Exporter

Tags: shopify, field reference, shopify fields