the orderrefID column is not 100% necessary. If you do not have one, you can either ignore that particular binding or create one in the orders table.
Everything else sounds like you are on the right track.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.