Ubercart

Awesome! Can't wait to see this coupled with recurring payments. Nice work! Will be glad to help test.

As per point 3 recurring payments is built in already...

3. If the customer or administrator choose the setting to automatically renew products, the order is created similarly to the administrator's reorder function and the payment is processed. This provides a method for automatically recurring charges.

I just found this and it seems to be exactly what I have been looking for.

I am just downloading today to start testing. Is there anything I should know from others who have previously tested this module before I get started?

Well, I got the module running ok. However, I am a little confused on exactly how to get this setup with my subscriptions...

I have 2 membership subscriptions. Monthly and 1 Year.

Here is what I did so far: (Just guessing at what I am suppose to do)

1... admin/store/subscriptions - > I went into the settings tab and made a new attribute I called "1Year".

2... I setup my actions on the actions tab.

3... I went to the product and set it to the new attribute I created.

Not sure if this is the steps I was suppose to take or not... What shows up now above the Add To Cart button on the product is a text field with the label "1Year"... I assume I did something wrong or am missing exactly the correct steps as this seems pretty confusing to a customer who has no idea what if anything they are suppose to enter in the text field. (Nor do I have a clue)

Can anyone shine some light on exactly how to set this all up properly and use it? Really want to help test this but first I need to get a handle on the correct steps to set it up properly.

I just posted version 2008/04/04, which includes some major updates to the Subscriptions module:

-- I am transitioning from store-wide to per-product configurations for subscriptions. This version introduces a 'Generic Subscription' product feature. The contract length of a product can be set either to a fixed default value or to the value of a product's attribute.

-- I've also added Workflow-ng events for when a subscription is registered, renewed, expires, or reaches the notification threshold. Since Workflow-ng provides an action for changing a user's role, the Subscription module provides the functionality of uc_roles.

-- This version adds support for credit card encryption. If a subscription is purchased with a credit card, the customer can be charged automatically for renewals.

-- Contract lengths should be specified in natural language, like '1 day' or '4 weeks'. The following length units are available: second(s), minute(s), hour(s), day(s), week(s), month(s), year(s). If using attributes, the attribute name can be something like 'Contract length' and the option names should be like '30 days', etc.

I'll try to provide more documentation soon. I hope this update helps. Let me know how it works for you.

It would be really nice to implement a feature allowing users to setup a recurring paypal payment with this. For a hosting company, users want to just draft their paypal accounts monthly without putting in more information. Using paypal recurring payments with this would be great. Until then, I have to stick with the recurring payments module.

nice! this looks promising.

"It would be really nice to implement a feature allowing users to setup a recurring paypal payment with this."

You'll be pleased to see that with the new uc_paypal_buttons module this is now not only possible, but easy.

http://www.ubercart.org/contrib/4218

What would it take to allow subscriptions for anonymous users and then create a new account? I can throw some $$ toward a solution.

Katrina
--
www.ambereyes.net

I am testing this, and have Cron setup to run every hour. My subscription is supposed to be renewed 10 mins before its expiration... but it's not. I haven't dug into the code but how is this supposed to work? I imagine that Cron should be doing some checking but I only see expiration and notification functions there. If you need help getting the auto-renew feature working I'll be glad to contribute. This is a feature our site requires within the next month or so

Hi targosPizza, How is it possible to have renewals at 10min before expire if cron is set to run hourly. I would think that cron would need to run every 9 minutes for this to work. Why would you need renewal control that close to expiration? Not criticizing, just curious about that.

Quick request to update this to the Drupal6 ubercart. Otherwise, it looks like exactly what I need! Thank you!

Hi,

I discovered a problem with order duplication on reorder in uc_subscribe_reorder_subscription().

Some extra variables added by 3th party modules where missing. This was due to the fact that not the order object is duplicated, but only a strict set of object attributes are copied.

I solved it like this:

In short I duplicated the order object and deleted/altered only the necessary attributes.

In my case this is a fine solution.

Regards,

Kees

Does this support Product Kit also
I mean to say, can i add the subscription feature to a product kit instead of an individual product?
Ajay

I keep getting the message 'This is your first subscription to this product. Please choose "New subscription" under "Activation fee".', when adding a product with generic subscription feature to cart. I checked everywhere but I haven't found where to set such option. In admin/store/subscriptions/settings, I have 'subscription term' attribute as subscription fee and subscription period. The options are 1 year / 2 year, and they have their related price.
If can help, in watchdog I read 'uc_subscribe_register_subscription called with an invalid duration for user Anonymous and order product id 21. Please check the attribute options for the attribute designated as contract length.'

