Recover Cart Sales

[shawnlg]

I reread a posting of someone who has a similar question. Any you werent aware of creloaded. Crelaoded is a oscommerce based software that incorporated a bunch of contributions and changes. I really liked it up until recently when they made it a subscription based software. I assume other people who are faithful to the older version like me could really use the help. It cant be too difficult to figure out. I am just not sure.

 

 

I made a typo, this mod works great even with Creloaded. Easy install this was my own mess.

[mondeo79]

I always try to do that; many times I found Topics with problems posted and then: "I found the solution, I'm good!" :D And that's it, no feedbak. If it's a community, a free thing, let's share.

In Romania we have a saying: "Let the neighbour's goat die, too" Well, I try not to be that person! I hope others do the same.

 

Thank you.

 

Thank you Roxana for posting this fix which also sorted my issue - contribution is now working fine :)

[linder60]

Hi,

 

I'm trying to do the RCS contribution. When I go to admin section and click on the recover cart sales, I get this error message.

Can someone please help me and tell me where I made my mistake.

 

Fatal error: Cannot redeclare tep_db_connect() (previously declared in /home/cocomilk/public_html/teststore/shoppingcart/admin/includes/functions/database.php:13) in /home/cocomilk/public_html/teststore/shoppingcart/admin/includes/functions/database.php on line 13

 

 

Thank you,

Linda

[Guest]

my recover cart sales report does not display the correct cart order total. Also should the order date column display the date i ordered the email to be sent, or when the customer added the item to their cart? here is a picture of what's going on:

 

[alarsdes]

Hello there,

I just installed the addon. And it works fine.

 

One thing: you should change in the install note, that you have to add the function to the general.php in the admin section, and not as you wrote in the catalog section.

 

If someone is interested.

Here is the Dutch translation.

 

File catalog/admin/includes/languages/dutch/recover_cart_sales.php

<?php

/*

$Id: recover_cart_sales.php,v 1.6 2005/08/16 20:56:39 lane Exp $

Recover Cart Sales v2.22 ENGLISH Language File

 

Recover Cart Sales contribution: JM Ivler ©

Copyright © 2003-2005 JM Ivler / Ideas From the Deep / OSCommerce

http://www.oscommerce.com

 

Released under the GNU General Public License

 

Modifed by Aalst (recover_cart_sales.php,v 1.2 .. 1.36)

aalst@aalst.com

 

Modifed by willross (recover_cart_sales.php,v 1.4)

reply@qwest.net

- don't forget to flush the 'scart' db table every so often

 

Modifed by Lane (stats_recover_cart_sales.php,v 1.4d .. 2.22)

lane@ifd.com www.osc-modsquad.com / www.ifd.com

*/

 

define('MESSAGE_STACK_CUSTOMER_ID', 'Cart voor Customer-ID ');

define('MESSAGE_STACK_DELETE_SUCCESS', ' Succesvol verwijderd');

define('HEADING_TITLE', 'Recover Cart Sales v2.22');

define('HEADING_EMAIL_SENT', 'E-mail verstuur rapport');

define('EMAIL_TEXT_LOGIN', 'Ga hier naar uw account in :');

define('EMAIL_SEPARATOR', '------------------------------------------------------');

define('EMAIL_TEXT_SUBJECT', 'Verzoek om feedback van '. STORE_NAME );

define('EMAIL_TEXT_SALUTATION', 'Geachte ' );

define('EMAIL_TEXT_NEWCUST_INTRO', "\n\n" . 'Dank u voor uw bezoek bij ' . STORE_NAME .

' Ik hoop u nog vaker als klant te mogen begroeten. ');

define('EMAIL_TEXT_CURCUST_INTRO', "\n\n" . ' Wij zijn blij dat u bij onze webshop ' .

STORE_NAME . ' goederen heeft besteld. ');

define('EMAIL_TEXT_BODY_HEADER',

'Wij bemerkten dat u bij een bezoek aan onze webshop ' .

'dat u de volgende producten in uw winkelwagentje in heeft geplaatst, maar de bestelling niet heeft afgerond ' .

'De transactie.' . "\n\n" .

'Inhoud winkelwagentje:' . "\n\n"

);

 

