A shipment arrived at the warehouse — table incoming_shipment with rows of the shape «product id plus quantity». If the product is already in inventory, add this quantity to the existing stock and refresh updated_at. If the product is new — create a new row. Do it in a single query, without loops or separate checks in the application.