MarketMan and Mailhook: Supplier Price Change Template
When a vendor emails an updated price list to your Spojit mailhook address, this template reads the new prices and updates the matching MarketMan catalog items so your food costing stays current.
What It Builds
A Mailhook trigger gives the workflow its own inbound email address. When a supplier sends a price update, an Attachment node pulls the attached list (PDF or spreadsheet), a Knowledge node in Transient mode extracts each item and its new unit price, and a MarketMan Connector node updates the matching catalog items so recipe and inventory costing reflects the latest prices.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that triggers when a supplier emails an updated price list to my mailhook address. Read the attached price list, extract each product name and its new unit price, then find the matching catalog item in MarketMan and update its cost. Send me a summary email listing every item that changed, the old price, and the new price.Connectors Used
- Mailhook trigger - starts a run when a vendor emails your dedicated mailhook address.
- MarketMan - matches catalog items by name and updates their cost.
- Send Email - delivers a summary of every price change.
Customize It
Change the summary recipient, ask it to flag any increase over a percentage you set (for example, alert on jumps above 10%), or have it skip items it cannot match by name and list them separately so you can map them by hand.
Tips
- Your MarketMan connection needs write access to catalog items, not just read.
- Match on a stable field such as supplier SKU when names vary between your catalog and the vendor's list.
- Add a Human approval step before writing if you want a buyer to sign off on large increases.