define('EMAIL_TEXT_BODY_FOOTER',

'Wij zijn altijd geinteresseerd om te weten waarom u niet verder bent gegaan ' .

'en dan met name wat hiervoor de reden was. ' .

'Ik vraag u dan ook vriendelijk om ons te informeren wat hiervoor de reden was. ' .

'Uw medewerking en feedback zorgen er voor dat wij er voor kunnen ' .

'zorgen dat uw ervaring met onze internetshop '. STORE_NAME . ' beter op uw wensen aansluit.'."\n\n".

'NOTA BENE:'."\n".' Als u denkt dat uw bestelling goed is afgerond ' .

'maar uw zich afvraagt waarom het nog niet is afgeleverd, dan kunt u door deze email aannemen ' .

'dat uw bestelling niet goed is afgerond,(bij Ideal betalingen kan het zijn dat de bestelling al wel is afgerekend) ' .

'U kunt als uw bestelling via Ideal betaald is, met ons contact opnemen voor een goede afronding van uw bestelling.'."\n\n".

'Onze verontschuldigingen als u de bestelling al wel helemaal heeft afgerond, ' .

'meestal sturen we dan geen herinnering, maar heel af en toe komen deze fouten voor. ' .

'En het is soms moeilijk uit te filteren wie wel en wie juist niet een herinnering nodig heeft. '."\n\n".

'Nogmaals, onze dank voor uw tijd en aandacht om ons ons te helpen zodat wij ' .

'onze internet winkel ' . STORE_NAME . " optimaal af kunnen stemmen op uw wensen.\n\nHoogachtend,\n\n"

);

 

define('DAYS_FIELD_PREFIX', 'Laatst getoond ');

define('DAYS_FIELD_POSTFIX', ' dagen ');

define('DAYS_FIELD_BUTTON', 'Verder');

define('TABLE_HEADING_DATE', 'Datum');

define('TABLE_HEADING_CONTACT', 'Gecontacteerd');

define('TABLE_HEADING_CUSTOMER', 'CUSTOMER NAME');

define('TABLE_HEADING_EMAIL', 'E-MAIL');

define('TABLE_HEADING_PHONE', 'Tel nr');

define('TABLE_HEADING_MODEL', 'ITEM');

define('TABLE_HEADING_DESCRIPTION', 'OMSCHRIJVING');

define('TABLE_HEADING_QUANTY', 'AANTAL');

define('TABLE_HEADING_PRICE', 'PRIJS');

define('TABLE_HEADING_TOTAL', 'SUBTOTAAL');

define('TABLE_GRAND_TOTAL', 'Grand Totaal: ');

define('TABLE_CART_TOTAL', 'Winkelwagen Totaal: ');

define('TEXT_CURRENT_CUSTOMER', 'KLANT');

define('TEXT_SEND_EMAIL', 'Zend E-mail');

define('TEXT_RETURN', '[Terug? Klik hier ]');

define('TEXT_NOT_CONTACTED', 'Niet benaderd');

define('PSMSG', 'Additional PS Message: ');

?>

 

File

File catalog/admin/includes/languages/dutch/stats_recover_cart_sales.php

 

<?php

/*

$Id: stats_recover_cart_sales.php,v 1.6 2005/08/16 20:56:39 lane Exp $

Recover Cart Sales ENGLISH Language File v2.22

 

Recover Cart Sales contribution: JM Ivler 11/23/03

Copyright © 2003-2005 JM Ivler / Ideas From the Deep / OSCommerce

http://www.oscommerce.com

 

Released under the GNU General Public License

 

Modifed by Aalst (stats_recover_cart_sales.php,v 1.2 .. 1.36)

aalst@aalst.com

 

Modifed by Lane (stats_recover_cart_sales.php,v 1.4d .. 2.22)

lane@ifd.com www.osc-modsquad.com / www.ifd.com

*/

 

