Recover Cart [Support Thread]

Peter,

Don't make any alterations at all to the script (SQL or not). If you use the SQL patch within the Zen admin it will automatically add the proper prefix to the needed areas upon install.

Try running the script from within the Zen Cart admin (and not phpMyAdmin). Copy and paste into there (do not upload and run.)

Also, what type of errors are you getting? That would help determine what may be the issue.

Hi - Is it possible to move the Additional PS Message up higher in the email? I'm having trouble finding the code that is controling it's placement.

Thanks,
Cindy

Look in this file /admin/recover_cart_sales.php

Around line 281 - 285 you find references to

"$html_msg['EMAIL_MESSAGE_HTML'] = nl2br($email) . zen_db_prepare_input($_POST['message_html']);" (for the HTML version)

zen_db_prepare_input($_POST['message']) (for the 'text version)

You can take those lines and do what you want with them.

I want to add a function, that is, when the customer does not pay more than 1 day, automatically send e-mail to remind customers. Anyone know how to modify it.Thanks

Can anyone tell me which part of the code to remove that shows the shopping cart contents in the email sent to the customer?

Reason I ask is that for some reason the email is linking to the products with the session id attached. Therefore clicking on the link returns a "page not found" message.

So rather than mess about with the sessions, I figure it would just be easier to remove the shopping cart contents from the email sent.

econcepts:

Look in this file /admin/recover_cart_sales.php

Around line 281 - 285 you find references to

"$html_msg['EMAIL_MESSAGE_HTML'] = nl2br($email) . zen_db_prepare_input($_POST['message_html']);" (for the HTML version)

zen_db_prepare_input($_POST['message']) (for the 'text version)

You can take those lines and do what you want with them.

Thank you! Another question... when I move that block around and send messages in Text Only format they come through fine, but when I send them in HTML format wherever I place that block of code nothing will populate in the email after it. The footer and copyright shows but nothing in the message area.

Do I need to add something else if I want it to show up higher in the email versus the bottom?

hopestar86:

I want to add a function, that is, when the customer does not pay more than 1 day, automatically send e-mail to remind customers. Anyone know how to modify it.Thanks

A few questions.

1. Why wouldn't a customer pay? If they completed the checkout, they would have paid ... otherwise they would not be showing in the abandoned carts area.

2. This module is for following up on abandoned carts (those customers who started the checkout process but did not complete it.) If you want to look into some other options for following up with customers you may want to checkout Cord's Mailbeez module.

Really good stuff there.

Interceptor:

Can anyone tell me which part of the code to remove that shows the shopping cart contents in the email sent to the customer?

Reason I ask is that for some reason the email is linking to the products with the session id attached. Therefore clicking on the link returns a "page not found" message.

So rather than mess about with the sessions, I figure it would just be easier to remove the shopping cart contents from the email sent.

Removing the shopping cart contents isn't the best idea. If you do that it's highly likely your conversion rates will suffer. The shopping cart is there to remind the user what they had in their cart when they left.

Having said that, if you must remove that section then you'll find the info in the /admin/recover_cart_sales.php file.

If the session ids are showing up in your emails, then there is likely an issue with the site in other areas. This (including the session variable in the recover carts email) is not a 'standard feature' and not what should be going on.

YouLookGreat:

Thank you! Another question... when I move that block around and send messages in Text Only format they come through fine, but when I send them in HTML format wherever I place that block of code nothing will populate in the email after it. The footer and copyright shows but nothing in the message area.

Do I need to add something else if I want it to show up higher in the email versus the bottom?

I'll have to look into that. I do recall a bug that affected various issues of the email send based on the use of the HTML field or not.

Sounds like this may related to that.

econcepts:

Removing the shopping cart contents isn't the best idea. If you do that it's highly likely your conversion rates will suffer. The shopping cart is there to remind the user what they had in their cart when they left.

Having said that, if you must remove that section then you'll find the info in the /admin/recover_cart_sales.php file.

If the session ids are showing up in your emails, then there is likely an issue with the site in other areas. This (including the session variable in the recover carts email) is not a 'standard feature' and not what should be going on.

Thanks for the reply econcepts

I was already aware of which file it is, but cannot pin point which part of the code to remove.

The website has no other issues with ids being sent in other emails or causing other problems, so i see no reaon to chase a problem which does not exist elsewhere on the site, and feel removing the cart contents would be a far easier option.

I should mention the emails in question are sent in html format, and i have ultimate seo urls installed if that makes a difference.

Also in the footer of the email the website address is like this https://www.mywebsite.com.com

Again I cannot find where the extra .com is being added, and is not present in the other store emails being sent.

Does the current download version of recover cart work okay with zen 139h ?

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=100

Thanks

DogTags:

Does the current download version of recover cart work okay with zen 139h ?

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=100

Thanks

This should work with any version right now. It isn't really dependent on that.

I am looking to see some actual Recover Cart implementations. Can anyone point me to a site that uses it? Before we launch head long into an integration, I would like to review with a client the end user experiece.

thanks,
\Amanda

amandagov:

I am looking to see some actual Recover Cart implementations. Can anyone point me to a site that uses it? Before we launch head long into an integration, I would like to review with a client the end user experiece.

thanks,
\Amanda

We use it on our site and if you want to see how it works, you can create an account on our site, add something to your shopping cart and then abandon. You will get the same email our customers receive and that will give you a perspective from the customer's view. To see how things work from the business perspective, you will need to have Admin access (which of course will require you install in the mod).

Our current installation is out of the box but you can definitely configure the email that goes out to the customer (i.e. add coupon to motivate them or promote other aspects of your site).

I just installed 3.1.0 on 1.3.9h the only item in the configuration>recover cart sales is ignore repeat customers.
Is that all that is supposes to be there?

i use it on my gift site, no problems whatsoever

I figured out my problem, I didn't get all of the sql file.

I have a couple questions:
my links show up in https
my site address shows as www . xyz.com/index..... can I make it just www . xyz .com?
Thank you

sham:

I figured out my problem, I didn't get all of the sql file.

I have a couple questions:
my links show up in https
my site address shows as www . xyz.com/index..... can I make it just www . xyz .com?
Thank you

What links are you referring to? Are these in the emails that go out, the admin, on the site, or what? Let me know and I'll see if I can tell you if what you are looking to do is possible.

econcepts:

Peter,

Don't make any alterations at all to the script (SQL or not). If you use the SQL patch within the Zen admin it will automatically add the proper prefix to the needed areas upon install.

Try running the script from within the Zen Cart admin (and not phpMyAdmin). Copy and paste into there (do not upload and run.)

Also, what type of errors are you getting? That would help determine what may be the issue.

I'm having a similar issue to Peter. If I try to upload the SQL via Zen Cart, I get the following report:

1062 Duplicate entry 'RCS_BASE_DAYS' for key 'unq_config_key_zen'
in:
[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.

However, if I upload the SQL directly through MyPHPAdmin, everything seems to get installed correctly, but I, too, get absolutely nothing in Admin-->Configuration-->Recover Cart Sales (the options are blank)

I am using the latest version of Zen Cart (v1.3.9h) and the latest version of the RCS module (v3.1.0).

Any and all help/suggestions will be appreciated.