Hi there,
I will be happy to help you with that, but actually using Google script bounded to the spreadsheet! It can read all rows, then it will iterate over each row, post the data for each row to the order form, so basically, it will be one click, not two clicks!
I will be happy to address any of your questions!
Sincerely,
Mohamed