Wholesale - order layout adding goods to products table

I’m working on wholesale app.
I’ve tables with orders and products.
How can I map a workflow:
when I receive a shipment
I should find order matching this shipment
and system should add quantity of this product in our stack.

So for this part what would you enter into the app? What will be your criteria of matching?

I’ve decided to add shipment table.
Automation based on it will add or remove goods from warehouse.
And order table will be connected to shipment table.

There might be a partial shipment
and the same good delivered by different suppliers

This is my first system in Glide so I’m going to have more tables. I hope this will help me to have better workflow.