Recover Cart [Support Thread]

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

http://www.zen-cart.com/index.php?ma...roducts_id=100

Thanks

Quote:

---

Originally Posted by DogTags

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

http://www.zen-cart.com/index.php?ma...roducts_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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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:

Code:

---

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.

Quote:

---

Originally Posted by 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?

Quote:

---

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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by envisionocity

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

Code:

---

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.)

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.)

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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by jeking

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.

---

Thank you for the quick response! We don't want to provide full admin access to the person we have calling. I assume then there is no option to email the abandoned cart user information. Is there a way to export the report of customer name, phone number, and cart contents?

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?ma...products_id=86

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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'] . "'

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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/conf...ion.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

Simple Google Analytics already has a v1.5. Check the free addons.

I'll be glad to chip in too. I wish the Zen community could come up with a way to have these various mods be sold here.

I suggested before that this would encourage the developers to upgrade their mods faster and also a part of the payment can become donation for the zencart developers.

The other cart website like Pretashop has both free and commercial mods on their site, it just makes it easier for the users to find the mods to use and ensure that upgrades are kept up.

OK, well, I'll offer $20 by PayPal to a developer that posts a fully-functional version of Recover Cart Sales that works for ZC 1.5 to the Addon repository here at www.zen-cart.com

For me to pay out, the module must be complete and posted by midnight on February 7, 2012. It must contain the correct SQL patches so that both the configuration menu, and the tool itself, pop up in the admin menus.

It must also have an upgrade path from the previous version, or at least include an uninstaller (or uninstall instructions in the readme) for the previous version of Recover Cart Sales.

We'll see if other users feel like pitching in - it looks like Tami might be willing.

How do you know I'll pay? Ummm... I don't want to piss off a ZC developer, that's how!

-T

Quote:

---

Originally Posted by sunflowertami

Simple Google Analytics already has a v1.5. Check the free addons.

---

Yeah, but it didn't appear in the admin menus without some fun SQL stuff. Similar problem to the Recover Cart Sales problem, except, I guess, that RCS has not been inspected for security stuff.

Thought since it doesn't have any front-end boxes, I don't think it has too many holes.

-T

This module has been downloaded 12694 times since it was posted. If each person who downloads it pays $1.00, think how much incentive that will be for the developer!

Good point! Are you willing to pitch in some money, DecoStyle?

-T

I'll be happy to pay the developer when he/she uploads the finished v1.5 version.

I can download my version of RCS. Compatible with php 5.3 and zen-cart 1.5.0. Not compatible with previous versions of RCS.
I can do it after February 7, 2012 - now there is no time for it.

[offtopic]

Quote:

---

Originally Posted by Decostyle

This module has been downloaded 12694 times since it was posted. If each person who downloads it pays $1.00, think how much incentive that will be for the developer!

---

For all the time I did not get a penny donation. More than that. The number of people have said thanks to much less than those who are outraged and poured mud at me because I refused to do for them their jobs. And I'm not alone. In recent years, several developers have left the forum.
I enjoy Zen-Cart, and I want and I will do with its development as much as time and opportunity.

Quote:

---

Originally Posted by sunflowertami

I wish the Zen community could come up with a way to have these various mods be sold here.

I suggested before that this would encourage the developers to upgrade their mods faster and also a part of the payment can become donation for the zencart developers.

The other cart website like Pretashop has both free and commercial mods on their site, it just makes it easier for the users to find the mods to use and ensure that upgrades are kept up.

---

I agree with the above 100%. This would seriously stimulate the development of commercial add-ons.
[/offtopic]

Hello Andrew,

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

I hope the Zen developers will find a way to allow the developers to post commercial modules on here. Just as now the description of the module states "version" why not add a type "free, shareware, commercial"?

(off topic)

I understand your predicament. For years I have offered free charts to customers who for most part were thankful but some were just nasty about getting more and demanding why I don't put more free charts on it!

So I finally stopped it and just started charging for it. 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.

I am using ZC version 1.3.9h and just installed the recovery cart mod today. I sent an email to my test account and the email that I received:

1) had a Zen Cart logo at the top
2) had a generic message
3) the message I typed showed at the bottom after the generic message.

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. I am wondering how and where I make these changes?

Thanks :smile:

Quote:

---

Originally Posted by jcrewe

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.

Hello sunflowertami,

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by sunflowertami

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!

Andrew,

two things:

1. good to see you are still active with RCS :clap:
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

Hello Frank,

Quote:

