Shopify Draft Orders: import/export data structure & description

See what each field/column from our “Draft Orders” template means including possible allowed values and examples.

Fields marked with “Export only” tag cannot be imported/set in Shopify but can be exported with Matrixify export.

To import Shopify Draft Orders read this tutorial.

Excel Sheet Name

Draft Orders

To tell the app that you are importing Draft Orders you need:

If using CSV file then the file name needs to contain the word “draft order”, for example, “my-shopify-draft-orders.csv”
If using XLSX file then the sheet/tab name in the file needs to be “draft order”. The file name for the XLSX file does not matter.

Need a quick start?

Download Draft Orders Demo file

See Tutorials about Draft Orders

Columns Available For Export And Import

Base Columns

Column Description / Example Value

Column	Description / Example Value
ID	ID is automatically generated number by Shopify to identify the item. It is filled in by an Export. Can be used for Import to identify and update existing Draft Orders. When creating new Draft Orders, leave this value empty. Allowed Values Number Example 11920047631
Name	Name of the Draft Order. Shopify is always generating its own Draft Order name and doesn’t allow you to assign any specific custom Name to it. When creating new Draft Orders use the “Number” column to tell the app what rows are from what Draft Order. When updating Draft Orders, Name cannot be used as a unique identifier. For an update, use exported Draft Order ID. Allowed Values Text Example #D100
Command	When importing Draft Order, it tells the app, what to do with it. `NEW`: will try to create a new Draft Order with the provided details. If such Draft Order will already exist (with the same ID or same Name), the Draft Order creation will fail. `MERGE`: will try to find existing Draft Order, and update it with data from the row. If such Draft Order will not be found, then it will create new. `UPDATE`: the app will search for an existing Draft Order and update it. If a draft order cannot be found then that item will fail to import. `REPLACE`: at first, if such Draft Order with provided ID or Name exists, then the app will delete it. After that, it will create a new one. If an existing Draft Order will not be found, then still the app will create a new Draft Order. `DELETE`: the app will delete the existing Draft Order, which is found by ID or Name. If such Draft Order will not be found, then this item import will fail. This DELETE command can be very handy when Draft Orders need to be deleted in bulk, or when such Draft Orders need to be deleted, which cannot be deleted through the Shopify Admin. `IGNORE`: the app will ignore this Draft Order and will skip it. Allowed Values NEW MERGE UPDATE REPLACE DELETE IGNORE Example MERGE
Number *Imported only*	When creating new Draft Orders you can specify this number to mark what rows are from what Draft Order. For example, if you have two Draft Orders in the file and each Draft Order has three rows, then the first three rows would have one number and the other three would have different numbers. Usually you would start with number “1” for all rows that first Draft Order has and then “2” for next Draft Order, but can be any number. It is not set anywhere in Shopify, only used by the app to know where new order starts and ends. Using the Number column is preferred as then the app will not need to index all existing Draft Orders in the store which can take a lot of time when having a lot of Draft Orders. Allowed Values Number Example 1
Order ID	ID of the real Order which was created from this Draft Order. If this cell is filled, this means that the real Order exists from this Draft Order. If this cell is empty, this means that real Order is not yet created. Allowed Values Number Example 234823948234
Status *Export only*	Shows the current status of the Draft Order. Possible values are: open: Draft Order is created but it doesn’t have an invoice sent, and no real order was yet generated. All importable fields can be updated at this stage. invoice_sent: invoice was sent to the customer of this Draft Order. All importable fields can be updated at this stage. completed: real Order was created from this Draft Order. You can see the ID of the real Order in the “Order ID” column. Only Tags can be updated – any other fields cannot be updated anymore. To change the Status, you need to use the respective command columns “Send Invoice” and/or “Complete“. Allowed Values open invoice_sent completed
Email	Darft Orders contact email – can be different from linked Customers email. Shopify is very strong about validating e-mail addresses – it is checking if e-mail actually exists in real life. If you import e-mails and get the error that the Email is not valid then first you should check that this e-mail is really correct. Allowed Values E-mail Example [email protected]
Note	Draft Order notes. Can be a large text going over several lines. Allowed Values Text Example Here I can write any notes I need for the Draft Order.
Tags	Tags allow you to add additional elements or “properties” to your order, which you can use for filtering in Admin. If Draft Order is in “complete” status, Tags is the only field which can be updated. See this tutorial on how to bulk manage your Tags. Allowed Values Comma seperated list Example Urgent, To Review
Tags Command	Tell the app, what to do with Tags: MERGE: will add Tags to existing tags. It means that you don’t need to list all the tags in the import file, you can import those which you want to add. If some of the tags you are importing already exist, then the app will ignore it. DELETE: will delete the Tags that are listed in the import file. If the listed tag will not exist, then the app will ignore it. REPLACE: will replace all existing tags with the tags from the import file. Use this method to maximize the import speed, because if you will use MERGE, it means that the app will need first to load existing tags which takes additional time. If Tags Command is not set, the app will assume the REPLACE command by default. You can also have Tags listed in multiple rows within the item and with different Tags Commands. They will be executed in the same order within the item as you have them listed in the file. See this tutorial on how to bulk manage your Tags. Allowed Values MERGE DELETE REPLACE Example REPLACE
Created At *Export only*	It will be automatically set to the time when the Draft Order was actually created. When migrating from another store, this time will always be the time of migration. Allowed Values Date & Time Example 2018-12-17 18:20:07 +0200
Updated At *Export only*	It will be automatically updated, whenever you change the Draft Order data. Allowed Values Date & Time Example 2018-12-17 18:20:07 +0200
Currency	Currency of the Draft Order. Allowed Values Currency code in ISO 4217 format Example USD
Weight Total *Export only*	Total weight of the ordered items, in grams. Calculated automatically from Line Items. Allowed Values Grams Example 4000
Price: Subtotal *Export only*	Value of the order, including discounts, but before shipping and taxes. Allowed Values Currency Example 1000
Charge Taxes	Whether taxes are calculated and added to an Order. If set to `FALSE`, then Shopify refers to the `Line: Taxable` field for each line_item.Importing this field empty when updating existing Draft Order then the app will not change the existing value, if creating new Draft Order then will assume `TRUE`.Can be both imported for new Draft Orders and updated for existing Draft Orders. Allowed Values TRUE FALSE Example TRUE
Tax 1: Title Tax 2: Title Tax 3: Title *Export only*	Title of each applied tax. Each Draft Order can have up to 3 different taxes applied, therefore all those are split into separate tax columns. To import Taxes – fill those for the Line Items. Allowed Values Text Example VAT
Tax 1: Rate Tax 2: Rate Tax 3: Rate *Export only*	The rate of the tax applied. To import Taxes – fill those for the Line Items. Allowed Values Number Example 0.21
Tax 1: Price Tax 2: Price Tax 3: Price *Export only*	The calculated tax in the Draft Order currency. To import Taxes – fill those for the Line Items. Allowed Values Currency Example 210.00
Tax: Included	Tells whether the Draft Order subtotal has taxes included or not. Cannot be updated, can be only set when creating a new or replacing the Draft Order. Allowed Values TRUE FALSE Example TRUE
Tax: Total	Total amount of the tax applied to the Draft Order. Allowed Values Currency Example 300.43
Price: Total	Total amount of the Draft Order, including line items, discounts, shipping cost, and taxes. Allowed Values Currency Example 1300.43
Additional Details	Additional details collected on the Draft Order from the customer – either from the product page or from the checkout page. Each added property will be shown as “<name>: <value>”, and will include all of those properties as several lines inside the Excel cell. When prepared in the same format, those details also can be imported. Those are visible in Shopify Admin, on each Order, section “Additional Details”. This section shows only if there are any details added, otherwise it’s not visible there. Read more about collecting additional data for orders: Collect information from your customers with cart attributes Allowed Values Lines of "name: value" Example Gift wrapped: yes Door code: 1234
Row # *Export only*	Will have row number from 1 till the end for each row. So that if you change the sorting in your exported file to easier update your data, you can sort it back by “Row #” and return it to the original sorting. Because, you know, all the item data should be together – and if you change the sorting, you need to sort it back.
Top Row *Export only*	It will have value “TRUE” for each “top row” of the item. That can help you filter in Excel to get only the base rows, in case you need to get rid of repeated rows for each item. Some sheets already had this as Primary Row column earlier, but we have added it now to all the sheets now and renamed to Top Row so it’s more clear.

