FlowRunner
Features Pricing
Theme
Start Free

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

Yes No Yes Yes Repeats for each item For each stockcorrection Action Read back whathas shipped Action Record thetracking Waits for an answer Dispatch from thewarehouse Condition Whole ordershipped? Condition Any stockcorrections? Code Read the dispatch Condition Everything shipped? Action Move the order toShipped Action Ship every line Action Ship the namedquantities Code Count what hasshipped

Inside the loop: For each stock correction

Action Log thecorrection Action Set the correctedstock

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

  1. 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.
  2. Record the tracking Records the carrier, tracking numbers and pickup date on the sales order.
  3. 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.
  4. 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.
  5. Move the order to Shipped Moves the sales order to the Shipped stage of its pipeline.
  6. Any stock corrections? Runs alongside the shipping steps. A dispatch with no corrections ends here.
  7. 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.
  8. 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.