Supplier orders from low stock — out of Stackby, automatically

Every night the scenario finds products running low, works out the reorder amount, creates orders in the table and emails them to suppliers.

  • Low stock is found on its own
  • The reorder amount is calculated automatically
  • Orders are grouped by supplier
  • The supplier emails go out without you
Set it upScriptera

How it works

To move data from Stackby to Gmail automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Run Every Mid Night
  2. Then: Get Products with low stock
  3. Then: Get supplier Details for those low stock products
  4. Then: Calculate Dynamic Re-order Quantity
  5. Then: Search records
  6. Then: Remove Duplicate Product Orders
  7. Then: Create purchase records in table
  8. Starts when: Schedule Trigger
  9. Then: Get Purchase Orders which are pending
  10. Then: Group products with suppliers
  11. Then: Send PO to suppliers via Email
  12. Then: Get the record id's of PO
  13. Then: Update the PO status to sent

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

Similar scenarios