My Checkout Without Account Mod

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 https://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

J_Schilz:

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

Noted. Yeah, I am not really a keen eye programmer. So this issue is in the database? Cheers

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

$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account != true";

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.

$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account <> 1";

Tim