This is the Code I have created using advice from @brucemcpherson and with some code framework from @mhawksey. Thank you both for being Awesome with in the community. It's written in Google Apps Script. The code will input a new row of data for every order an ad the qty to the appropriate SKU column on the main sheet
An attempt to log all orders upon creation to google spreadsheets