define('HEADING_TITLE', 'Recover Cart Sales Rapport v2.22');

define('DAYS_FIELD_PREFIX', 'Laatst getoond ');

define('DAYS_FIELD_POSTFIX', ' dagen ');

define('DAYS_FIELD_BUTTON', 'Verder');

define('TABLE_HEADING_SCART_ID', 'SCart ID');

define('TABLE_HEADING_SCART_DATE', 'Datum toegevoegd');

define('TABLE_HEADING_CUSTOMER', 'Klant naam');

define('TABLE_HEADING_ORDER_DATE', 'Order datum');

define('TABLE_HEADING_ORDER_STATUS', 'Status');

define('TABLE_HEADING_ORDER_AMOUNT', 'Bedrag');

define('TOTAL_RECORDS', 'Beoordeelde Records:');

define('TOTAL_SALES', 'Recovered Sales:');

define('TOTAL_SALES_EXPLANATION', ' (Mogelijke verkopen die bestelling niet afgerond zijn & nu worden ingelicht via RCS)');

define('TOTAL_RECOVERED', 'Totaal Recovered:');

?>

[Guest]

Hi the experts here,

 

the install of Recover Cart Sales v2.22 was easy and works brilliantly.

Thank you so much for this great contrib.

 

I however noticed that some functions do currently not work under my configuration:

 

The button SHOW at the upper left and the EMAIL Button just link to "Not founds" under my configuration.

 

The reason is, that these links are not absolute links, but relative ones ( /catalog... instead of HTTP:// ...)

The second reason is that the admin pages (all admin pages, not only RCS) miss the <base href="... statement, which should be present to enable above mentionned short links, when for example the shop is running preceded by a SSL proxy.

 

1) the first thing would have been to change the buttons to issue absolute links, the better solution would have been to ensure that all Admin pages would have got correct <base href statements...

 

Since i am not used to programming PHP, could someone care for this small fix?

 

 

 

Thank you in advance.

 

RIN67630

[autoxtreme]

Hi,

 

I am not sure if I am posting in the right place for this, but I am using a CRE Loaded version of OSC. I am trying to install this contribution to my store but I am having a couple of small problems.

 

Everything seems to work ok apart from the main tool. I have the admin menu under configuration, I have the report, but the tool does not seem to be showing.

 

I think the problem is in the tool.php file where it says........

 

Edit /catalog/admin/includes/boxes/tools.php and add someplace between the first and last line of the "$contents[] = array('text' =>" line:

'<a href="' . tep_href_link(FILENAME_RECOVER_CART_SALES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_TOOLS_RECOVER_CART . '</a><br>' .

 

The tools.php file I have on CRE loaded is.......

 

<?php
/*
 $Id: tools.php,v 1.1.1.1 2004/03/04 23:39:44 ccwjr Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License

 Chain Reaction Works, Inc.
 Copyright © 2005-2006 

 Last Modified By : $Author: Author $
 Last Modifed On :  $Date: LastChangeDate$
 Latest Revision :  $Revision: 8871 $
*/
?>
<!-- tools //-->
	  <tr>
		<td>
<?php
 $heading = array();
 $contents = array();

 $heading[] = array('text'  => BOX_HEADING_TOOLS,
				 'link'  => tep_href_link(FILENAME_BACKUP_MYSQL, 'selected_box=tools'));

 if ($selected_box == 'tools' || $menu_dhtml == true) {
//RCI start
$returned_rci_top = $cre_RCI->get('tools', 'boxestop');
$returned_rci_bottom = $cre_RCI->get('tools', 'boxesbottom');
$contents[] = array('text'  => $returned_rci_top .
										   tep_admin_files_boxes(FILENAME_BACKUP_MYSQL, BOX_TOOLS_MYSQL_BACKUP, 'SSL') .
										   tep_admin_files_boxes(FILENAME_BACKUP,BOX_TOOLS_BACKUP) .
										   tep_admin_files_boxes(FILENAME_CACHE, BOX_TOOLS_CACHE) .
										   tep_admin_files_boxes(FILENAME_EDIT_LANGUAGES, BOX_TOOLS_DEFINE_LANGUAGE) .
										   tep_admin_files_boxes(FILENAME_EMAIL_SUBJECTS, BOX_TOOLS_EMAIL_SUBJECTS ) .
										   tep_admin_files_boxes(FILENAME_MAIL, BOX_TOOLS_MAIL) .
										   tep_admin_files_boxes(FILENAME_SERVER_INFO, BOX_TOOLS_SERVER_INFO) .
										   tep_admin_files_boxes(FILENAME_MY_SQL_MANAGER, BOX_TOOLS_MY_SQL_MANAGER) .
										   tep_admin_files_boxes(FILENAME_WHOS_ONLINE, BOX_TOOLS_WHOS_ONLINE) .
										   $returned_rci_bottom);
//RCI eof
 }

 $box = new box;
 echo $box->menuBox($heading, $contents);
?>
		</td>
	  </tr>
<!-- tools_eof //-->

 

 

Where in the code do I need to add the extra bit of code?

 

Thank you for any help!

[Guest]

Hello everyone,

 

I have recently installed Recover Cart Sales version 2.23 and I almost have everything running smoothly. Unfortunately, I cannot, for the life of me, get the addon to e-mail customers no matter how many times I press the "Send E-mail" button. I am able to send e-mails, newsletters, and product notifications via the admin panel just fine, but not RCS. I'm a bit baffled at the moment. I'm using a test account I created for myself to test this.

 

After searching through this thread for a few hours I see that I am not alone and the common answer is to check the logs. I'm not sure exactly how to do that but I will contact my Web host for assistance regarding that matter.

 

As to what happens when I click "Send E-mails", the page simply refreshes every time. I do not get any messages that the e-mail has been sent. I do see that the checkbox gets checks under contacted but right next to is "Uncontacted". Any idea what I need to do to make this great contribution to send the e-mails?

 

Thanks.

[JSR]

I installed the contribution and its working smoothly! Thanks for a great addon!

I was just wondering how i can get the product image to show as a link instead of te actual link in the email.

Can anyone help with that? Thanks.

[Guest]

Thanks for this contribution,

I've sent a small donation to the author.

 

In the update.html for v2.23a, it doesn't list what the changes are from v2.23 to v2.23a.

Do you know what the changes are?

 

It says in the community contributions page only `Updated with bugfix by country.'

So does this mean `the email to the customer will be sent in the customers chosen language, not with the admin tool language',

is the only change from v2.23 to v2.23a?

[Guest]

I have a working contribution installed that allows someone to go straight to the checkout process without creating a free account

(so their postal address and order history won't be saved in oscommerce as a result).

 

The link it goes to is /create_account.php?guest=guest

 

Now I've noticed that when people choose to do this (go straight to checkout without creating a free account), then for some reason Recover Cart Sales

doesn't store the cart.

 

What changes must I make for RCS to recognize and store the carts of those who do this?

 

Thanks a lot.

[pbor1234]

Hello everyone,

 

I have recently installed Recover Cart Sales version 2.23 and I almost have everything running smoothly. Unfortunately, I cannot, for the life of me, get the addon to e-mail customers no matter how many times I press the "Send E-mail" button. I am able to send e-mails, newsletters, and product notifications via the admin panel just fine, but not RCS. I'm a bit baffled at the moment. I'm using a test account I created for myself to test this.

 

After searching through this thread for a few hours I see that I am not alone and the common answer is to check the logs. I'm not sure exactly how to do that but I will contact my Web host for assistance regarding that matter.

 

As to what happens when I click "Send E-mails", the page simply refreshes every time. I do not get any messages that the e-mail has been sent. I do see that the checkbox gets checks under contacted but right next to is "Uncontacted". Any idea what I need to do to make this great contribution to send the e-mails?

 

Thanks.

 

 

Guess you have register_globals disabled? (as it should)

 

Try to add:

 

$custid = $_POST['custid'];

 

just below

 

//link_post_variable('custid'); // fix to allow turning off register_globals in php - does not work w/standard osC (requires some other mod!)

[simon@jazzwise.com]

Hello

 

Is it possible to exclude any customers who have added 'out of stock' products to their shopping cart from being reported in RCS? We don't take backorders so anyone who does this will appear as a RCS result.

 

Thanks

[pbor1234]

Who has additions to run the contribution from a cronjob with default settings? Say for example to run the contribution each day to send customers the email after 2 days of incomplete orders.

Paul

[ambishop]

Who has additions to run the contribution from a cronjob with default settings? Say for example to run the contribution each day to send customers the email after 2 days of incomplete orders.

Paul

 

Paul,

 

thanks for updating this contribution but I am having issues with your classes/recover_cart_sales.php file. I fixed one issue but right now I can not see to figure out the issue here Call to undefined function: _getcustomersessions()

 

Can you make sure the classes/recover_cart_sales.php file is the most updated

[ambishop]

Paul,

 

thanks for updating this contribution but I am having issues with your classes/recover_cart_sales.php file. I fixed one issue but right now I can not see to figure out the issue here Call to undefined function: _getcustomersessions()

 

Can you make sure the classes/recover_cart_sales.php file is the most updated

 

Warning: implode() [function.implode]: Bad arguments. in XXXX/admin/includes/classes/recover_cart_sales.php on line 238

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 ') and date_purchased >= "0"' at line 1

 

select orders_id, orders_status from orders where (customers_id = 266 OR customers_email_address like "XXX@ZZZ.com" or customers_name like "XXX") and orders_status NOT IN () and date_purchased >= "0"

 

[TEP STOP]

[VWAntigo]

If only I could get this interesting contrib. running. I actually need it because some customers are not returning from my payment service (brazilian) but leave the money there, so it would be helpful for me to recover these unfinished carts.

Well, I installed and everything looks fine but when using the tool, I get no results. The page reloads for a while and nothing happens. No error message. Just the same page as before.

Any indication where to start looking would be greatly apreciated.

 

SQL 4, OSC 2.2 MS2, RCS 2.30 (trying out with all values set to default).

[Frogger34]

Hi all,

 

Looks like a great contribution, i have installed it completly double checked it and made a abo. cart with a customer account.

When i click tools/ recover_cart_sales.php after 1 day ( settings from the admin store ) i'am getting a blanc screen, no ab. cart.

 

When i click the reports after clicking the tools section nothing is show,

What is checked is the scart table, i have reinstalled it like someone else in this forum, but didn't work

 

I'am also unable to see the buttons to email the customer, or are they only shown if a ab, cart is displayed in the report?

 

What could be wrong, there are no errors displayed?

 

Running on php 4.4.4 mysql 5.2

 

Thanks in advance

Edited April 15, 2009 by Frogger34

[ambishop]

Hi all,

 

Looks like a great contribution, i have installed it completly double checked it and made a abo. cart with a customer account.

When i click tools/ recover_cart_sales.php after 1 day ( settings from the admin store ) i'am getting a blanc screen, no ab. cart.

 

When i click the reports after clicking the tools section nothing is show,

What is checked is the scart table, i have reinstalled it like someone else in this forum, but didn't work

 

I'am also unable to see the buttons to email the customer, or are they only shown if a ab, cart is displayed in the report?

 

What could be wrong, there are no errors displayed?

 

Running on php 4.4.4 mysql 5.2

 

Thanks in advance

 

 

I recommend using an older version than V2.3 pbor1234's v2.3 seems to have something strange going on. I had troubles as well. I am running V2.23 and it works fine. You can also add the cron job support to the older versions.

[pbor1234]

I recommend using an older version than V2.3 pbor1234's v2.3 seems to have something strange going on. I had troubles as well. I am running V2.23 and it works fine. You can also add the cron job support to the older versions.

 

I'm kind of puzzled what went wrong. 2.30 is working in my store without any problems. What ambishop did is restore the original implementation leaving the new logic for the cronjob only. Must be a simple bug because the exact same logic is parsed, so if your cronjob works, so should the admin page....

 

I guess my shop is to modified to extract it for a contribution, ambishop, or anyone else, maybe you which to debug some more because it's not nice to have the original admin page while the cronjob does something different (well, it should not but when different code is parsed you never know....).

 

Sorry for the inconvenience,

Paul

[pbor1234]

I couldn't resist to try it on a fresh 2.2rc2a, it works but only after:

- i copied the 2 language files from dutch to english

- i added the filename definiitions to filenames.php

 

I think this is all written down in the manual, sorry i did not complete the language files for other than dutch. Afterall it's something every shopowner must do for himself!

 

Sorry again,

Paul

[Frogger34]

I'm kind of puzzled what went wrong. 2.30 is working in my store without any problems. What ambishop did is restore the original implementation leaving the new logic for the cronjob only. Must be a simple bug because the exact same logic is parsed, so if your cronjob works, so should the admin page....

 

I guess my shop is to modified to extract it for a contribution, ambishop, or anyone else, maybe you which to debug some more because it's not nice to have the original admin page while the cronjob does something different (well, it should not but when different code is parsed you never know....).

 

Sorry for the inconvenience,

Paul

 

I have also have a modified shop and with the old version like ambishop told it's working and i can also mail out to the customers, now we have to test the new cronjob function. I can't see why the new version isn't working but the tip for version 2.23 worked out

 

Thanks !

Edited April 17, 2009 by Frogger34

[ambishop]

[jcim]

Hello.

 

After installing RecoverCartSales 2.30a everything seems ok, but I get no results and the scart table is empty.

 

I get no errors anywhere. I have verified the installing instructions a couple of times and I have made no mistakes, so I'm absolutely lost.

 

What I do is:

 

In the admin > tools > Recover Cart Sales, I press GO button. I get no erros, but the result page is the same as before pressing the button.

 

After, I go to admin > Reports > Recovered Sales Results and the page result is ever the same (no result):

Total Recovered: 0% €0,00

 

The scart table is absolutely empty.

 

I have paste this SQL into phpmyadmin to test:

 

select cb.customers_id cid,
							  cb.products_id pid,
							  cb.customers_basket_quantity qty,
							  cb.customers_basket_date_added bdate,
							  cus.customers_firstname fname,
							  cus.customers_lastname lname,
							  cus.customers_telephone phone,
							  cus.customers_email_address email
					   from   customers_basket cb,
							  customers cus
					   where  cb.customers_id = cus.customers_id 
		 order by cb.customers_basket_date_added desc,
							  cb.customers_id

 

I got 1122 records from 20090510 to 20050111 (I have my oscommerce working since january 2005)

There are 4 pending baskets with 30 items in the last week.

 

I have installed Quick Updates, Who's Online and some shipment and payment gateways modules, but I don't know it any of them can conflict with RecoverCartSales.

 

My software versions.

osCommerce 2.2-MS2

MySQL 5.0.32-Debian_7etch8-log

PHP Version: 5.2.0-8+etch13 (Zend: 2.2.0)

I have disabled this PHP functions: system, system_exec, passthru, shell, shell_exec, exec, phpinfo, pcntl_exec, dl, proc_close, proc_get_status, proc_nice, proc_open, proc_terminate, popen, pclose.

 

Any clue?

[smaden]

I do have a small problem. If i enabled the Show Attributes function in the Configuration panel then i get the error below:

 

 

1054 - Unknown column 'po.products_options_name' in 'field list'

 

select cba.products_id pid, po.products_options_name poname, pov.products_options_values_name povname from customers_basket_attributes cba, products_options po, products_options_values pov, languages l where cba.products_id ='58{1}28' and cba.customers_id = 27 and po.products_options_id = cba.products_options_id and pov.products_options_values_id = cba.products_options_value_id and po.language_id = 1 and pov.language_id = 1

 

Hi,

 

Just replace:

Show Attributes to :false

in the configuration pannel and it should work