Automatic supplier reorders based on stock levels

The scenario regularly checks stock and sales pace, uses AI to prepare optimal supplier orders and sends them out, setting large ones aside for approval.

  • Catches low-stock items in advance
  • Computes demand from real sales
  • AI prepares optimal supplier orders
  • Large orders go for approval
Set it up for yourselfScriptera

How it works

Automating Postgres and sendPulse takes no code: a ready-made scenario does the routine for you.

  1. Starts when: Run inventory check every 6 hours
  2. Then: Query ERP for low stock items
  3. Then: Fetch 90-day sales velocity data
  4. Check: Combine stock and sales data
  5. Then: Calculate sales velocity and stockout risk
  6. Then: Generate optimized purchase orders with Mistral AI
  7. Then: Parse and validate AI response
  8. Check: Route based on approval criteria
  9. If yes: Insert approved POs into ERP database
  10. Then: Update inventory with pending orders
  11. Then: Group purchase orders by supplier
  12. Then: Email purchase order to supplier
  13. Then: Create audit log for compliance
  14. Then: Send summary notification to Slack
  15. If no: Flag for manager approval
  16. Then: Tool: Get supplier catalog
  17. Then: Tool: Check budget availability
  18. Then: Mistral AI language model

You can launch this Postgres + sendPulse integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios