Ben, I noticed you didn't get my PM from Friday, so I thought I'd repost the info here. (That way others can see it, too.)

"Just had a chance to briefly read your post and am excited about the work you're going to be doing! I just wanted to send you a quick message that I'm heading out of the office right now, but if you've gotta do some work over the weekend here's one lead - you can use the Content Templates module for individual node type design. That's what I do here and elsewhere (albeit very lightly). If you like, though, you can also create individual template files in your theme itself. I would advise you to do this because the UI isn't that great for the Contemplate module and it looks like you'll need to have good access to it. I believe the process is just creating a node-type.tpl.php file in your theme, like node-product.tpl.php for product nodes or node-story.tpl.php for story nodes. You might want to verify that through a Google search on Drupal.org, though. ; )"

Mike should be able to verify that as well, or some of the other developers here. I just think it'll save you some of the headache I run into when modifying templates. The module can be good to preview the available fields, though, so you may use it just to examine what variables nodes generate for displaying data.

For populating your tables w/ data from a database... do you already have this data entered somewhere? If not, you may consider using the product class system. You can create a new class for each type of product and then add fields using CCK per product. You can make these fields not required and then theme the output however you wish. (You could even choose to hide them and then handle the query yourself to load the data.)

Regarding teasers, these are fairly standard Drupal features. You can only specify one teaser per node. You can use a little PHP snippet to load the teaser from any page in your site and input that in a page, although I think the quickest thing for you to do will be to use a custom query.

As for the pricing difference, I believe you can use the discounts contribution to give a cheaper price based on a user's account role. If not, we should look into adding that functionality. Many folks have mentioned it in the past. Also, you can use the Taxonomy Access Control Lite module to restrict access to certain parts of your site for people with the wholesaler account role.

I don't have a CSV order export done yet, but it wouldn't be hard to accomplish. I'd be happy to incorporate any code you come up with or look into developing my own format in the future.

Basically, if you don't know a little bit of PHP/MySQL yourself, I'd seriously consider hiring someone that can do the custom queries and bits of display that will allow you to do the things you want to do. I'm really impressed with the design, and I think you'll need the custom code - it will save you a lot of frustration trying to use various modules to get the same jobs done.