Guest Posted October 15, 2009 Share Posted October 15, 2009 Hello, I am still using V2.2 and I just noticed 2 days ago that customer cannot reply to the e-mail that was sent to them. RCS is putting the from address in incorrectly. My store e-mails are correct and can be replied to, but not the ones created by RCS. In admin/config I have this for e-mail from: My Store Name<[email protected]> of course the names have been changed, but this is the format. When my store sends an e-mail and I hit reply, this is what is in the to box: My Store Name and clicking properties shows this: [email protected] When RCS sends an e-mail and I hit reply, the name in the to box is: My Store Name > and clicking properties shows this: My Store Name<[email protected] I know this was working correctly before because numerous customers had replied to the e-mail. However 2 days ago I had a customer let me know that he could not reply and I have been digging into the code for a solution. Since I could not find one, I have posted here in the hopes that someone knows the answer. Tim Quote Link to comment Share on other sites More sharing options...
shaberstroh Posted November 12, 2009 Share Posted November 12, 2009 Hi, I installed the contribution (2.30a with all fixes), and I think, I followed the instructions carefully and completely. I prepared the customers_basket table, so I have only one open cart for testing. The problem is: The Recover cart sales Tool doesn't report any open cart. So i debugged and found out: $rcs->processSearch() returns correctly the customer_id with the open cart $rcs->getInfoBox() returns nothing, so nothing is shown. The reason is: getInfoBox calls $box->infoBox($this->infoBoxHeading, $this->infoBoxContents) $this->infoBoxHeading is empty $this->infoBoxContents contains the correct cart data Anyone with a solution? Yours Stefan Quote Link to comment Share on other sites More sharing options...
shaberstroh Posted November 17, 2009 Share Posted November 17, 2009 Hi, I installed the contribution (2.30a with all fixes), and I think, I followed the instructions carefully and completely. I prepared the customers_basket table, so I have only one open cart for testing. The problem is: The Recover cart sales Tool doesn't report any open cart. So i debugged and found out: $rcs->processSearch() returns correctly the customer_id with the open cart $rcs->getInfoBox() returns nothing, so nothing is shown. The reason is: getInfoBox calls $box->infoBox($this->infoBoxHeading, $this->infoBoxContents) $this->infoBoxHeading is empty $this->infoBoxContents contains the correct cart data Anyone with a solution? Yours Stefan Ok. Ifound somewhere else: With regard to the code that i had to change to get my Recovery Sales Cart tool to work i found it in a post on 24 August 2009: in /admin/includes/classes/table_block.php change the following line CODE if (isset($contents[$i][$x]['text']) && tep_not_null(isset($contents[$i][$x]['text']))) { to CODE if (isset($contents[$i][$x]['text']) && isset($contents[$i][$x]['text'])) { It still looks not good, but it works now. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 18, 2009 Share Posted November 18, 2009 (edited) I've got problem with text displaying. Show for last RCS_SKIP_DAYS - 30 days is what's showing in search box top right. Running contribution V 2.23c on new install of OSC 2.2rc2a. Can't seem to find where the RCS_SKIP_DAYS text is defined (along with other problems). shaberstroh, I changed this and didn't make any dif in my OSC V. Also have 500+ in scart db table but none will pull into Unsold Carts. Edited November 18, 2009 by nyconnected Quote Link to comment Share on other sites More sharing options...
steve_s Posted November 18, 2009 Share Posted November 18, 2009 I've got problem with text displaying. Show for last RCS_SKIP_DAYS - 30 days is what's showing in search box top right. Running contribution V 2.23c on new install of OSC 2.2rc2a. Can't seem to find where the RCS_SKIP_DAYS text is defined (along with other problems). shaberstroh, I changed this and didn't make any dif in my OSC V. Also have 500+ in scart db table but none will pull into Unsold Carts. Hi I think i searched and replace <? with <?php then search and replace <?phpphp with <?php <? is xml now and not php Steve Quote Link to comment Share on other sites More sharing options...
OSSamm Posted January 3, 2010 Share Posted January 3, 2010 When I go to recover cart stats page I get the following error. Working... 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 ':1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.customers_id = 817 OR o.customers_email_address like "" OR o.customers_name like "**********") and o.orders_status > a:1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20100103" and ot.class = "ot_total" and when I look in the file I see $orders_query_raw = "select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where (o.customers_id = " . (int)$cid . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and orders_status NOT IN (' . implode(unserialize(RCS_PENDING_SALE_STATUS), ',') . ') and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"'; $orders_query = tep_db_query($orders_query_raw); $orders = tep_db_fetch_array($orders_query); any suggestions Quote Link to comment Share on other sites More sharing options...
sunrise99 Posted February 1, 2010 Share Posted February 1, 2010 Hi, Now I use the lastest version & 2.23C for testing, when run admin/recover_cart_sales.php on tools of admin , Show for last - days can't work and return to login page. Best Regards, Sunrise99 Quote Link to comment Share on other sites More sharing options...
xtreme109 Posted February 21, 2010 Share Posted February 21, 2010 I just installed the plugin, and it shows the recovered carts. Everything looks great to far! I created a fake account with a "lost" cart. The test user shows up under "tools-->recover cart sales" along with many others and when i click "Send E-mail" email never gets sent and status remain "uncontacted" Please help! The email function works for all other parts of the site. using OSCommerce 2.2 RC2 Quote Link to comment Share on other sites More sharing options...
bateseric Posted February 23, 2010 Share Posted February 23, 2010 I have the same problem as Xtreme109. I install everything, and it looks like it is working perfectly. It shows my recovered carts, but when I try to sent email, the email never sends and it just refreshes my page of recovered carts. Anybody know a fix for this problem? Quote Link to comment Share on other sites More sharing options...
xtreme109 Posted February 23, 2010 Share Posted February 23, 2010 It appears as though the code does not recognize that there are selected users to send emails to. PLEASE HELP! ANY HELP OUT THERE! Quote Link to comment Share on other sites More sharing options...
xtreme109 Posted February 23, 2010 Share Posted February 23, 2010 check the rendered code...is this correct? <input type="checkbox" name="custid[]" value="39" CHECKED> Quote Link to comment Share on other sites More sharing options...
xtreme109 Posted February 23, 2010 Share Posted February 23, 2010 OK GOT IT! on or around line 157 of the /admin/recover_cart_Sales.php <?php $custid = $_POST['custid']; //<---ADD THIS // Are we doing an e-mail to some customers if (count($custid) > 0 ) { ?> Quote Link to comment Share on other sites More sharing options...
xtreme109 Posted February 23, 2010 Share Posted February 23, 2010 new problem on the reports/stats page!! Working... 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 ':3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_stat' at line 1 select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.customers_id = 39 OR o.customers_email_address like "[email protected]" OR o.customers_name like "Evan xxx") and o.orders_status > a:3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20100223" and ot.class = "ot_total" Ideas? Quote Link to comment Share on other sites More sharing options...
Naloomi Posted February 24, 2010 Share Posted February 24, 2010 Okay, after a brief search through this topic, I don't see a solution to my problem. The install seems to have gone through okay. Everything displays well when I do the check, but it will not e-mail out on the test account. After pressing e-mail it seems to refresh the page and show 'Uncontacted' as still checked. Any help would be greatly appreciated. Naloomi Quote Link to comment Share on other sites More sharing options...
steve_s Posted February 25, 2010 Share Posted February 25, 2010 (edited) Okay, after a brief search through this topic, I don't see a solution to my problem. The install seems to have gone through okay. Everything displays well when I do the check, but it will not e-mail out on the test account. After pressing e-mail it seems to refresh the page and show 'Uncontacted' as still checked. Any help would be greatly appreciated. Naloomi Hi Naloomi, from a previous post I finally ended up pulling the installing of version 2.30 out of the site. I installed an older version (2.23a) dated Dec '08 and all is well that seems to work =, you could try that one Steve Edited February 25, 2010 by steve_s Quote Link to comment Share on other sites More sharing options...
jowendtd Posted March 19, 2010 Share Posted March 19, 2010 I understand this is a good alternative when trying to fix abandoned carts. Should I use this add-on or does somebody know of a way I can update items in the cart. Our problem is that customers add an item to their cart and then (weeks later) completes the check-out. By that point, our prices could have changed and we either overcharge the customer or we lose money. Either way somebody is at a loss. Any ideas? Thanks. Quote Link to comment Share on other sites More sharing options...
MouCo Posted April 12, 2010 Share Posted April 12, 2010 Okay, after a brief search through this topic, I don't see a solution to my problem. The install seems to have gone through okay. Everything displays well when I do the check, but it will not e-mail out on the test account. After pressing e-mail it seems to refresh the page and show 'Uncontacted' as still checked. Any help would be greatly appreciated. Naloomi I am having this same issue, has anyone figured out the error? Thanks, Robert Quote Link to comment Share on other sites More sharing options...
simonhornby Posted April 23, 2010 Share Posted April 23, 2010 RCS and SEO URLs Hi all, I have Recover Cart Sales(v2.23d) & SEO URLS's installed - both are working fine - thanks for the great work. There is just one problem I have with them. When RCS sends out an email to the customer its shows the link to the product as /product_info.php?products_id=XXX ie in the stock Osc format. So when the link is clicked, SEO URLs jumps in and rewrites it to just /product_info.php - which then gives the message that the product is out of stock even when there's loads of stock!!! The link code I have for the RCS email is HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'product_info.php'.'?products_id='. I have disabled this for the time being until I get a fix. Can anyone suggest something that will work with SEO URL's - to tweak .htacces maybe?? If so how??? Thanks in anticipation Simon Quote Link to comment Share on other sites More sharing options...
forummaker Posted April 25, 2010 Share Posted April 25, 2010 (edited) Nevermind... Edited April 25, 2010 by forummaker Quote That "Can" you're about to open... has worms! Don't say I didn't worn ya. n. pl. cans of worms Informal - A source of unforeseen and troublesome complexity. Link to comment Share on other sites More sharing options...
Idefix_SIN Posted May 16, 2010 Share Posted May 16, 2010 new problem on the reports/stats page!! Working... 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 ':3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_stat' at line 1 select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.customers_id = 39 OR o.customers_email_address like "[email protected]" OR o.customers_name like "Evan xxx") and o.orders_status > a:3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20100223" and ot.class = "ot_total" Ideas? I have exactly the same problem. Any solution to this yet?? Thanks ! Quote Link to comment Share on other sites More sharing options...
Idefix_SIN Posted May 18, 2010 Share Posted May 18, 2010 (edited) I have exactly the same problem. Any solution to this yet?? Thanks ! Update: This has apparently been fixed in V2.30a. I have downloaded the 2.30a package and copied the "stats_recover_cart_sales.php" file to the sover overwriting the old one. Now it works. Update of the Update: Tested it again. The names shown in the stats page do not match the recover emails send......back to the drawing board :-( Edited May 18, 2010 by Idefix_SIN Quote Link to comment Share on other sites More sharing options...
Guest Posted May 29, 2010 Share Posted May 29, 2010 For some unknown reason, the email that is sent out to customers that have products in their cart has changed. Now its has an extra line that wasn't there before - "Your account: http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php".'>http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php". Also the link is incorrect as it should be "https://www.fitness-shop.com.au/account.php" Also, the products listed in the email under "contents of the shoppingcart" have a link to the website page. however, this link is incorrect and sends them to en error page. In the below example of the email that is now getting sent out, the link from the product is "http://www.fitness-shop.com.au/catalog/product_info.php?products_id=432".'>http://www.fitness-shop.com.au/catalog/product_info.php?products_id=432". In order to get to the proper page, the link should be "http://www.fitness-shop.com.au/knee-raisedipchinpushup-combo-p-432.html"'>http://www.fitness-shop.com.au/knee-raisedipchinpushup-combo-p-432.html" This is what the email looks like: Thank you for stopping by Fitness Shop and considering us for your purchase. We noticed that during a visit to our store you placed the following item(s) in your shopping cart, but did not complete the transaction (see shopping cart below). 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 Fitness Shop better. 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. 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. Your account: http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php Contents of the shoppingcart: 1 x Knee Raise/Dip/Chin/Pushup Combo Again, thank you for your time and consideration in helping us improve Fitness Shop. Yours Sincerely The team from Fitness Shop Fitness Shop http://www.fitness-shop.com.au I thought it may have had something to do with the adding Friendly SEO URL's addon, but i have sent out several email since that installation that have been ok. I have no idea why this extra line has been added, and why the links are now appearing. Any ideas please? Richard Quote Link to comment Share on other sites More sharing options...
Guest Posted May 30, 2010 Share Posted May 30, 2010 For some unknown reason, the email that is sent out to customers that have products in their cart has changed. Now its has an extra line that wasn't there before - "Your account: http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php".'>http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php". Also the link is incorrect as it should be "https://www.fitness-shop.com.au/account.php" Also, the products listed in the email under "contents of the shoppingcart" have a link to the website page. however, this link is incorrect and sends them to en error page. In the below example of the email that is now getting sent out, the link from the product is "http://www.fitness-shop.com.au/catalog/product_info.php?products_id=432".'>http://www.fitness-shop.com.au/catalog/product_info.php?products_id=432". In order to get to the proper page, the link should be "http://www.fitness-shop.com.au/knee-raisedipchinpushup-combo-p-432.html"'>http://www.fitness-shop.com.au/knee-raisedipchinpushup-combo-p-432.html" This is what the email looks like: Thank you for stopping by Fitness Shop and considering us for your purchase. We noticed that during a visit to our store you placed the following item(s) in your shopping cart, but did not complete the transaction (see shopping cart below). 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 Fitness Shop better. 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. 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. Your account: http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php Contents of the shoppingcart: 1 x Knee Raise/Dip/Chin/Pushup Combo Again, thank you for your time and consideration in helping us improve Fitness Shop. Yours Sincerely The team from Fitness Shop Fitness Shop http://www.fitness-shop.com.au I thought it may have had something to do with the adding Friendly SEO URL's addon, but i have sent out several email since that installation that have been ok. I have no idea why this extra line has been added, and why the links are now appearing. Any ideas please? Richard Anyone out there able to help me with this one? Richard Quote Link to comment Share on other sites More sharing options...
Guest Posted May 31, 2010 Share Posted May 31, 2010 For some unknown reason, the email that is sent out to customers that have products in their cart has changed. Now its has an extra line that wasn't there before - "Your account: http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php".'>http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php". Also the link is incorrect as it should be "https://www.fitness-shop.com.au/account.php" Also, the products listed in the email under "contents of the shoppingcart" have a link to the website page. however, this link is incorrect and sends them to en error page. In the below example of the email that is now getting sent out, the link from the product is "http://www.fitness-shop.com.au/catalog/product_info.php?products_id=432".'>http://www.fitness-shop.com.au/catalog/product_info.php?products_id=432". In order to get to the proper page, the link should be "http://www.fitness-shop.com.au/knee-raisedipchinpushup-combo-p-432.html"'>http://www.fitness-shop.com.au/knee-raisedipchinpushup-combo-p-432.html" This is what the email looks like: Thank you for stopping by Fitness Shop and considering us for your purchase. We noticed that during a visit to our store you placed the following item(s) in your shopping cart, but did not complete the transaction (see shopping cart below). 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 Fitness Shop better. 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. 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. Your account: http://www.fitness-shop.com.au/catalog/account.php'>http://www.fitness-shop.com.au/catalog/account.php Contents of the shoppingcart: 1 x Knee Raise/Dip/Chin/Pushup Combo Again, thank you for your time and consideration in helping us improve Fitness Shop. Yours Sincerely The team from Fitness Shop Fitness Shop http://www.fitness-shop.com.au I thought it may have had something to do with the adding Friendly SEO URL's addon, but i have sent out several email since that installation that have been ok. I have no idea why this extra line has been added, and why the links are now appearing. Any ideas please? Richard sorry for posting again, but i still cant figure it out and need some help on it. Cheers, Richard Quote Link to comment Share on other sites More sharing options...
Mort-lemur Posted June 6, 2010 Share Posted June 6, 2010 Hi, Does this contribution work with RC2.2Rc2a? the reason I ask is that when I ran the SQL I lost the ability to log on as a customer ? Thanks Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
New 
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.