Shopify and ShipStation: Carrier Cost Audit Template
A scheduled Spojit workflow that pulls your recent ShipStation shipments and posts a weekly carrier cost audit to Slack so you can see where spend is concentrated.
What It Builds
A Schedule trigger runs once a week and a ShipStation Connector node pulls the period's shipments. A Transform node groups the data, totalling cost by carrier and service level, and a Slack Connector node posts the ranked summary to a channel. The result is a recurring snapshot of where your shipping budget actually goes, ready for your next carrier negotiation.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every Monday at 7am, pulls the last 7 days of shipments from ShipStation, totals the shipping cost grouped by carrier and service level, and posts a ranked summary to the #logistics Slack channel showing each carrier's total spend, shipment count, and average cost per shipment.Connectors Used
- Schedule trigger - fires the audit weekly on a cron schedule in your timezone.
- ShipStation - reads the period's shipments, carriers, services, and costs.
- Slack - posts the formatted cost breakdown to your chosen channel.
Customize It
Change the day and time, swap #logistics for your own channel, or widen the window to a full month. You can also ask Miraxa to break the totals down by destination region, or to flag any carrier whose average cost rose against the prior period. Shopify order references travel through ShipStation, so you can group by store too.
Tips
- The ShipStation connection needs read access to shipments for cost and service fields to populate.
- Keep the ShipStation step in Direct mode for a predictable pull with no AI cost; reserve Agent mode for the optional narrative summary.
- If the channel gets noisy, post only when one carrier exceeds a spend threshold you set in the prompt.