Sample File

Download a sample spreadsheet with draft orders to import.

General

ID

Description	Example Value
Shopify's unique draft order identifier	`567890123456`

If present, the ID will be used to find an existing draft order on the store. When importing, the ID will be used to see if the draft order already exists. If there's no ID match the app will attempt to find an existing draft order using the Name.

Name

Description	Example Value
Draft order name (automatically generated) - Export only	`#D205`

The draft order name that is automatically generated by Shopify. This field is export-only and cannot be imported.

Command

Description	Example Value
Action to perform	`MERGE`

MERGE: Update existing draft order or create if not found
DELETE: Remove the draft order from the store
NEW: Create a new draft order (will fail if draft order already exists)
UPDATE: Update existing draft order (fails if not found)
REPLACE: Delete existing draft order completely and create new with file data
IGNORE: Skip this draft order during import

Number

Description	Example Value
Import grouping number for multi-line orders	`1`

Used for grouping multiple rows together into a single draft order when importing.

Order ID

Description	Example Value
ID of completed order if draft was converted - Export only	`890123456789`

The unique identifier of the actual order if the draft order was converted to a completed order. This field is export-only and cannot be imported.

Status

Description	Example Value
Current status of the draft order - Export only	`open`

The current status of the draft order:

open: Draft order created but no invoice sent, no order generated yet
invoice_sent: Invoice was sent to customer but order not yet completed
completed: Real order was created from this draft order

This field is export-only and cannot be imported.

Email

Description	Example Value
Contact email for the draft order	`[email protected]`

The email address associated with the draft order for contact purposes.

Note

Description	Example Value
Internal notes for the draft order	`Priority order for VIP client`

Internal notes about the draft order that are visible only to store staff.

Tags Command

Description	Example Value
Tag action	`REPLACE`

MERGE: Add new tags to existing tags without removing any
REPLACE: Replace all existing tags with the new tags from the import
DELETE: Remove the specified tags from the existing tags

Created At

Description	Example Value
Date and time when draft order was created - Export only	`2024-02-20 14:45:00 -0500`

The timestamp when the draft order was originally created. This field is export-only and cannot be imported.

Updated At

Description	Example Value
Date and time when draft order was last updated - Export only	`2024-02-20 16:30:00 -0500`

The timestamp when the draft order was last modified. This field is export-only and cannot be imported.

Currency

Description	Example Value
Currency code of the draft order - Export only	`USD`

The three-letter currency code of the draft order. This field is export-only and cannot be imported.

Send Invoice

Description	Example Value
Whether to send invoice to customer	`TRUE`

TRUE: Send an invoice to the customer after creating/updating the draft order
FALSE: Do not send an invoice

Send Invoice: To

Description	Example Value
Email address to send invoice to	`[email protected]`

The email address where the invoice should be sent. If not specified, the draft order email will be used.

Send Invoice: From

Description	Example Value
Sender email address for invoice	`Sarah Martinez <[email protected]>`

The sender email address and name that will appear in the invoice email.

Send Invoice: Bcc

Description	Example Value
Blind carbon copy recipients	`[email protected]`

Email addresses to receive a blind carbon copy of the invoice email.

Send Invoice: Subject

Description	Example Value
Email subject line	`Invoice #{{name}} - #{{total_price}}`

The subject line for the invoice email. You can use variables like #{{name}} and #{{total_price}}.

Send Invoice: Message

Description	Example Value
Custom message in invoice email	`Thank you for choosing our services`

A custom message that will be included in the invoice email.

Complete

Description	Example Value
Whether to convert draft to actual order	`TRUE`

TRUE: Convert the draft order to a completed order
FALSE: Keep as draft order

Complete: Payment Pending

Description	Example Value
Whether completed order should have payment pending	`FALSE`

TRUE: Completed order will have payment pending status
FALSE: Completed order will be marked as paid

Invoice URL

Description	Example Value
Checkout URL for the draft order - Export only	`https://mystore.myshopify.com/invoices/xyz789`

The URL customers can use to complete checkout for the draft order. This field is export-only and cannot be imported.

Invoice Sent At

Description	Example Value
Date and time when invoice was sent - Export only	`2024-02-20 15:00:00 -0500`

The timestamp when the invoice was sent to the customer. This field is export-only and cannot be imported.

Row

Description	Example Value
Row number for multi-row data	`1`

Used when a draft order spans multiple rows (e.g., when including multiple line items).

Top Row

Description	Example Value
Whether this is the first row for this item	`TRUE`

TRUE: This is the primary row for the draft order
FALSE: This is a secondary row for additional line items or data

