PopTheTop Posted February 10, 2005 Share Posted February 10, 2005 Are you saying that you have the guest account mod installed so the customers do not have to login or register? Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
Guest Posted February 10, 2005 Share Posted February 10, 2005 Well I have now :D and it works perfectly. But what about people who are unregistered, add an item, and go all the way through checkout - obviously having registered on the way? When they get to paypal, or nochex and then abandon the process, is there any way to pick those people up and get them into the recover carts process? <{POST_SNAPBACK}> I'm not sure; the query is for customers that still have a cart. So, 1. They have to be customers with an account. (ie, PWA/Guest will not show up) 2. Their cart still has to exist. Thus, if your customers chooses to use Purchase Without Account method then you can't recover their cart. Also, if your payment module clears the cart before payment is completed then you couldn't recover. And, finally, if your customer goes to paypal then decides not to pay and returns to the store and empties their cart you couldn't recover the cart. Quote Link to comment Share on other sites More sharing options...
zboyblue Posted February 23, 2005 Share Posted February 23, 2005 (edited) I am trying to install this but when I get to step 8 I have NO idea what he is talking about here. 8) A. Go to your OSC Admin Admin File Acess area. Enter the Customer folder and click store files to add the recover_cart_sales.php file to the Customer menu. B. Return to the File Access root - and enter the Reports folder. Click on Store files to add the stats_recover_cart_sales.php file to the reports menu. WHAT IS THAT talking about?? What is an Admin Admin Acess Area??? I cannot figure out what in the world he is talking about but if someone would please tell me I would be SUPER greatful. Thanks! Craig Murphey's Law - 2 seconds after I posted this I found what he was talking about. In the Admin click "Administrator", then "File Access" ..... Thanks. Craig Edited February 23, 2005 by zboyblue Quote Link to comment Share on other sites More sharing options...
Guest Posted February 23, 2005 Share Posted February 23, 2005 (edited) I am trying to install this but when I get to step 8 I have NO idea what he is talking about here. 8) A. Go to your OSC Admin Admin File Acess area. Enter the Customer folder and click store files to add the recover_cart_sales.php file to the Customer menu. B. Return to the File Access root - and enter the Reports folder. Click on Store files to add the stats_recover_cart_sales.php file to the reports menu. WHAT IS THAT talking about?? What is an Admin Admin Acess Area??? I cannot figure out what in the world he is talking about but if someone would please tell me I would be SUPER greatful. Thanks! Craig Murphey's Law - 2 seconds after I posted this I found what he was talking about. In the Admin click "Administrator", then "File Access" ..... Thanks. Craig <{POST_SNAPBACK}> Never mind then..................... Edited February 23, 2005 by baddog Quote Link to comment Share on other sites More sharing options...
Guest Posted February 23, 2005 Share Posted February 23, 2005 Hi. I just installed RecoverCartSales1.4f I tried testing by placing a an item in my cart & logging off at the payment page. Admin > Reports > Recover Carts shows: "Examined Records 0" & "Recovered Sales 0" Apparently something is not right... Any ideas where to start looking ???? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 23, 2005 Share Posted February 23, 2005 Hi. I just installed RecoverCartSales1.4f I tried testing by placing a an item in my cart & logging off at the payment page. Admin > Reports > Recover Carts shows: "Examined Records 0" & "Recovered Sales 0" Apparently something is not right... Any ideas where to start looking ???? <{POST_SNAPBACK}> You have to look at Recover Carts. Once you have sent an email and the customer has made a purchase, you will see data under Recovered Carts. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 24, 2005 Share Posted February 24, 2005 Shouldn't the test cart I abandoned be listed under Admin > Reports > Recover Cart??? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 24, 2005 Share Posted February 24, 2005 Nevermind... I didn't realize there is also a "recover carts" under Admin > Tools....... >_< Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 4, 2005 Share Posted March 4, 2005 I'm a little confused. I have unsold cart 1.6 installed. I am getting the impression that recover cart has both the functionality of unsold cart and the added ability to send an email to the customer who abandon the cart. Is this correct? should I uninstall that and only install recover cart. http://www.oscommerce.com/community/contri...ch,Unsold+Carts Quote Link to comment Share on other sites More sharing options...
Guest Posted March 4, 2005 Share Posted March 4, 2005 I'm a little confused. I have unsold cart 1.6 installed. I am getting the impression that recover cart has both the functionality of unsold cart and the added ability to send an email to the customer who abandon the cart. Is this correct? should I uninstall that and only install recover cart. http://www.oscommerce.com/community/contri...ch,Unsold+Carts <{POST_SNAPBACK}> Your understanding of the functionality of Recover Cart is correct. Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 8, 2005 Share Posted March 8, 2005 I can not get the email letter that is sent to the customer who abandon the cart to update. The code looks a little stange and would appreciate your help. Code below. admin/languages/english/recover_cart_sales.php. What am I doing wrong. I wanted to take out the "we try not to send these messages in those cases, but sometimes it is hard for us to tell depending on individual circumstances." and place a break then put the following message. If you have any further questions please feel free to call us at phone number or send an email to [email protected] 'We are always interested in knowing what happened ' . 'and if there was a reason that you decided not to purchase at ' . 'this time. If you could be so kind as to let us ' . 'know if you had any issues or concerns, we would appreciate it. ' . 'We are asking for feedback from you and others as to how we can ' . 'help make your experience at '. STORE_NAME . ' better.'."\n\n". 'PLEASE NOTE:'."\n".'If you believe you completed your purchase and are ' . 'wondering why it was not delivered, this email is an indication that ' . 'your order was NOT completed, and that you have NOT been charged! ' . 'Please return to the store in order to complete your order.'."\n\n". 'Our apologies if you already completed your purchase, ' . 'we try not to send these messages in those cases, but sometimes it is ' . 'hard for us to tell depending on individual circumstances.'."\n\n". 'Again, thank you for your time and consideration in helping us ' . Quote Link to comment Share on other sites More sharing options...
dasonix2000 Posted March 14, 2005 Share Posted March 14, 2005 I have this module installed and have a few carts show up that have been processed and payed for. Is there a way to get this mod to move the orders from unprocessed orders to a compleated order status the same as all other compeated orders ? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 14, 2005 Share Posted March 14, 2005 I can not get the email letter that is sent to the customer who abandon the cart to update. The code looks a little stange and would appreciate your help. Code below. admin/languages/english/recover_cart_sales.php. What am I doing wrong. I wanted to take out the "we try not to send these messages in those cases, but sometimes it is hard for us to tell depending on individual circumstances." and place a break then put the following message. If you have any further questions please feel free to call us at phone number or send an email to [email protected] 'We are always interested in knowing what happened ' . 'and if there was a reason that you decided not to purchase at ' . 'this time. If you could be so kind as to let us ' . 'know if you had any issues or concerns, we would appreciate it. ' . 'We are asking for feedback from you and others as to how we can ' . 'help make your experience at '. STORE_NAME . ' better.'."\n\n". 'PLEASE NOTE:'."\n".'If you believe you completed your purchase and are ' . 'wondering why it was not delivered, this email is an indication that ' . 'your order was NOT completed, and that you have NOT been charged! ' . 'Please return to the store in order to complete your order.'."\n\n". 'Our apologies if you already completed your purchase, ' . 'we try not to send these messages in those cases, but sometimes it is ' . 'hard for us to tell depending on individual circumstances.'."\n\n". 'Again, thank you for your time and consideration in helping us ' . <{POST_SNAPBACK}> "\n\n" . 'If you have any further questions please feel free to call us at phone number or send an email to [email protected]'."\n\n". 'Again, thank you for your time and consideration in helping us ' . Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 19, 2005 Share Posted March 19, 2005 The email sent to the customer is all text. I was wondering if there is any way the email that is sent to the customer can have a link to the items that is in their cart. Thanks Elizabeth Quote Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2005 Share Posted March 19, 2005 If you know PHP it should not be too difficult to add a link to the email. I'm not very knowledgable about OSC's internals, so I simply have not yet figured out how to create the URL to the products. But it is on my todo list, so at some point I hope to get to it. Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 19, 2005 Share Posted March 19, 2005 I am new to php so I am hoping for help getting a link in the email. What would be perfect is a link each item placed in the cart. Or a login page to view the cart. I think the items stay in the cart if I am correct. Thanks Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 22, 2005 Share Posted March 22, 2005 Hello Lane and thanks for this contribution. I was wondering if anyone was able to figure out how a link to one of the items in the abandon cart in the email that is sent to the customer. Thanks Elizabeth Quote Link to comment Share on other sites More sharing options...
bjraybould Posted March 22, 2005 Share Posted March 22, 2005 since installing this contribution (which is great other than this problem) whenever i search for a customer name i get where NAME = the name searched for. <{POST_SNAPBACK}> Hi, I'm having the same problem. I understand the problem is in customers.php?search=xxxxx and is nothing to do with the recover cart. Did anyone ever find a fix for this problem? I've searched the forums but cannot find the fix for this specific MySQL error. thanks anyone. Barry Quote Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2005 Share Posted March 22, 2005 Hello Lane and thanks for this contribution. I was wondering if anyone was able to figure out how a link to one of the items in the abandon cart in the email that is sent to the customer. I finally figured out my problem; for some reason wrapping a URL with < and > in an email causes the URL to disappear. (It's standard practice to wrap URLs like that to prevent line wrapping from corrupting the URL). I ended up wrapping the URLs with ( and ) which work on my tests, hopefully other major email clients as well. Now emails have: 1. A link to the login page at the top of the email 2. A link to the product information page for each product in the abandoned cart 3. A link to the main website for the store at the bottom of the email Uploaded v1.50 here Quote Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2005 Share Posted March 22, 2005 I'm having the same problem. I understand the problem is in customers.php?search=xxxxx and is nothing to do with the recover cart. Did anyone ever find a fix for this problem? I've searched the forums but cannot find the fix for this specific MySQL error. <{POST_SNAPBACK}> I could not figure out what the error was in his report. He didn't even saw which file gave the error. (At least not that I saw). Can you post an actual example (with the name used, not replaced since the name could be the cause) that you are getting. Also, please let me know exact steps you take to replicate the problem so I can try it here. Quote Link to comment Share on other sites More sharing options...
bjraybould Posted March 22, 2005 Share Posted March 22, 2005 If you go to Admin Customers, and type anything in the Search box, you get the error message. For example /admin/customers.php?search=gfgf Customers Search: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 'where c.customers_lastname like '%gfgf%' or c.customers_firstna select count(*) as total from customers c, address_book a, customers_info ci where c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id and c.customers_id = ci.customers_info_id where c.customers_lastname like '%gfgf%' or c.customers_firstname like '%gfgf%' or c.customers_email_address like '%gfgf%' [TEP STOP] Quote Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2005 Share Posted March 22, 2005 If you go to Admin Customers, and type anything in the Search box, you get the error message. <{POST_SNAPBACK}> I don't get any errors, I get what I search for (or nothing if there is no match, but no error). Here is my code (line 784 in my admin/customers.php file): if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) { $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search'])); $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } Quote Link to comment Share on other sites More sharing options...
iantates Posted March 23, 2005 Share Posted March 23, 2005 Just upgraded to 1.5 but get an error in the email log in path and product path! Login to your account here: (https://www.simply-fancydress-online.co.ukFILENAME_CATALOG_LOGIN) ------------------------------------------------------ 1 x Santa Hat - Budget (http://www.simply-fancydress-online.co.ukFILENAME_CATALOG_PRODUCT_INFO?products_id=2804) I guess these have to be defined somewhere but not sure where and with what. Quote Link to comment Share on other sites More sharing options...
bjraybould Posted March 23, 2005 Share Posted March 23, 2005 Thank you lane, I appreciate your reply. This has me baffled? Perhaps you are using a different version of MySQL. My server is running MySQL 4.0.22. regards Barry This is my code. It looks identical to yours. <?php $search = ''; if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) { $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search'])); $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } This is my customers table. It should be pretty standard. Field Type Attributes Null Default Extra Action customers_id int(11) No auto_increment Change Drop Primary Index Unique Fulltext customers_gender char(1) No Change Drop Primary Index Unique Fulltext customers_firstname varchar(32) No Change Drop Primary Index Unique Fulltext customers_lastname varchar(32) No Change Drop Primary Index Unique Fulltext customers_dob datetime No 0000-00-00 00:00:00 Change Drop Primary Index Unique Fulltext customers_email_address varchar(96) No Change Drop Primary Index Unique Fulltext customers_default_address_id int(11) No 0 Change Drop Primary Index Unique Fulltext customers_telephone varchar(32) No Change Drop Primary Index Unique Fulltext customers_fax varchar(32) Yes NULL Change Drop Primary Index Unique Fulltext customers_password varchar(40) No Change Drop Primary Index Unique Fulltext customers_newsletter Quote Link to comment Share on other sites More sharing options...
Guest Posted March 23, 2005 Share Posted March 23, 2005 In my code these are defined in "filenames.php" in the admin/includes folder. That gets included by my #include "application_top.php". Just upgraded to 1.5 but get an error in the email log in path and product path! Login to your account here: (https://www.simply-fancydress-online.co.ukFILENAME_CATALOG_LOGIN) ------------------------------------------------------ 1 x Santa Hat - Budget (http://www.simply-fancydress-online.co.ukFILENAME_CATALOG_PRODUCT_INFO?products_id=2804) I guess these have to be defined somewhere but not sure where and with what. <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.