---

Originally Posted by frank18

1. good to see you are still active with RCS :clap:

---

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.

Quote:

---

Originally Posted by frank18

Keep up the good work!

---

Thank you! :smile:

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.:(

Any progress on making this 1.5 compatible???

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.

Quote:

---

Originally Posted by 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.:(

---

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

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.

Quote:

---

Originally Posted by 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.

---

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

I have it working with 1.5...I am still making minor changes but if anyone wishes to test it before I upload it as compatible please PM me for a copy.

Quote:

---

Originally Posted by Stuff4Toys

Any progress on making this 1.5 compatible???

---

Quote:

---

Originally Posted by 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.

---

Quote:

---

Originally Posted by jonnyboy22

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

---

Updated module to work with Zen Cart v1.5.

Should be up in download section soon. Please PM for donation details if necessary.

Here's the link: http://www.zen-cart.com/downloads.php?do=file&id=25

Here's the zip file until it's updated in the downloads section. Works with Zen Cart v1.5 as requested in thread.

Attachment 10355

PM for donation details per thread.

Sure would be nice to see some automation in this module, via cron to run every xx minutes. also a shorter wait time, instead of waiting for customer to time out, set it for 8 - 10 minutes of inactivity.

Thanks for all your hard work.
JOhn ><>

Having a problem with the install. Just installed 1.50 and when I attempted to run the sql install file it identified an error in the syntax at: TYPE=MyISAM. Per another post, I changed Type to Engine, and it errored out at: SQL query:

SELECT (

@configuration_group_id := configuration_group_id
)
FROM configuration_group
WHERE configuration_group_title = 'Recover Cart Sales'
LIMIT 1 ;

MySQL said:

#1146 - Table 'sql_file_name.configuration_group' doesn't exist

I'm in over my head, any insights?

Um, "sql_file_name" would clearly be incorrect. It should say your database name there instead.

Sounds like your database is using table-prefixes and the script you're trying to run needs you to manually add those prefixes before running it. Or if you don't understand the concept of tablename prefixes, then run the SQL script using the supplied SQL Patch tool in your ZC admin so that it can add them for you.

Quote:

---

Originally Posted by DrByte

Um, "sql_file_name" would clearly be incorrect. It should say your database name there instead.

---

Dr B,

;) When I originally posted, it showed my sql file name (the REAL ONE), and I figured, I probably shouldn't name my database on a forum, as a security precaution so I changed it for this post to "sql_file_name" - but you may have hit upon the problem.

So if my real database name were talijewe_tj09 and my prefix is spm, my individual tables are:

spm_categories
spm_categories_description
spm_configuration
spm_configuration_group
spm_counter

The error I am getting is then: Table 'talijewe_tj09.configuration_group' doesn't exist.

As I've mentioned I am no SQL genius (apologies for stating the obvious, LOL), but now that you mention it, I'm curious where the 'spm' is in the error message? Do I need to edit the install-ZC-v-1-5.sql file somehow in order to add the prefix?

So if the table did exist what would its full 'name' be? Am I making any sense at all? ;)

Any help is appreciated!

Quote:

---

Originally Posted by smcelligott

Dr B,

;) When I originally posted, it showed my sql file name (the REAL ONE), and I figured, I probably shouldn't name my database on a forum, as a security precaution so I changed it for this post to "sql_file_name" - but you may have hit upon the problem.

So if my real database name were talijewe_tj09 and my prefix is spm, my individual tables are:

spm_categories
spm_categories_description
spm_configuration
spm_configuration_group
spm_counter

The error I am getting is then: Table 'talijewe_tj09.configuration_group' doesn't exist.

As I've mentioned I am no SQL genius (apologies for stating the obvious, LOL), but now that you mention it, I'm curious where the 'spm' is in the error message? Do I need to edit the install-ZC-v-1-5.sql file somehow in order to add the prefix?

So if the table did exist what would its full 'name' be? Am I making any sense at all? ;)

Any help is appreciated!

---

I have the exact same problem! Anybody know if we should add the prefix (mine is zen_)

I am using ultimate seo and the email sent to customer does not reflect seo url

I want to modify this line but I do not know how to do it, anyone here familiar with this?

$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";

The link it generated will be site.com/index.php?main_page=product_info&products_id=281:ece5b925171ef7577e4923a0a71b685 e

where I got no idea where to remove ece5b925171ef7577e4923a0a71b685e

I am using this on zen cart v1.5.0

I just installed and configured this module without any problem or error message.

When I go to either tool->Recover cart sales or Report->Recover cart sales results I see the following warring with no listing even though I have personally created few abandoned cart!

WARNING: An Error occurred, please refresh the page and try again.

Thanks for your help.

Check your cache folder for the debug log and it will give you a clue as to what went wrong.

Quote:

---

Originally Posted by ak6000

I just installed and configured this module without any problem or error message.

When I go to either tool->Recover cart sales or Report->Recover cart sales results I see the following warring with no listing even though I have personally created few abandoned cart!

WARNING: An Error occurred, please refresh the page and try again.

Thanks for your help.

---

Thanks for your reply DecoStyle. Per your recommendation, I checked the cache folder and find out the 'scart' db table did not exist.

Since I was upgraded from v1.3.9 I used the Upgrade sql patch, but apparently I needed to use Install instead!

So I used the install-ZC-v-1-5.sql and everything is working.

This seems like a very simple problem, but I can't figure out why only one other responder has said that their site has the same problem.

Since my problems seem to be prefix related, I courageously changed the beginning of the install script to be:

(Please note: <PREFIX> is replaced with my actual prefix; and <DATABASE> is replaced by the name of my database)

DROP TABLE IF EXISTS <PREFIX>_scart;
CREATE TABLE <PREFIX>_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)
) ENGINE=MyISAM;

When I run this amended SQL statement, it errors out with:

MySQL said:
#1146 - Table '<DATABASE>.configuration_group' doesn't exist

Well duh silly Zen Cart, I know that table doesn't exist because the actual table is: <DATABASE>.<PREFIX>_configuration_group.

Since I am rather SequIlliterate (for those who humour is not as warped as mine, that means illiterate when it comes to all things SQL), I have no idea how I could, or more importantly whether I should, further edit this SQL statement.

Is there some other place in my admin settings where perhaps my prefix name should be stored but it isn't? Surely the fact that I have a prefix would not be unusual, but perhaps for some unknown reason some 'processes' may not be 'seeing' that a prefix exists???? This might explain some other dramas I am experiencing . . . your insights would be majorly appreciated!

Downloaded, Installed files on my website and ran the SQL in the ZC Admin. Not seeing anything in the Admin under Tools or Configuration.

Running ZC v1.3.9
Installed v 1.3.0 Recover Cart Sales - Version: 3.1.0 for Zen Cart® Versions v1.3.8.

Maybe I did something wrong?
Thanks

Got it working. I never changed user permissions under Tools > Admin Settings.

ma bad

Just wanted to add my two cents, after one whole morning wasted trying to solve my problem with no success...

Running ZenCart v1.3.9
Followed instructions as given, carefully.
I was always getting the following message:

Quote:

---

