I ended up running the Checkout Wizard about 3 times. I wanted to get the db behavior done properly from start and see what I had missed. The first two times it was not generated properly. The first time it gave me some error about checkout.php not found but it kept going thru the process after I pressed ok to continue., The second time it went thru but both 1st and 2nd time it was missing a closing php tag on the first line in the checkout plus a host of other issues with forming the code. I ended up closing DW and rebooting the pc. Then reran for a third time. This time seems to be running right. I saw that I could select the correct Table (mine is not called 'orders' but 'ecart_orders'). I can get thru the process but I get the 'Transaction Failed' message.
How do I check what's causing that when iit seems I have the correct Paypal sandbox info in the confirm.php and am entering the correct Paypal cc credentials?
I have a meeting tomorrow am to show this so I hope to get thru it soon. If you want to look at the files, the ftp is still the same. (I am trying to resolve it at this moment but don't know how to debut the 'transaction failed' issue.