Recover Cart [Support Thread]

[a_berezin]

I am using ZC version 1.3.9h
...
I actually dont mind the generic message, however, I'd like to make some minor changes to it and I also dont want the Zen Cart logo at the top of the email.

1. Edit email template. As far as I remember there used template default.
2. Edit admin\includes\languages\english\recover_cart_sales.php.

[a_berezin]

Hello sunflowertami,

When you have perfected your RCS on v 1.5 then, put it up as a commercial module and just charge for it.

I can imagine how much in this case the perturbation!

I don't charge a lot for it but I learned that when people get things for free do not appreciate the worth of it and have a tendency to bite the hand that feeds them.

Oh, yes! This is a great example!

[frank18]

Andrew,

two things:

1. good to see you are still active with RCS
2. once your version of RCS is v1.5 ready and working you will get my donation, that's a promise

Keep up the good work!

Frank

[a_berezin]

Hello Frank,

1. good to see you are still active with RCS

And I'm nowhere and never left. Just got a lot of wishing to participate in this module and I decided not to disturb them.

Keep up the good work!

Thank you!

[wirefram]

Hi

Great mod, i was wondering how far back can i set it up to recover carts?

I have a bunch of abandoned carts sitting in my db for years and i'd like to make a bit of cleaning but i am afraid setting up to something like

loop back days: 2600

could crash my db.....

is there a way to set it up per year/month? like abandoned carts from 2009-01 to 2009-12 ?

Thanks

L.

[Stuff4Toys]

Any progress on making this 1.5 compatible???

[canemasters]

I'll offer up $50 to whoever can get this working with 1.5.0, without compromising on 1.5.0's security. It's super important to us here at canemasters.com! Stupid me should have checked to see if this mod was compatible. I never would have upgraded if I knew it wasn't.

[Stuff4Toys]

Hi

Great mod, i was wondering how far back can i set it up to recover carts?

I have a bunch of abandoned carts sitting in my db for years and i'd like to make a bit of cleaning but i am afraid setting up to something like

loop back days: 2600

could crash my db.....

is there a way to set it up per year/month? like abandoned carts from 2009-01 to 2009-12 ?

Thanks

L.

Do it a few months at a time so start with 30 then 60 then 90 etc and see how it goes from there...

[giancalr]

Hello, i installed recover cart sale, but when I apply the patch from this sql 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, customers_i' at line 1
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 @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, 'Ignore Repeat Customers', 'RCS_CHECK_REPEAT', 'false', 'Setting this to true will cause recover cart sales to ignore abandoned carts by repeat customers', @configuration_group_id, 45, 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.

[jonnyboy22]

I'll offer up $50 to whoever can get this working with 1.5.0, without compromising on 1.5.0's security. It's super important to us here at canemasters.com! Stupid me should have checked to see if this mod was compatible. I never would have upgraded if I knew it wasn't.

i have a client who needs this aswell so ill chip £20 in