12 statements processed
Error: Impossible to add configuration_key "" as already existand (or similar meaning message, I'm Italian)
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

---

Well, the upgrade_exceptions table was empty, and I was only able to find the _scart table, correctly created, but I was not able to find ANY of the RCS_ entry in zencart_configuration table.

I tried to apply the SQL patch using the Admin side, but the message was always the same.
I tried doing this UPLOADING the patch, but this not even worked (it was indeed my first time...)
I tried doing this from myPHPAdmin and obviously there were many references missing...

So, after a DB clearing of the wrongly created tables (the ones created from myPHPAdmin for example...), I decided to run the "DO IT BY HAND" way...

Well, I know this could be very dangerous, but I know how SQL behaves and I know how to enter some data...

I took my risks.

I then entered the first zencart_configuration table value and I succeeded, so I went on with the second... and the third (I know, I had to enter also the value for zencart_configuration_group, but I looked for the right value before starting...).

After the third value, I was already tired (you know: computers should help, not complicate our lives...).

So I edited the original SQL patch to remove the already entered values, to reflect the values which were created by the script (see above) and decided to try to complete this phase within myPHPAdmin...

I succeeded and I was finally able to find all the configuration values within the Configuration menu, to edit them and to finally find my abandoned carts...

I guess that the instruction to create the configuration table is somewhat too long and this could be a problem.

My suggestion is to split it into two shorter instructions to avoid any problems to other, similar to the one I personally suffered.

Hope having given some useful hints to you all.

Best regards.

mickymix

this is in amazing module and thanks much for putting together! the problem i'm having is that the URL's in the dispatched emails are not friendly at all - is there a way to fix this? i'm using seo urls if it matters.

no one using this has configured it to use friendly urls?

Just wanted to say thanks to whomever wrote and maintains this module.

I currently have better than 10% recovery rate since implementing it, not only that, but even have a few repeat 'recovered' customers now.

Quote:

---

Originally Posted by bi11i

the problem i'm having is that the URL's in the dispatched emails are not friendly at all - is there a way to fix this? i'm using seo urls if it matters.

---

1. Why you need seo url in the emails? Search engines do not look at them. You're not surprised by the lack of seo url in the remaining emails of admin - newsletters, notifications, status changes notice, individual emails, etc.

2. The problem of using user Friendly URL in the admin - is a global problem and solved it must be by a seo url developer.

Quote:

---

Originally Posted by a_berezin

1. Why you need seo url in the emails? Search engines do not look at them. You're not surprised by the lack of seo url in the remaining emails of admin - newsletters, notifications, status changes notice, individual emails, etc.

2. The problem of using user Friendly URL in the admin - is a global problem and solved it must be by a seo url developer.

---

You're right and I should have used different terminology. I guess what I was after was displaying the URL's in the email as the link using the title of the product, rather than just displaying the URL itself.

displaying this: Mimosa hostilis (Jurema) Brazilian Purple Pink Inner Root Bark - Powdered

rather than this: https://www.phytoextractum.com/index.php?main_page=product_info&products_id=141:77ff19653324db0868353221feb6b9a d

Quote:

---

Originally Posted by bi11i

You're right and I should have used different terminology. I guess what I was after was displaying the URL's in the email as the link using the title of the product, rather than just displaying the URL itself.

displaying this: Mimosa hostilis (Jurema) Brazilian Purple Pink Inner Root Bark - Powdered

rather than this: https://www.phytoextractum.com/index.php?main_page=product_info&products_id=141:77ff19653324db0868353221feb6b9a d

---

OK, now I understand you.

well, so now that we are in an understanding, is there an easy way for me to make this happen, at least on my own end? thanks and i appreciate your help!

Quote:

---

Originally Posted by ak6000

Thanks for your reply DecoStyle. Per your recommendation, I checked the cache folder and find out the 'scart' db table did not exist.

Since I was upgraded from v1.3.9 I used the Upgrade sql patch, but apparently I needed to use Install instead!

So I used the install-ZC-v-1-5.sql and everything is working.

---

I am having the same issue, however, I did not upgrade from 1.3.9, and I am trying to run the Install-ZC-v-1-5.sql.
[I did copy over my database from 1.3.8, but did not have this mod installed - I did have Keepcart, in case that was related.]


I get the same error, but here is my log:

Quote:

---

PHP Fatal 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 'TYPE=MyISAM' at line 1 :: CREATE TABLE zen_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; in /home/spartan1/public_html/shop/includes/classes/db/mysql/query_factory.php on line 101

---

I notice that the SQL says "CREATE TABLE scart", where the log says "CREATE TABLE zen_scart".
I dont know if that is somehow a problem.

Any ideas as to the problem here?

Should I try to run the Upgrade sql?

"TYPE=MyISAM" should be "ENGINE=MyISAM" in modern versions of MySQL.

Quote:

---

Originally Posted by bi11i

well, so now that we are in an understanding, is there an easy way for me to make this happen, at least on my own end? thanks and i appreciate your help!

---

find

PHP Code:

---

$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"; 


---

replace by

PHP Code:

---

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


---

New case you have problems with the plain-text mail.

Quote:

---

Originally Posted by a_berezin

find

PHP Code:

---

$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"; 


---

replace by

PHP Code:

---

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


---

---

thanks, that's awesome and looks much better. would there be an easy way to

1. turn off plain-text mails?
2. change the email content to remove the duplicate content

1 x Mimosa hostilis (Jurema) Purple Pink Root Bark - Powdered
Mimosa hostilis (Jurema) Purple Pink Root Bark - Powdered

thanks for being so helpful.

did you ever get this working? running this as a cron every x days at x time would be pretty sweet.

Quote:

---

Originally Posted by tmdelia

Does anyone have a working CRON script for this? I had one, but it just quit working. And I can't for the life of me remember where it came from.

Here's my Cron:

cd "/home/fakedir/public_html/fakeadmin/" php -f ./rcs_cron.php -- rcs_cron=1

Using fakedir and fakeadmin to be safe, but I assure you, the paths are correct.

Here is the script I have in the admin folder:

Code:

---

<?php

/** RECOVER CART SALES -- AUTOMATED SCRIPT FOR CRON PROCESSING
 *
 * Proper use:
 * -----------
 *  php -f ./rcs_cron.php -- rcs-cron=1 [tdate=x]
 *
 * where [tdate=x] is an optional parameter, with x being the number of days (history) you wish to process for.
 *
 * NOTE: it's expected that you will run this script from inside the admin folder. 
 *      (ie: chdir to admin folder, then run this script)
 */

// process command-line vars into GET vars:
if ($argc > 0) {
  for ($i=1; $i<$argc; $i++) {
    $it = split("=", $argv[$i]);
    $_GET[$it[0]] = $it[1];
  }
}
// Check whether has been started with required parameters:
if (!isset($_GET['rcs_cron'])) {
  echo "\n Recover Cart Sales (RCS) \n Automated processing script\n ===========================\n Proper use:\n -----------\n  php -f ./rcs_cron.php -- rcs-cron=1 [tdate=x]\n\n where [tdate=x] is an optional parameter, with x being the number of days (history) you wish to process for.\n NOTE: it's expected that you will run this script from inside the admin folder.\n\n\n";
  exit();
}

// set some prerequisites:
define('RCS_CRON_USERID', 100);
$tdate = (isset($_GET['tdate'])) ? $_GET['tdate'] : '';

// load the Zen Cart core:
require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . FILENAME_MAIL . '.php');
require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/recover_cart_sales.php');
require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();

