E-Commerce: Signup / Event With Payment
I am convinced that Drupal has the tools I need to sell
online. However, I am very frustrated because I cannot
seem to get the pieces to work. Ok, enough complaining.
Here's a look at the steps I need help with.
I am so positive others have these same questions so
hopefully when they are addressed they can help all you
who have these same questions that need answers.
Goal: To sell events using the signup or event module
with Authorize.net as the payment gateway.
Using: I am setup with Drupal 5.5 running on mySQL 5.0
and PHP 5.2.4.
Roadblocks: Here's the steps I am taking to install this
setup.
1. Install Module: E-Commerce (5.x, 3.4)
2. Install Module: Signup (5.x, 2.3)
3. Install Module: Token (5.x, 1.9)
What I know: You don't need to have all of this stuff
intalled. I know you can pull this off with e-commerce,
token (which is needed for e-commerce) and either
signup or the event module. What is UNclear to me is
which one, event or signup?
Here's the problem: When I have signup installed, there
is simply NO WAY to make e-commerce understand that
you want to use signup to sell! Also I don't get a price
input on the product (Create Content > Product) when
I try to create a product. I liked the alpha6 (I'm talking
about e-commerce module version) because if you tried
to enable the store it would enable much of what was
needed to get going. In the older stable version of
e-commerce you cannot seem to get things going.
The bottom line.
If someone could just shove everything aside for a few
hours and say look, here's how you can sell this type
of product -- here's what MODULES you need, and here's
the steps, Step-By-Step -- with a limited amount of
assumptions. I'm a developer and I can't get this thing
working (Voice: "so that does that say about you?", lol).
Maybe I"m dumb, but I cannot seem to get this working
and I really need to understand how this stuff is working.
Hopefully someone could help me here. I would even be
willing to pay someone to hep me out. However, I'm sure
this is quite simple.
Any takers?
I want to make it clear as well, that I am grateful for this
software, especially that it's free. This is more of a quetion
than a complaint. I really appreciate this CMS. In my mind
I categorize like this... there's CMS's and then there's Drupal!
Help!
Yes this is an interesting
Yes this is an interesting requirement that I might find useful too! It looks as though Signup is not E-Commerce enabled and vice versa. A small custom module might be needed to link them together.
On the other hand there may already be solutions to your requirement. Have a thorough search round this site if you've not already done so, and a good trawl through the page listing all the modules.
Good luck!
gpk
----
www.alexoria.co.uk
This is the very thing I've
This is the very thing I've been looking for as well, I've spent many many hours looking for a module or combo to pull this off and there isn't one out there. I'm close to completing my own solution, which uses Event, Signup, and e-commerce. I'm new to Drupal and PHP so take this as a grain of salt, but I think I'm on the right track. Also keep in mind that this code is in mid development, but I hope it gives you an idea of what you need to do to pull this off or allows more experienced developers the opportunity to tell me how much my idea/code sucks :o)
1. Create events with signup enabled
2. Create products to be used as event deposits
3. Create taxonomy terms to be assigned to events that have the product id of the deposit amount as the description
a. A better solution would probably be to create a new table and fields in the create screen, but at the time I was just trying to get this to work.
4. Make an exact copy of signup_log named signup_log_tmp
5. Set e-commerce receipt to redirect user to page: confirmation upon payment completion
Below are the changes to signup.module that I've made so far.
function signup_form_submit($form_id, $form_values) {
//JK: Get product id for event
$node = node_load($form_values['nid']);
$deposit_pid = $node->taxonomy[3]->description;
//JK: If not a free event add info to a temp table and send user to check out
if ($deposit_pid != 0) {
//JK: Remove any temp records for this user - prevents multiple entries when canceling at check out
db_query("DELETE FROM {signup_log_tmp} WHERE uid = %d", $form_values['uid']);
// Insert the user into the signup_log.
$curtime_tmp = time();
$signup_form_data_tmp = serialize($form_values['signup_form_data']);
db_query("INSERT INTO {signup_log_tmp} (sid,uid, nid, anon_mail, signup_time, form_data) VALUES (%d, %d, %d, '%s', %d, '%s')", $form_values['sid'], $form_values['uid'], $form_values['nid'], $form_values['signup_anon_mail'], $curtime_tmp, $signup_form_data_tmp);
cart_add_item($deposit_pid);
drupal_goto('cart/checkout');
}
else {
signup_sign_up_user($form_values);
}
}
function _signup_conf() {
Global $user;
$TmpSignups = db_fetch_object(db_query("SELECT a.uid,
a.nid,
a.anon_mail,
a.form_data
FROM {signup_log_tmp} a
WHERE a.uid = %d", $user->uid));
if ($TmpSignups) {
$signup_form['nid'] = $TmpSignups->nid;
$signup_form['uid'] = $TmpSignups->uid;
$signup_form['signup_anon_mail'] = $TmpSignups->anon_mail;
$signup_form['signup_form_data'] = unserialize($TmpSignups->form_data);
unset($signup_form['signup_form_data']['disclaimer']);
}
signup_sign_up_user($signup_form);
$output = 'Hello Justin ' . $TmpSignups->nid;// . print_r($signup_form['signup_form_data']);
return $output;
}
$output = 'Hello Justin ' . $TmpSignups->nid;// . print_r($signup_form['signup_form_data']);This will be the confirmation screen when complete, right now I just use it as a check
This was added to the menu hook function
//JK: conf page to move record from temp table to perm and send email$items[] = array(
'path' => 'confirmation',
'title' => t('Event signup confirmation'),
'callback' => '_signup_conf',
'access' => user_access('administer users'),
'type' => MENU_CALLBACK
);
At this time the module is working and I have a Paypal test environment set up through e-commerce and am pleased with the results so far. You'll notice in _signup_conf that I unset a disclaimer variable, this is a disclaimer I'm setting up to protect us from deposit disputes as this site is being designed for a skydiving club I am a part of and often customers are upset when they are unable to make a jump due to things out of our control such as weather etc. The one problem I am running into right now is a field I added in signup.theme, and maybe I can get some help with this. What I want to do is create a textarea field that displays it's contents in HTML format for text formatting. I posted on this yesterday at http://drupal.org/node/205793. I hope this helps, any comments or suggestions appreciated.
Justin
Have you explored Ubercart
Have you explored Ubercart (http://ubercart.org)?
----------------------------------------------------------------------
http://www.bwv810.com/
I am a writer and researcher. In my spare time I build websites with Drupal.
Je peux communiquer en français. / Я могу общаться на русском языке.
I haven't really bothered to
I haven't really bothered to read your post, but I did notice that you haven't mentioned enabling signup_ecommerce which is part of the signup download package. If you haven't got it already (which would be puzzling...) it's here;
http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/signup/cont...
I can't imagine that you've overlooked this step, but I thought it prudent to check seeing as your problem is with bridging the signup and ecommerce modules...
Pobster
I Might Have Overlooked This
Thank you for your reply. As I think about it now, it seems
as if I never noticed this option in the modules. Usually
they will show up in the group. For example, they'll be 2
modules instead of 1. When I installed signup, I am positive
I only noticed 1 installed module, with no extra checkboxes
in the group. However, the version I had may have been old
and I did not notice it. I will give that a try and report back
for the benefit of others.
Yeah it wasn't in the 5.x
Yeah it wasn't in the 5.x package at first, the maintainer didn't update it until much later (well I say the maintainer... I actually updated it and posted it to the issue queue...), so yep - that's probably why you didn't notice it, as it wasn't there!
Pobster
Where is this module posted?
Man, this module is pretty elusive. I installed the latest version of signup in the 5.1 branch and the ecommerce signup doesn't show up. Is it on the 5.2 dev branch?
Drupal Theming and site design http://www.translationdesigns.com
My music and Blog http://www.waitingforthestorm.com
The 5.1 branch isn't
The 5.1 branch isn't supported any more (only for bug fixes, no new features) hence how comes it doesn't have the signup_ecommerce contrib. It hasn't been updated since April last year... Maybe it's time to try out the 5.2 branch? ;o)
...I already posted a link to the CVS repository, why not try downloading from there and see if it's 5.1 compatible?
Pobster
Getting Ready To Pull The Plug!
Either my thinking must be faulty or I'm just not
getting this. I downloaded the 3 files that were
listed there. By the way, those directory things
tick me off, they can't just have 1 button to
DOWNLOAD, they have the whole list. It makes
you wonder whether your doing it right. Anyways,
I downloaded those files, created a new folder in
"modules" folder called "signup_e" then uploaded
those files, nothing. It does not show up in my
modules page. What the heck am I doing wrong?
I can't believe it's taking this many posts just to
figure out this thing. I think maybe it should be
included with the e-commerce module. Afterall
there's tons of people who sell this type of stuff
like events and what-knot. Any comments b4
I launch my computer??? :)
Well the CVS repository
Well the CVS repository isn't really there for 'normal' users to download things, it's for developers really... I can only assume that you've downloaded the files as webpages and not as the actual php code? Anyways forget about that - it was probably a bad idea to suggest it and also get it out of your mind that signup_ecommerce is anything to do with the ecommerce package... It's not... It's part of the signup package and actually belongs in the 'contrib' folder within the signup module folder. TBH though it doesn't matter where the folder resides, Drupal will still 'read' it and display it correctly - the problem you'll have is that if you have signup_ecommerce in a separate directory of its own and then you go on to update the signup module one day, you'll then have two instances of signup_ecommerce and it'll bring your site down (or fill it up with errors about duplicate functions).
I think in your case it's really best to simply download the signup modules 5.2 branch?
Pobster
I am a developer. LOL.
I am a developer. LOL. However, I can't stand those directory type setups. I like things organized to where they can be grasped quickly. Now that you've clearly explained where the files need to go, I will go ahead and give that a try. Just to note though, it sounded like you were saying that it will show up anyways even if I put it in a separate folder, which it has not. However, I will move the files to...
/modules/signup/contrib/
... and see if that changes anything. When you say "branch" are you speaking about version? (5.x, 1.0) Because there is only that version available to my knowledge. Post the link in your next reply so others have it (the actual signup module). I will report back. Thanks for the reply.
Oops, well that presumption
Oops, well that presumption was quite embarrassing! Sorry about that! ;o)
...Well like all the project downloads, you just click through 'view all releases' to see the non-default branches (if there are any of course!) In the case of the signup module the 2.3 download is at the top of this page;
http://drupal.org/node/29351/release
But yeah as I mentioned earlier, it shouldn't matter where the folder is (although it *does* matter as in the case of updating I mentioned above somewhere) Drupal should still scan the modules folders and pick up all the .info files present.
Pobster
Now, I wonder... I have
Now, I wonder... I have installed the updated 2.3 version. Uploaded the files into the modules directory. That's done. Enabled it, done. I do not see a "Signup Ecommerce" check-box. I DO see the files in the directory "/modules/contrib/" What's the last step in this mad chase to get this working?
» Respectfully, GreenLED
»
Readme Identifies Problem?
Could the below explain why my Drupal 5.5 installation is not showing or allowing the use of this module? What does ported mean? It sounds like this is the problem here.
NOTE: this module requires both the ecommerce and signup modules to beinstalled and properly configured.
NOTE: This code is currently only ported to the 4.7.x core API.» Respectfully, GreenLED
»
Now, I wonder... I have
Now, I wonder... I have installed the updated 2.3 version. Uploaded
the files into the modules directory. That's done. Enabled it, done.
I do not see a "Signup Ecommerce" check-box. I DO see the files in
the directory "/modules/contrib/" What's the last step in this mad
chase to get this working?
What README file are you
What README file are you referring to? I don't have one in my installation and I can clearly see on my modules page;
Signup 5.x-1.0 Allow users to sign up for content (especially events).
Required by: Signup Ecommerce (disabled)
Signup Ecommerce Integrates the signup and e-commerce modules.
Depends on: Signup (disabled)
Ignore that mine says 5.x-1.0 I don't use signup myself and so have never updated it, I only had it installed as I updated the signup_ecommerce module myself for 5.x compatibility just because someone requested it on the forums. The three files you should have in your contrib folder are;
signup_ecommerce.info
signup_ecommerce.module
signup_ecommerce.install
If perhaps you've downloaded them separately as a root user then it's likely your webserver as a user (could be user 'nobody', 'www', 'apache', etc...) isn't sufficiently permissioned to read the files? You might want to flush your cache as well to make sure the page is completely up to date?
BTW, 'ported' refers to the process of updating contrib modules which work with one Drupal core to another (newer) core. For instance, 4.7 modules DO NOT work with Drupal 5.x and likewise 5.x modules DO NOT work with Drupal 4.7 - hence the two download paths for projects, one for 4.7 and one for 5.x.
Pobster
Anyone have any suggestions
Anyone have any suggestions for my textarea above?
That's my
That's my problem.
signup_ecommerce.module
signup_ecommerce.install
(These are included)
signup_ecommerce.info
(This file is not!)
I cannot understand why not.
It does not come with the package.
Can anyone explain why not?
Yes it would appear that
Yes it would appear that even the latest 5.x-2.3 package is missing the signup_ecommerce.info because the latter module has not been updated to Drupal 5.x yet. It might be a simple matter of creating a .info file in suitable format, or it might involve some mods.
Actually pobster did some work on it here ... http://drupal.org/node/159938.
You could do some testing for him by applying his patch to the 5.x-2.3 package (see http://drupal.org/patch/apply) - but don't test patches on a site you can't afford to hose :-P
gpk
----
www.alexoria.co.uk
Ahhhhh right, I thought
Ahhhhh right, I thought seeing as the maintainer had tagged the module as a DRUPAL-5...xxx release that it was compatible with Drupal 5.x - I mean the code 'looks' compatible, but maybe he has just made a mistake? Or maybe the mistake is that he's omitted the .info file? Meh, I dunno - make your own one and just see if it works? It only has to contain;
name = Signup Ecommerce
description = "Integrates the signup and ecommerce modules"
dependencies = signup
Pobster
The dots are not connecting.
The dots are not connecting. Here's what I did.
The module does NOT appear in the modules table.
I have a strange suspicion that there is a reason
that this is not working. Possibly there have been
errors or conflicts with it working in Drupal 5.x? In
any event. You can understand now the frustration
that I KNOW dozens of people are having
just simply trying to create a site that can sell events.
Just as an aside. Even if I can get this to work and people
can then pay for a particular event. It seems really awkward
that they are signing up for a "node" -- what I mean by this
is... Let's say you have a phone conference coming up soon.
You setup your event and then people pay there $5 or w/e
they will pay. Could you possibly forward them somehow to
that page. I think I'm answering my own question really.
I think I would write where to go for the event in the email
reminders and such. Anyhow, this is more a matter of logistics.
Let's please not get side-tracked by this paragraph. It's more
of a thought then something I want to discuss. I really
desperately need to get this working.
I hope this can be solved soon. I am sensing that I am
becoming a change agent here. I wonder why no one
else went this far to try and make it work. I can assure
you there are probably hundreds of people who'd like this
to work. I guess they probably still are on Drupal 4.7 and
never bothered because they didn't need to. Anyways,
let's get this working.
Someone should really test this besides me. This way if
they happen to get it working, they can print out the
steps or at least the setup they are using.
I feel like I'm speaking
I feel like I'm speaking Latin here or something lol...Is there a reason why no one has responded to my posts above? Maybe I'm not explaining myself correctly, or I'm off track from what you are looking for?
When I looked into the signup_ecommerce contrib it was very limited and didn't allow much flexibility for selling events but with the code I posted above I've been able to to accomplish most of what I(and most of you) are looking for. The mods are not ready to go live yet, and need to be modify to meet coding standards and such, but I think it is a step in the right direction compared to the signup_ecoomerce contrib. With a little guidance I believe I can add the functionality we are all looking for.
In a way you are speaking a
In a way you are speaking a different language. I did notice your huge post above. I neglected to read the entire post. My apologies for this. When I saw the code, I simply skipped it. The reason for this is quite simple. I really was looking for something that is already in a module format. I have clients that expect to be able to change options and such without having to edit code or anything of the sort. I really didn't even take the time to see whether it would work for this reason. Are you planning to publish the module sometime soon? If you are, then I welcome that code. You see, I am looking to be able to scale things and duplicate my results and I don't know for a fact that your code actually is in working mode. I will read your previous post and glean from it what I can input in my test site. How's that sound?
» Respectfully, GreenLED
»
I recall now why I initially
I recall now why I initially did not pursue your posts instructions...
I find these instructions a bit had to follow. Rather than saying
"Create products to be used as event deposits" you could say
something like "Create A Product" or something similar. I just
did not understand really what you were accomplishing when
I was reading there. Also I think a "turn-off" of your method is
that you need signup + event + e-commerce. I was wondering
and maybe you can explain in some detail why you need event
module in this structure as well. I am just concerned that you
are needing so many dependent modules to pull this off. I could
understand e-commerce, but signup + event I did not really
understand. These questions are really more inquisitive and
not meant to be condescending in any way.
Honestly that post was meant
Honestly that post was meant for someone more experience than myself to let me know if I was taking the right approach at all this etc. Once I was sure on this then I would make more permanent modifications, but since I am so new to Drupal and module development in general I don't want to waste hours of my time just to be told there was a better way to do it.
I use the event module because I want to give the users a calendar to select the event and everything else that comes along with that module. Basically Event handles the individual event, Signup handles the users signed up for that event, and e-commerce handles the payments.
Did you submit your idea to
Did you submit your idea to the signup_ecommerce creator?
I don't think there is
I don't think there is one...I spoke with the maintainer of the signup module and he suggested I look into the signup_ecommerce contrib, but he didn't know anything about it really. I don't think there is a working ver of it right now, besides even if there was the modifications I need are for the signup module itself. It's easy enough to pass a product to the e-commerce module, but I need a disclaimer and multiple payment options etc. I think I can pull it off, I just need an experienced module developer to answer some simple questions for me. I thought this was an active community but unfortunately no one has responded to any of my posts on it.
My impression is that it is
My impression is that it is an active community. The problem is getting your question into the right place at the right time. I would wager if you posted your question somewhere where developers check often then you would have better luck. I am a developer, but I don't do that type of coding. I don't know the engine as well as others do. I'm disappointed however in the response that some questions I've posted get. I don't even think this site supports getting email notifications whenever I get a new message, which seems a little lame to me. I have to constantly monitor the site, which I guess is what they're trying to accomplish. Well, it seems as if this conversation is ending and I still haven't got my answer really. I will look over your code and try to implement it. I will come back with questions, which I'm sure I will have.
Thank you for your contributions. I'm sure someone will take it seriously. You would post a "Answer My Question" in the forum and refer to your post in this thread. That might get some response. I did try that, and it has yielded some good responses.
» Respectfully, GreenLED
»
I am working on the same problem
I tried writing a .info file for the ecommerce_signup module and the module is definitively not working on drupal 5.x. Like Krythis I can't believe this functionality is not built into any drupal module currently. Like Krythis I very much need this functionality and hope to figure something out in the very near future.
Converting 4.7.x modules to
Converting 4.7.x modules to 5.x: http://drupal.org/node/64279
Alternatively I wonder if http://drupal.org/project/ubercart would be any use?
This may also be of interest Drupal shopping carts: Ubercart and e-Commerce module still the way to go http://cmsreport.com/node/1485.
gpk
----
www.alexoria.co.uk
I looked at the ubercart
I looked at the ubercart module but it didn't seem like I could easily do the signup stuff that I need to do. We are doing signups with free events and with paid events. Signup would easily let us print our list of paid attendees (if I could get this to work).
I'm still at the beginning stages of learning PHP and coding for drupal and I think updating the module is beyond me. It has been updated by pobster here but it isn't quite working and I don't know enough yet to fix it...
After many hours of learning
After many hours of learning how sign up works etc I've added this functionality, and must admit I'm very pleased with it :o)
I need to talk with the SignUp maintainer and see how I can have this reviewed/added. Since I'm new to module development I expect to have to make some adjustments to meet standards, but hope to have this approved soon.
If you'd like to check it out in action please visit my development site: http://krythis.com/frontierskydivers/ Event registration is restricted to registered users, and paypal sandbox is running. If you have any suggestions or comments you can reach me on AIM: xxKrythisxx or Justin.D.Kelly@gmail.com
It looks like your using
It looks like your using events, is this right? Do you have it for download perhaps? Have you contacted the person who does the signup module?
SIDEnote: By the way, that skydiving really looks like some fun. I don't want to sidetrack this topic in any way, but man, I think I'm going to look into it!
Yes, I'm using the event
Yes, I'm using the event module. You can follow the progress at http://drupal.org/node/159938 I left a few questions for the maintainer, once answered I will start working on the patch. I need to know if I have to update a newer ver of signup.
Skydiving is amazing, I love it :o)
I'm gonna guess here and say
I'm gonna guess here and say that this probably won't be ready anytime soon. However, it is imperative that I have something working within the next few days. One of my clients is selling events online and I must have a way to forwarding people to the shopping cart (e-commerce) so could you give post the files that you altered somewhere and some instructions on how to get it working. I have windows and patching is a nightmare. Anyhow, please get back to me as soon as you can. I have to deliver, thanks.
I fixed signup_ecommerce
GreenLED: signup_ecommerce is now working! I have posted a patch here. I know you said applying patches is difficult for you so, but if you contact me via my contact form and give me your email address I can email you the whole signup_ecommerce module. I'm trying to get it added to the official signup module but it is fully working. I am using it on one of my production sites.
Keep an eye on this module
Keep an eye on this module too:
http://drupal.org/project/signup_pay
subscribing
subscribing :^)
Hi I am interested signup_ecommerce module
Hi I am interested signup_ecommerce module
Can you email it to marsimaging@yahoo.com
I plan to use for our upcoming event site.
Thanks,
Marsimaging
download it
download it here
http://drupal.org/project/signup_ecommerce
Never thought my post would
Never thought my post would get so huge. I'm starting this new "thread" so-to-speak so we can once again read like normal human beings instead of the text smashed up against the edge of the page. :) Enjoying this activity.
subscribing
subscribing
subscribe
- Victor