Please advice.

Thanks,

marco.

I installed an old version of Ubercart (1.0), with the same configuration as above, and the problem disappeared.
Upgrading to Ubercart 1.3 doesn't recreate the issue. In short, it only appears on a fresh installation of Ubercart 1.3

Thanks so much! This is exactly what I need, How does automatic renewal work with PCI compliance? I see that it's storing the CC info in the database using encryption, but it looks like PCI does not allow the CVV to be stored, even if it's encrypted.
https://www.pcisecuritystandards.org/security_standards/download.html?id...

Any thoughts?

I installed this but I keep getting a text box rather than a drop down selector to control the subscription length. Also, the subscriptions Status is expired instantly.

I wish to be able to generate a 6 month product subscription where the subscription generates a new order with that product and charges the card automatically every month for 6 months. How would I do this?

The last two commenters should read the text files that come with the manuals. I'm pretty sure your questions are answered there.

@poppers: Quickly, the text box appears because you didn't add anything for Options. You need to create an Attribute (call it "subscription length" and then give it Options (1 month, 1 year, etc.).

@islandpinnick: The PCI Compliance I think will be fine as long as you use something like Authorize.net CIM where you are not storing any local data. If you read up on that I think it will make sense, let us know here if what you read does not agree with this concept.

I've read the text files that came with this module. Are you referring to files in a different location as well? I agree that it is PCI compliant if you use CIM with Authorize.net, but I'm concerned with these lines of code:

This implies that this information is stored in the database. However, I haven't found anywhere that actually stores the info so I'm a bit confused here.

Thanks so much for your response.

An FYI for all PayPal users that are looking to integrate with subscriptions. I found the best way to do this was to use PayPal's Reference Transaction. Instead of the code above, you look up the past transaction ID form the order history and send that to PayPal.

Hello,

We have multiple video subscriptions with each having it's own corresponding role/permissions. I'm a bit unclear on how to make the expiration happen for the specific role.

-- For new product purchases --
event: new subscription
add condition: numeric comparison, [product:nid] = 99
add action: add user role (crib live)

-- For renewed subscriptions --
event: renew subscription
add condition: numeric comparison, [product:nid] = 99
add action: add user role (crib live)

What do I do for the expired subscription event if I want to expire the role that it enabled? How can I know which role it is tied into?

Thanks,
Andrey.

I was wondering if anyone else noticed that if you have a user, lets say BOB, and bob orders a subscription for 1 unit every 30days. But if BOB wants to purchase another unit, the unit and its subscription is added to the current period and not stored for later.

Has anyone else had this issue?

Has anyone figured this out yet?

It's kinda importent...

I have subscriptions setup and seemingly working. I created a test subscription that expires in 5 minutes and is set to renew automatically. However, after the initial subscription expired it just ended and did not renew automatically. I ran cron a few times and still nothing happened and a new order was not created.

Any help would be appreciated.

This one had me stumped for a bit. You'll notice that the cron works fine when you run it manually from the admin, but it doesn't renew when you're using something like crontab. If you check out the code that gets called when cron runs (sorry, can't remember where it is right now) you'll see that it checks to see if you're the admin user. However, when you run cron from crontab, you're likely running it as Anonymous so it doesn't renew. I removed the check for admin user and it worked for me.

This looks like a great module. Is there a plan to have a version of uc_subscribe for Drupal 6?

I am having the same issue as Marco with a new install of UC 1.6. Marco seemed to solve it by installing an older version of UC and updating. Is there any other way to deal with this? Is there a specific setting that I am missing?

Thanks,

Sam

I'll have an update later this week fixing some issues.

Does this module automaticaly act as a single checkout or does it only advise ubercart to do a payment?

I ask this because I enabled the node_access feature... so if the user choose a 3 month period he got access to the node for exact 3 months.

Any word on that update?

Thanks in advance.

Sam

Any updates?

Also, am I able to use naming conventions like "Monthly" or "Annually"? "1 month" and "12 months" looks pretty silly.

Hi,

this must be a great module and just what i need on my site!

I really don't know what i'm doing wrong though. I followed the readme and read this whole forum but still i get 'This is your first subscription to this product. Please choose "New subscription" under "Activation fee" message when trying to add a test product with subscription feature enabled. I created an attribute "Subscription" with options "3 months", "6 months", "1 year". I have enabled the subscription feature for the product and set the "Subscription length is defined by" and "Product attribute for subscription length" to my attribute. Still it displays the error message. When i set the "Subscription lenght is defined by" to "Default value" and type in say 1 hour i get the same error message.

