Recover Abandoned Cart Sales

[gardengate]

I downloaded the Recover Cart Sales for the admin and install it with the sql patch It look like it is working no eror that I see and I see abandant product however when I click on the product I get nothing where can I see the attribute options and value in the abandant cart. Did I install it wrong ?

[Pixxi]

If the version you have came from the main downloads area, try un-installing it and instead install Andrew's tweaked version:

http://www.zen-cart.com/forum/showthread.php?t=37128

[gardengate]

How do I un-install it the Download version? Is it simply loading these files over the old files

[Pixxi]

IIRC, it is just a matter of installing the files over the existing files (and running the SQL). Although you may want to do a 'Find' on your local dev site before installing just to check the locations of the existing files.

[gardengate]

Okay I downloadwd your latest version and all I get is errors
First when I uploaded the sql patch I got a large error I will copy in the bottom and now: at Tool recover cart:
1054 Unknown column 'sc.datemodified' in 'field list'
in:
[select cb.customers_id, cb.products_id, cb.customers_basket_quantity, cb.customers_basket_date_added, cus.customers_firstname, cus.customers_lastname, cus.customers_telephone, cus.customers_email_address, sc.datemodified from zen_customers_basket cb left join zen_customers cus on (cb.customers_id = cus.customers_id) left join zen_scart sc on (cb.customers_id = sc.customers_id) where cb.customers_basket_date_added >= '20061016' and cb.customers_id not in ('') order by cb.customers_id asc, cb.customers_basket_date_added 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.

and at Reports recover carts:
1054 Unknown column 'RCS_PENDING_SALE_STATUS' in 'where clause'
in:
[select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from zen_orders o left join zen_orders_total ot on (o.orders_id = ot.orders_id), zen_orders_status s where (o.customers_id = 1 OR o.customers_email_address = '' OR o.customers_name like 'Amer Khiyami') and o.orders_status > RCS_PENDING_SALE_STATUS and s.orders_status_id = o.orders_status and o.date_purchased >= '20061010' and ot.class = 'ot_total']
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

At SQL I got the current error:
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
in:
[DROP TABLE IF EXISTS zen_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 @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales'; DELETE FROM configuration WHERE configuration_group_id = @t4; DELETE FROM configuration_group WHERE configuration_group_id = @t4; INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) values ('', 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', '1', '1'); UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id(); SET @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales'; 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 ('', 'Look back days', 'RCS_BASE_DAYS', '30', "Number of days to look back from today for abandoned cards.", @t4, 10, NULL, NOW(), 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!.", @t4, 15, NULL, NOW(), 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", @t4, 20, NULL, NOW(), 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.", @t4, 30, NULL, NOW(), NULL, "zen_cfg_select_option(array('true', 'false'),"), ('', '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.", @t4, 40, NULL, NOW(), NULL, "zen_cfg_select_option(array('true', 'false'),"), ('', '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", @t4, 40, NULL, NOW(), NULL, "zen_cfg_select_option(array('true', 'false'),"), ('', '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.", @t4, 50, NULL, NOW(), 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.", @t4, 60, NULL, NOW(), 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.", @t4, 70, NULL, NOW(), 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.", @t4, 72, NULL, NOW(), 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.", @t4, 80, NULL, NOW(), NULL, "zen_cfg_select_option(array('true', 'false'),"), ('', "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.", @t4, 85, NULL, NOW(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses('), ('', 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', "Style for even rows in results report. Typical options are dataTableRow and attributes-even.", @t4, 90, NULL, NOW(), 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.", @t4, 92, NULL, NOW(), 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", @t4, 35, NULL, NOW(), 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).", @t4, 82, NULL, NOW(), NULL, "zen_cfg_select_option(array('true', 'false'),"), ('', "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.", @t4, 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.

[gardengate]

I re-installed back the download version.
it shows the cart and attribute (Checkboxes) the text attribute say TEXT only and no delivery address. Also it shows the following warning:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/findaflorist.org/httpdocs/sendflowers/admin/recover_cart_sales.php on line 450
Can anyone help me get the text (Value - What customers said in it) and how I can get the delivery address? Thanks

[Pixxi]

You need to run the SQL successfully first or you will get errors when you try to run the mod in admin.

Are you using prefixes on your database tables (eg 'zen_')?

Did you modify the SQL before you ran it?

The error you're getting:

DROP TABLE IF EXISTS zen_scart; CREATE TABLE scart ...

is modified from the original SQL.

What version of MySQL are you running?

[gardengate]

You need to run the SQL successfully first or you will get errors when you try to run the mod in admin. When I re-installed the Download version My SQL ran successfully (The modified tweeked versions errored big time)

Are you using prefixes on your database tables (eg 'zen_')? No

Did you modify the SQL before you ran it? Only with the supplied patch

The error you're getting:
Quote: DROP TABLE IF EXISTS zen_scart; CREATE TABLE scart ...
is modified from the original SQL. ???

What version of MySQL are you running? phpMyAdmin 2.6.3 - MySQL 3.23.32 I hope that helps. I am only getting the error of Line 450 + Attribute with TEXT say TEXT rather than contenet of text.

[gardengate]

What it is on line 450 is the bolded line of this string

$hasAttributes = false;

if (mysql_num_rows($attribquery)){
$hasAttributes = true;
$prodAttribs = '<br>';

And still no value in text attribute just TEXT
and no Shipping Delivery addres in the recovered item.

[Pixxi]

Andrew's version installs and works fine. If you're getting errors it's likely to be something else.

The SQL in Andrew's mod start with:

DROP TABLE IF EXISTS scart;
CREATE TABLE scart

Your error showed the SQL you'd run started with:

DROP TABLE IF EXISTS zen_scart; CREATE TABLE scart

Which is why I asked you if you'd modified the SQL before you ran it - ie. whether you'd added the 'zen_' prefix. If you want to try installing that version you'd be best posting in the support thread for that mod:

http://www.zen-cart.com/forum/showthread.php?t=37128

The version from the downloads section needs register_globals to be on, so you might try that. I don't use that mod so can't really help you more.