ID is automatically generated number by Shopify to identify the item.
It is filled in by an Export.
Can be used for Import to identify and update existing Draft Orders.
When creating new Draft Orders, leave this value empty.

Allowed Values

Number

Example

11920047631

Name

Name of the Draft Order.

Shopify is always generating its own Draft Order name and doesn’t allow you to assign any specific custom Name to it.
When creating new Draft Orders use the “Number” column to tell the app what rows are from what Draft Order.

When updating Draft Orders, Name cannot be used as a unique identifier. For an update, use exported Draft Order ID.

Allowed Values

Text

Example

#D100

Command

When importing Draft Order, it tells the app, what to do with it.

NEW: will try to create a new Draft Order with the provided details. If such Draft Order will already exist (with the same ID or same Name), the Draft Order creation will fail.
MERGE: will try to find existing Draft Order, and update it with data from the row. If such Draft Order will not be found, then it will create new.
UPDATE: the app will search for an existing Draft Order and update it. If a draft order cannot be found then that item will fail to import.
REPLACE: at first, if such Draft Order with provided ID or Name exists, then the app will delete it. After that, it will create a new one. If an existing Draft Order will not be found, then still the app will create a new Draft Order.
DELETE: the app will delete the existing Draft Order, which is found by ID or Name. If such Draft Order will not be found, then this item import will fail. This DELETE command can be very handy when Draft Orders need to be deleted in bulk, or when such Draft Orders need to be deleted, which cannot be deleted through the Shopify Admin.
IGNORE: the app will ignore this Draft Order and will skip it.

Allowed Values

NEW
MERGE
UPDATE
REPLACE
DELETE
IGNORE

Example

MERGE

Number

Imported only

When creating new Draft Orders you can specify this number to mark what rows are from what Draft Order.

For example, if you have two Draft Orders in the file and each Draft Order has three rows, then the first three rows would have one number and the other three would have different numbers.
Usually you would start with number “1” for all rows that first Draft Order has and then “2” for next Draft Order, but can be any number.
It is not set anywhere in Shopify, only used by the app to know where new order starts and ends.

Using the Number column is preferred as then the app will not need to index all existing Draft Orders in the store which can take a lot of time when having a lot of Draft Orders.

Allowed Values

Number

Example

Order ID

ID of the real Order which was created from this Draft Order.

If this cell is filled, this means that the real Order exists from this Draft Order.

If this cell is empty, this means that real Order is not yet created.

Allowed Values

Number

Example

234823948234

Status

Export only

Shows the current status of the Draft Order.

Possible values are:

open: Draft Order is created but it doesn’t have an invoice sent, and no real order was yet generated. All importable fields can be updated at this stage.
invoice_sent: invoice was sent to the customer of this Draft Order. All importable fields can be updated at this stage.
completed: real Order was created from this Draft Order. You can see the ID of the real Order in the “Order ID” column. Only Tags can be updated – any other fields cannot be updated anymore.

To change the Status, you need to use the respective command columns “Send Invoice” and/or “Complete“.

Allowed Values

open
invoice_sent
completed

Email

Darft Orders contact email – can be different from linked Customers email.

Shopify is very strong about validating e-mail addresses – it is checking if e-mail actually exists in real life.
If you import e-mails and get the error that the Email is not valid then first you should check that this e-mail is really correct.

Allowed Values

E-mail

Example

[email protected]

Note

Draft Order notes.

Can be a large text going over several lines.

Allowed Values

Text

Example

Here I can write any notes I need for the Draft Order.

Tags

Tags allow you to add additional elements or “properties” to your order, which you can use for filtering in Admin.

If Draft Order is in “complete” status, Tags is the only field which can be updated.

See this tutorial on how to bulk manage your Tags.

Allowed Values

Comma seperated list

Example

Urgent, To Review

Tags Command

Tell the app, what to do with Tags:

MERGE: will add Tags to existing tags. It means that you don’t need to list all the tags in the import file, you can import those which you want to add. If some of the tags you are importing already exist, then the app will ignore it.
DELETE: will delete the Tags that are listed in the import file. If the listed tag will not exist, then the app will ignore it.
REPLACE: will replace all existing tags with the tags from the import file. Use this method to maximize the import speed, because if you will use MERGE, it means that the app will need first to load existing tags which takes additional time.

If Tags Command is not set, the app will assume the REPLACE command by default.

You can also have Tags listed in multiple rows within the item and with different Tags Commands.
They will be executed in the same order within the item as you have them listed in the file.

See this tutorial on how to bulk manage your Tags.

Allowed Values

MERGE
DELETE
REPLACE

Example

REPLACE

Created At

Export only

It will be automatically set to the time when the Draft Order was actually created. When migrating from another store, this time will always be the time of migration.

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

Updated At

Export only

It will be automatically updated, whenever you change the Draft Order data.

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

Currency

Currency of the Draft Order.

Allowed Values

Currency code in ISO 4217 format

Example

USD

Weight Total

Export only

Total weight of the ordered items, in grams.

Calculated automatically from Line Items.

Allowed Values

Grams

Example

Price: Subtotal

Export only

Value of the order, including discounts, but before shipping and taxes.

Allowed Values

Currency

Example

Charge Taxes

Whether taxes are calculated and added to an Order.
If set to FALSE, then Shopify refers to the Line: Taxable field for each line_item.Importing this field empty when updating existing Draft Order then the app will not change the existing value, if creating new Draft Order then will assume TRUE.Can be both imported for new Draft Orders and updated for existing Draft Orders.

Allowed Values

TRUE
FALSE

Example

TRUE

210.00

Tax: Included

Tells whether the Draft Order subtotal has taxes included or not.

Cannot be updated, can be only set when creating a new or replacing the Draft Order.

Allowed Values

TRUE
FALSE

Example

TRUE

Tax: Total

Total amount of the tax applied to the Draft Order.

Allowed Values

Currency

Example

300.43

Price: Total

Total amount of the Draft Order, including line items, discounts, shipping cost, and taxes.

Allowed Values

Currency

Example

1300.43

Additional Details

Additional details collected on the Draft Order from the customer – either from the product page or from the checkout page.

Each added property will be shown as “<name>: <value>”, and will include all of those properties as several lines inside the Excel cell.

When prepared in the same format, those details also can be imported.

Those are visible in Shopify Admin, on each Order, section “Additional Details”. This section shows only if there are any details added, otherwise it’s not visible there.

Read more about collecting additional data for orders:

Collect information from your customers with cart attributes

Allowed Values

Lines of

"name: value"

Example

Gift wrapped: yes
Door code: 1234

Row #

Export only

Will have row number from 1 till the end for each row. So that if you change the sorting in your exported file to easier update your data, you can sort it back by “Row #” and return it to the original sorting. Because, you know, all the item data should be together – and if you change the sorting, you need to sort it back.

Top Row

Export only

It will have value “TRUE” for each “top row” of the item. That can help you filter in Excel to get only the base rows, in case you need to get rid of repeated rows for each item. Some sheets already had this as Primary Row column earlier, but we have added it now to all the sheets now and renamed to Top Row so it’s more clear.

Customer Columns

Each Draft Order can have one customer or no customer at all.

When importing Draft Orders with Customer data, Matrixify will link them by Email or by Phone to existing customers, or create new Customers if such customer doesn’t exist yet.
If Draft Order is also linked to the Company then the Customer in these columns needs to have role assigned in the linked Company Location.

If you need to change the fields of existing Customer, you cannot change them through Draft Order – you need to import the update through the Customers sheet.

If you are about to send the invoice to the customer, you can skip filling the customer columns – because the customer who will receive the invoice, will fill their customer data themselves.

Column	Description / Example Value
Customer: ID	Shopify generated Customer ID. If specified existing customer ID from that store, Draft Order will be linked to that customer. If you don’t have an ID, then leave it empty, and Matrixify will link to existing customer by Customer Email or Phone – whichever is found first. Allowed Values Number Example 1234567890
Customer: Email	Customer e-mail. The app will link to existing store Customer by this e-mail or Phone number if e-mail is empty. If the app will not be able to find existing customer to link to, it will create a new customer. Shopify is very strong about validating e-mail addresses – it is checking if e-mail actually exists in real life. If you import e-mails and get the error that Email is not valid then first you should check that this e-mail is really correct. If it happens to be some old customer Email which you still need to import then you can move that Email value to Note field and leave this Email field empty. To change for an existing Draft Order – change the data of the Customer. Allowed Values E-mail Example [email protected]
Customer: Phone	Phone number must be full – with the country code and must be valid for the respective country. You can prefix phone numbers with ‘ (apostrophe) to allow Excel to show the + (plus) sign. But the + (plus sign) is not required. The app will clean out any non-digit characters from the Phone field. If e-mail is empty, the app will search existing customer by Phone number – and if will find, then will attach this order to that customer. To change for an existing Draft Order – change the data of the Customer. Allowed Values Phone Number Example '+15417543000
Customer: First Name	The first name of the Customer. To change for an existing Draft Order – change the data of the Customer. Allowed Values Text Example John
Customer: Last Name	The last name of the Customer. To change for an existing Order – change the data of the Customer. Allowed Values Text Example Smith
Customer: Note	Whatever is written on the Customer card, accessible from Shopify Admin. To change for an existing Order – change the data of the Customer. Allowed Values Text Example Your notes go here.
Customer: Orders Count *Export only*	Total count of orders made by this Customer. Allowed Values Number Example 100
Customer: State	The Customer status – one of those: disabled: customers are disabled by default until they are invited. invited: the customer has been emailed an invite to create an account. enabled: the customer accepted the email invite and created an account. declined: the customer declined the email invite to create an account. If Customer has declined your invitation, you cannot generate new Account Activation URL. To change for an existing Draft Order – change the data of the Customer. Allowed Values disabled invited enabled declined Example enabled
Customer: Total Spent *Export only*	The total amount the customer has spent at the moment of the export. Allowed Values Currency Example 1024.99
Customer: Tags	Tags allow you to add additional elements or “properties” to your Customer, which you can use for filtering, for developing some additional logic for those Customers in your Store Theme. To change for an existing Draft Order – change the data of the Customer. Allowed Values Comma seperated list Example Friend, Migrated
Customer: Accepts Marketing	Whether Customer accepted that he can be sent Marketing e-mails. To change for an existing Draft Order – change the data of the Customer. Allowed Values TRUE FALSE Example TRUE
Customer: Tax Exempt	Whether the Customer has attribute tax exempt enabled. To change for an existing Draft Order – change the data of the Customer. Allowed Values TRUE FALSE Example TRUE