Additional Details

Description	Example Value
Custom order properties	`Special packaging: fragile\nDelivery note: Handle with care`

Custom properties and notes that can be added to the draft order for special handling instructions.

Customers

Customer: ID

Description	Example Value
Shopify customer ID	`9876543210`

The unique identifier of the customer associated with the draft order.

Customer: Email

Description	Example Value
Customer email address	`[email protected]`

The email address of the customer. This will be used to link to existing customers or create new ones if not found.

Customer: Phone

Description	Example Value
Customer phone number with country code	`+17185556789`

The customer's phone number. Must include country codes (e.g., +1 for US/Canada).

Customer: First Name

Description	Example Value
Customer first name	`Emily`

The first name of the customer.

Customer: Last Name

Description	Example Value
Customer last name	`Rodriguez`

The last name of the customer.

Customer: Note

Description	Example Value
Notes about the customer	`Premium business account`

Internal notes about the customer.

Customer: Orders Count

Description	Example Value
Total orders by this customer - Export only	`12`

The total number of orders placed by this customer. This field is export-only and cannot be imported.

Customer: State

Description	Example Value
Customer account status	`enabled`

The status of the customer account:

disabled: Customer account disabled (default until invited)
invited: Customer has been sent an account activation invite
enabled: Customer accepted invite and created account
declined: Customer declined the account activation invite

Customer: Total Spent

Description	Example Value
Total amount spent by customer - Export only	`8750.50`

The total amount spent by this customer across all orders. This field is export-only and cannot be imported.

Customer: Tags

Description	Example Value
Customer tags	`Premium, B2B`

Tags associated with the customer.

Customer: Email Marketing Status

Description	Example Value
Email marketing consent status	`SUBSCRIBED`

The customer's email marketing subscription status:

SUBSCRIBED: Customer has opted in to receive marketing emails
NOT_SUBSCRIBED: Customer has not opted in or has unsubscribed
PENDING: Subscription is pending confirmation

Customer: SMS Marketing Status

Description	Example Value
SMS marketing consent status	`SUBSCRIBED`

The customer's SMS marketing subscription status:

SUBSCRIBED: Customer has opted in to receive SMS marketing
NOT_SUBSCRIBED: Customer has not opted in or has unsubscribed
PENDING: Subscription is pending confirmation

Customer: Tax Exempt

Description	Example Value
Whether customer is tax exempt	`FALSE`

TRUE: Customer is exempt from paying taxes
FALSE: Customer is subject to applicable taxes

Payment Terms

Payment Terms: Type

Description	Example Value
Payment terms	`Net 30`

The type of payment terms applied to the draft order. If you are using payment terms you need to use one of the following values:

Due on receipt: Payment due immediately upon receipt
Due on fulfillment: Payment due when order is fulfilled
Net 7: Payment due 7 days after invoice
Net 15: Payment due 15 days after invoice
Net 30: Payment due 30 days after invoice
Net 45: Payment due 45 days after invoice
Net 60: Payment due 60 days after invoice
Net 90: Payment due 90 days after invoice
Fixed date: Payment due on a specific fixed date

Shopify does not support custom 'Net X' payment terms. For example, 'Net 14' is not supported.

Payment Terms: Issued At

Description	Example Value
The date from which 'Net X' payment terms are calculated	`2024-12-05 06:12:35 -0500`

The date and time when payment terms were issued to the customer. ISO-formatted timestamps are also supported. This field is used with the Net X payment terms types. If you do not set this field, the app will use the current date.

Payment Terms: Due At

Description	Example Value
When the payment is due	`2024-12-05 06:12:35 -0500`

The date when payment is due according to the payment terms. ISO-formatted timestamps are also supported. This field is only required if you use the Fixed date payment terms type.

Payment Terms: Completed At

Description	Example Value
Payment completion date - Export only	`2024-12-05 06:12:35 -0500`

The date and time when payment terms were completed or paid in full. Empty if payment is still pending. ISO-formatted timestamps are also supported.

Payment Terms: Overdue

Description	Example Value
Payment terms overdue - Export only	`FALSE`

Indicates whether the payment for the order is past due.

TRUE: Payment is overdue based on the due date
FALSE: Payment is not overdue or has been completed

Billing Address

Billing: First Name

Description	Example Value
Billing address first name	`Emily`

The first name for the billing address.

Billing: Last Name

Description	Example Value
Billing address last name	`Rodriguez`

The last name for the billing address.

Billing: Name

Description	Example Value
Full billing name	`Emily Rodriguez`

The complete name for billing purposes.

Billing: Company

