Import / Export Draft Orders
Migrato allows you to import and export Shopify Draft Orders using CSV or XLSX files. You can select the required Draft Order fields, export existing Draft Order data, prepare data for import, and use filters to export only the Draft Orders that match specific conditions
You can use draft order import/export to transfer, manage, update, or migrate draft order data in bulk instead of processing draft orders individually through Shopify Admin.
Migrato also supports importing draft order data from a publicly accessible file URL, making it possible to work with files hosted on external systems.
Before importing or exporting draft orders: We recommend reviewing the Draft Order Template Documentation and downloading the Draft Order Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.
How to Import and Export Shopify Draft Orders
Import Draft Orders
Migrato allows you to bulk import Shopify Draft Order data using CSV or XLSX files.
You can upload a prepared Draft Order file directly to Migrato or provide a publicly accessible URL to the file.
Step 1: Open Draft Order Import
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Import section.
- Add the order file you want to import.
Step 2: Upload or Provide the Draft Order File
Migrato provides two ways to provide the draft order file.
Option 1: Upload a File
You can upload or drag and drop your draft order file into the upload area.
Migrato supports:
-
CSV
-
XLSX
Option 2: Import from a Public URL
Instead of uploading the file manually, you can provide the full publicly accessible URL of the draft order file.
For example:
https://example.com/draft_orders.csv
Enter the URL and select Upload from URL.
Note: The file URL must be accessible to Migrato. Make sure the file can be accessed without authentication or a login requirement.
Step 3: Review the Import Details
After the file is uploaded or retrieved from the provided URL, Migrato creates an import job and displays the import details.
The import details can include:
-
Import ID
-
Import state
-
File format
-
Operation
-
Uploaded file
-
Import start information
Review the displayed information before continuing with the import.
Step 4: Review the Draft Order Sheet
Migrato identifies the draft order data contained in the uploaded file and displays it under the Sheets section.
Review the detected draft order sheet before selecting the import operation.
Step 5: Select an Import Operation
Migrato allows you to select the operation to perform on the order data.
Depending on the supported draft order operations, the available options include:
-
Merge – Update existing records and create new records.
-
Create only – Create new records and skip records that already exist.
-
Update only – Update existing records and skip records that cannot be matched.
-
Replace – Delete the existing record and create it again using the imported data.
-
Delete – Delete the matching record if it exists.
The selected operation determines how Migrato handles existing and new draft order records.
Important: Carefully select the operation before starting an draft order import, particularly when using Replace or Delete.
Step 6: Configure Import Options
Open the Options section to configure additional settings available for the import.
Depending on the Migrato draft order import configuration, this section may include options such as scheduling and result-file settings.
Step 7: Schedule the Draft Order Import
Migrato can schedule an import job when scheduling is enabled for the operation.
You can configure:
-
Schedule date
-
Schedule time
-
Repeat interval
-
Number of repetitions or run until cancelled
This is useful when draft order data needs to be imported repeatedly from an external source.
Step 8: Start the Draft Order Import
After reviewing the file and selecting the required operation:
- Review the import details.
- Confirm the selected operation.
- Review the available options.
- Import.
Screenshot: Migrato – Import Draft Orders Button
Migrato will begin processing the draft order import.
Step 9: Monitor the Import
Migrato processes the draft order import as a job and displays the current processing status.
You can use the job information to track the progress of the import.
Step 10: Review Import Results
After processing is completed, review the import results.
The result information can include:
-
Import status
-
Total records
-
Successfully processed records
-
Failed records
-
Skipped records
-
Processing duration
-
Error information
If any records fail, review the reported errors, correct the source file where required, and run the import again.
Export Draft Orders
Migrato also allows you to export Shopify draaft order data into a downloadable CSV or XLSX file.
This can be useful for:
-
Order reporting
-
Data analysis
-
Backup
-
Store migration
-
Data processing
-
External system integration
-
Record keeping
Step 1: Open Draft Order Export
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Export section.
- Select Draft Orders.
Step 2: Select Draft Order Fields
Select the draft order fields you want to include in the export.
Depending on the available Migrato configuration, order data may be organized into different field groups.
Select only the fields required for your export to keep the resulting file focused and easier to work with.
Step 3: Apply Draft Order Filters
If you only need specific draft orders, use the Filters section to narrow down the export.
For example, You can filter draft orders using supported fields such as:
-
Draft Order ID
-
Created At
-
Updated At
-
Tags
-
Status
-
Customer Tax Exempt
-
Line Type
-
Line Title
-
Line Name
-
Line Variant ID
-
Line Variant Title
-
Line SKU
-
Line Vendor
For complete information about available filters, see Filter Draft Orders.
Step 4: Start the Export
After selecting the required fields and filters, start the export.
Migrato processes the selected draft order data and creates the export file.
Step 5: Review the Export Result
After the export is completed, Migrato displays the export result.
The result page can display information such as:
-
Export status
-
Exported file name
-
File format
-
Number of records exported
-
Processing duration
-
Selected order fields
-
Applied filters
You can download the generated export file from the completed export screen.
Supported Draft Order Data
Migrato's draft order import/export functionality is designed to work with supported Shopify draft order information.
Depending on the current Migrato draft order template, supported data may include:
-
Draft Order identification and status
-
Customer information
-
Billing information
-
Shipping information
-
Company information
-
Line-item information
-
Product and variant information associated with line items
-
Tax information
-
Discount information
-
Additional Draft Order details
-
Metafields
Note: The exact fields available for import and export depend on the current Migrato Draft Order Template. Refer to Template Documentation for the complete field reference.
Important Notes for Draft Order Import/Export
-
Always review the Draft Order Template Documentation before preparing an import file.
-
Make sure the file follows the required Migrato structure.
-
Use a test file with a small number of records before processing a large draft order dataset.
-
Carefully review the selected operation before importing.
-
Take extra care when using Replace or Delete operations.
-
When importing from a URL, make sure the file is publicly accessible.
-
Review the import results and error information after processing.