Column

Description / Example Value

Customer: ID

Shopify generated Customer ID. If specified existing customer ID from that store, Draft Order will be linked to that customer.

If you don’t have an ID, then leave it empty, and Matrixify will link to existing customer by Customer Email or Phone – whichever is found first.

Allowed Values

Number

Example

1234567890

Customer: Email

Customer e-mail.

The app will link to existing store Customer by this e-mail or Phone number if e-mail is empty. If the app will not be able to find existing customer to link to, it will create a new customer.

Shopify is very strong about validating e-mail addresses – it is checking if e-mail actually exists in real life. If you import e-mails and get the error that Email is not valid then first you should check that this e-mail is really correct. If it happens to be some old customer Email which you still need to import then you can move that Email value to Note field and leave this Email field empty.

To change for an existing Draft Order – change the data of the Customer.

Allowed Values

E-mail

Example

[email protected]

Customer: Phone

Phone number must be full – with the country code and must be valid for the respective country.

Customer: State

The Customer status – one of those:

disabled: customers are disabled by default until they are invited.
invited: the customer has been emailed an invite to create an account.
enabled: the customer accepted the email invite and created an account.
declined: the customer declined the email invite to create an account. If Customer has declined your invitation, you cannot generate new Account Activation URL.

To change for an existing Draft Order – change the data of the Customer.

Allowed Values

disabled
invited
enabled
declined

Example

enabled

Customer: Total Spent

Export only

The total amount the customer has spent at the moment of the export.

Allowed Values

Currency

Example

1024.99

Customer: Tags

Tags allow you to add additional elements or “properties” to your Customer, which you can use for filtering, for developing some additional logic for those Customers in your Store Theme.

To change for an existing Draft Order – change the data of the Customer.

Allowed Values

Comma seperated list

Example

Friend, Migrated

Customer: Accepts Marketing

Whether Customer accepted that he can be sent Marketing e-mails.

To change for an existing Draft Order – change the data of the Customer.

Allowed Values

TRUE
FALSE

Example

TRUE

Customer: Tax Exempt

Whether the Customer has attribute tax exempt enabled.

To change for an existing Draft Order – change the data of the Customer.

Allowed Values

TRUE
FALSE

Example

TRUE

Customer Billing Address Columns

All the following fields will be shown in the Draft Order in the Billing Address block.

Can only be updated for draft orders with statuses “open” and “invoice sent”, cannot be updated for “completed” Draft Orders.

Column	Description / Example Value
Billing: First Name	The first name of the Customer in the Billing Address. Allowed Values Text Example John
Billing: Last Name	The last name of the Customer. Allowed Values Text Example Smith
Billing: Name	Full name of the Customer. First Name and Last Name joined.Imported only if Billing: First Name and Billing: Last Name is not at all in the file as columns Allowed Values Text Example John Smith
Billing: Company	Company name, if the billing address is a company. Allowed Values Text Example Smith Inc.
Billing: Phone	Phone number to use for this address. Allowed Values Phone Number Example '+15417543002
Billing: Address 1	Address 1st line. Allowed Values Text Example Calvin Street 5
Billing: Address 2	Address 2nd line. Allowed Values Text Example 2nd Floor
Billing: Zip	Zip number of the address. Shopify doesn’t check its correctness. Allowed Values Zip Example ZIP-1234
Billing: City	City name. Is not checked, so it’s possible to enter any city name. Allowed Values Text Example Dough
Billing: Province	Province names are checked against Shopify geographic classifier. If provided province will not be valid, then Shopify will accept it, but it will be empty on the customer card. If you are not sure, what are available values, go to Shopify Admin, edit the Address, and click the drop-down to choose the Province for chosen Country. If the Province Code is filled, this can be left empty, then Province will be set from there. Allowed Values Province Name Example Ontario
Billing: Province Code	In Shopify classifier there are Province Codes. If provided province code will not be valid, then Shopify will accept it, but it will be empty on the customer card. If Province is filled, this can be left empty, then Province will be set from there. Allowed Values Province Code Example ON
Billing: Country	Country names are checked against Shopify geographic classifier. If the provided country will not be valid, then Shopify will accept it, but it will be empty on the customer card. If you are not sure, what are available values, go to Shopify Admin, edit the Address, and click the drop-down to choose the Country. If Country Code is filled, this can be left empty, then Country will be set from there. Required Country or Country Code. If empty, the address will not be created. Allowed Values Country Name Example Canada
Billing: Country Code	Country international code, consisting of 2 letters. If Country is filled, this can be left empty, then Country will be set from there. Allowed Values Country Code Example CA

Customer Shipping Address Columns

All the following fields will be shown in the Draft Order in the Shipping Address block.

Can only be updated for draft orders with statuses “open” and “invoice sent”, cannot be updated for “completed” Draft Orders.

