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?
Columns Available For Export And Import
Base Columns
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 ValuesNumber Example11920047631 |
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 updating Draft Orders, Name cannot be used as a unique identifier. For an update, use exported Draft Order ID. Allowed ValuesText Example#D100 |
Command | When importing Draft Order, it tells the app, what to do with it.
Allowed ValuesNEW MERGE UPDATE REPLACE DELETE IGNORE ExampleMERGE |
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. 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 ValuesNumber Example1 |
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 ValuesNumber Example234823948234 |
Status
Export only |
Shows the current status of the Draft Order.
Possible values are:
To change the Status, you need to use the respective command columns “Send Invoice” and/or “Complete“. Allowed Valuesopen invoice_sent completed |
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. Allowed ValuesExample[email protected] |
|
Note | Draft Order notes.
Can be a large text going over several lines. Allowed ValuesText ExampleHere 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 ValuesComma seperated list ExampleUrgent, To Review |
Tags Command | Tell the app, what to do with Tags:
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. See this tutorial on how to bulk manage your Tags. Allowed ValuesMERGE DELETE REPLACE ExampleREPLACE |
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 ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Updated At
Export only |
It will be automatically updated, whenever you change the Draft Order data.
Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Currency | Currency of the Draft Order.
Allowed ValuesCurrency code in ISO 4217 format ExampleUSD |
Weight Total
Export only |
Total weight of the ordered items, in grams.
Calculated automatically from Line Items. Allowed ValuesGrams Example4000 |
Price: Subtotal
Export only |
Value of the order, including discounts, but before shipping and taxes.
Allowed ValuesCurrency Example1000 |
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 ValuesTRUE FALSE ExampleTRUE |
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 ValuesText ExampleVAT |
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 ValuesNumber Example0.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 ValuesCurrency Example210.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 ValuesTRUE FALSE ExampleTRUE |
Tax: Total | Total amount of the tax applied to the Draft Order.
Allowed ValuesCurrency Example300.43 |
Price: Total | Total amount of the Draft Order, including line items, discounts, shipping cost, and taxes.
Allowed ValuesCurrency Example1300.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: Allowed ValuesLines of "name: value" ExampleGift 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 ValuesNumber Example1234567890 |
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 ValuesExample[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 ValuesPhone 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 ValuesText ExampleJohn |
Customer: Last Name | The last name of the Customer.
To change for an existing Order – change the data of the Customer. Allowed ValuesText ExampleSmith |
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 ValuesText ExampleYour notes go here. |
Customer: Orders Count
Export only |
Total count of orders made by this Customer.
Allowed ValuesNumber Example100 |
Customer: State | The Customer status – one of those:
To change for an existing Draft Order – change the data of the Customer. Allowed Valuesdisabled invited enabled declined Exampleenabled |
Customer: Total Spent
Export only |
The total amount the customer has spent at the moment of the export.
Allowed ValuesCurrency Example1024.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 ValuesComma seperated list ExampleFriend, 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 ValuesTRUE FALSE ExampleTRUE |
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 ValuesTRUE FALSE ExampleTRUE |
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 ValuesText ExampleJohn |
Billing: Last Name | The last name of the Customer.
Allowed ValuesText ExampleSmith |
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 ValuesText ExampleJohn Smith |
Billing: Company | Company name, if the billing address is a company.
Allowed ValuesText ExampleSmith Inc. |
Billing: Phone | Phone number to use for this address.
Allowed ValuesPhone Number Example'+15417543002 |
Billing: Address 1 | Address 1st line.
Allowed ValuesText ExampleCalvin Street 5 |
Billing: Address 2 | Address 2nd line.
Allowed ValuesText Example2nd Floor |
Billing: Zip | Zip number of the address. Shopify doesn’t check its correctness.
Allowed ValuesZip ExampleZIP-1234 |
Billing: City | City name. Is not checked, so it’s possible to enter any city name.
Allowed ValuesText ExampleDough |
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 ValuesProvince Name ExampleOntario |
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 ValuesProvince Code ExampleON |
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 ValuesCountry Name ExampleCanada |
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 ValuesCountry Code ExampleCA |
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 ValuesText ExampleJohn |
Shipping: Last Name | The last name of the Customer.
Allowed ValuesText ExampleSmith |
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 ValuesText ExampleJohn Smith |
Shipping: Company | Company name, if the billing address is a company.
Allowed ValuesText ExampleSmith Inc. |
Shipping: Phone | Phone number to use for this address.
Allowed ValuesPhone Number Example'+15417543002 |
Shipping: Address 1 | Address 1st line.
Allowed ValuesText ExampleCalvin Street 5 |
Shipping: Address 2 | Address 2nd line.
Allowed ValuesText Example2nd Floor |
Shipping: Zip | Zip number of the address. Shopify doesn’t check its correctness.
Allowed ValuesZip ExampleZIP-1234 |
Shipping: City | City name. Is not checked, so it’s possible to enter any city name.
Allowed ValuesText ExampleDough |
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 ValuesProvince Name ExampleOntario |
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 ValuesProvince Code ExampleON |
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 ValuesCountry Name ExampleCanada |
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 ValuesCountry Code ExampleCA |
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 ValuesNumber Example916274112 |
Company: Name | Name of the Company linked to the Draft Order.
Allowed ValuesText ExampleShopify |
Company: External ID | External ID for the Company linked to the Draft Order.
Allowed ValuesText ExampleShopify-123 |
Company: Location ID | Shopify internal ID for the Company Location linked to the Draft Order.
Allowed ValuesNumber Example123876123 |
Company: Location Name | Company Location Name linked to Draft Order.
Allowed ValuesText ExampleShopify South Warehouse |
Company: Location External ID | Company Location External ID linked to the Draft Order.
Allowed ValuesText ExampleShopify-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.
Allowed ValuesLine Item Discount Shipping Line ExampleLine 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 ValuesNumber Example200005386255 |
Line: Product Handle | Has a different value, depending on the Line Type:
Allowed ValuesText Exampletshirt-with-picture-of-me |
Line: Title | Has a different value, depending on the Line Type:
If Title will contain HTML tags then they will be removed by the app. Allowed ValuesText ExampleTshirt With Picture Of Me |
Line: Name | Has a different value, depending on the Line Type:
Allowed ValuesText ExampleTshirt 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 ValuesNumber Example1834691428367 |
Line: Variant Title | Has a different value, depending on the Line Type:
Allowed ValuesText ExampleRed / XS |
Line: SKU | Has a different value, depending on the Line Type:
Allowed ValuesText ExampleSKU-1234567 |
Line: Quantity | Has a different value, depending on the Line Type:
Allowed ValuesNumber Example100 |
Line: Price | Has a different value, depending on the Line Type:
Allowed ValuesCurrency Example5.49 |
Line: Discount | Has a different value, depending on the Line Type:
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 ValuesCurrency Example49.00 |
Line: Discount per Item
Export only
|
Line item level discount divided with line item quantity. Cannot be imported.
Allowed ValuesCurrency Example15.49 |
Line: Total | Has a different value, depending on the Line Type:
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 ValuesCurrency Example500.00 |
Line: Grams | Has a different value, depending on the Line Type:
Allowed ValuesNumber Example250 |
Line: Requires Shipping | Has a different value, depending on the Line Type:
Allowed ValuesTRUE FALSE ExampleTRUE |
Line: Vendor | Vendor name of the product purchased.
Allowed ValuesText ExamplePuma |
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: Allowed ValuesLines of "name: value" ExampleColor: Red Engraving: My Name |
Line: Gift Card | TRUE if the line item is a gift card.
Allowed ValuesTRUE FALSE ExampleFALSE |
Line: Taxable | TRUE if the line item is taxable.
Allowed ValuesTRUE FALSE ExampleTRUE |
Line: Tax Total
Export only |
Sum of taxes in this line.
Allowed ValuesCurrency Example29.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 ValuesText ExampleVAT |
Line: Tax 1 Rate Line: Tax 2 Rate Line: Tax 3 Rate |
The rate of the tax applied.
Allowed ValuesDecimal Number Example0.21 |
Line: Tax 1 Price Line: Tax 2 Price Line: Tax 3 Price |
The calculated tax in the order currency.
Allowed ValuesCurrency Example105.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 ValuesNumber Example50 |
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 Valuesmanual amazon shipware <other provider handle> Examplemanual |
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
TypeText |
Line: Product Tags
Export only |
Product Tags
TypeText |
Line: Variant SKU
Export only |
Product Variant SKU
TypeText |
Line: Variant Barcode
Export only |
Product Variant Barcode
TypeText |
Line: Variant Weight
Export only |
Product Variant Weight
TypeNumber |
Line: Variant Weight Unit
Export only |
Product Variant Weight Unit
TypeText |
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. TypeNumber |
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. Examplehttps://cool-store.myshopify.com/4412382123/invoices/98ab1235882c48gh9123v4983c6154d3 |
Invoice Sent At
Export only |
Date and Time when the invoice was sent.
Example2018-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 ValuesTRUE 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 |
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 ValuesE-mail or Name <e-mail> ExampleJon 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 |
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.
You can find a documented list of variables in the Shopify documentation. Allowed ValuesText ExampleInvoice {{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 ValuesText |
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 ValuesTRUE FALSE ExampleTRUE |
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 ValuesTRUE FALSE ExampleFALSE |
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
Example12311123423,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
|
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
|
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
|
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
Exampletag1, tag2, tag3 |
Metafield | Filters the Orders export by Draft Order Metafields.
Specify Metafield by:
Possible Conditions for Text value
Possible Conditions for Number
|
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.