// begin RCS processing:
echo 'RCS processing for date range: past ' .  ($tdate != '' ? $tdate : RCS_BASE_DAYS) . ' days.' . "\n";
doUnattendedRCS($tdate);
echo 'Finished.' . "\n\n";

---

I also found this bit of code in my fakeadmin/includes/init_includes/overrides/init_admin_auth.php and don't know if it is what is causing the prob:

Code:

---

  if (!isset($_SESSION['admin_id']) && $_GET['rcs_cron'] == 1 && defined('RCS_CRON_USERID')) {

    $_SESSION['admin_id'] = RCS_CRON_USERID;

    $bypass_additional_auth = true;

  }

---

---

I just documented what I did for auto-cron on the Back in Stock Notifications.


Shouldn't take much to figure out what needs to be changed for this mod too.


http://www.zen-cart.com/showthread.p...34#post1144934

nice. thanks!

Quote:

---

Originally Posted by bi11i

would there be an easy way to
1. turn off plain-text mails?

---

Correct to create content for the text version separately, and separately for html-version. But these changes in the two lines do not fit.

Quote:

---

Originally Posted by bi11i

would there be an easy way to
2. change the email content to remove the duplicate content

---

PHP Code:

---

$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"; 


---

replace by

PHP Code:

---

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


---

Hi,
I've installed this mod with no problems (sort of...more on that in a minute). The mod works, in that it picks up abandoned carts...I've amended the PHP to show friendly URLs (from Ceon) and changed the wording to suit my shop. I can send emails OK and, from this perspective, all is well. However.....
Under Configuration>Configure RCS there are *NO* options listed - just headings, i.e. "Title Value Action"
I ran the SQL install for ZC1.5.0 (my site was a clean 1.5 install, although now heavily modified)...and I've checked three times that all six files are where they should be. I've just compared the actual content against the original files and all is as it should be. I'm at a bit of a loss...any bright ideas - about either a) what's wrong or b) what I've done wrong?

Cheers,
Gavin

Hi,

Just installed this mod but I get an error when trying to install the sql patch. I installed v1.5 as a clean install so I did not use the upgrade patch.

Any ideas as to why I am getting an error message.

Quote:

---

Originally Posted by coucho

Hi,

Just installed this mod but I get an error when trying to install the sql patch. I installed v1.5 as a clean install so I did not use the upgrade patch.

Any ideas as to why I am getting an error message.

---

You didn't post the error you were having so I'm assuming it's this here.
Probably the sql statement. Change the TYPE=MyISAM' to ENGINE=MyISAM and the problem may go away.

Quote:

---

Originally Posted by countrycharm

You didn't post the error you were having so I'm assuming it's this here.
Probably the sql statement. Change the TYPE=MyISAM' to ENGINE=MyISAM and the problem may go away.

---

Yep changing TYPE to ENGINE did the trick.

Thanks!

