Recover Cart [Support Thread]

econcepts:

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.

The links in the emails that go out are https://
I found an earlier post about changing the .xyz. com/index....
took a while but I got that figured out.
How would I go about adding a coupon code similar to the out going email shown in post 374?

I'm having a similar issue to Peter. If I try to upload the SQL via Zen Cart, I get the following report:
I had trouble coping the SQL file when I opened in zen-cart I could not see or copy the entire file. I open using winmerge copied and installed and then got Admin-->Configuration-->Recover Cart Sales options.

sham:

I had trouble coping the SQL file when I opened in zen-cart I could not see or copy the entire file. I open using winmerge copied and installed and then got Admin-->Configuration-->Recover Cart Sales options.

I'm not clear on how you may have used WinMerge to get the configuration sub-menu to work correct, sham, so could you explain?

envisionocity:

I'm not clear on how you may have used WinMerge to get the configuration sub-menu to work correct, sham, so could you explain?

I'm not sure if I can explain this right, I uploaded all the files to their destination I uploaded the sql file to a temp folder then opened and copied so that I could install tool>install sql patches but after installing I did not get anything in configuration>recoverycartsales
after trying several times, I downloaded recovery cart again and compared the new file to the one I installed using winmerge I noticed that the sql file was a lot larger then the one I had copied and installed, so I copied it from winmerge installed in tools> sql patches and I then had configuration>recoverycartsales options.
I hope this make some sort of sense. If not let me know and I will try again.

envisionocity:

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.


A few things:

1) You NEVER want to use the 'upload file' option to install an SQL patch in Zen Cart (this can be buggy.) The preferred way is to copy and paste the SQL patch into the proper area and then update.

2) You should also avoid using a tool like phpMyAdmin to run patches. If you have a prefix for your zen cart tables (like 'zen_') then using a tool like phpMyAdmin to run the patch will not include that prefix (unless you manually alter the patch file to include it in all locations) and as a result, although the patch may look to run, you won't see it working on the Zen Cart side (because your zen site will be referring to tables that lead with your designated prefix.)

3) Based on #2 above, this would explain why it appears your patch runs under phpMyAdmin (with no 'error'). The patch installed to a new table that is not lead by your prefix (thus not copying over what was already there.)

4) The error message you received saying a field / column was already present can be ignored. This simply means you already installed the patch and those fields are present. They can't be added if already in the DB and thus the SQL patch will not add them (and you are returned with a default SQL message saying so.)

sham:

How would I go about adding a coupon code similar to the out going email shown in post 374?

To add that coupon code you would need to alter the actual email message. Create the coupon, make a note of what the value is, and then open the following file (admin/includes/languages/english/recover_cart_sales.php) and include whatever copy you want to promote it.

envisionocity:

I'm not clear on how you may have used WinMerge to get the configuration sub-menu to work correct, sham, so could you explain?

If you don't see the sub-menu but you think you have installed everything (including the patch) make sure that you allow yourself access to this new add-on if running "Admin Profiles" (which would hide the new options even if installed in the event you did not allow access to the admin user logged in.)

jessicab:

Rather than setting an automatic email to be sent to users that abandon a cart, we would like to call each user to follow up. Is there a way we can set it to email the admin everytime a cart is abandoned and it include the users contact information?

With the module installed, you can go to Tools>Recover Cart Sales

The on screen report lists the customers name, phone number and cart contents. Just pick up the phone and call.

There is not a way to export or email that page, no.

You might consider the Admin Profile Module. It would allow you to limit what pages in the admin can be accessed based upon the admin user id.

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

sham:

The links in the emails that go out are https://
I found an earlier post about changing the .xyz. com/index....
took a while but I got that figured out.

Hi, Do you have the post number? Or page of where this info is?

I would like to change my links as well.

Thank you in advance!

bonnit:

the attributes (in my case personalisations) do not show up in the email sent to customer or in the recover_cart_sales.php page which displays abandoned carts from the admin

am i misunderstanding what this is supposed to do or do i have a problem somewhere?

all other functions are fine, emails are sent etc. its just the attributes list that doesnt show up anywhere

This problem appeared a few times in this thread. I have the same problem working with the latest version of RCS in combination with 1.3.8a.

Did I miss the solution? Is there anybody who knows how to solve this problem?

Thanks

i never got an answer im afraid :S

maybe someone can help?

:clap:

