I see the query builder has the lines in it. So all the sql should be in.
The step seems like to check whether the email entered is a COWOA or not checking against the customer table. Where could the problem lie?
Printable View
I see the query builder has the lines in it. So all the sql should be in.
The step seems like to check whether the email entered is a COWOA or not checking against the customer table. Where could the problem lie?
Alright, we figured this one out over PM.
Apparently, the windows server didn't like equating true and false with 1 and 0.
I'll repackage and upload this fix shortly. If you're getting a similar error you can fix it by going to the offending line and replacing TRUE with 1 or FALSE with 0.
Thanks for the lesson. (;
--Joe
I cant help it, I have to come and post it:
COWOA ROCKS!!
I just implemented on 2 live carts and orders start pouring in. Its only 12 hours. I have 3000 pdts on the site, and relatively good reach and local marketing... apparently I have seen a lot of potential orders gone to waste, those where you see them add to cart, then the cart time out...
All my new orders today are COWOA orders!
A few notes though.
1. I see that you can use differnt names and address with the same email, so looking at the customer table, I see duplicated emails, ie:
Simon - [email protected]
Simon A. - [email protected]
The customer may not use the same name or address every time, so there maybe a lot of entries. Even if they use the same name, will there be a new 'customer' created?
2. From the biz point of view, COWOA is good and bad. BEcuase people no longer want to register when they have COWOA. THey just want to get your stuff and get out. So I think my 'fixed customer base' will basically stall. While COWOA accounts will flood in.
Advertising would probably have to be targetted to get the COWOAs to convert to fixed customers, via refferal benefits or incentive coupons, loyalty programs or lucky draws etc. That would be a whole new field to look into, my next step.
Regarding the COWOA accounts, I am not sure if we should at all, be allowed to email marketing stuff to them to get them to convert. Becuase I beleive they did not need to agree to terms or stuff when they check out and order. That may be something to look into. Also things like warranty and returns.
3. Lastly, if we look at it, the information they need to enter is no less than registering an account as people previously pointed out. But we conquered the psychology of the buyers, they will enter 10 pages of info COWOA over 5 page of info to register an account. But it would be good to make it cleaner though. I will tweak mine slowly to take in the minimum necessary for COWOA.
Again, COWOA ROCKS!
I have just installed this mod on my 1.3.6 store and also installed both addons too, but when i come to checkout now the payment screen is just blank and nothing is showing up, but when i change my template to the default template everything works fine, the template which i made my self worked fine before i install this mod can anyone help me ?
also im using the worldpay contrib
I am using all base classic template so I dont have problem. I also use worldpay. I dont think anything got to do with wp. Did you get all the files into your templete directories? its blank? no error message?
found the problems now it was the tpl_checkout_payment_default.php, so i just got the orginal file and just added the code from the order steps so it will display the different steps table at the top.
Everything seems to be working now
does this contrib only work with MYSQL 5.0.22 or higher, because i just installed it on my test server which is running 4.1.21-standard-log and it wont show any of the order at all, it creates the customer but when you click on orders to view the customers order nothing is there. Even tho is says they have made 1 order on the right hand side.
Anyone else has this problem ?
Joe -- I know you're starting to hate seeing me post in this thread! :laugh:
I just thought of something which may or may not be a problem...since I don't know how this stuff works. :blush:
I mainly use DHL shipping. The DHL shipping mod does not show estimates unless you are logged in (wish someone could find a fix for this!).
Does this mean it will not offer DHL as a choice to my COWOA buyers or will it still show up once they hit the SSL page?
Boggled: For all intents and purposes, the user is logged in once they pass the "Billing" page. So, it sounds like they should be able to use it once they get to the shipping menu.
Regarding your SQL issues, bean_2k1, we've identified only one so far. Apparently, at least one server configuration does not like my use of trues and falses for 0 and 1. I've uploaded a fix, but I haven't had an opportunity to test it yet, and probably won't until Friday.
If you're interested in trying it: This is the link. This link will expire once I can give this package a test and replace the main one with it.
In case anyone has my links bookmarked, they'll likely be changing this weekend as I move them under a different domain.
Ron: *nods* There will be a new customer created for every COWOA transaction regardless of whether they use the same info or not. The only thing that need be unique about a customer is their id. Permanent customer accounts must have unique e-mail addresses as well, otherwise login would be hit and miss.
You bring up some good points as well regarding the business aspects of this mod.
As you point out, visitors are more inclined to use COWOA and less likely to abandon their carts. Customers who use COWOA, however, feel less committed to your store and are more likely than regular account holders to buy elsewhere. In my case, I think there's a net boon. Namely, I have a content and community site along with my store which gives people a reason to come back.
If you use COWOA and don't have something similar, you might not get a particular boon in giving people a reason to come back. I agree with you, Ron, if I buy something without an account I expect the company not to hound after me with e-mail. Depending on your product and market, though, you might do well to include a nice color printout with a little personal backstory about your store, as well as the benefits of shopping with you. Maybe a nice coupon as well. Give the COWOA customers a reason to come back one more time and it might become a habit. Just some thoughts. (;
You also reference filling out a lot of pages. In the end, I decided to include checkout success as a page in the 'Page x of y' display. It has been shown that to label checkout confirmation as the last page can result in abandoned carts and customer confusion because people think they're finished. I had to balance this against the fact that people are more likely to be intimidated out of checkout by 5 pages than by 4. I think I made the right decision, but it's another factor that you have to weigh against your market.
One last thing of note. For a few reasons, I've decided to go ahead and drop the handle. There doesn't appear to be a way to change your forum name, so I'll probably just create a new account. I'll reference this in my signature.
Thanks again for your support and encouragement,
Joe
Can some point to the latest download please,,,thk you
is it in your sig or is there another link as above
Its in the wiki:Quote:
Originally Posted by IntelCos
http://www.zen-cart.com/wiki/index.p...ithout_Account
Joe-
Just a quick word of major, major thanks for all your hard work in making this happen! I've been experimenting with Craftzombie's original hack, but this is really taking it to the next level.
Basically, you guys all rock. :-)
Waiting patiently for the final version,
-Peggy
you taking donations for this?...just incase I get it up and in and it works out well for me, I would like to thank you for your hard work!
Thank you for all of your support. (;
Ah, donations. I very much appreciate it, but I think I will decline. I'm going to be launching something professional, soon, though, and if you like my work and know anyone in need of design or consultation I could definitely use a kind word.
--Joe
I haven't downloaded or installed this mod yet but I've read this entire thread, and the wiki and visited the demo store and went through a test order.Quote:
Originally Posted by KGZotU
I just HAD to say how much you F*#&ING ROCK!!!
Sorry for that outburst but Joe, people like you are the reason I love open source communities and programmers in general.
That you would spend so much of your own time on this to help others and then not ask for ANYTHING in return goes a long way to restoring some of my faith in the human race. LOL I predict you will be successful in whatever ventures you pursue in your future.
Eh, well, thank you. (;
If I do f'ing rock, I'm only a small addition a large list of people who's names can be found in the download section, and elsewhere in this community.
Thank you, though. It means a lot to me that people find this mod helpful. I know I've been wanting it for some time, and through some inspiration from the thoughts of others I finally saw the path.
I'm just glad to put myself on the other side of this free software equation. I'm only a modifier, but it's still good to be on the helping side of the movement that's brought me so many free things.
Thank you for your predictions, et all. (;
--Joe
is the current version the one on the wiki or should I wait untill this has been updated?? i am very happy to see this here:cheers: :bigups: :bigups:
I dont see this in the download section? or is only available in the wiki?
I believe the latest version is in the wiki. Someone can correct me if I'm wrong. Can someone describe a little more what this option is and what the heck are Tableless Order Steps.
OPTIONAL: An optional modification of Tableless Order Steps has been included. This modification will display four steps during normal check out and 5 steps during COWOA.
Thanks,
Scott
I am not sure if this is related to COWOA, but I get this now:
PHP Fatal error: Call to a member function on a non-object in C:\Program Files\Ensim\Sitedata\onlineshop\Inetpub\wwwroot\includes\modules\order_total\ot_ payment.php on line 80
this appear on my step 2 of 3 payment information screen for cowoa accounts as well as normal accounts. I am looking, line 80 seems to point at some GV related stuff...
any idea?
Jewelrylady: Thanks for your support. (; Yep, the latest version is linked to in the Wiki. For the moment, it's just in the wiki. I'll be submitting it once I'm sure we've rolled all of the bugs out.
Sbross: I modified the tableless order steps mod to work with this checkout without account mod. If you go to the wiki and look at screenshot number three you can see this in action. It's the visual indicator of what step you are on in the checkout process, and how many steps are left. Sometimes customers accidentally abandon their carts when they mistakenly think they've completed checkout. The order steps mod helps prevent this by giving the customer a visual guide of the whole process. I had to modify this mod so that it would display the "billing" step to COWOA users.
I'm still planning on putting together some html installation instructions if any of this is confusing. (;
ron: It's conceivable that COWOA is doing this. I do have something in there to prevent the gift voucher box from being displayed to COWOA users. I'll contact you by PM to see if we can work out what's going on.
That makes sense. I appreciate you clearing that up for me.
I will be installing the mod tonight.
Scott
I'm going to install the mod tonight. I have installed easy populate and Image Handler 2. Does anyone know if this mod will mess with those installations or can I just drop the folders in?
Scott
Scott,
I took a look at those two mods, and at least as far as overwriting files goes they don't seem to conflict. So long as you haven't done any other modification to overwrite/override files you should be good with renaming the template folders and dropping the files in. And running the SQL patch of course.
I always recommend a backup beforehand as well. (;
--Joe
PS: Just to confirm, I've gone through with dropping my handle. The first link in my sig confirms my intent, as well as the sig of my former profile.
Sweet!!! That will make it really easy. I will install tonight. Thanks for the info.
Scott
Hi first of all this is a great mod and I hope this will be a standard integration in zen cart in the future.
I'd like to modify the split login page so that the COWOA floating box stands on top with the original split login boxes underneath. Any idea can I modify this in tpl_login_default page without messing up the Paypal layout?
J_Schilz,
Hey that sucks about your name. There should be a way to change that as long as you are in good standings but I can see reasons why not.
Hey is there a reason that this in not in the download section? Is the zen team against it? I am about to integrate it into my new site that I am working on in Japanese.
Thanks so much for your help in this.
GDSpeed
im thinking since its still in a beta version (from what the wiki says) thats why it hasn't been accepted.. of course i have no clue though :)
does this work with linkpoint and paypal? the test site only has check/money order, which of course is to prevent real payments from coming through. I apologize for nto reading through the thread first.. im tired so im heading off to bed right now and thought i'd ask that question before i did so :P
Samad's got it right. Once I'm sure I've got all the bugs ironed out and have taken it out of beta I'll submit it for the download section. I keep on telling myself, "I am not my post count," but at any rate most of those were over the last few months.
I haven't tested this with any payment methods, however it should not have any effect upon them. Other people have installed this to their live shops and have not reported payment module problems. The only thing it should effect in payment is removing the Gift Voucher box from checkout payment.
Also of of note, due to an error with my host none of my sites were sending out e-mails last night. I should have this fixed shortly, but Zen was not sending out e-mails, nor were any of my contact forms working.
Thanks again for the support!
Joe
Slitter: Sorry I missed your post earlier. It shouldn't be a problem. If you're familiar with php and html, just use my included tpl_login_default as a guide. Shoot me a PM if you have any problems.
Bug: I found a small bug when I tried putting this mod on a fresh install under different settings. If I created a COWOA account and then created a regular account with the same e-mail address I could checkout, logoff from, but not log back onto that permanent account. If you have the SQL version of this mod you might want to give this a check by creating a COWOA account, logging off, creating a new account with the same e-mail address, logging off, and then trying to log back on.
The fix is simple enough:
This has been included in the most recent package.Code:/includes/modules/pages/login/header.php
=====================================================
FIND:
-
$check_customer_query = "SELECT customers_id, customers_firstname, customers_password,
customers_email_address, customers_default_address_id,
customers_authorization, customers_referral
FROM " . TABLE_CUSTOMERS . "
WHERE customers_email_address = :email";
-
REPLACE WITH:
-
$check_customer_query = "SELECT customers_id, customers_firstname, customers_password,
customers_email_address, customers_default_address_id,
customers_authorization, customers_referral
FROM " . TABLE_CUSTOMERS . "
WHERE customers_email_address = :email
AND COWOA_account != 1";
-
--Joe
I use this mod on 1.3.6 with regular PayPal (not that quick checkout thing on 1.3.7) and it works great. Haven't tried it with linkpoint yet because I manually enter my credit card orders, but I hope to automate that soon.Quote:
Originally Posted by samad64
Hi slitter,Quote:
Originally Posted by slitter
i can help you with this, only i can't do it today. i've got orders from this last weekend to deal with. i'll try to post instructions tomorrow. i used to have my login like the one you want, but then i changed it to this:
Attachment 1602
i'll get back to you as soon as i can. :smile:
hey there... just want to add... I would be interested as well in knowing howto do it... maybe you can add my name in the pm as cc ;)
Thx.
TMontana
Thanks for your help craftzombie your split login page looks even better
Joe, have you thought more about Boggled suggestion or does it not fit in the scheme
Quote:
Originally Posted by Boggled
Quote:
Originally Posted by KGZotU
slitter,
Thanks for bringing that back up. (;
I could see the real utility of that. I think it's going to be another feature I'm going to leave to whoever wants it built. Here's how it would work, though.
Upon checkout success, COWOA users are given an option to have their data saved as an account.
People who say yes are sent a new e-mail password and their SQL COWOA flag is flipped from 0 to 1.
You could probably do that by either creating a new handler page, or perhaps by piggybacking on the regular password forgotten page using a passed variable to designate this secondary mode. There are other ways as well, I'm sure. (;
If you have any questions about how the mod works specifically, feel free to ask.
--Joe
I have downloaded this fabulous mod but have not installed yet. Before I do, I would like my split login page to look like the screenshot that slitter showed.
I don't think the instruction for doing this has been posted yet so will be watching and waiting..................:smile:
many thanks,
Shirley
Shabby Chic Cottage
I'm also sitting in limbo wondering if the download I have now from the link is the latest, or should one wait because a newer version is close.
I've also noted that a modified version of ordersteps is included. What happens if we already have the ordersteps installed, do we do just an overwrite or is there something else that requires attention before install?
IntelCos,
Good thoughts regarding 1.4. For anyone interested, I do intend to adapt this rapidly to 1.4 whenever it comes out and I don't expect much difficulty in the matter.
Alright, it occurs to me that I might have misunderstood your version question. If you're asking about the COWOA version, it seems at this point like it's pretty much mature. I don't have any updates planned for it...I think if I do the admin control panel I'll save it for 1.4.
As for the order steps, it's fairly easy. If you haven't modified your checkout steps otherwise, then it's just an overwrite with the provided template and page specific css files. If you do have other modifications, it's just a matter of overwriting the order steps code--which is nicely marked off with comments near the top of the page--using the code given in the instructions. Pretty straight forward.
Also of note, the modified order steps is designed to show 4 steps during account holder checkout and 5 during COWOA checkout.
Hope this helps,
Joe
Dear Schilz...
my question is concerning your statement on the wiki-pages...."
-I plan to release a genuine fix for this on or around the weekend of 17 March 2007."
- Mod is not compatible with Super Orders, or in general any admin mod which sends email links to the account area.
Did that already happen... cause I would love to use your mod in combination with super orders...
T.
TMontana,
Sorry, no, it didn't happen. I ended up a bit busier that weekend than I thought I'd be. Though I can't promise a date, it seems like a simple issue and I'll go ahead and try to get a combination working on my dev servers this weekend.
Thanks for bringing that up. (;
--Joe
well without beeing too charming, its guys like you who make the life of noobs like me alot easier... (well wrong sentence: its actual impossible for me to built an online store like this without the ZC community)...
I am excited to hear any news (fixes)....
Thx.
T.
ps: why isnt your mod on the download section??? Its a must-have! Any logic explanations?
this is regarding my mod, not Joe's mod, but he may be in the same boat as me here...Quote:
Originally Posted by TMontana
I submitted my mod in December to be included in the downloads section. Since that time, I have heard nothing. Now my first conclusion was that my mod was just a dirty little hack and didn't rank high enough for the zen teams approval. Okay, fine. But at least tell me that. Tell me SOMETHING. Tell me what I need to do to get it approved. Its not like I am doing it for myself. The whole point was to help other people. I have been thanked a million times for that mod. How many other people out there could use it but have no clue it exists because they haven't stumbled upon that thread? So my other conclusion is that ANY mod that has to do with bypassing the creation of accounts will not make it into the downloads section. Why? Not sure, although I can take a good guess after reading all the other threads on the topic.
I hope I am wrong Joe and your mod makes it. It is far from a dirty little hack and has proved to be extremely beneficial to me and others.
craftzombie,
I have noticed a certain ambivalence on the topic, and apparently others have as well. And, thank you for your kind words and continued support; I'd like to think as well that this has gotten past a quick and dirty mod. I agree that this is a good feature, depending on your market of course, and would like to see it reach many people.
At any rate, the simplest answer is that I haven't submitted it yet. I'd like to make sure that all the bugs are out. It appears that it's just about there. In the near future I'll formalize my heading comments, etc., and see how it sits.
I could understand a certain reluctance on the part of the devs to give a deep reaching mod like this one an official nod. In any case, I've reaped the benefit for myself and the truly industrious will find this. I do hope, as you, that it finds its audience.
I won't speculate upon motives or causes--effects of the military, I suppose--but it's unfortunate that you've been kept in the dark.
TMontana: Thanks for the support. (; I'm just glad to be on the giving side of the equation for once. I really feel like this open source thing is getting to critical mass.
--Joe
As you know, craftzombie, I have installed your "no account" mod on my site yesterday and I decided to use yours because I am SO new to all this, and yours was very simple, clear, easy and did exactly what I wanted. I did not want "optional" sign up, I wanted NO signup. I almost used Joe's, but I really, really did not want customers to have to do ANY signup.
Once the customer finds something they want, I don't want any obstacles or any hesitation to fill out the form and submit. Just clean, quick and be done.
I've done a bunch of shopping over the past 5 years online and I can count on one hand the sites that require signup. That's out of hundreds. I just want to buy, not join or feel committed.
I think yours and Joe's mods should make it into the download section. They are both good and it's just a matter of which one suits your personal needs or wants.
Kudos to you both!
many thanks,
Shirley
Hi people, the mod is upand running without problems, the 5 language packs are almost finished and just need a little fine tuning...
The problems encountered on the live site have been ironed out, maily serverside (after server ftp update) and as soon as we get a chance to post all the data we will do so...
Big thanks to JOE best mod for a long time and customers seem to like it... the issues with Emails retuning customers dont seem to create any major issues and all of our payment moduels are working properly...
If anyone wants a language pack for this mod (German, French, Italian, Spanish) or if any of you have any amendments drop us a line we will incoorperate them and then stick the completed item in a zip for all....
Good luck to all
Richie
how do i remove the detailed invoice hyperlink from the order update email if they havent got an account ?
also today i found on my store when you checkout with creating an account, it takes about 1 minute to load the shipping screen once you have entered in your address on the first screen, does anyone else have this problem
my website is www.bargaintowelrails.com
I apologize for the delay with the Super Orders issue. Aside from being generally busy I've had both some bad and some good in my life recently that's disrupted my schedule. At any rate, I'm taking off for a trip Wednesday morning and I resolve, with Benjamin Franklin as my witness, to knock this out before then. I've got 100% track record with such resolutions. (;
bean2k1: The order update e-mail issue should be resolved in recent versions of this with /admin/orders.php. You should be able to just overwrite it in, there being no override folder for it of course.
I took a look at your page. Unfortunately I haven't seen it elsewhere and I don't know what might be causing it. Perhaps a file was corrupted in the upload? Are you running with the SQL version of COWOA? Have you ran the SQL patch? I'm not sure specifically how these might cause the delay but it's what comes to mind.
--Joe
yeah im running the sql version and i have installed the sql patch too, ill try and overwrite the files again see if that works. But i have tryed the checkout out on my computer and it works fine for me, but when someone else trys to checkout with an account they get a really slow loading screen between the address and shipping page
Alright, let me know by PM if it persists, and I'll see if I can devise some tests to narrow it down and figure out what's happening.
--Joe
Hey Joe, as we know a 1.4 is around the corner someplace, but as it stands 1.3.7 is stable for the most part.
So, your latest revision, I gather I can now take this and use it on a live cart ?
Also, would this work on 1.3.0.2?
Have been installed and happy and testing. Found a problem today:
If you try to send a Gift Voucher in admin, the page shows:
1054 Unknown column 'true' in 'where clause'
in:
[select customers_email_address, customers_firstname, customers_lastname from customers where COWOA_account != true order by customers_lastname, customers_firstname, customers_email_address ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I am on 1.36, have not started to look at anything to narrow the issue, dont know if its across or only in certain installation, but it should be COWOA related. Will be looking more into it. Does anyone else have encountered this or do you have no problem sending GVs?
Ron:
Eh, probably that true false vs. 1 0 issue that cropped up earlier. I notice that I don't have it on mine, is this the windows installation that was giving you problems earlier?
I'll provide an sql patch for you by PM this evening.
IntelCos:
*nods* It's good to go. At least a few people have it up and running on their live sites. I'm working on a compatibility mod for Super Orders at the moment, and that should be it.
Hope this helps,
Joe
Alright, I see where I went wrong with my original Super Orders mod. I've learned my lesson, though, and I'm putting the new one in the wiki presently. I've tested this one out. Please let me know if you have any problems with it.
Thanks for your patience.
--Joe
Noted. Yeah, I am not really a keen eye programmer. So this issue is in the database? CheersQuote:
Originally Posted by J_Schilz
Hej Schilz!
Thank you very much for this fix and compliancy update!!!
A great support of your mod.
However I have currently installed a few other modules (localhost testing) which I think could interefere with this mod:
I do not really know which one is sending what to whom or maybe just modifying the files... these mainly are:
Superorders 2.0
PDF Order Center
Email Archive Manager 1.2
Add Customer 1.0
Edit Orders 1.1
Email address exporter 1.2c
EU Standard Bank Transfer 1.1
Ty_Packer_Tracker 2.2b
I am guessing that Email Archive Manager (just for emails within admin), add Customer, edit orders, email adress export (modifying admin account) is fine, but what about PDF Order Center, Tyy_Packer_Tracker and the EU Bank transfer?
Does anybody know, can anybody confirm?
Thank you very much!
ps: I think it was ok to leave out the graphical addons like CSS bars/grids and the shipping modules (insurance, priority handling, national packaging) as well as IH2, Ordersteps and QBI
Hi TMontana we have ADD CUSTOMER, And EU BANK TRANSFER on our live site alongside JOEs MOD and they are working fine, we do have a problem with EDIT ORDERS but its not that dramatic and we will attack that when we have a bit of free time...
Hope this helps
Richie
Hey JMS Music... thx for your reply.
Can you post updates on how to fix the problem? That would be great!
Anyone any further comments, compliance issues (maybe with the mods stated above?).
Greetings.
T.
Hi Joe,
First of all thank you for the contribution. It is exactly what I am looking for.
I have been trying to install it for a few days now, and I must do something wrong (that's why I am bothering you here):oops:
I upload all the files in the appropriate directories (I checked, they are there) and I run the sql instructions.
When I try to login I am presented with exactly the same screen as before (the standard New Customer/Returning customers options).
I have not any other modification. It is a new install with just a custom template (yes, I renamed the YOUR_TEMPLATE directories, and yes, I cleaned the cache of both IE and Firefox)
I also tried to install your mod on the classic template, but still no luck.
If you want my url, I can give it to you, but the site is not live yet and the DNS as not been re-pointed to the new server yet (I am moving to a new host and in the meantime I am changing from Shopsite to Zen cart).
I have php version 5.0.4, not as cgi, as apache module, Linux OS, and I am using zen cart 1.3.7.
Any idea?
Thank you
vatel,
Thanks for your words of support. (;
One thing springs to mind as a possibility, you say "when I try to login". Do you have anything in your cart at that time?
--Joe
Joe,
Thank you for your fast reply.
I tried to start from scratch and uploaded the saved version of my site, but unfortunately it did not work anymore. So I am back to step one.:down:
I am re-installing Zen Cart and will try to install your mod before any other modification.
I will keep you posted.
Vatel
vatel,
Sure, let me know how it goes.
Just to clarify, I asked if you had anything in your cart at the time because the checkout without account option will not show unless you have something in your shopping cart.
If you have any more problems installing shoot me a PM and we'll figure it out. (;
--Joe
I was getting a SQL statement error with one of your queries. The error was unknown column 'true' in 'where clause'. The problem can be found in the following statement within modules/templatename/no_account.php about line 119
The COWA_account field is a tinyint field, so 'true' is not a valid value. I'm not sure about the != in SQL, but I know <> works. So, the following change makes the code work for me.Quote:
$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account != true";
TimQuote:
$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account <> 1";
Tim,
Thanks for pointing this out. I've been working with ronwong regarding this issue. Apparently the true false syntax is not valid across all SQL servers. I have most, if not all, of the instances fixed.
I'm on a bit of a vacation and unable to immediately repackage the fix. As it stands, the syntax works across most implementations.
If you're having the true false syntax problem, you'll want to use your developer's tool kit to search for instances of:
and replace it with:Code:COWOA_account != true
Thanks again,Code:COWOA_account != 1
Joe
Joe,
I love this mod! It's awesome! Thanks man. I've customised it so it's a 2-page checkout... the customer enters their details, goes to checkout confirmation and bang, it's done. I personally find the 5 page checkout thing quite tedious, specially when you have to then go through paypal as in my store, so it works quite well.
If anyone wants to test it out, it's on http://www.dreamofrussia.com (live store - please use "testing" in your name so I know what's going on :cool:)
Cheers
I'm sure I got all the files uploaded correctly, I checked few times. I ran the .SQL patch too.
All I get is the message after filling up details and continuing to the next page is this:
1054 Unknown column 'COWOA_account' in 'where clause'
in:
[select count(*) as total from customers where customers_email_address = '[email protected]' and COWOA_account != true]
Please help. Thanks.
Hi Joe, thanks for your PM. I'd just post here to say finally I got it solved. It's about the .SQL patch which I incorrectly installed.
Now its ready and hope it will be OK when the site go 'live'.
BTW, this mod rocks! TWO Thumbs Up :bigups:to Joe.:clap:
Hi Barnamania!Quote:
Originally Posted by barnamania
Looks great, but I did see one glitch for US buyers. There was no place to enter the State. I didn't do a screen shot...just copied/pasted what it showed on the confirmation page:
Don't know if this is just because you modified it or if it's something in the original code (I haven't gotten around to installing it yet myself.)Quote:
Delivery Address
Testing Checkoutmod
123 Main
Mcminnville, 37110
United States
Thanks man - I'm actually targeting UK buyers at the moment, so it's not an issue. If I remember right, I disabled State from the admin, although I did edit bits of code on the login page itself.
Hi, just trying to figure out what state this mod is in before trying to install this. Should I wait until a few more bugs are worked out, or is it a good thing to install at this stage with 1.3.7?
IntelCos,
This mod is good to go. I've finally got all of the proper version notes, etc., on it and upgraded it from beta to public. I think the only problem that's come up in the last couple weeks is this cross platform SQL tiny int true/false issue. I've got that all rooted out and quite a few people have said it's working well.
--Joe
After using this for several weeks now (LOVE IT!), 95% of my new customers have chosen NOT to create an account. I know this because I have copies of all emails sent to me and when I receive new orders, there is not copy of a welcome email being sent to me. I just wonder how many of these people would have left had I required them to create an account. Good stuff Joe!
I've been following this thread for a while. I think I'm about to give up on Paypal Express Checkout...I found so many bugs (small ones), and no one's addressing the issue, and I'm kind of fed up.
So I'm thinking about implementing this mod, and I wasn't sure if this was mentioned already. Does this allow product review submissions without account too?
Thanks!
Katie,
I don't use the reviews feature myself, but I'll guess that it won't allow you to do this aside from somebody jumping out of the checkout process to write a review.
Basically, once somebody who is checkout out without an account enters their billing information an account is created for them. The account has a randomly generated password. The net effect is that they can checkout via the standard process but they can never log back in. Of course, aesthetically all accounts references are hidden from those who COWOA.
Aside from this, the only other modification is to disallow GV use to those who COWOA.
So, if you require a person to login before leaving a review then those who COWOA will not be able to leave reviews.
Hope this answers your question. (;
--Joe
Thanks, Joe. I think I'll install it on my test directory and play around.
Would there be a slight chance you might consider writing a mod to enable writing reviews without logging in? Nudge, nudge? :wink:
I'm sorry, I'd give give it a go except that my hacking time is dedicated towards learning LISP right now.
I will keep it in mind, however. If I'm working in that area and I see a fix I'll let you know. (;
--Joe
Quote:
Originally Posted by KTNaturals
KT - go to includes/modules/pages/product_reviews_write/header_php.php
Find and delete:
if (!$_SESSION['customer_id']) {
$_SESSION['navigation']->set_snapshot();
zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));
}
and then anyone can write a review without need for an account :clap:
Hi Joe,
You were right. I guess. Probably the mod was working fine and it did not appear because I did not have anything in the shopping cart. I reinstalled everything and it works very well.
Thanks.
I have two suggestions (I think someone already asked though and I will pretend I do not know).
I would like the check without account option to appear before the other two (now it sits below the create account box).
Also I really believe the 5 steps are too long. It would be enough to combine the billing and shipping info in the same page with a box to be checked if the shipping address is the same as the billing address.
Would it be a major change to implement? I'd rather not use other people's mods to shorten the checkout: too many cooks in the kitchen...
Thank you for the great work, your mod was needed and works great.
vatel,
After stepping back from this for a bit, I think you and others are correct about the proper placement of the COWOA option. It's a pretty simple matter and I'll go ahead and hit it this weekend.
As for your other suggestion, I think it's reasonable. Although, one thing to keep in mind is that it's only 4 steps, really. There's this "Your Done" 5th step to keep the customer from think they're done once they reach step 4.
At any rate, I don't think I'll be implementing a reduction in steps. I've posted my thoughts on the matter before. But, I do encourage people to customize this however they like and to share the results. I could even link them from the wiki, to provide a bit of centralization.
Sorry I can't address all of your issues. I will, however, move the COWOA box on split-login checkout this weekend. This should be a simple template replacement for those who already have it installed. If you've got too much customization for a template replacement let me know and I'll provide instructions.
--Joe
yeah, and i know i was supposed to post my login page for those who expressed an interest, but i have been extremely busy and i also have my in-laws visiting right now (which is always fun). so i apologize for not following through. :frusty:
Joe,
Thank you so much for moving the COWA box at the top. It will look much better.
Please do not apologize for not addressing the other issues, you did so much already! And they are not so important. What's important is that with your mod my visitors will not find a "wall" in front of my shop.
I am looking forward to the box modification.
Thanks again
Can somebody tell me - in the install.txt file, it says,
"STEP 2 - Upload the includes directory to your zen cart directory. For most FTP clients the directory structure of the /includes directory should be preserved, and the files should "fall" into their proper places. If your FTP client isn't capable of this, you might have to manually place each file according to where they appear in this mod."
Should this not read "upload the 'install' directory"?
Thank you,
Trilby
No, that is correct - you must upload the 'includes' directory which is in the 'install' directory. If you use something like FlashFXP it will sort out the directory structure for you - all you have to do is rename any 'YOUR_TEMPLATE' directories to ..... well your template directory, if you see what I mean.
Hiya,
Joe - and everyone else who's contributed to this mod - thanks for all your hard work!
Thought I'd contribute a small addition if anyone's interested. Had a quick look and couldn't find this done anywhere else - small changes in the Admin - Customers section that let you quickly check to see which customers chose not to create an account.
This adds an extra column to the list of customers to show which ones chose not to create an account.
Then when you view a single customers details there's an additional section at the top indicating if they created a full account or not.
NB I've created this on version 1.3.7 and haven't tested on any other version.
Mod includes following:
- 1 additional file with additional texts - so you can change my clunky descriptions if you like.
- 1 copy of the original admin/customers.php file as delivered in 1.3.7 renamed customersORIG.php
- new version of customers.php with changes included
All additions to the file are commented - just search for key word COWOA to see all details.
NB you must rename the 'admin' folder to match what ever you have renamed your admin folder.
Since it's only an eeny change I haven't done extensive testing .. so if anything breaks - let me know!
Oops .. just spotted a small bug with the sorting of the customers ... have fixed it but having trouble uploading the new zip file ...
Will keep trying .. in the meantime it's a change to file admin/customers.php around line 947
change should read
// COWOA+
case "COWOA-asc":
$disp_order = "c.COWOA_account";
break;
case "COWOA-desc":
$disp_order = "c.COWOA_account DESC";
break;
// COWOA+
Ah ha - finally managed to upload it!
So attached is the version that works properly when you try to sort customers by those that have accounts and those that don't!
Been tinkering some more and now I've included some changes on the front page of the admin console - so you can distinguish between real and COWOA customers .. more details in the readme file.
I don't know how much more time I'll have to work on this - but I'll post up any more changes I make - or if there are any bugs or general recommendations I'd be glad to hear them.
I'd love take these changes and make them configurable too - so you could pick how you want to see the data - maybe one day soon when work slacks off a bit ...
I got the COWOA and the add ons installed successfully. My problem is that customers are still having to type in their name and address twice when checking out. Is there any way to send the data to paypal or vice versa, so that they only have to type their address once?
www.Wholesomehound.com
It also overwrote my header and I need to go in and fix it. It looks frapped up right now, so please ignore it.:yuck:
Quote:
Originally Posted by mathewchan
I had found your reply today in the thread. It would be very helpful if you were able to provide me with the modifactions to this mod as i am still running version 1.3.5 myself. I went through the whole thread and hadn;t found anymore posts added in regrads to this thread. Please, it would be much appreciated if you could help. You may email me at [email protected].
Best Regards,
slash74
Please HELP! I had found your reply today in the thread. It would be very helpful if you were able to provide me with the modifications to this mod as i am still running version 1.3.5 myself. I went through the whole thread and hadn't found anymore posts added in regards to this thread. Please, it would be much appreciated if you could help. You may email me at [email protected].Quote:
Originally Posted by mathewchan
Best Regards,
slash74
SORRY FOR THE SECOND POST. DIDN'T REALISE it WOULD GO TO THE LAST PAGE.
I finally installed this on my test site, and it's running great! Thanks guys!!!
I modified the login page so that COWOA option is at the top left. Please feel free to use it. Rename the attached file to tpl_login_default.php, and uploaded to includes\templates\YOUR_TEMPLATE\templates directory.
Note: I used the split panel login option (1.3.7), which, IMO, looks a bit nicer than the normal login option. You can turn it on in Admin - Configuration - Layout Settings - Use split-login page. Or, you can modify the template I provided so that there's no "if-then" statement for split or normal, and delete the normal login stuff. LMK if anyone needs help.
ETA: You'll need to make changes to your language file.
How did you do this? I have 2 payment options, so I probably have to make it 3 pages, but less checkout pages would be great!!Quote:
Originally Posted by barnamania
After sending the SQL patch, I got a message in red "NOTE: Zen Cart database-upgrade scripts should NOT be run from this page.
Please upload the new zc_install folder and run the upgrade from there instead for better reliability."
Is that expected, or did I do something wrong?
Download my mod from: http://sasha1962.powweb.com/checkoutsystem.zipQuote:
Originally Posted by KTNaturals
It's only been tested with 1 payment system, I'll have a look at making it work with more in the future... I *think* that if you use more than one payment option it will choose paypal as default, with the option to edit payment options in the checkout_confirmation. Unfortunately I'm very busy with university exams at the moment (they start tomorrow) so I won't be able to provide any detailed support for a while. If you decide to try it out, just back everything up :cool:
Great mod been after something like this for ages.
seems to work like a dream
will post any problems or errors if i find any but all seems great at the moment
rgds
BiGGy
www.inkandcables.co.uk
Alright, sorry for the delay guys. I've got the box moved to the top, as you can see in the new screen shot:
Shot 1
I've repackaged the new layout into the zip, but it's just a matter of replacing two files.
includes/languages/english/your_template/login.php
includes/templates/your_template/templates/tpl_login_default.php
login.php
tpl_login_default.php
Of course, if you've already customized either of these files files then it isn't just a simple overwrite...unless you want to lose your changes. Let me know if you need any help and I can give more detailed instructions.
Oh, I also felt like the header needed changing from "Welcome, Please Login," since logging in is no longer the main emphasis. But, I don't think "Welcome, Please Choose How to Proceed" is that great either. Looking for any ideas. Mind the fact of course that both 'Login' and 'Checkout' link to the page.
--Joe
I just d/l the mod and before I get too excited or started in the install, are there any mySql or php version limitations? Can any template and OS be used?
thank you,
betty
I'm having a hard time getting that first file, login.php. Maybe the system here (OS X) reserves that file name in some odd way. It doesn't matter what I try, it does not appear where I download it to. The other file does, however. Maybe you could zip them together? Or are they now part of the full download?
Never mind -- just reread your post and you say it's part of the full package, so I'll just go get that.
Thanks!
Rob
Double-never mind. Just downloaded the full COWOA from your wiki page and it does not contain the new files.
AWESOME MOD! Thank you! It's just what I have been looking for! ZC should come with this mod enabled by default! When I shop online, I hate it when the site forces me to create another user name and password to remember on top of the 30+ that I already have to keep track of. It also discourages me to shop online where they force you to make a user name and password just to check out. It's extremely nice to have the option of a quick checkout.
If anybody wants to see another site in action with this mod enabled, checkout my new cane site!
www.hardwoodcanes.com
If you make a test purchase, please make your first and last name TEST TEST and credit card # 4111-1111-1111-1111
Thank you!
This may have already been mentioned, but once the mod is installed i assume its possible to shut it off if i ever decide i want to force people to register?
I finally got around to installing this. LOL
I have a few questions:
1) I have the Ty Package Tracker installed which automatically sends an email to the customer with their tracking number. This email unforunately includes a link to their invoice. LOL
How can I remove this from the email?
2) I forgot my template had the navigation bar set to be under my header. So when I installed the COWOA, the navigation bar (with home, login) moved up above my header.
Can I just install the mod in the downloads section to move this back down or is there another way?
3) In the admin section, I can't tell if they created an account or not. I'm not seeing a 'dot' after the email address. Am I supposed to?
Thanks in advance!!