Order CSV by email
Filter with a Shopify order search, optionally exclude previously tagged orders, and send the CSV as an email attachment. The task offers a nightly setting.
Use cases / Reports
Get the orders you need into a CSV and into your team’s inbox. Use a ready-made Mechanic task to email an order export on demand or nightly, with filters that match your workflow.
Start with a library task. Configure it for your store.
A nightly handoff
Use an order search, such as unfulfilled orders.
The task writes a row for each line item.
The file arrives as an attachment for review or import.
Ready-made starting points
A regular export can support a packing review, an operations spreadsheet, or a handoff to another team. Decide which orders belong in the file and who needs it before turning on the schedule.
Filter with a Shopify order search, optionally exclude previously tagged orders, and send the CSV as an email attachment. The task offers a nightly setting.
This simple example emails product IDs and titles as a CSV. Use it as a starting point when you need a custom product export.
Use the dedicated inventory-export task when your workflow calls for a scheduled inventory file in Shopify’s CSV format.
Add the order-export task and set its order search. Start with a small, known group so you can check exactly which orders and line items the file contains.
Choose the recipient, subject, body, and filename. Complete Mechanic’s email approval, review the task preview and permissions, then enable it for a manual test.
Open the test attachment and confirm the columns and values with the receiving team. Enable the nightly option once the file fits the workflow.
For a fresh snapshot each night, keep every currently matching order eligible. For a handoff of new work, configure an export tag and exclude orders carrying that tag. The tag records task processing; it is not confirmation that an email arrived or a receiving system imported the file. Plan how you will handle corrections or a resend.
The order-export task produces one row per line item. An order containing several line items occupies several rows. Check this structure before importing the file into another system.
The ready-made order task emails its defined CSV columns. A different column layout, SFTP delivery, or a direct API handoff requires a custom task or a task-code change. Use the library task as a starting point for that work.
The current order task sends its export email when the CSV contains line-item rows. If no eligible orders produce rows, there is no export email.
Check the task’s requested access and the date range of your order search. Orders older than 60 days require additional order access. Test the intended range before relying on a recurring historical report.
Shopify offers order CSV exports from the admin. This Mechanic task adds a recurring email workflow with configurable order selection. Its column layout is its own, so compare a sample with your existing export before switching.
Open the task to see its options and instructions. Use the library version as it is, or work with a developer to adapt its Liquid code for your workflow.
More workflows to explore: