Update deal vendor IDs from updated spreadsheet rows

Your deals miss valid vendor IDs when spreadsheet rows are updated with malformed or empty identifiers, causing billing and reconciliation delays. It adds validated vendor IDs to deal records so billing and partner matching complete the same day.