How do I export an order from a Shopify Flow workflow?
Columna adds the action Export order with Columna to Shopify Flow. When a workflow runs it, the app sends that one order through one of your scheduled exports: with the export’s template and file format, to the export’s destination (email, SFTP, FTP, Amazon S3, Google Drive or webhook). Use it when only some orders should go out, for example orders tagged wholesale, orders over a certain total or orders from one market. This is part of the Pro plan.
Before you start
- Install Shopify Flow from the Shopify App Store if your store does not have it yet.
- In Columna, create the scheduled export the action should use (see “How do I get an order export by email every day, week or month?”). Give it a name that no other scheduled export has. If the export should only run from Flow, you can turn it off: the action still uses it.
Set it up
- In Shopify Flow, create a workflow and pick a trigger that has an order, such as Order created or Order paid.
- Add the conditions you want, for example “Order tags include wholesale”.
- Add an action, search for Export order with Columna and select it.
- In Scheduled export name, enter the name of the scheduled export exactly as it appears in Columna under Settings > Scheduled email exports. Upper and lower case do not matter.
- Turn on the workflow.
What the action does
- The order goes out a minute or two after the workflow runs, in a file of its own named after the export and the order, such as
warehouse-feed-order-450789469.csv. By email, the subject says that the order came from Shopify Flow. - The export’s template, file format and destination are used. Its order filters and its schedule are not: the workflow’s conditions decide which orders go out.
- The export’s regular schedule does not change, and an export of every new order does not skip the order.
- Each run of the action sends the order once. If Shopify Flow sends the same run again, nothing is sent twice.
- A destination that cannot be reached is tried again a few minutes later, for up to 6 hours. After that the export shows the error, and the failure email of the export is sent as for any scheduled run.
- Columna does not keep the order: the order passes through to the file and the destination.
Verify it worked
- In Shopify Flow, open the workflow’s Recent runs: the action shows as completed.
- In Columna, the export’s Status shows the last send with 1 order.
- The file arrives at the export’s destination within a few minutes.
Troubleshooting
The messages below appear on the workflow run in Shopify Flow.
“Exporting orders from Shopify Flow needs Columna’s Pro plan.” Upgrade in Columna under Plans, then run the workflow again.
“Columna has no scheduled export with that name.” Check the name in Columna under Settings > Scheduled email exports and update the action. A renamed export needs the new name in the workflow.
“More than one scheduled export in Columna has that name.” Give the export a name no other scheduled export has, then use it in the workflow.
“The action needs an order.” Use the action in a workflow whose trigger has an order, such as Order created.
The action completed but no file arrived. Open the export in Columna and check its Status for an error, such as a refused login or a full mailbox.
To start a workflow when a sync or export stops working, use the trigger Columna export failed (see “How do I start a Shopify Flow workflow when an export stops working?”).