Column	Description / Example Value
Shipping: First Name	The first name of the Customer in the Shipping Address. Allowed Values Text Example John
Shipping: Last Name	The last name of the Customer. Allowed Values Text Example Smith
Shipping: Name	Full name of the Customer. First Name and Last Name joined.Imported only if Shipping: First Name and Shipping: Last Name is not at all in the file as columns Allowed Values Text Example John Smith
Shipping: Company	Company name, if the billing address is a company. Allowed Values Text Example Smith Inc.
Shipping: Phone	Phone number to use for this address. Allowed Values Phone Number Example '+15417543002
Shipping: Address 1	Address 1st line. Allowed Values Text Example Calvin Street 5
Shipping: Address 2	Address 2nd line. Allowed Values Text Example 2nd Floor
Shipping: Zip	Zip number of the address. Shopify doesn’t check its correctness. Allowed Values Zip Example ZIP-1234
Shipping: City	City name. Is not checked, so it’s possible to enter any city name. Allowed Values Text Example Dough
Shipping: Province	Province names are checked against Shopify geographic classifier. If provided province will not be valid, then Shopify will accept it, but it will be empty on the customer card. If you are not sure, what are available values, go to Shopify Admin, edit the Address, and click the drop-down to choose the Province for chosen Country. If the Province Code is filled, this can be left empty, then Province will be set from there. Allowed Values Province Name Example Ontario
Shipping: Province Code	In Shopify classifier there are Province Codes. If provided province code will not be valid, then Shopify will accept it, but it will be empty on the customer card. If Province is filled, this can be left empty, then Province will be set from there. Allowed Values Province Code Example ON
Shipping: Country	Country names are checked against Shopify geographic classifier. If the provided country will not be valid, then Shopify will accept it, but it will be empty on the customer card. If you are not sure, what are available values, go to Shopify Admin, edit the Address, and click the drop-down to choose the Country. If Country Code is filled, this can be left empty, then Country will be set from there. Required Country or Country Code. If empty, the address will not be created. Allowed Values Country Name Example Canada
Shipping: Country Code	Country international code, consisting of 2 letters. If Country is filled, this can be left empty, then Country will be set from there. Allowed Values Country Code Example CA

Companies

Company linked to the Draft Order.

If you set Company when creating or updating the Draft Order, then the Customer linked to the Draft Order in the Customer columns must have a role assigned in the specified Company Location.

Column	Description
Company: ID	Shopify internal ID for the linked Company. Allowed Values Number Example 916274112
Company: Name	Name of the Company linked to the Draft Order. Allowed Values Text Example Shopify
Company: External ID	External ID for the Company linked to the Draft Order. Allowed Values Text Example Shopify-123
Company: Location ID	Shopify internal ID for the Company Location linked to the Draft Order. Allowed Values Number Example 123876123
Company: Location Name	Company Location Name linked to Draft Order. Allowed Values Text Example Shopify South Warehouse
Company: Location External ID	Company Location External ID linked to the Draft Order. Allowed Values Text Example Shopify-123-w

Line Item Columns

Each Draft Order must have at least one line item.

Can only be updated for draft orders with statuses “open” and “invoice sent”, cannot be updated for “completed” Draft Orders.

Column	Description / Example Value
Line: Type	Draft Order consists of “Line Items”, where each of them as a certain line type. That allows to group items together in a fashion that can be reconciled with actual draft order data, and most importantly – cross-check that all amounts match. Some of the line types will have details in the Line Item columns, but some will have details in their own respective columns. Line Item: Draft Order line item. Discount: Discount which is applied to the whole order. A Draft Order can have only one discount line. Shipping Line: Shipping cost of the whole order. A Draft Order can have only one shipping line. Allowed Values Line Item Discount Shipping Line Example Line Item
Line: Product ID	ID of the line item Product – if the line item is a product. Line items can be custom, without a link to the Product, in that case, the Product ID will be empty. When importing a Draft Order, can have a real product ID from the store. If such ID will not be found in the store (e.g. when copying Draft Orders from another store), then the app will try to match it by “Line: Product Handle” column value. Allowed Values Number Example 200005386255
Line: Product Handle	Has a different value, depending on the Line Type: Line Item: this is the secondary way how to identify the product if it can’t be found by Product ID. It is used in cases when copying Draft Orders from one store to another, which have the same Products – then the right product will be linked to the Draft Order by the Handle. Discount: ignored Shipping Line: Shipping service Handle. Allowed Values Text Example tshirt-with-picture-of-me
Line: Title	Has a different value, depending on the Line Type: Line Item: the title of the Draft Order line item. When importing, if Line Item is linked to Product then Shopify will always take this value from the actual Product. Discount: “percentage” or “fixed_amount”. To set the discount value, see the column “Line: Quantity”. Shipping Line: the shipping title written in free form. If Title will contain HTML tags then they will be removed by the app. Allowed Values Text Example Tshirt With Picture Of Me
Line: Name	Has a different value, depending on the Line Type: Line Item: full name of the Draft Order line item, which includes the variant title. Formatted as <product title> – <variant title>. When importing – it will be saved, but will not be visible anywhere on the Draft Order screen. Discount: the free text comment that was written for the discount. If the discount code was used, then it will be here. Shipping Line: the shipping code, usually has value “custom”. Allowed Values Text Example Tshirt With Picture Of Me - Red / XS
Line: Variant ID	Variant ID of the line item Product variant – if the line item is a product. In case of the custom line item (not related to a real product), this ID will be empty. When importing a Draft Order, can have a real variant ID from the store. If such ID will not be found in the store for that product (e.g. when copying Draft Orders from another store), then the app will try to match it by “Line: SKU” column value. Allowed Values Number Example 1834691428367
Line: Variant Title	Has a different value, depending on the Line Type: Line Item: the title of the product variant included in the line item. Discount: ignored Shipping Line: ignored Allowed Values Text Example Red / XS
Line: SKU	Has a different value, depending on the Line Type: Line Item: the SKU of the product variant included in the line item. Discount: ignored Shipping Line: ignored Allowed Values Text Example SKU-1234567
Line: Quantity	Has a different value, depending on the Line Type: Line Item: the quantity of the line item purchased. Discount: the value of the discount applied. If “Line: Title” is “percentage” then this will be the percentage number. If “fixed_amount” then the value of the fixed amount discount. The value should be positive. Shipping Line: ignored Allowed Values Number Example 100
Line: Price	Has a different value, depending on the Line Type: Line Item: the price of one line item purchased – can only be set for Custom Line Items. Line items that are linked to the actual product will get their Line: Price set from the Products price. Price is required for Line Item when creating a new Order – be it as custom price, or from the linked product. Discount: ignored Shipping Line: the price of the shipping applied to the order. Allowed Values Currency Example 5.49
Line: Discount	Has a different value, depending on the Line Type: Line Item: line item level discount amount. Always expressed as a fixed value, regardless if the percentage or fixed amount is used. Discount: the whole Draft Order level discount amount. The amount is negative. If importing empty value for “percentage” discount type, then it’s automatically calculated from the specified percentage in the “Line: Quantity” column. Shipping Line: ignored Amounts in this column are organized so that you can sum all discount column per order, and get the correct total discount value for that Draft Order. Allowed Values Currency Example 49.00
Line: Discount per Item *Export only*	Line item level discount divided with line item quantity. Cannot be imported. Allowed Values Currency Example 15.49
Line: Total	Has a different value, depending on the Line Type: Line Item: line item total as Quantity * Price + Discount (because Discount is negative). Discount: the whole Draft Order level discount amount total. The amount is negative. If importing empty value for “percentage” discount type, then it’s automatically calculated from the specified percentage in the “Line: Quantity” column. Shipping Line: the same as “Line: Price”. Ignored when imported. Amounts in this column are organized so that you can sum all Line Totals per order, and get the correct total value for that Draft Order. Allowed Values Currency Example 500.00
Line: Grams	Has a different value, depending on the Line Type: Line Item: weight per line item sold in grams (weight of one item). To get the weight of the whole line item – multiply this by “Line: Quantity”. Discount: ignored Shipping Line: ignored Allowed Values Number Example 250
Line: Requires Shipping	Has a different value, depending on the Line Type: Line Item: TRUE if the line item requires shipping. Discount: ignored Shipping Line: ignored Allowed Values TRUE FALSE Example TRUE
Line: Vendor	Vendor name of the product purchased. Allowed Values Text Example Puma
Line: Properties	Additional details collected on the Draft Order from the customer about the line item – either from the product page or from the checkout page. Each added property will be shown as “<name>: <value>”, and will include all of those properties as several lines inside the Excel cell. When prepared in the same format, those details also can be imported. Those are visible in Shopify Admin, on Draft Order, for each Line Item. Those properties show only if there are any added, otherwise, they are not shown here. Read more about collecting additional properties for order line items: Get customization information for products with line item properties Allowed Values Lines of "name: value" Example Color: Red Engraving: My Name
Line: Gift Card	TRUE if the line item is a gift card. Allowed Values TRUE FALSE Example FALSE
Line: Taxable	TRUE if the line item is taxable. Allowed Values TRUE FALSE Example TRUE
Line: Tax Total *Export only*	Sum of taxes in this line. Allowed Values Currency Example 29.85
Line: Tax 1 Title Line: Tax 2 Title Line: Tax 3 Title	Title of each applied tax. Each order can have up to 3 different taxes applied, therefore all those are split into separate tax columns. Allowed Values Text Example VAT
Line: Tax 1 Rate Line: Tax 2 Rate Line: Tax 3 Rate	The rate of the tax applied. Allowed Values Decimal Number Example 0.21
Line: Tax 1 Price Line: Tax 2 Price Line: Tax 3 Price	The calculated tax in the order currency. Allowed Values Currency Example 105.00
Line: Fulfillable Quantity *Export only*	The quantity of the line item that is still left to be fulfilled. Only exported – when importing it is calculated from actual line items. Allowed Values Number Example 50
Line: Fulfillment Service	Service provider handle who is doing the fulfillment. To find out the handle, easiest is to enter one through the Shopify Admin, and then look in the export file. If empty, will be assumed as “manual” by default. Allowed Values manual amazon shipware <other provider handle> Example manual

Column

Description / Example Value

Line: Type

Draft Order consists of “Line Items”, where each of them as a certain line type. That allows to group items together in a fashion that can be reconciled with actual draft order data, and most importantly – cross-check that all amounts match.

Some of the line types will have details in the Line Item columns, but some will have details in their own respective columns.

Line Item: Draft Order line item.
Discount: Discount which is applied to the whole order. A Draft Order can have only one discount line.
Shipping Line: Shipping cost of the whole order. A Draft Order can have only one shipping line.

Allowed Values

Line Item
Discount
Shipping Line

Example

Line Item

Line: Product ID

ID of the line item Product – if the line item is a product.

Line items can be custom, without a link to the Product, in that case, the Product ID will be empty.

When importing a Draft Order, can have a real product ID from the store. If such ID will not be found in the store (e.g. when copying Draft Orders from another store), then the app will try to match it by “Line: Product Handle” column value.

Allowed Values

Number

Example

200005386255

Line: Product Handle

Has a different value, depending on the Line Type:

Line Item: this is the secondary way how to identify the product if it can’t be found by Product ID. It is used in cases when copying Draft Orders from one store to another, which have the same Products – then the right product will be linked to the Draft Order by the Handle.
Discount: ignored
Shipping Line: Shipping service Handle.

Allowed Values

Text

Example

tshirt-with-picture-of-me

Line: Title

Has a different value, depending on the Line Type:

Line Item: the title of the Draft Order line item. When importing, if Line Item is linked to Product then Shopify will always take this value from the actual Product.
Discount: “percentage” or “fixed_amount”. To set the discount value, see the column “Line: Quantity”.
Shipping Line: the shipping title written in free form.

If Title will contain HTML tags then they will be removed by the app.

Allowed Values

Text

Example

Tshirt With Picture Of Me

Line: Name

Has a different value, depending on the Line Type:

Line Item: full name of the Draft Order line item, which includes the variant title. Formatted as <product title> – <variant title>. When importing – it will be saved, but will not be visible anywhere on the Draft Order screen.
Discount: the free text comment that was written for the discount. If the discount code was used, then it will be here.
Shipping Line: the shipping code, usually has value “custom”.

Allowed Values

Text

Example

Tshirt With Picture Of Me - Red / XS

Line: Variant ID

Variant ID of the line item Product variant – if the line item is a product.

In case of the custom line item (not related to a real product), this ID will be empty.

When importing a Draft Order, can have a real variant ID from the store. If such ID will not be found in the store for that product (e.g. when copying Draft Orders from another store), then the app will try to match it by “Line: SKU” column value.

Allowed Values

Number

Example

1834691428367

Line: Variant Title

Has a different value, depending on the Line Type:

Line Item: the title of the product variant included in the line item.
Discount: ignored
Shipping Line: ignored

Allowed Values

Text

Example

Red / XS

