Do I have to change the Output Type to "Number" or "Currency" instead of the default setting of "Text"? 
It is not 100% percent necessary to change the out put from text. Since we will be using numeric values, you _could_ change it to Number, but you dont have to.
However there is a Server Behavior entry called "eCart Add From Recordset (WA_Store_Cart, WADAProducts)"I'm almost sure these are not one and the same. Are they?
Yes, the eCart Add From Recordset is the same server behavior. It gets named slightly different in the Server behaviors list based on the choice of "Add Static item To Cart" or "Look up Item ID From recordset"
