My Checkout Without Account Mod

Hi, been looking back but can't seem to find anything on this... I'm new to ZC, but have tried to really dig on this one before asking the question...

Through my FTP I think all of the file overrides/replacements goes fine (my site is new so I haven't really touched much). When it comes to installing the SQL patch (I'm opening the COWOA.sql in notepad and copying and pasting into the sql field, after hittting send I'm receiving an error of:

1062 Duplicate entry 'Permanent Account Holders Only' for key 'query_name'
in:
[INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 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.

Then trying with checkout it brings me to my default error page... https://www.throwdownperformance.com

Thanks in advance for any help!

I cant seem to get past the "Billing Information" page. I fill everything out and when I click "Submit" it reloads the page.

see here: http://www.highwaycreations.com

Help is appreciated.
Thanks
Steve.

Quick question on COWOA, for all those that may have possibly implemented it.

I only use PayPal as my payment provider and although I can use PayPal Express, users need to open a PayPal account to be able to use that, so I am looking for an rapid checkout option to minimise potential shopping cart abandonment.

My question is this - how many of the fields can I remove to still enable COWOA to work? Ideally I only want a name and email address field, then to move straight onto the next page to input a destination country to work out the shipping costs. PayPal and many other payment processors already have all the customers details, so I really don't want them entering it all over again on my site. Has anyone tried, or achieved this at all?

Although I love Zen-Cart to bits, its long drawn checkout processes inevitably cost us all sales. Other shopping cart softwares out there simply let you add items to a cart, choose the shipping destination from a drop down, then click straight out to a mainstream payment provider. Simple but effective.

Any ideas, thoughts, clues, or potential solutions would be greatly appreciated. :hug:

I did get this to work. I'm not sure I can remember all the steps I did, but it's working now. Steve B.

After careful evaluation of the options available and seeing that checkout with account options typically only remove the password input, but still leaves all the other inputs on the form to still be filled in, I have decided on a more radical solution.

I am going to simply remove the checkout button completely from the cart page and just have PayPal Express and Google Checkout buttons showing. That way potential buyers will never even have the opportunity to endure those tedious form filling exercises.

Of course this option will only work with sites whose only method of payment is PayPal or Google, but until someone comes up with a more graceful and effective solution, that is the direction I am going in with my own sites.

I have the same problem as sbergkakmp, I can't get past the "Billing Information" page.
Another problem I have is that the State choice is gone when cowoa is activated, no text, no combo box, just an empty text field.

Does anyone have a solution to these problems?

The client had me uninstall COWOA ....

I obviously got all the files changed appropriately, but there is no uninstall.sql file of any sort.

What ill effects would there be if I just left the database as is with COWOA accounts in them? I am I correct to assume that if I did do an uninstall in the database, then those COWOA account order histories would also be wiped out? Would it be best to just not do any uninstall of COWOA in the database?

Just installed COWOA and tried to login to my site. Getting the following SQL error msg:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':email AND COWOA_account != 1' at line 9
in:
[SELECT customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral FROM zen_customers WHERE customers_email_address = :email AND COWOA_account != 1]

Was there a syntax error in the original SQL patch for this mod??

Throwdown:

....

Through my FTP I think all of the file overrides/replacements goes fine ....
When it comes to installing the SQL patch (I'm opening the COWOA.sql in notepad and copying and pasting into the sql field, after hittting send I'm receiving an error of:

1062 Duplicate entry 'Permanent Account Holders Only' for key 'query_name'
in:
[INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 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.

Then trying with checkout it brings me to my default error page... www.throwdownperformance.com

Thanks in advance for any help!

Have you gotten any answer to this problem? I am getting the same thing and, if I can't resolve it, I'd rather not use the mod.

NEXT QUEST:
Has anyone found any instructions to UNinstall the COWOA mod?

I just asked that question two posts ago.

I deleted the appropriate code from the files ... but would like to have an uninstall .sql .....

I guess no one has the answer. I,also, had to go through and pick out all the pieces.

beyre:

I just asked that question two posts ago.

I deleted the appropriate code from the files ... but would like to have an uninstall .sql .....

There is no uninstall sql.

It doesn't hurt anything to leave it there. It does nothing to the regular checkout. Leaving all of the files, but only removing the code from the login page, is really the only thing that needs to be done if this mod is not for you.

sbergkakmp:

I did get this to work. I'm not sure I can remember all the steps I did, but it's working now. Steve B.

I am having the same issues. Can you remember what you did? I tried to load new FEC update with COWOA. Then I went back to old files because did not work. Now I get blank screen.:frusty::frusty:

CUSTOM_UK:

After careful evaluation of the options available and seeing that checkout with account options typically only remove the password input, but still leaves all the other inputs on the form to still be filled in, I have decided on a more radical solution.

I am going to simply remove the checkout button completely from the cart page and just have PayPal Express and Google Checkout buttons showing. That way potential buyers will never even have the opportunity to endure those tedious form filling exercises.

Of course this option will only work with sites whose only method of payment is PayPal or Google, but until someone comes up with a more graceful and effective solution, that is the direction I am going in with my own sites.

I only use PayPal. I really like FEC and COWOA, but has cost so much in sales. I have had several customers call. And I am beyond frustration level. :frusty::frusty:

What files did you modify/delete? Do customers still show up in admin? Wondering how you do this because all information will go directly to PayPal.

znrinarz:

Just installed COWOA and tried to login to my site. Getting the following SQL error msg:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':email AND COWOA_account != 1' at line 9
in:
[SELECT customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral FROM zen_customers WHERE customers_email_address = :email AND COWOA_account != 1]

Was there a syntax error in the original SQL patch for this mod??

I am having the same problem :(

Did anybody have an answer for this, my customers cannot log in currently so I am losing sales :frusty:

ANY help would be greatly appreciated

I found the answer in a (much) earlier post on this thread:

I replaced modules/pages/login/header_php.php with the origional code from the over-writes folder.

Which is what I just done and seems to be working fine now :)

I have a ZenCart 1.3.8a site, https://www.lifering.com, on which COWOA has been performing brilliantly for months. However, I recently got an update notice from ZC about a patch for PHP 5.3 - it apparently breaks ZC extravagantly. I consulted my ISP about their upgrade plans, and they're going to upgrade to PHP 5.3 in about 2 weeks, which means I need to get cracking.

The patch contains 11 files, of which one is part of COWOA:

/<ADMIN>/orders.php

(I changed the name of /admin last summer per another patch.)

I put the patch file in WinMerge and compared it against my production file and there are exactly 5 differences, but - how do I know what they may break? I don't have a test site. WinMerge will only produce a diff file in HTML, and I can't upload HTML to show you.

Has anybody done this and was it OK? Is anybody running COWOA successfully on PHP 5.3??

OK, for the record, and because I only have a short time before PHP 5.3 rolls out, I went ahead and put it in. I modified the orders.php in the patch by putting back in the two sections that referenced COWOA, and leaving untouched the patched code that didn't. For the record, in case it helps someone else, here are the changes I made.

In every case below, the first line is from the patch; the second line is from the production COWOA file.

First:
date_purchased from " . TABLE_ORDERS . "

versus
date_purchased, COWOA_order from " . TABLE_ORDERS . "

I think we're safe with the COWOA entry from that. Changed.

Second:
$zc_max_days = zen_date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;

versus
$zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;

No COWOA mentions; keep the patch version.

Third:
date_purchased from " . TABLE_ORDERS . "

versus
date_purchased, COWOA_order from " . TABLE_ORDERS . "

Keep the COWOA version.

Fourth:
EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .

versus
EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n";
if(!$check_status->fields['COWOA_order']) {
$message .= EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n";
}
$message .= EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .

Damn if I'm sure, but I think I need to keep the COWOA stuff here.

Last:
$zc_max_days = zen_date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;

versus
$zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;

Keep the patch version.

After I rolled this out, I ran a full purchase transaction and it worked correctly. I hope it all still works after the PHP upgrade.

Hi all
I have one problem after I start to use this mod

Sometimes customers ask me - Where is my order ID 2215?
They resend me email with order confirmations and I see order ID2215
But in the databaze exist another order with same ID and with different name and order date is one month early...

Im not sure , but last mode what Im install is COWOA... It is nice worked... but meibe I have problem with database... or something else...
Dont know how its happenes

sad maxus 8(

Hello all I'm fairly new to this code changing but the directions seemed easy enough. I've just finished installing everything logged off tryed to log back in and got

Fatal error: Call to undefined function zen_href_link() in /home/sandhi7/public_html/cart/admin/login.php on line 35

I'm on 1.3.8 and just tryed to install the cowao mod no addons or anything else not a clue where to start.

any idea's

Thanks in advance.