Line: SKU

Has a different value, depending on the Line Type:

Line Item: the SKU of the product variant included in the line item.
Discount: ignored
Shipping Line: ignored

Allowed Values

Text

Example

SKU-1234567

Line: Quantity

Has a different value, depending on the Line Type:

Line Item: the quantity of the line item purchased.
Discount: the value of the discount applied. If “Line: Title” is “percentage” then this will be the percentage number. If “fixed_amount” then the value of the fixed amount discount. The value should be positive.
Shipping Line: ignored

Allowed Values

Number

Example

Line: Price

Has a different value, depending on the Line Type:

Line Item: the price of one line item purchased – can only be set for Custom Line Items. Line items that are linked to the actual product will get their Line: Price set from the Products price. Price is required for Line Item when creating a new Order – be it as custom price, or from the linked product.
Discount: ignored
Shipping Line: the price of the shipping applied to the order.

Allowed Values

Currency

Example

5.49

Line: Discount

Has a different value, depending on the Line Type:

Line Item: line item level discount amount. Always expressed as a fixed value, regardless if the percentage or fixed amount is used.
Discount: the whole Draft Order level discount amount. The amount is negative. If importing empty value for “percentage” discount type, then it’s automatically calculated from the specified percentage in the “Line: Quantity” column.
Shipping Line: ignored

Amounts in this column are organized so that you can sum all discount column per order, and get the correct total discount value for that Draft Order.

Allowed Values

Currency

Example

49.00

Line: Discount per Item

Export only

Line item level discount divided with line item quantity. Cannot be imported.

Allowed Values

Currency

Example

15.49

Line: Total

Has a different value, depending on the Line Type:

Line Item: line item total as Quantity * Price + Discount (because Discount is negative).
Discount: the whole Draft Order level discount amount total. The amount is negative. If importing empty value for “percentage” discount type, then it’s automatically calculated from the specified percentage in the “Line: Quantity” column.
Shipping Line: the same as “Line: Price”. Ignored when imported.

Amounts in this column are organized so that you can sum all Line Totals per order, and get the correct total value for that Draft Order.

Allowed Values

Currency

Example

500.00

Line: Grams

Has a different value, depending on the Line Type:

Line Item: weight per line item sold in grams (weight of one item). To get the weight of the whole line item – multiply this by “Line: Quantity”.
Discount: ignored
Shipping Line: ignored

Allowed Values

Number

Example

Line: Requires Shipping

Has a different value, depending on the Line Type:

Line Item: TRUE if the line item requires shipping.
Discount: ignored
Shipping Line: ignored

Allowed Values

TRUE
FALSE

Example

TRUE

Line: Vendor

Vendor name of the product purchased.

Allowed Values

Text

Example

Puma

Line: Properties

Additional details collected on the Draft Order from the customer about the line item – either from the product page or from the checkout page.

Each added property will be shown as “<name>: <value>”, and will include all of those properties as several lines inside the Excel cell.

When prepared in the same format, those details also can be imported.

Those are visible in Shopify Admin, on Draft Order, for each Line Item. Those properties show only if there are any added, otherwise, they are not shown here.

Read more about collecting additional properties for order line items:

Get customization information for products with line item properties

Allowed Values

Lines of

"name: value"

Example

Color: Red
Engraving: My Name

Line: Gift Card

TRUE if the line item is a gift card.

Allowed Values

TRUE
FALSE

Example

FALSE

Line: Taxable

TRUE if the line item is taxable.

Allowed Values

TRUE
FALSE

Example

TRUE

Line: Tax Total

Export only

Sum of taxes in this line.

Allowed Values

Currency

Example

29.85

105.00

Line: Fulfillable Quantity

Export only

The quantity of the line item that is still left to be fulfilled.

Only exported – when importing it is calculated from actual line items.

Allowed Values

Number

Example

Line: Fulfillment Service

Service provider handle who is doing the fulfillment.

To find out the handle, easiest is to enter one through the Shopify Admin, and then look in the export file.

If empty, will be assumed as “manual” by default.

Allowed Values

manual
amazon
shipware

Example

manual

Product Data Columns

Those columns are only exported. They will get ignored if being imported back.

Note that if you change the data of your Shopify Product, the Draft Order Line items will remain as they were when the order was placed, but the Product Data columns will contain the current product data.

Column	Description / Example Value
Line: Product Type *Export only*	Product Type Type Text
Line: Product Tags *Export only*	Product Tags Type Text
Line: Variant SKU *Export only*	Product Variant SKU Type Text
Line: Variant Barcode *Export only*	Product Variant Barcode Type Text
Line: Variant Weight *Export only*	Product Variant Weight Type Number
Line: Variant Weight Unit *Export only*	Product Variant Weight Unit Type Text
Line: Variant Inventory Qty *Export only*	Product Variant Inventory Quantity If you have the inventory distributed across several locations, then this quantity will show the total sum of available inventory of this variant across all your locations. Type Number

Column

Text

Line: Variant Inventory Qty

Export only

Product Variant Inventory Quantity

If you have the inventory distributed across several locations, then this quantity will show the total sum of available inventory of this variant across all your locations.

Type

Number

Invoice Columns

You can instruct Shopify to send an invoice for the Draft Order to the customer – by importing those invoice columns.