Description	Example Value
Billing company name	`ClientCorp Ltd`

The company name associated with the billing address.

Billing: Phone

Description	Example Value
Billing phone number	`+17185556789`

The phone number for the billing address.

Billing: Address 1

Description	Example Value
Billing street address line 1	`123 Business Ave`

The primary street address line for billing.

Billing: Address 2

Description	Example Value
Billing street address line 2	`Unit 450`

Additional address information for billing.

Billing: Zip

Description	Example Value
Billing postal code	`10005`

The postal or zip code for the billing address.

Billing: City

Description	Example Value
Billing city	`New York`

The city for the billing address.

Billing: Province

Description	Example Value
Billing province/state name	`New York`

The full name of the state or province for billing.

Billing: Province Code

Description	Example Value
Billing province/state code	`NY`

The abbreviated code for the state or province.

Billing: Country

Description	Example Value
Billing country name	`United States`

The full country name for billing.

Billing: Country Code

Description	Example Value
Billing country code	`US`

The two-letter country code for billing.

Shipping Address

Shipping: First Name

Description	Example Value
Shipping address first name	`David`

The first name for the shipping address.

Shipping: Last Name

Description	Example Value
Shipping address last name	`Thompson`

The last name for the shipping address.

Shipping: Name

Description	Example Value
Full shipping name	`David Thompson`

The complete name for shipping purposes.

Shipping: Company

Description	Example Value
Shipping company name	`Thompson & Associates`

The company name associated with the shipping address.

Shipping: Phone

Description	Example Value
Shipping phone number	`+13235554567`

The phone number for the shipping address.

Shipping: Address 1

Description	Example Value
Shipping street address line 1	`789 Commerce Blvd`

The primary street address line for shipping.

Shipping: Address 2

Description	Example Value
Shipping street address line 2	`Building C`

Additional address information for shipping.

Shipping: Zip

Description	Example Value
Shipping postal code	`90210`

The postal or zip code for the shipping address.

Shipping: City

Description	Example Value
Shipping city	`Los Angeles`

The city for the shipping address.

Shipping: Province

Description	Example Value
Shipping province/state name	`California`

The full name of the state or province for shipping.

Shipping: Province Code

Description	Example Value
Shipping province/state code	`CA`

The abbreviated code for the state or province.

Shipping: Country

Description	Example Value
Shipping country name	`United States`

The full country name for shipping.

Shipping: Country Code

Description	Example Value
Shipping country code	`US`

The two-letter country code for shipping.

Line Type

Line: Type

Description	Example Value
Type of line: Line Item, Discount, Shipping Line	`Line Item`

The type of line item being processed:

Line Item: Product or custom item in the order
Discount: Order-level discount
Shipping Line: Shipping cost and information

Multiple rows with the same draft order ID can have different line types to build complex orders.

Line Items

Line: Product ID

Description	Example Value
Product ID for the line item	`789456123789`

The unique identifier of the product for this line item.

Line: Product Handle

Description	Example Value
Product handle	`wireless-headphones`

The URL-friendly identifier for the product.

Line: Title

Description	Example Value
Line item title	`Wireless Headphones`

The title of the line item as it appears in the order.

Line: Name

Description	Example Value
Full line item name with variant	`Wireless Headphones - Black / Standard`

The complete name of the line item including variant information.

Line: Variant ID

Description	Example Value
Product variant ID	`321654987321`

The unique identifier of the specific product variant.

Line: Variant Title

Description	Example Value
Variant title (size, color, etc.)	`Black / Standard`

The title describing the variant options (size, color, etc.).

Line: SKU

Description	Example Value
Product SKU	`WH-BLK-001`

The stock keeping unit identifier for the product variant.

Line: Quantity

Description	Example Value
Quantity ordered	`3`

The number of items being ordered.

Line: Price

Description	Example Value
Price per item	`89.99`

The price per individual item.

Line: Discount

Description	Example Value
Discount amount for line	`15.00`

The total discount amount applied to this line item.

Line: Discount per Item

Description	Example Value
Discount per individual item	`5.00`

The discount amount applied to each individual item in the line.

Line: Total

Description	Example Value
Total amount for line item	`254.97`

The total amount for this line item after applying discounts.

Line: Grams

Description	Example Value
Weight per item in grams	`180`

The weight of each item in grams.

Line: Requires Shipping

Description	Example Value
Whether line item needs shipping	`TRUE`

TRUE: This line item requires shipping
FALSE: This line item does not require shipping (e.g., digital products)

Line: Vendor

Description	Example Value
Product vendor	`AudioTech`

The vendor or manufacturer of the product.

