Skip to content
DataEase
Try for free

Draft Orders

A Draft Order is an order a merchant builds for a customer before payment.
Use cases with DataEase:

  • Phone or chat sales – build and email a checkout link.
  • Wholesale or pre-order deals – add custom prices and items.
  • Re-create orders or take quick quotes in bulk.

Shopify draft-order guide.

Table of Contents

Section titled “Table of Contents”
  1. Export
  2. Import
  3. Field reference
  4. Filters

2. Export

Section titled “2. Export”
  1. Pick CSV (best for many line items) or Excel.
  2. Choose DraftOrder as the entity.
  3. Select columns such as tags, lineItemVariantId, customerEmail.
  4. Run the task and download your file.

Details: Export guide

3. Import

Section titled “3. Import”

Commands

Section titled “Commands”

Draft-order row command: CREATE, UPDATE, REPLACE, DELETE, IGNORE
Line-item row itemCommand: CREATE, UPDATE, MERGE, DELETE, IGNORE
Action (optional): COMPLETE, DUPLICATE, SEND_INVOICE

Rules

  • At least email or phone (or customerId) is required for CREATE.
  • First line (topRow = TRUE) is the order header; following lines add items/addresses.
  • UPDATE skips blank cells; REPLACE overwrites with only given columns.
  • Only one action per import run.

Steps

  1. Download the sample: DraftOrder-import-sample.xlsx
  2. Edit header row and add item rows.
  3. Map columns in DataEase, upload, and start.

Full help: Import guide

4. Field reference

Section titled “4. Field reference”

Below you’ll see every column you can use. “Import only” means the value can be uploaded but isn’t returned on export.

General order fields

Section titled “General order fields”

  • id — Draft-order ID. Needed for UPDATE, REPLACE, DELETE.

  • command — Main row action (CREATE, UPDATE, etc.).

  • acceptAutomaticDiscounts — true lets Shopify auto-apply store discounts.

  • allowDiscountCodesInCheckout — true lets customers enter discount codes at checkout.

  • presentmentCurrencyCode — Currency the customer will pay in.

  • discountCodes — Comma list of codes on the order.

  • email — Customer email for invoice.

  • phone — Customer phone.

  • note — Internal note for the order.

  • tags — Comma list of tags.

  • tagsCommand — ADD, REMOVE, or REPLACE tags.

  • poNumber — Purchase-order number.

  • customAttributes — Key-value meta info shown to customer.

  • reserveInventoryUntil — ISO date when held stock is released.

Line-item fields (topRow = FALSE with item values)

Section titled “Line-item fields (topRow = FALSE with item values)”

  • lineItemUuid — Unique ID for the line; mandatory when using bundles.

  • itemCommand — CREATE, UPDATE, MERGE, DELETE, IGNORE for this line.

  • lineItemVariantId — Variant ID (leave blank for custom item).

  • lineItemTitle — Title for custom item (ignored if variantId set).

  • lineItemQuantity — Quantity to add.

  • lineItemOriginalUnitPrice — Price before discounts.

  • lineItemOriginalUnitPriceCurrency — Currency code of originalUnitPrice.

  • lineItemAppliedDiscountValue — Value of discount on this line.

  • lineItemAppliedDiscountValueType — FIXED_AMOUNT or PERCENTAGE.

(similar fields exist for weight, SKU, barcode, etc.)

Section titled “Customer link”

  • customerId — Existing customer ID. If blank, match by email/phone or create new.

  • customerCompanyId — Company ID for B2B orders.

Billing & shipping addresses

Section titled “Billing & shipping addresses”

  • billingAddress1 — Billing street line 1.

  • shippingAddress1 — Shipping street line 1.

(each address has corresponding city, zip, provinceCode, countryCode, phone, etc.)

Order-level discount

Section titled “Order-level discount”

  • appliedDiscountTitle — Name of custom order discount.

  • appliedDiscountValue — Discount amount (money or percent).

  • appliedDiscountValueType — FIXED_AMOUNT or PERCENTAGE.

Shipping line

Section titled “Shipping line”

  • shippingTitle — Title shown for shipping.

  • shippingLinePresentmentPrice — Shipping cost in presentment currency.

Import-only helpers

Section titled “Import-only helpers”

  • action — COMPLETE, DUPLICATE, or SEND_INVOICE after rows import. Import only.

  • shippingLinePrice — Shipping cost in shop currency. Import only.

  • useCustomerDefaultAddress — true to pull customer default shipping/billing. Import only.

Metafields

Section titled “Metafields”

5. Filters

Section titled “5. Filters”

  • CreatedAt — Export draft orders created on a date or range.

  • CustomerId — Export drafts tied to one customer.

  • Id — Export a single draft by ID.

  • Source — Filter by source (API, POS, etc.).

  • Status — OPEN, INVOICE_SENT, COMPLETED.

  • Tag — Include drafts with matching tag.

  • UpdatedAt — Choose last-updated date range.

