Looks well thought out. We wrestle with website, real ERP and building Notion connectors for production orders in make to order scenarios so there’s definitely a pain point.

Yeah. Notion is not a bad idea but you'll need to maintain the connections. In fact i did model the idea first in notion