I manage to figure out what the problem was.

admin/recover_cart_sales.php

line 471:
WHERE cba.products_id ='" . (int)$basket->fields['products_id'] . "'

They declared '$basket->fields['products_id']' as an integer but its
alphanumeric.

By removing the (int) part the attributes will show.

Solution:
line 471:
WHERE cba.products_id ='" . $basket->fields['products_id'] . "'

Datax:

:clap:

I manage to figure out what the problem was.

admin/recover_cart_sales.php

line 471:
WHERE cba.products_id ='" . (int)$basket->fields['products_id'] . "'

They declared '$basket->fields['products_id']' as an integer but its
alphanumeric.

By removing the (int) part the attributes will show.

Solution:
line 471:
WHERE cba.products_id ='" . $basket->fields['products_id'] . "'

ive made this change, how do i confirm its worked, is this to show in the email or in my recover cart sales admin page?

bonnit:

ive made this change, how do i confirm its worked, is this to show in the email or in my recover cart sales admin page?

This is a great point you came up with.

Attributes can be alphanumeric as they attached a 'session' type of identifier to each when adding to the cart. So it changes the typical '1' for example to '1.scnmvbiwsapagtdrtm' (or something like that.)

In these cases anything forcing them to numeric will fail.

To confirm if this is working or not you can start a cart (as if you are shopping on your site), login, then abandon it.

Wait 20 mins or more (till the session dies) and then look for your entry in the "recover carts' console. Send yourself the email and see if it includes the data you expect.

Let us know how it works.

econcepts:

This is a great point you came up with.

Attributes can be alphanumeric as they attached a 'session' type of identifier to each when adding to the cart. So it changes the typical '1' for example to '1.scnmvbiwsapagtdrtm' (or something like that.)

In these cases anything forcing them to numeric will fail.

To confirm if this is working or not you can start a cart (as if you are shopping on your site), login, then abandon it.

Wait 20 mins or more (till the session dies) and then look for your entry in the "recover carts' console. Send yourself the email and see if it includes the data you expect.

Let us know how it works.

Thanks for your reply econcepts, i did as stated above and can confirm that no attributes have been passed over to either the recover cart console (not sure if they should !?) and not in the recover cart email sent to cutsomer, in this case myself.

i have reversed the change as it seems pointless if it doesn't make any difference.

does anyone else have any suggestions? or perhaps Datax you could confirm the change this makes and how you tested it to be a success? perhaps i've misinterpreted your post

Thanks

It does make a difference. The data shows up in tools/recover cart sales.

I think thats the place where you need it. You want the client to remember his cart. He does not need the exact description of the items in the cart.

For you its important to see if products are in stock.

Thats how it works for me.

I don't know much about php. The solution I found was based on try and error. I don't think its very difficult to let the attributes show elsewhere, maybe someone else can help you.

Hello, can anyone confirm if this works on v 1.5? Thanks

I just installed this in 1.5 but it doesn't get added to the administration menus automatically.

I know there is some voodoo you can do with the "register admin pages" tool, but I'm not really sure what to do there so I'm leaving it alone.

I can type in a manual url for the config like
http://www.mydomain.com/myadmin/configuration.php?gID=36 where 36 is a number you just trial and error find.

The actual tool is at
http://www.mydomain.com/myadmin/recover_cart_sales.php

Everything seems to work great...

Could some master-zenner tell us how to register the pages so they show up in the menus? This is the second mod I've got that doesn't show up in 1.5 (but works great).

-Tyler

Hello Tyler,

I wouldn't rush installing the mods that are not confirmed to work on v1.5.

If you have been reading the threads on "Confirmed working mods in Zen Cart 1.5", you would know that there are security measures that need to be considered for it to be compatible with v1.5.

I'm eager to upgrade the cart too however, all those mods I currently have, are not compatible yet, so I just have to wait patiently until the original writer of the mod or some zen guru would jump in and fix it for v1.5.

Sunflowertami:

Thanks for the word of caution. The other plugin I'm using is Simple Google Analytics, the thread for which seems to be populated by some pretty smart scripters making it work for 1.5, so I'm not too worried.

As for Recover Cart, it's to essential to my store not to run it, so I'll stick with it for now.

Fingers crossed for an update here. I suppose, we could set a bounty for it to be done? Would you be interested in chipping in? I'm not too wealthy but could offer a few bucks for the pot.

-T