So how difficult is it to design a store like this and get all the different pieces to work together? Will I be tearing my hair out, wishing I had just gone with a simple integrated package and/or outside designer? I do have html programming knowledge, but I am unfamilar with the configuration of a linux server config such as cPanel. And I am unfamiliar with how to program the site to work with a shopping cart and auth gateways, catalog databases, etc... These are things I will need to learn.
If you have html and css skills, I think you will be fine doing the site yourself. Zen Cart has an inherent templating feature and most providers have a snapshop of osCommerce that includes a templating feature. As far as open source shopping carts go - these are your 2 best options (IMO).
They come ready to go an integrated with various payment gateways, 3rd party processors and shipping providers. No additional coding or expertise is required.
May I recommend you play with a live demo of both these products and familiarize yourself with them...
There is actually a really nice integrated module available for zen cart where you can manage your inventory, customers, quotes, etc from a functionally complete, web based application that is integrated with your shopping cart (ie if you sell something from your store front, it is subtracted from your master stock, etc....)
I do think solutions like yahoo have value, however, the value is more on the marketing end then the functionality end...
If you are confident in your ability to market an ecommerce site, as well as have some sort of established local presence in a more traditional brick and mortar associated business, I think the value of yahoo stores drops dramatically...
Andrew - http://www.cartikahosting.com
Business Grade, Clustered Application Hosting
Windows, Linux, Coldfusion, FreeBSD, MS Exchange and Dedicated Servers