COWOA (for ZC v1.5.x)

[countrycharm]

Finding that one of the on-screen messages may not be fully understood by all customers. It's the error message displayed when a customer attempts to use COWOA with an e-mail address that is linked to a standard customer account.

So I've revised it so it is much more detailed than the current message. Thought I'd share in case anyone else has the same experience.

Updated includes\languages\YOUR_TEMPLATE\english.php:
Change this:

define('ENTRY_EMAIL_ADDRESS_ERROR_EXISTS', 'Our system already has a record of that email address - please try logging in with that email address. If you do not use that address any longer you can correct it in the My Account area.');

To this:

define('ENTRY_EMAIL_ADDRESS_ERROR_EXISTS', 'You cannot use our "<strong>checkout without an account</strong>" feature with the e-mail address provided because our system already has a regular store account on file using that email address - please try logging in to our store with that email address. If you do not use that email address any longer you can correct it in the "<strong>My Account</strong>" area once logged in.');

Hi Diva,
thanks that make even better sense.

[DivaVocals]

Hi Diva,
thanks that make even better sense.

You're welcome.. My client and I collaborated to come up with the revised message.. Fortunately THE customer who had the issue contacted my client when she couldn't complete her purchase.. I think the revised message will ensure that future customers don't abandon the cart because of an unclear error message..

[Datax]

Somewhere I read something about sending email in a COWOA shop.

Everytime a customer orders through COWOA he adds his emailaddress to the list. So when he ordered 6 times and I want to send him an email from Admin he is receiving 6 emails. I've read something about this but can't find it anymore. Someone else seen this thread?

[countrycharm]

Somewhere I read something about sending email in a COWOA shop.

Everytime a customer orders through COWOA he adds his emailaddress to the list. So when he ordered 6 times and I want to send him an email from Admin he is receiving 6 emails. I've read something about this but can't find it anymore. Someone else seen this thread?

A customer who uses COWOA does so for a reason. They don't want their information stored on your site. That's one of the reasons for a customer checking out without an account, so they don't receive unsolicited e-mails? This could give those customers on your site an incentive to create an account, tell them you do this for registered customers only. NEVER send any additional information to a customer unless they sign up for your newsletter. Also, deleting them from the customers table is not the same as deleting them from the orders table. You can delete them as a customer but their order will remain and there would be no issues with duplicate emails, etc.

[Datax]

Thanx. You're right. Never send any additional info to a COWOA client.
The problem still occurs when a COWOA client later decides to make a full account with the same emailaddress.
Directly deleting the COWOA client is the solution.

I still would like a situation where only 1 email is send.

[DivaVocals]

Thanx. You're right. Never send any additional info to a COWOA client.
The problem still occurs when a COWOA client later decides to make a full account with the same emailaddress.
Directly deleting the COWOA client is the solution.

I still would like a situation where only 1 email is send.

You can always customize the code yourself.. or you can look into hiring someone to create this custom code for you..

[Datax]

You can always customize the code yourself.. or you can look into hiring someone to create this custom code for you..

Of course, but I thought I've seen it before. And why spend a lot of energy at something that already exists.

[countrycharm]

Of course, but I thought I've seen it before. And why spend a lot of energy at something that already exists.

You can try this, change line 87 to 95 In the file includes/functions/audience.php, Changed function get_audience_sql_query to:

//if no match found against queries listed in database, then $selected_entry must be an email address
  if ($query_name=='' && $query_category=='email') {
        $cust_email_address = zen_db_prepare_input($selected_entry);
        $query_name   = $cust_email_address;
        $query_string = "select customers_firstname, customers_lastname, customers_email_address
                              from " . TABLE_CUSTOMERS . "
                              where customers_email_address = '" .     zen_db_input($cust_email_address) . "'  
                              and COWOA_account = '0'";
    } 

By doing this Cowoa will not send any emails to Cowoa customers.

[DivaVocals]

You can try this, change line 87 to 95 In the file includes/functions/audience.php, Changed function get_audience_sql_query to:

//if no match found against queries listed in database, then $selected_entry must be an email address
  if ($query_name=='' && $query_category=='email') {
        $cust_email_address = zen_db_prepare_input($selected_entry);
        $query_name   = $cust_email_address;
        $query_string = "select customers_firstname, customers_lastname, customers_email_address
                              from " . TABLE_CUSTOMERS . "
                              where customers_email_address = '" .     zen_db_input($cust_email_address) . "'  
                              and COWOA_account = '0'";
    } 

By doing this Cowoa will not send any emails to Cowoa customers.

But this also includes order e-mails too right???

[Datax]

But this also includes order e-mails too right???

Which order emails do you mean?


It seems to work


If you add this in de query around line 55 also, the COWOA clients are removed from the dropdown field too.