How to add extra column in existing csv that displays the staus of entry is failed or success in ui vision?

1.I am doing macros in ui vision about e com transaction.i have csv file with multiple records.
2.I can run macros till the payment is success or failed…
3.now the task is i want to write payment status i.e failed or success in front of particular row i.e.in last column in that csv file.how to write code ??

See here: How to mark a row in a CSV line as processed?

Thank you.
this macro is for payment gateway.where 100 entries in csv file including card no,name -numerical,expiry date,CVV,OTP, AMount -.6 columns are there. Now the task is once we OTP is entered and payment gets successful or failed - my CSV file should automatically save this in colum 7 infront of respective card number.