I can share the 3.40 backup, how?
Please upload it to some file sharing server (e.g. mediafire) and share a link here
UPDATE [ShipmentItem]
SET [WarehouseId] = (SELECT p.[WarehouseId] FROM [Product] p
INNER JOIN [OrderItem] oi ON p.[Id] = oi.[ProductId]
WHERE [oi].[Id] = [ShipmentItem].[OrderItemId])
GO
UPDATE [ShipmentItem]
SET [WarehouseId] = COALESCE((SELECT p.[WarehouseId] FROM [Product] p
INNER JOIN [OrderItem] oi ON p.[Id] = oi.[ProductId]
WHERE [oi].[Id] = [ShipmentItem].[OrderItemId]), 0)
GO