Jump to content
Met00

Recover Cart Sales

Recommended Posts

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<sales@mydomain.net>

 

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:

sales@mydomain.net

 

 

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<sales@mystorename.net

 

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by nyconnected

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 ) {  ?>

Share this post


Link to post
Share on other sites

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 "evan@xxx.com" 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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by steve_s

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Nevermind...

Edited by forummaker

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.

Share this post


Link to post
Share on other sites

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 "evan@xxx.com" 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 !

Share this post


Link to post
Share on other sites

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 by Idefix_SIN

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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


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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×