Line: Properties

Description	Example Value
Custom line item properties	`Color: Black\nWarranty: 2 Years`

Custom properties for the line item, typically entered by the customer during checkout.

Line: Gift Card

Description	Example Value
Whether line item is a gift card	`FALSE`

TRUE: This line item is a gift card
FALSE: This line item is a regular product

Line: Taxable

Description	Example Value
Whether line item is taxable	`TRUE`

TRUE: This line item is subject to taxes
FALSE: This line item is not taxable

Line: Fulfillable Quantity

Description	Example Value
Quantity available for fulfillment	`3`

The quantity of this line item that can be fulfilled.

Line: Fulfillment Service

Description	Example Value
Fulfillment service provider	`manual`

The fulfillment service responsible for shipping this line item.

Line Items Product Data

Line: Product Type

Description	Example Value
Product type - Export only	`Electronics`

The product type category. This field is export-only and cannot be imported.

Line: Product Tags

Description	Example Value
Product tags - Export only	`Wireless, Premium`

Tags associated with the product. This field is export-only and cannot be imported.

Line: Variant SKU

Description	Example Value
Current variant SKU - Export only	`WH-BLK-001`

The current SKU of the variant. This field is export-only and cannot be imported.

Line: Variant Barcode

Description	Example Value
Current variant barcode - Export only	`987654321098`

The current barcode of the variant. This field is export-only and cannot be imported.

Line: Variant Weight

Description	Example Value
Current variant weight - Export only	`0.18`

The current weight of the variant. This field is export-only and cannot be imported.

Line: Variant Weight Unit

Description	Example Value
Weight unit - Export only	`kg`

The unit of measurement for the variant weight. This field is export-only and cannot be imported.

Line: Variant Inventory Qty

Description	Example Value
Current inventory quantity - Export only	`47`

The current inventory quantity of the variant. This field is export-only and cannot be imported.

Taxes and Totals

Charge Taxes

Description	Example Value
Whether taxes are calculated and charged	`TRUE`

TRUE: Taxes are calculated and charged on the draft order
FALSE: No taxes are calculated or charged

Tax: Included

Description	Example Value
Whether taxes are included in item prices	`FALSE`

TRUE: Taxes are included in the displayed item prices
FALSE: Taxes are calculated and added separately

Tax: Total

Description	Example Value
Total tax amount for the order	`8.50`

The total amount of tax calculated for the entire draft order.

Tax 1: Title

Description	Example Value
First tax name	`VAT`

The name of the first tax applied to the order.

Tax 1: Rate

Description	Example Value
First tax rate	`0.10`

The rate of the first tax as a decimal (e.g., 0.10 for 10%).

Tax 1: Price

Description	Example Value
First tax amount	`5.00`

The amount of the first tax applied to the order.

Tax 2: Title

Description	Example Value
Second tax name	`GST`

The name of the second tax applied to the order.

Tax 2: Rate

Description	Example Value
Second tax rate	`0.05`

The rate of the second tax as a decimal (e.g., 0.05 for 5%).

Tax 2: Price

Description	Example Value
Second tax amount	`2.50`

The amount of the second tax applied to the order.

Tax 3: Title

Description	Example Value
Third tax name	`PST`

The name of the third tax applied to the order.

Tax 3: Rate

Description	Example Value
Third tax rate	`0.07`

The rate of the third tax as a decimal (e.g., 0.07 for 7%).

Tax 3: Price

Description	Example Value
Third tax amount	`3.50`

The amount of the third tax applied to the order.

Weight Total

Description	Example Value
Total weight of all items in grams	`1000`

The combined weight of all line items in the draft order.

Price: Subtotal

Description	Example Value
Subtotal before shipping and taxes	`75.00`

The subtotal amount before shipping charges and taxes are applied.

Price: Total

Description	Example Value
Total amount including taxes and shipping	`95.50`

The final total amount including all taxes, shipping, and other charges.

Export Filters

You can use these filters to limit which draft orders are exported:

status: Filter by draft order status (open, invoice_sent, completed)
created_at: Filter by creation date
updated_at: Filter by last update date
email: Filter by customer email
tag: Filter by draft order tags

Description	Example Value
Draft order tags	`Express, Corporate`

Description	Example Value
Shopify company ID	`456789012345`

Description	Example Value
Company name	`TechSolutions Inc`

Description	Example Value
External company identifier	`TECH-SOL-789`

Description	Example Value
Company location ID	`987654321098`

Description	Example Value
Company location name	`TechSolutions West`

Description	Example Value
External location identifier	`TECH-WEST-456`

Draft Order Fields