How Did You Hear About Us? Referrals Mod [Support Thread]

[DivaVocals]

Thank you. I understand the overrides system, I was clarifying the instructions that were posted here earlier...because I was going to say that as far as I know, modified files should only be placed in an override folder. But I did try to stick my override create_account.php for this mod in the default folder just to see if my results would change...but it didn't.

I have replaced the create_account.php default file in the default folder.

And you are absolutely right.. UNLESS the file is NOT a core Zen Cart file, you should never replace a core file in the default_template folder without using an override.. (even if a module's instructions or anyone else suggests otherwise..)

[joyjoy]

Okay,cool. Thanks for clearing that up. It'll be one less mess that I can get myself into.

[joyjoy]

Anymore ideas anyone?

[joyjoy]

Hi everyone, I FINALLY got this working! Just one quick question. What would I add to my files if I wanted the "Referred By" field on the customer page.

I want the referred by filed to be visible right away instead of having to go into the details of the customer account.

Thank you!

[tym27]

Been happily using the "How Did You Hear About Us" add on without any problems or issues.

Now, I'd like to include the referral source response in the order confirmation email (mainly for the sake of the copy sent to the admin, but it won't hurt for the customer to see it too). Is this possible? How would I do it?

Can anybody help with this? Thanks so much!

[fepb]

After hours scouring this forum and the mod files, I just wanted to share a solution I've found for:

Admin showing --none-- under "Referred by" regardless of selected source upon account creation.

I'm using Fast and Easy Checkout by Numinix so this probably applies to those of you using COWOA as well.

Found this post on the Numinix forum and replaced lines 540-559 in /modules/MY_TEMPLATE/create_account.php with the following:

// FEC MODIFICATION WITH REFERRAL CODE (HOW DID YOU HEAR ABOUT US MOD)
      $_SESSION['sendto'] = $_SESSION['cart_address_id'] = (int)$address_id;
    }
    $_SESSION['shipping'] = ''; 
    $sql = "insert into " . TABLE_CUSTOMERS_INFO . "
                          (customers_info_id, customers_info_number_of_logons,
                           customers_info_date_account_created, customers_info_source_id)
              values ('" . (int)$_SESSION['customer_id'] . "', '0', now(), '" . (int)$source . "')";

    $db->Execute($sql);
     if ($source == '9999') {
         zen_db_perform(TABLE_SOURCES_OTHER, array('customers_id' =>  $_SESSION['customer_id'], 'sources_other_name' => $source_other));
      }
//      $sql = "insert into " . TABLE_CUSTOMERS_INFO . "
//                          (customers_info_id, customers_info_number_of_logons,
//                           customers_info_date_account_created)
//              values ('" . (int)$_SESSION['customer_id'] . "', '0', now())";
//
//      $db->Execute($sql);
//rmh referral end

The referral source now shows up in the customers table as well as order details page.

Good luck.

Versions: 1.3.9h and FEC 1.9.4.

[fepb]

That number "16" under "Other" is most likely the number of orders you received before installing this mod. Because there were no referral sources at the time of those orders, they've been automatically allocated to "Other."

The only way to edit this as far as I know is to go into your database, look for the table "customers_info" and edit the values of "customers_info_source_id".

If that 16 bothers you, you could create a new referral source (under Extras -> Referrals) named something along the lines of "Pre-Referral Mod" and assigning the id of that source to those 16 customers under "customers_info_source_id".

But be very careful when working with the database! Make a backup before messing with it. No guarantees/warranties that this will work. I'm no expert; just another user who recently installed this mod and spent hours trying to get it to work.

I had over 300 "Others" when I installed this mod and decided to just leave it. If your customers enter their own custom source under "Other" you can see those entered sources by clicking on "Other" in Extras -> Referral Sources which will open a new page showing their entries.

[yeah!]

Hello People!
I am another one having issues getting the "how did you hear about us" mod to work. The installation appeared to go smoothly. I have double and triple checked that I got all the files in the correct places. I installed the sql through Tools>Install SQL and uploaded. I am running 1.39d at hoopclothes dot com.

On making a new customer acct the referral drop down shows up and appears to function fine, but I have no idea where the data for this is going. It isn't showing up on the customer's details nor in the extras>referrals or referral sources. The "Other" count goes up so I know new customers are registering somewhere. But if you click other the sources don't show up so ?

Did anyone have a similar problem with this that they solved? I did read through this entire thread, but most of the posts seem to be from much older versions of the mod. And I didn't see any applicable solutions to what is going on with my site. Thanks for your help!

[yeah!]

To update - I upgraded my cart to 1.3.9h in case that was causing the issue.
The mod still isn't working correctly, no data showing up in back end. See previous post...

If it helps the other mods I've got installed are: Image Handler2, Newsletter Subscribe 2.2 and Simple Google Analytics.

[mydanilo]

After hours scouring this forum and the mod files, I just wanted to share a solution I've found for:

Admin showing --none-- under "Referred by" regardless of selected source upon account creation.

I'm using Fast and Easy Checkout by Numinix so this probably applies to those of you using COWOA as well.

Found this post on the Numinix forum and replaced lines 540-559 in /modules/MY_TEMPLATE/create_account.php with the following:

// FEC MODIFICATION WITH REFERRAL CODE (HOW DID YOU HEAR ABOUT US MOD)
      $_SESSION['sendto'] = $_SESSION['cart_address_id'] = (int)$address_id;
    }
    $_SESSION['shipping'] = ''; 
    $sql = "insert into " . TABLE_CUSTOMERS_INFO . "
                          (customers_info_id, customers_info_number_of_logons,
                           customers_info_date_account_created, customers_info_source_id)
              values ('" . (int)$_SESSION['customer_id'] . "', '0', now(), '" . (int)$source . "')";

    $db->Execute($sql);
     if ($source == '9999') {
         zen_db_perform(TABLE_SOURCES_OTHER, array('customers_id' =>  $_SESSION['customer_id'], 'sources_other_name' => $source_other));
      }
//      $sql = "insert into " . TABLE_CUSTOMERS_INFO . "
//                          (customers_info_id, customers_info_number_of_logons,
//                           customers_info_date_account_created)
//              values ('" . (int)$_SESSION['customer_id'] . "', '0', now())";
//
//      $db->Execute($sql);
//rmh referral end

The referral source now shows up in the customers table as well as order details page.

Good luck.

Versions: 1.3.9h and FEC 1.9.4.

I am trying hard to get these two to work together but I can not follow the steps you did merging the files. What exactly did you replace with this posted code? Which file did you start out with? The version in FEC for how did you hear about us? FEC puts the create_account.php in the YOUR_TEMPLATE folder as where Referral mod puts it directly in to modules. Please help, maybe upload the merged file with instruction where to put it. Thank you.