Warehouse dispatch to shipped sales order in Holded
When the warehouse reports a dispatch, this flow records tracking on the Holded sales order, marks lines shipped, moves a fully shipped order along, and logs stock corrections to Google Sheets.
The prompt
When our warehouse system sends a dispatch for a Holded sales order, record the carrier and tracking numbers on the order. If the whole order went out, mark every line shipped. If only part of it did, mark the quantities shipped line by line. Then check how many units of each line have shipped, and when everything has gone, move the order to the Shipped stage of its pipeline. If the dispatch includes stock corrections, set the corrected stock level on each product in Holded and log the correction and its reason to a Google Sheet so our inventory owner can see what changed and why.
FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.
The flow
Inside the loop: For each stock correction
Download the file, then in FlowRunner click + beside Flows, pick it under Import a Flow Version and click Create. How importing works
What each step does
- Dispatch from the warehouse Your warehouse system posts each dispatch to the flow's URL: the Holded sales order, the carrier, tracking numbers, the lines shipped and any stock corrections.
- Record the tracking Records the carrier, tracking numbers and pickup date on the sales order.
- Whole order shipped? A dispatch with no lines listed means the whole order went out, so every line of the sales order is marked shipped. A partial dispatch marks the quantity shipped on each named line.
- Everything shipped? Reads back from Holded how many units of each line have gone. Once every line has shipped in full, the order moves on, and a partly shipped order stays where it is until the next dispatch.
- Move the order to Shipped Moves the sales order to the Shipped stage of its pipeline.
- Any stock corrections? Runs alongside the shipping steps. A dispatch with no corrections ends here.
- Set the corrected stock Sets each corrected product's stock level in Holded for that warehouse. Holded records this as a correction, with no movement document.
- Log the correction Adds a row to your stock log in Google Sheets with the date, sales order, product, warehouse, new stock level and reason.
Before you turn it on
- Enter your Holded API key and connect your Google account.
- Pick the spreadsheet for the stock log in Log the correction. Its first sheet needs the columns Date, Sales order, Product, Warehouse, New stock and Reason.
- Set the flow setting Shipped stage to the stage of your Holded sales order pipeline that shipped orders move to.
- Copy the URL of the block Dispatch from the warehouse into your warehouse system, so it posts each dispatch there.