Using:

D 5.14
UC 1.6

Any ideas are really welcome coz i'm scratching my head all day long!

Thanks!

Rob

@islandpinnick@d...: I would check my user table to make sure ID 0 is not missing. Some modules remove it from the database. If you don't have it just insert it in phpmyadmin and it should work fine.

Rob

I've made a patch to make uc_subscribe compatible with Drupal 6.x.
It works for me, but I haven't tried all functionallity so please test it and post feedback.
Apply with: patch < uc_subscribe_drupal_6_x.patch

Why can't we put this module on drupal.org?

Just noticed a minor mistake in the patch. In the uc_subscribe.install file, a new database schema is defined but is misspelled. Replace all 'uc_subscribe' with 'uc_subscription' and the initalization of the database should work better.

Is it safe to give this a go or do I really need to wait for a release into 6.x?

Thanks

I've applied the patch and made the changes noted for uc_subscribe.install, but Drupal still says "This version is incompatible with the 6.8 version of Drupal core." Am I missing something?

Hi All,

I am newly converted to Ubercart from Drupal Ecommerce. This subscription module is exactly what I need and I am impressed with Ubercart. I am using Drupal 6.9 . I too have applied the patch for Drupal 6 and I can get it most of the way. However I think I am still having a problem with this ammendment from the post above:

"In the uc_subscribe.install file, a new database schema is defined but is misspelled. Replace all 'uc_subscribe' with 'uc_subscription'".

I do seem to have an issue here, if I make no additional changes to the patch from it's download I get the following error on the subscriptions-manage page.

user warning: Table 'neos_drplclas.uc_subscriptions' doesn't exist query: SELECT * FROM uc_subscriptions AS us JOIN uc_order_products AS uo ON (us.order_product_id = uo.order_product_id) ORDER BY texpire DESC in /home/neos/public_html/classifieds/sites/all/modules/uc_subscribe_6/uc_subscribe.module on line 1180.

When I then change references to 'uc_subscribe' with 'uc_subscription' I still get the same error, and I dont even get a table installed on the database. With just the patch I did get a table installed but I still had the same error above each time.

Looking at the code with my untrained eye I then tried using 'uc_subscriptions' instead in the .install file, still no change, and no table installed in the DB.

I have been uninstalling the module in between file changes.

The only other error I seem to get is the following on the modules page after installation:

warning: Invalid argument supplied for foreach() in /home/neos/public_html/classifieds/includes/common.inc on line 3286.
warning: Invalid argument supplied for foreach() in /home/neos/public_html/classifieds/includes/common.inc on line 3207.

I feel like I am close as the subscription admin pages are showing. I would happily upload my complete files for the module if I can get it working cleanly for D6.

Thanks,
Matt.

$schema['uc_subscribe'] on line 11 should be $schema['uc_subscriptions']
If you already had the module enabled, first uninstall it.

Regards

Corrected some errors in the patch that I could tell were wrong:

1. (line 47) changed to subscribe to subscriptions (this error has already been mentioned in these comments)

2. (line 54) changed int to uid (without this change the uid is not added to the table, and the subscription will not work)

Hopefully this module will work now. It seems to work, but I am going to keep testing.

I am still having one problem with the D6 patch.

All seems to work up until setting the product feature options. Even though I have an attribute assigned for the product I then edit the generic subscription that has been created and I cannot get the drop-down to appear under the "Product attribute for subscription length". So I cannot select the "Product attribute" option to define my subscription length.

In my logs I get the message "uc_subscribe_register_subscription called with an invalid duration for user test and order product id 4. Please check the attribute options for the attribute designated as contract length."

It seeems to be related to this piece of code below. Can anyone shed any light on why this would not be working in D6?

-------------------------------------------------------------------

// get product attributes
$attropts = array();
$res = db_query('SELECT ua.* FROM {uc_attributes} ua JOIN {uc_product_attributes} upa ON (ua.aid = upa.aid) WHERE upa.nid = %d', $node->nid);
while ($obj = db_fetch_object($res)) {
if ($obj->aid && !empty($obj->name)) {
$attropts[$obj->aid] = $obj->name;
}
}

