I like starting with simple linked tables for orders, customers, and products, then adding views and automations as needed. It keeps things clear while you build out the workflow.
I tried a similar setup recently, and the trick for me was keeping each step lightweight so the system didn’t turn into a chore to maintain. I eventually paired parts of my workflow with some bespoke software development to handle the odd edge cases Airtable couldn’t cover, which kept everything running smooth without changing how I worked. Mixing the two has been a sweet spot for me.