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

[cherylkemp]

Martyn,

Have you had any luck with this? I'm running 1.3.1 and thought it all installed correctly - the customers can still select where they heard of us (and I can administer the choices) but I don't get the information - on my old version of Zen it used to appear in the "Customers" section of Admin.

Anyone else?

I just installed this a couple of days ago and it works fine...however the logged info shows up under extras/referral sources as well as in the customer section under "referred by" not sure if that will help you at all

[narsaw]

I just installed this a couple of days ago and it works fine...however the logged info shows up under extras/referral sources as well as in the customer section under "referred by" not sure if that will help you at all

Strange, I do see a "referred by" in Admin->Customers??, what version of zen cart are you using?

Can you post the exact link where you downloaded this contrib from?

[narsaw]

Ok I reinstalled all the files and tried running "update_zen.sql and I get this message

ERROR: Cannot ADD column customers_info_source_id because it already exists.
Error ERROR: Cannot insert configuration_key "DISPLAY_REFERRAL_OTHER" because it already exists
Error ERROR: Cannot insert configuration_key "REFERRAL_REQUIRED" because it already exists

[cherylkemp]

Ok I reinstalled all the files and tried running "update_zen.sql and I get this message

ERROR: Cannot ADD column customers_info_source_id because it already exists.
Error ERROR: Cannot insert configuration_key "DISPLAY_REFERRAL_OTHER" because it already exists
Error ERROR: Cannot insert configuration_key "REFERRAL_REQUIRED" because it already exists

that might not be a big deal...just means they're already in the database. Still didn't work after that? Did you get any other message about any successful sql stuff in that same pass? you could change the references to "create" below to "replace and run it again to see if it is completely successful then. Not sure if that will solve your problem though.

DROP TABLE IF EXISTS sources;
CREATE TABLE sources (
  sources_id int NOT NULL auto_increment,
  sources_name varchar(64) NOT NULL,
  PRIMARY KEY (sources_id),
  KEY IDX_SOURCES_NAME (sources_name)
);

INSERT INTO sources VALUES (1, 'Google');
INSERT INTO sources VALUES (2, 'Yahoo!');
INSERT INTO sources VALUES (3, 'AOL');
INSERT INTO sources VALUES (4, 'MSN');
INSERT INTO sources VALUES (5, 'ZenCart');

DROP TABLE IF EXISTS sources_other;
CREATE TABLE sources_other (
  customers_id int NOT NULL default '0',
  sources_other_name varchar(64) NOT NULL,
  PRIMARY KEY (customers_id)
);

ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display "Other" Referral option', 'DISPLAY_REFERRAL_OTHER', 'true', 'Display "Other - please specify" with text box in referral source in account creation', '1', '22', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Referral', 'REFERRAL_REQUIRED', 'true', 'Require the Referral Source in account creation', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

[narsaw]

Still same thing "Other" gets update no matter what the customer selects.

Here is what is looks like:


****Giant image deleted****

[ranger_lp]

Referral Sources only show Other as a count. You have to look at Customers -> Customers to see what was entered as a "write-in" on an Other selection.

[narsaw]

Here is a screen shot of Admin->Customers->Customers

http://www.pcappliances.com/referrals.JPG

I've personally created some of those ac****s and selected "Google, yahoo and Other (and typed in "friend", "word of mouth", etc

Referral Sources only show Other as a count. You have to look at Customers -> Customers to see what was entered as a "write-in" on an Other selection.

[cherylkemp]

Strange, I do see a "referred by" in Admin->Customers??, what version of zen cart are you using?

Can you post the exact link where you downloaded this contrib from?

this link It was updated 6/30

[CES]

Anybody know if this contribution is compatible with 1.3.6 of ZenCart.

I've compared a couple of the files and there seems to be a large numer of differences.

Craig

[mydanilo]

Yes, there are a lot of files that have changed. I tried to merge them and was only partly successful. The log in form works now just fine, but I do not see what customers selected in the admin. I guess I still miss something.

Did anybody come up with an updated file set for 1.3.6? I can't figure this out myself.

This contribution was really what I need to see how my new customers find me. How else can one know how people that register really learned about us and how the found us? This contribution seems to be a small one but is incredibly useful.