Recover Cart [Support Thread]

Does anyone know if there's a particular lag between a cart being abandoned and the customer showing up in the report? I see several abandoned carts, but I logged in to do a test and the cart I abandoned isn't showing up. It's been about 30 mins.

There shouldn't be a delay. You do need to log out for it to show up.

bestore:

I'm using ZC 1.38a. Has anyone used the RC mod with the Multi-sites mod? It'd be great if the links in the email message directed the customer to the specific site (theme) they shopped on and not to the main site. Thanks in advance for any responses.

Any suggestions or thoughts on this problem?

I'm having problems loading the sql file.

Here's what I'm getting:
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 'CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id int(1' at line 1

and then it goes on and on...
I use ZC 1.3.8a

Any ideas?

Hi all,

I just installed the file onto a linux server (godaddy) and when I went to install the sql patch via admin panel I got the folling message:

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 'CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id i' at line 1
in:
[DROP TABLE IF EXISTS scart; CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', dateadded varchar(8) NOT NULL default '', datemodified varchar(8) NOT NULL default '', PRIMARY KEY (scartid), UNIQUE KEY customers_id (customers_id), UNIQUE KEY scartid (scartid) ) TYPE=MyISAM; SET @configuration_group_id=0; SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 1; DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id; DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id; INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', '1', '1'); SET @configuration_group_id=last_insert_id(); UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id; SET @configuration_group_id=0; SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 1; INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Look back days', 'RCS_BASE_DAYS', '30', 'Number of days to look back from today for abandoned cards.', @configuration_group_id, 10, NULL, NOW(), NULL, NULL), (NULL, 'Sales Results Report days', 'RCS_REPORT_DAYS', '90', 'Number of days the sales results report takes into account. The more days the longer the SQL queries!.', @configuration_group_id, 15, NULL, NOW(), NULL, NULL), (NULL, 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', 'Number of days to give for emails before they no longer show as being sent', @configuration_group_id, 20, NULL, NOW(), NULL, NULL), (NULL, 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', 'If true then the customer's name will be used in the greeting. If false then a generic greeting will be used.', @configuration_group_id, 30, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', 'Controls display of item attributes.

Some sites have attributes for their items.

Set this to true if yours does and you want to show them, otherwise set to false.', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Ignore Customers with Sessions', 'RCS_CHECK_SESSIONS', 'false', 'If you want the tool to ignore customers with an active session (ie, probably still shopping) set this to true.

Setting this to false will operate in the default manner of ignoring session data & using less resources', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', 'Color for the word/phrase used to notate a current customer

A current customer is someone who has purchased items from your store in the past.', @configuration_group_id, 50, NULL, NOW(), NULL, NULL), (NULL, 'Uncontacted hilight color', 'RCS_UNCONTACTED_COLOR', '80FFFF', 'Row highlight color for uncontacted customers.

An uncontacted customer is one that you have not used this tool to send an email to before.', @configuration_group_id, 60, NULL, NOW(), NULL, NULL), (NULL, 'Contacted hilight color', 'RCS_CONTACTED_COLOR', 'FF9FA2', 'Row highlight color for contacted customers.

An contacted customer is one that you have used this tool to send an email to before.', @configuration_group_id, 70, NULL, NOW(), NULL, NULL), (NULL, 'Matching Order Hilight', 'RCS_MATCHED_ORDER_COLOR', '9FFF22', 'Row highlight color for entrees that may have a matching order.

An entry will be marked with this color if an order contains one or more of an item in the abandoned cart and matches either the cart's customer email address or database ID.', @configuration_group_id, 72, NULL, NOW(), NULL, NULL), (NULL, 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', 'To ignore carts with an a matching order set this to true.

Setting this to false will cause entries with a matching order to show, along with the matching order's status.

See documentation for details.', @configuration_group_id, 80, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Lowest Pending sales status', 'RCS_PENDING_SALE_STATUS', '1', 'The highest value that an order can have and still be considered pending. Any value higher than this will be considered by RCS as sale which completed.

See documentation for details.', @configuration_group_id, 85, NULL, NOW(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses('), (NULL, 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', 'Style for even rows in results report. Typical options are dataTableRow and attributes-even.', @configuration_group_id, 90, NULL, NOW(), NULL, NULL), (NULL, 'Report Odd Row Style', 'RCS_REPORT_ODD_STYLE', '', 'Style for odd rows in results report. Typical options are NULL (ie, no entry) and attributes-odd.', @configuration_group_id, 92, NULL, NOW(), NULL, NULL), (NULL, 'E-Mail Copies to', 'RCS_EMAIL_COPIES_TO', '', 'If you want copies of emails that are sent to customers by this contribution, enter the email address here. If empty no copies are sent', @configuration_group_id, 35, NULL, NOW(), NULL, NULL), (NULL, 'Autocheck 'safe' carts to email', 'RCS_AUTO_CHECK', 'true', 'To check entries which are most likely safe to email (ie, not existing customers, not previously emailed, etc.) set this to true.

Setting this to false will leave all entries unchecked (you will have to check each entry you want to send an email for).', @configuration_group_id, 82, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Match orders from any date', 'RCS_CARTS_MATCH_ALL_DATES', 'true', 'If true then any order found with a matching item will be considered a matched order.

If false only orders placed after the abandoned cart are considered.', @configuration_group_id, 84, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Can anyone help with what I need to do in order to fix this problem.

Hi, is possible close abandoned cart from admin????

Thanks.

Let look at the Creat Table part where you got error at line 1. Since you already had scartid int(11) NOT NULL auto_increment, & set scartid as unique key. Then you also set scartid as Primary key. Both do the same job.

So you have:

CREATE TABLE
scart ( scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
dateadded varchar(8) NOT NULL default '',
datemodified varchar(8) NOT NULL default '',
PRIMARY KEY (scartid), < = REMOVE THIS
UNIQUE KEY customers_id (customers_id),
UNIQUE KEY scartid (scartid) )
TYPE=MyISAM;

Then you will have:
this this. just replace this part in your sql file. Hope it works.

CREATE TABLE
scart ( scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
dateadded varchar(8) NOT NULL default '',
datemodified varchar(8) NOT NULL default '',
UNIQUE KEY customers_id (customers_id),
UNIQUE KEY scartid (scartid) )
TYPE=MyISAM;

Bruce1952:

Hi all,

I just installed the file onto a linux server (godaddy) and when I went to install the sql patch via admin panel I got the folling message:

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 'CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id i' at line 1
in:
[DROP TABLE IF EXISTS scart; CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', dateadded varchar(8) NOT NULL default '', datemodified varchar(8) NOT NULL default '', PRIMARY KEY (scartid), UNIQUE KEY customers_id (customers_id), UNIQUE KEY scartid (scartid) ) TYPE=MyISAM; SET @configuration_group_id=0; SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 1; DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id; DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id; INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', '1', '1'); SET @configuration_group_id=last_insert_id(); UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id; SET @configuration_group_id=0; SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 1; INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Look back days', 'RCS_BASE_DAYS', '30', 'Number of days to look back from today for abandoned cards.', @configuration_group_id, 10, NULL, NOW(), NULL, NULL), (NULL, 'Sales Results Report days', 'RCS_REPORT_DAYS', '90', 'Number of days the sales results report takes into account. The more days the longer the SQL queries!.', @configuration_group_id, 15, NULL, NOW(), NULL, NULL), (NULL, 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', 'Number of days to give for emails before they no longer show as being sent', @configuration_group_id, 20, NULL, NOW(), NULL, NULL), (NULL, 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', 'If true then the customer's name will be used in the greeting. If false then a generic greeting will be used.', @configuration_group_id, 30, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', 'Controls display of item attributes.

Some sites have attributes for their items.

Set this to true if yours does and you want to show them, otherwise set to false.', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Ignore Customers with Sessions', 'RCS_CHECK_SESSIONS', 'false', 'If you want the tool to ignore customers with an active session (ie, probably still shopping) set this to true.

Setting this to false will operate in the default manner of ignoring session data & using less resources', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', 'Color for the word/phrase used to notate a current customer

A current customer is someone who has purchased items from your store in the past.', @configuration_group_id, 50, NULL, NOW(), NULL, NULL), (NULL, 'Uncontacted hilight color', 'RCS_UNCONTACTED_COLOR', '80FFFF', 'Row highlight color for uncontacted customers.

An uncontacted customer is one that you have not used this tool to send an email to before.', @configuration_group_id, 60, NULL, NOW(), NULL, NULL), (NULL, 'Contacted hilight color', 'RCS_CONTACTED_COLOR', 'FF9FA2', 'Row highlight color for contacted customers.

An contacted customer is one that you have used this tool to send an email to before.', @configuration_group_id, 70, NULL, NOW(), NULL, NULL), (NULL, 'Matching Order Hilight', 'RCS_MATCHED_ORDER_COLOR', '9FFF22', 'Row highlight color for entrees that may have a matching order.

An entry will be marked with this color if an order contains one or more of an item in the abandoned cart and matches either the cart's customer email address or database ID.', @configuration_group_id, 72, NULL, NOW(), NULL, NULL), (NULL, 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', 'To ignore carts with an a matching order set this to true.

Setting this to false will cause entries with a matching order to show, along with the matching order's status.

See documentation for details.', @configuration_group_id, 80, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Lowest Pending sales status', 'RCS_PENDING_SALE_STATUS', '1', 'The highest value that an order can have and still be considered pending. Any value higher than this will be considered by RCS as sale which completed.

See documentation for details.', @configuration_group_id, 85, NULL, NOW(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses('), (NULL, 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', 'Style for even rows in results report. Typical options are dataTableRow and attributes-even.', @configuration_group_id, 90, NULL, NOW(), NULL, NULL), (NULL, 'Report Odd Row Style', 'RCS_REPORT_ODD_STYLE', '', 'Style for odd rows in results report. Typical options are NULL (ie, no entry) and attributes-odd.', @configuration_group_id, 92, NULL, NOW(), NULL, NULL), (NULL, 'E-Mail Copies to', 'RCS_EMAIL_COPIES_TO', '', 'If you want copies of emails that are sent to customers by this contribution, enter the email address here. If empty no copies are sent', @configuration_group_id, 35, NULL, NOW(), NULL, NULL), (NULL, 'Autocheck 'safe' carts to email', 'RCS_AUTO_CHECK', 'true', 'To check entries which are most likely safe to email (ie, not existing customers, not previously emailed, etc.) set this to true.

Setting this to false will leave all entries unchecked (you will have to check each entry you want to send an email for).', @configuration_group_id, 82, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Match orders from any date', 'RCS_CARTS_MATCH_ALL_DATES', 'true', 'If true then any order found with a matching item will be considered a matched order.

If false only orders placed after the abandoned cart are considered.', @configuration_group_id, 84, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Can anyone help with what I need to do in order to fix this problem.

L88K thanks for your advise on the problem that I had but I ended up working it out and all is working ok now and it is a great little add on.

Hello,
I'm using ZenCart version v.1.3.7.1
I have had RCS version v.3.00 installed and working perfectly for quite some time.
I recently have this error when I navigate to the "Tools/Recover Cart Sales" page:

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 's Studio Joel Dumont") AND date_purchased >= "20090420"' at line 5
in:
[SELECT orders_id, orders_status FROM joker_orders WHERE (customers_id = 3866 OR customers_email_address like "[email protected]" OR customers_name like "Removed"s Studio Joel Removed") AND date_purchased >= "20090420"]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I now cannot use the RCS module as the "send" button is not available on the page? Any idea on how to get this corrected? Thank You.

Very weird...
I deleted the customer from my ZenCart, and now the RCS module is working again. I'm not sure what caused the error in RCS regarding the customer, but it is working now.

Hi, please hint me with this:

how i include actual price in line with product name?

i not mean products_price, i mean price showed in cart...

here is constructor:

		$mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
		$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . "</a></blockquote>\n\n";
		$basket->MoveNext();

but i not know, how add (where from get)

1. price (actual, not street price products_price) per line

2. date of cart

thanx for link to any docs

Holz:

where from get
Replace

cb.customers_basket_quantity,

by

cb.customers_basket_quantity, cb.final_price,

Holz:

1. price (actual, not street price products_price) per line
   $basket->fields['final_price']
   Holz:

2. date of cart
   $basket->fields['customers_basket_date_added']
   Holz:

thanx for link to any docs
DB table customers_basket

I just downloaded the new v.3.00b of this mod.

I have v3.0 installed now.

I noticed that i have a fix in my v.3.0 version on line 382. this fixed was implemented from instructions from http://www.zen-cart.com/forum/showthread.php?p=443329#post443329.

I don't see this similar fix in the new version. I'm just curious if this fix is implemented.

Thanks

a_berezin:

Replace

cb.customers_basket_quantity,

> by
> ```
cb.customers_basket_quantity, cb.final_price,

$basket->fields['final_price']

$basket->fields['customers_basket_date_added']

DB table customers_basket

Hello,

thanx, but i have all rows final_price filled with 0.0000, you not?

And if you not, i ask for actual price today (when generate mails), not for price actal in long time before... :(

Holz:

i ask for actual price today (when generate mails), not for price actal in long time before... :(
You got what you asked:
Holz:

1. price (actual, not street price products_price) per line
   If you need the final price - take it from the tables of goods. If you need an actual price with all discounts and actions - use function zen_get_products_actual_price.

Hi,

Thanks for the nice add-on but I have a problem on "Reports > Recovered Sales Results". I used a test account to resubmit the abandoned carts and I noticed that it disappeared from "Tools > Recover Cart Sales" but it did not display as a 'recovered' cart within "Reports > Recovered Sales Results"!:(

Why and how to deal with?

Thanks in advanced,

Hi! Please:

1054 Unknown column 's.datemodified' in 'field list'
in:
[SELECT s.scartid, s.customers_id, s.dateadded, s.datemodified, c.customers_firstname, c.customers_lastname, c.customers_email_address FROM scart s LEFT JOIN customers c ON (s.customers_id = c.customers_id) WHERE dateadded >= '19700101' ORDER BY dateadded DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What's it?:(

Version 1.3.8

How can I tell what products my customers have in their cart. The program is working fine but I cant see any attributes for each product.

Hi,

I'm considering installing this mod but was wondering - are emails only sent manually through the admin or can emails be scheduled to go out for all abandoned carts from the previous day (or some other time interval)?

thanks
Don

It's a manual process. When you click the button, the emails go out. I do it every morning for any carts from the previous day.