Mailhook to MarketMan: Supplier Price Update Email to Catalog Template
When a supplier emails a price update, this Spojit template extracts the changed items and updates the matching products in your MarketMan catalog automatically.
What It Builds
A Mailhook trigger gives the workflow its own inbox address, so any supplier price email starts a run. An Agent-mode Connector node reads the message body, pulls out each item name, SKU, and new unit price, then matches and updates the corresponding products in MarketMan. A Send Email node confirms what changed.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow triggered by a Mailhook email. When a supplier sends a price update, read the email body and extract each affected item with its SKU and new unit price. For every item, find the matching product in MarketMan and update its cost to the new price. Then email me a summary listing each item updated, its old price, and its new price.
Connectors Used
- Mailhook - the trigger; the workflow's own address receives the supplier price email.
- MarketMan - matches items and updates catalog product costs.
- Send Email - sends the change summary back to you.
Customize It
Edit the prompt to match on item name instead of SKU, to round prices to a set number of decimals, or to skip increases above a threshold for review. You can also change the summary recipient or have it post to a different address.
Tips
- If suppliers attach a price list as a PDF or CSV, add an Attachment node so the agent reads the file contents.
- Make sure your MarketMan connection has write access so cost updates save.
- Add a Human approval node before the update if you want a buyer to sign off on large price jumps.