Hi again,
I'd already changed 'TYPE' to 'ENGINE'...but I still see no configuration values!
:-(

Quote:

---

Originally Posted by gavwright

Hi again,
I'd already changed 'TYPE' to 'ENGINE'...but I still see no configuration values!
:-(

---

Uninstall and install the sql statement again to see if that resolves your problem.

Thanks for your input - sorry if I'm being thick...but how do I uninstall, as there isn't an uninstall SQL file?

Just in case this is what you meant, I renamed all six files (I don't use Russian...) and then ran the install SQL again. I then renamed the six files to what they should be. Still no configuration values...

Quote:

---

Originally Posted by gavwright

Thanks for your input - sorry if I'm being thick...but how do I uninstall, as there isn't an uninstall SQL file?

Just in case this is what you meant, I renamed all six files (I don't use Russian...) and then ran the install SQL again. I then renamed the six files to what they should be. Still no configuration values...

---

Run this uninstall statement I provided for you. Before you go about renaming the file you need to make sure everything installs right first.

PHP Code:

---

DROP TABLE IF EXISTS scart;
DELETE FROM admin_pages WHERE page_key='config_recover_cart_sales';
DELETE FROM admin_pages WHERE page_key='recover_cart_sales';
DELETE FROM admin_pages WHERE page_key='stats_recover_cart_sales'; 


---

Check your PM

Works a treat - thanks :-)

Quote:

---

Originally Posted by ma.r.a

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?:(

---

I have this message as well, installed this mod last night on v1.3.9h. I couldn't find a reply to this query back in 2009.
What does it mean?
Does it change if there is an abandoned order?
???

The only thing that shows up is in Configuration -> Recover Cart Sales

When I installed the SQL file, I get this error.

15 statements processed.
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

I am assuming this is because the table names have custom prefixes. How do I go about changing these and fixing these errors?

when I install sql, there is an error:

PHP Fatal 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 'TYPE=MyISAM' at line 1 :: CREATE TABLE zen_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; in /public_html/includes/classes/db/mysql/query_factory.php on line 120

how to fix it?

changed

TYPE=MyISAM

to

ENGINE=MyISAM

then it works well

I've been upgrading my cart from 1.3.8a to 1.5.1 and well as most of the addons I've installed over the years. I'm working on my home copy at this point. For the most part its gone well, but I've run into a small problem with recover cart sales for zen cart 1.5. I've checked the location of the uploaded files several times and all seems to be correct, and I got no error messages when running the sql patch. Since I had an earlier copy installed before my general upgrade the scart table still existed in my sql data base (I checked it in phpMyAdmin) I ran the update version. The tools menu and the report menu looked fine and old abandoned carts were listed as usual, BUT the configuration menu is blank except for "title, value, and action. Tried running the full sql install and nothing changed. Didn't even wipe out the names of customers who had abandoned carts.

I've looked though this forum and couldn't find any answers. Anybody have any ideas of what might be wrong?

Is there a way to remove the session ID's from the URL attached to the message this mod sends customers? For example, we'd much prefer if the link was clickable so instead of this:

Code:

---

We would like to thank you for having shopped at SILK BLOOMS LTD in the past. We noticed that during a visit to our store you placed the following item(s) in your shopping cart, but did not complete the transaction.

Shopping Cart Contents:
1 x Stunning Vintage Ivory Rose & Hydrangea Flowergirls Pomander
http://www.silkblooms.co.uk/index.php?main_page=product_info&products_id=5505:fb9fab1a6f0d49978602e19f71abc707

---

Is there a way to make it do this:

Code:

---

We would like to thank you for having shopped at SILK BLOOMS LTD in the past. We noticed that during a visit to our store you placed the following item(s) in your shopping cart, but did not complete the transaction.

Shopping Cart Contents:
1 x Stunning Vintage Ivory Rose & Hydrangea Flowergirls Pomander
http://www.silkblooms.co.uk/index.php?main_page=product_info&products_id=5505

---

That is not a session id that is a Product with the products_id plus the Attributes selected ...

I always wondered what that gobblydeegook was at the end of some of the URL's we get sent.... Is there a way to switch them off at all?

Probably, but I do not use this add on so I cannot speculate on the customization that you would need ...

Quote:

---

Originally Posted by Ajeh

Probably, but I do not use this add on so I cannot speculate on the customization that you would need ...

---

If you have ecommerce stores then I'd recommend this mod. It's definitely a good sale clincher as it gets you back in contact with any bailed cart customers. I find that nine times out of ten they'll get back in touch because of this mod. Definitely a good add-on to use...... If you do decide to download it, maybe you can have a look at the weird URL with attributes selected issue :)