Ubercart

Hey Everyone,

I need to make a decision on what membership software to use in our Drupal system. Right now, even if the solution costs $200 or $2000, we still want it on the table to make our decisions. Ubercart is free and a big part of the Drupal Comunity, so if we can use it, then we will.

As a little background, here is how our site will be structured (with Drupal 6.10):

www.mainsite.com (this is our main drupal set up.)
Then
www.mainsite.com/site2 (this will be another drupal set up, with its own database)
And then
www.mainsite.com/site3 (...same...)

All the separate drupal sites will of course share the same Users, Session, Roles database tables. But all the node information and such will be in separate databases. Don't worry, I know how to connect those databases all together.

I need a membership software that can pretty much do the following:

1. Allow an anonymous or authenticaed user to buy 1 or more memberships which will give them access to /site1, or /site2, etc (by access we really mean "roles" of course.
2. Has a separate order page per each type of member ship a person wishes to buy.
3. And also can have a big order page where a users can check off all the separate memberships he/she wishes to add
4. Basically having access to site1 is just a "role" we give them
5. A way to handle expired accounts. So if their site1 subscription ends, only their site1 "role" ends. Not for site2 or whatever
6. If they lose all subscriptions, they go back to either anonymous, or they default to "free" role or something
7. Handles banning and blocking (I think drupal can do that internally)
8. Handles refunds
9. Works with Paypal (that is a given right?) but it can work with more than just Paypal too
10. Works with the Google Analytics Module (I don't see why not, but need to mention it anyway)

I think that covers almost all the bases. I notice there is Ubercart v1 and v2. Which one is most stable to accomplish those tasks?

I was looking into Amember's drupal "plugin", but their integration with drupal is a little clunky. Also, it seems like a user must first sign up as a free member before they can buy anything, or it seems like only 1 member can sign up for 1 type of account. The same member can't be part of more than 1 role? It doesn't seem like a lot of deep thought went into it or its UI for drupal. I'd rather this tool be internal to Drupal as a module than a 3rd part database. Also, all user activity must be done through the Amember users database first, not the Drupal database, since Drupal doesn't talk to Amember. Amember only talks to Drupal.

Thus, I suspect Ubercart and Drupal can work with each other with the users table.

Again, if what I am asking does require a premium module made by a retailer, that is okay. It will be factored into our decision.

I hope to create a really amazing Case Study for Drupal's front page since I want to use Drupal to its fullest. Using Ubercart would be extra cool in that regard!