// build the form
$form['subscription'] = array(
'#type' => 'fieldset',
'#title' => t('Configure subscription settings for @title', array('@title' => $node->title)),
);
foreach ($sdata['attributes'] as $key => $title) {
$form['subscription']['attr-'. $key] = array(
'#type' => 'select',
'#title' => t('Please choose the attribute that designates @type', array('@type' => $title)),
'#options' => $attrs,
'#default_value' => $defattrs[$key],
);
}
$form['subscription']['length'] = array(
'#type' => 'fieldset',
'#title' => t('Subscription length settings'),
);
$form['subscription']['length']['length'] = array(
'#type' => 'radios',
'#title' => t('Subscription length is defined by'),
'#options' => array('attribute' => t('Product attribute'), 'value' => t('Default value')),
'#default_value' => isset($defattrs['length']) ? $defattrs['length'] : 'value',
);
if (count($attropts)) {
$form['subscription']['length']['lattr'] = array(
'#type' => 'select',
'#title' => t('Product attribute for subscription length'),
'#options' => $attropts,
'#default_value' => $defattrs['lattr'],
);
}
else {
$form['subscription']['length']['lattr'] = array(
'#type' => 'item',
'#title' => t('Product attribute for subscription length'),
'#value' => t('No attributes defined for this product.'),
);
}
$form['subscription']['length']['lvalue'] = array(
'#type' => 'textfield',
'#title' => t('Default value for subscription length'),
'#default_value' => $defattrs['lvalue'],
'#size' => 12,
);
$form['subscription']['length']['quantity'] = array(
'#type' => 'checkbox',
'#title' => t('Item quantity multiplies contract length'),
'#default_value' => $defattrs['quantity'],
);
/* TODO add activation fee settings
$form['subscription']['activation'] = array(
'#type' => 'fieldset',
'#title' => t('Activation fee settings'),
);
*/
$form['subscription']['subid'] = array(
'#type' => 'hidden',
'#value' => $module,
);
return uc_product_feature_form($form);
}

to get uc_subscribe tested and released for D6? I can really use a working release. Thanks.

Bit by bit I'm getting this to work with D6. I'll post a patch when I've got it squared away.

One of the things I keep wondering about with this is why not use the Recurring Payments and Role Assign features that come with UC. Would appreciate if I could find some discussion on why go with one or the other.

I looked into using role assignments for advertisers on my site, however, I'd like them to be able to add multiple listings and pay for each one separately. Roles makes that almost impossible. I thought about using node_checkout for this, but I need the listings to seamlessly upgrade/downgrade with different features. What I've ended up going with is subscriptions which, when bought give a user points in a table using actions. Then my node templates and hook_alters for that node type offer them the ability to create nodes with more or less features depending on their points usage. I'm working on getting the expiration all figured out, but subscriptions was really my only option for this. It would be nice if expiration could be set as a trigger!

Hi,

Thats cleary what i need! Is there someone that can help me to put the patch into that module? I can open them but i have no clue to MERGE or update the first one with the patch...

The BEST would be to have a module that DIRECTLY work with Drupal 6 but while i wait i would use some tips!

Thanks

The current patch for D6 is a long way from being a working version. I have tested it extensively and there are a lot of issues.

There are also issues with the D5 version. I can get the D5 version to work by installing it on a very early release of Ubercart, and then upgrading to the latest release of Ubercart (this has been discussed in earlier posts above). If you install the D5 version directly on the latest version of Ubercart you will encounter problems. I have no idea why it works via an upgrade but it does.

Regarding the D6 version, my best results have then come from upgrading the 'upgraded D5 version' to D6 with the patched D6 module. If you install the patched D6 version on a new installation of D6 you get the same issues as using the latest version of Ubercart in D5.

Even then, the D6 version is incomplete. While I have finally been able to get a subscription to actually register in D6 (after also making a database modification that is not documented in the D6 patch) there is still issues with the end user management. I think I have the admin side mostly working, but end user cannot renew or manage their subscriptions.

I can go into a lot more detail on specific errors and provide my current files and so forth if anyone can help with creating a solid D6 version (and an updated release for D5 too for that matter). I cannot code PHP so cannot do it myself. However I do have a number of installations at different working points and I am willing to do as much testing and feedback as is necessary to assist.

to get uc_subscribe tested/released for D6.

I want my customer should received "Membership renewal notification". Let say website membership life is one year. Then before expiration he should received mail notification.
Let say he should received notification mail 1 day/ 5 days/ 10 days before the expiration date.

I would love to contribute to a bounty to get this module working for D6.