Column	Description / Example Value
Invoice URL *Export only*	Draft Orders Invoice / Checkout URL. URL can be used to send invoices manually to Customers. Example https://cool-store.myshopify.com/4412382123/invoices/98ab1235882c48gh9123v4983c6154d3
Invoice Sent At *Export only*	Date and Time when the invoice was sent. Example 2018-12-17 18:20:07 +0200
Send Invoice	If setting this to TRUE, it tells the Matrixify app to send the invoice for this Draft Order. The link received by the customer will take them to the Checkout page. Once they will complete the checkout, the Draft Order will get completed – it will create the real Order. When importing new Draft Order with this set to TRUE, at first the Draft Order is created and instantly the invoice is sent to the customer. Allowed Values TRUE FALSE
Send Invoice: To	E-mail address of the invoice recipient. If left empty, the invoice is being sent to the Customer which is the “Customer: Email”. Allowed Values E-mail
Send Invoice: From	Sender e-mail address which will show for the customer who received the invoice. You can also enclose the email in “<>” and add a sender name at the beginning. That will show up in the received invoice as a sender name. Allowed Values E-mail or Name <e-mail> Example Jon Sunny <[email protected]>
Send Invoice: Bcc	“Blind carbon copy” of the e-mail – which means, additional recipients of the invoice. Their e-mail addresses will not be visible by e-mail receivers, hence the “blind”. Allowed Values E-mail
Send Invoice: Subject	The e-mail subject. If left empty, the Shopify will put its own default e-mail subject. You can also use some variables in the invoice subject that Shopify knows how to decode. For example: {{name}} {{total_price}} {{note}} You can find a documented list of variables in the Shopify documentation. Allowed Values Text Example Invoice {{name}} - {{total_price}}$ - {{note}}
Send Invoice: Message	The message of the invoice e-mail. HTML code is allowed. If empty, then the default Shopify e-mail message will be used. Allowed Values Text

Column

Description / Example Value

Invoice URL

Export only

Draft Orders Invoice / Checkout URL.

URL can be used to send invoices manually to Customers.

Example

https://cool-store.myshopify.com/4412382123/invoices/98ab1235882c48gh9123v4983c6154d3

Invoice Sent At

Export only

Date and Time when the invoice was sent.

Example

2018-12-17 18:20:07 +0200

Send Invoice

If setting this to TRUE, it tells the Matrixify app to send the invoice for this Draft Order.

The link received by the customer will take them to the Checkout page. Once they will complete the checkout, the Draft Order will get completed – it will create the real Order.

When importing new Draft Order with this set to TRUE, at first the Draft Order is created and instantly the invoice is sent to the customer.

Allowed Values

TRUE
FALSE

Send Invoice: To

E-mail address of the invoice recipient.

If left empty, the invoice is being sent to the Customer which is the “Customer: Email”.

Allowed Values

E-mail

Send Invoice: From

Sender e-mail address which will show for the customer who received the invoice.

You can also enclose the email in “<>” and add a sender name at the beginning. That will show up in the received invoice as a sender name.

Allowed Values

E-mail or Name <e-mail>

Example

Jon Sunny <[email protected]>

Send Invoice: Bcc

“Blind carbon copy” of the e-mail – which means, additional recipients of the invoice. Their e-mail addresses will not be visible by e-mail receivers, hence the “blind”.

Allowed Values

E-mail

Send Invoice: Subject

The e-mail subject.

If left empty, the Shopify will put its own default e-mail subject.

You can also use some variables in the invoice subject that Shopify knows how to decode.
For example:

{{name}}
{{total_price}}
{{note}}

You can find a documented list of variables in the Shopify documentation.

Allowed Values

Text

Example

Invoice {{name}} - {{total_price}}$ - {{note}}

Send Invoice: Message

The message of the invoice e-mail.

HTML code is allowed.

If empty, then the default Shopify e-mail message will be used.

Allowed Values

Text

Completion Columns

You can instruct the Shopify to complete the Draft Order – thus making the real Order from the Draft Order.

Column	Description / Example Value
Complete	If setting this to TRUE, it tells the Matrixify app to generate the real Order from this Draft. When importing new Draft Order with this set to TRUE, at first the Draft Order is created and instantly the real Order is generated. Allowed Values TRUE FALSE Example TRUE
Complete: Payment Pending	If setting this to TRUE, the created Order will have the payment status as “Payment Pending”. If this will be empty or FALSE, then the real Order will not have the payment pending. Allowed Values TRUE FALSE Example FALSE

Column

Description / Example Value

Complete

If setting this to TRUE, it tells the Matrixify app to generate the real Order from this Draft.

When importing new Draft Order with this set to TRUE, at first the Draft Order is created and instantly the real Order is generated.

Allowed Values

TRUE
FALSE

Example

TRUE

Complete: Payment Pending

If setting this to TRUE, the created Order will have the payment status as “Payment Pending”.

If this will be empty or FALSE, then the real Order will not have the payment pending.

Allowed Values

TRUE
FALSE

Example

FALSE

Metafields

You can import and export Metafields for Draft Orders the same way as for any other items.

Read more detailed documentation on the Metafields page.

Export Filters

In the Matrixify app, you can apply filters to Export only specific items from your Shopify Store.
When creating new export, select what you wish to export, and under that entity click on the “Filters” button.

Note: total displayed item count and estimated time won’t be affected by the filters applied.

Filter	Description
ID	Allows you to list specific Order IDs to export, separated by a comma. Possible Conditions equals to any of not equal to any of Example 12311123423,2342342342
Created At	Allows exporting Draft Orders which were created in the Shopify within a specific date range. Relative date condition allows you to export Draft Orders that have been created in the last full amount of time. For example – Last 1 Days, would export Draft Orders from last full day, so yesterday. Possible Conditions on or after on or before date range relative date
Updated At	Allows exporting Draft Orders which were last updated in the Shopify within a specific date rangeRelative date condition allows you to export Draft Orders that have been updated in the last full amount of time. For example – Last 1 Days, would export Draft Orders from last full day, so yesterday. Possible Conditions on or after on or before date range relative date
Status	Allows exporting all Draft Orders that have a specific status. You can select multiple conditions in this filter. Selecting all would be the same as not applying the filter. Possible Conditions Open Invoice Sent Completed
Tags	Allows to export Customers that have all listed tags, any of listed tags, or none of the listed tags. Separated by a comma. Possible Conditions contains any of contains all of contains none of equals to any of equals to all of not equal to any of starts with any of matches pattern Example tag1, tag2, tag3
Metafield	Filters the Orders export by Draft Order Metafields. Specify Metafield by: Namespace Key Value Possible Conditions for Text value equals to any of not equal to any of contains any of contains all of contains none of matches pattern contains does not contain is empty is not empty Possible Conditions for Number equals less than less than or equal to greater than greater than or equal to between is empty is not empty

Good To Know

If you need to update something beyond that is allowed to update, please use the REPLACE command and replace the whole Draft Order with another – that will allow you to set any data at the moment of draft order creation.
To import several line items to Draft Order, just repeat the row with the same ID or Name.