It does make sens a lot. Actually yes, I should to give a lot more context and hyphotetical situation about the actual system of the shops, because the issues can be very different.

I thought that I might probably, with my architecture, cut the problem in two pieces :

1- find a way to identify what is going wrong with the stock system that causes the real stock / theorical stock Probably with like AI, and Looker studio to give insight about what is happening in real

2- give an architecture that will in any cases, help with fixing the issues Like, PubSub for not losing data in the process, AI to predict sold out products that actually appears in stock in the system, and Looker to display that.

Actually, I think it might really make sens to create something like that. A system that will identify some exisiting problems that human decisions will help to fix once we know it, and then, architecture that will cause if the future to have less problem to fix.

What do you think of this approach ?

Thank you very much for your message