Need help? Our support team answers within 24 hours.

Additional fields

Section titled “Additional fields”

More columns DataEase supports for this entity:

  • currencyCode — Currency code for the draft order.
  • completedAt — Timestamp when the draft order was completed.
  • name — Name of the draft order.
  • totalPrice — Total price of the draft order.
  • totalShippingPrice — Total shipping price for the draft order.
  • totalWeight — Total weight of the draft order.
  • totalTax — Total tax applied to the draft order.
  • subtotalPrice — Subtotal price before taxes and discounts.
  • invoiceUrl — URL to the invoice for the draft order.
  • invoiceSentAt — Timestamp when the invoice was sent.
  • taxesIncluded — true if taxes are included in the prices.
  • visibleToCustomer — true if the draft order is visible to the customer.
  • warnings — Warnings related to the draft order.
  • lineItemId — ID of the line item in the draft order.
  • lineItemName — Name of the line item.
  • lineItemOriginalTotal — Original total price of the line item.
  • lineItemTaxable — true if the line item is taxable.
  • lineItemTotalDiscount — Total discount applied to the line item.
  • lineItemSku — SKU of the line item.
  • lineItemVariantBarcode — Barcode of the line item variant.
  • lineItemVariantTitle — Title of the line item variant.
  • lineItemVendor — Vendor of the line item.
  • lineItemVariantPrice — Price of the line item variant.
  • lineItemVariantProductTags — Product tags for the line item variant.
  • lineItemVariantInventoryQuantity — Inventory quantity of the line item variant.
  • lineItemWeightUnit — Unit of weight for the line item.
  • lineItemWeightValue — Weight value of the line item.
  • lineItemIsGiftCard — true if the line item is a gift card.
  • lineItemRequiresShipping — true if the line item requires shipping.
  • lineItemProductId — Product ID of the line item.
  • lineItemProductHandle — Product handle of the line item.
  • lineItemProductType — Product type of the line item.
  • lineItemCustomAttributes — Custom attributes for the line item.
  • lineItemAppliedDiscountPresentmentAmount — Presentment amount of the applied discount on the line item.
  • lineItemAppliedDiscountShopAmount — Shop amount of the applied discount on the line item.
  • lineItemAppliedDiscountDescription — Description of the applied discount on the line item.
  • lineItemAppliedDiscountTitle — Title of the applied discount on the line item.
  • customerEmail — Email address of the customer.
  • customerFirstName — First name of the customer.
  • customerLastName — Last name of the customer.
  • customerCreatedAt — Timestamp when the customer was created.
  • customerLocale — Locale of the customer.
  • customerNote — Note associated with the customer.
  • customerPhone — Phone number of the customer.
  • customerNumberOfOrders — Number of orders placed by the customer.
  • customerState — State of the customer.
  • customerAmountSpentAmount — Total amount spent by the customer.
  • customerTags — Tags associated with the customer.
  • customerSmsMarketingConsent — true if the customer consents to SMS marketing.
  • customerEmailMarketingConsent — true if the customer consents to email marketing.
  • customerTaxExempt — true if the customer is tax-exempt.
  • customerCompanyName — Company name of the customer.
  • customerLocationId — Location ID associated with the customer.
  • customerContactId — Contact ID of the customer.
  • customerCompanyExternalId — External company ID of the customer.
  • billingName — Full billing name.
  • billingFirstName — First name for billing.
  • billingLastName — Last name for billing.
  • billingCompany — Company name for billing.
  • billingPhone — Phone number for billing.
  • billingAddress2 — Second line of the billing address.
  • billingCity — City for billing.
  • billingCountry — Country for billing.
  • billingCountryCode — Country code for billing.
  • billingZip — ZIP code for billing.
  • billingProvince — Province for billing.
  • billingProvinceCode — Province code for billing.
  • shippingName — Full shipping name.
  • shippingFirstName — First name for shipping.
  • shippingLastName — Last name for shipping.
  • shippingCompany — Company name for shipping.
  • shippingPhone — Phone number for shipping.
  • shippingAddress2 — Second line of the shipping address.
  • shippingCity — City for shipping.
  • shippingCountry — Country for shipping.
  • shippingCountryCode — Country code for shipping.
  • shippingZip — ZIP code for shipping.
  • shippingProvince — Province for shipping.
  • shippingProvinceCode — Province code for shipping.
  • appliedDiscountPresentmentAmount — Presentment amount of the applied discount.
  • appliedDiscountShopAmount — Shop amount of the applied discount.
  • appliedDiscountDescription — Description of the applied discount.
  • shippingRateHandle — Handle for the shipping rate.
  • taxLines — Tax lines applied to the draft order.