Recover Cart [Support Thread]

econcepts:

Will look into this, but it should already automatically select all of those carts that are abandoned and that fit within the criteria to follow up with. Does your version not do that?

It does default to all selected. Just thought a toggle would be handy. Like an inverse toggle or a unselect all. (no big deal if not added thou)

This is odd. I've uploaded all the correct files to all the correct folders and verified that I'm using the correct permissions (755 for folders and 644 for files) concerning this module. When I try to install the module I get an error saying "Internal Server Error". However, I've noticed that both new boxes for the module are indeed located under the tools and reports menu but nothing new is in the configuration section. When I click on the link in the tools or reports section to use the mod I get an error reading of that below. Being that I'm no database guru I have no idea what it means.......

Ian

1146 Table 'redlines_zen.scart' doesn't exist
in:
[SELECT cb.customers_id, cb.products_id, cb.customers_basket_quantity, cb.customers_basket_date_added, cus.customers_firstname, cus.customers_lastname, cus.customers_telephone, cus.customers_email_address, sc.datemodified FROM customers_basket cb LEFT JOIN customers cus ON (cb.customers_id = cus.customers_id) LEFT JOIN scart sc ON (cb.customers_id = sc.customers_id) WHERE cb.customers_basket_date_added >= '20101028' AND cb.customers_id NOT IN ('') ORDER BY cb.customers_id ASC, cb.customers_basket_date_added DESC]

Please help someone!

Ian

r1formetoo:

1146 Table 'redlines_zen.scart' doesn't exist
in:
[SELECT cb.customers_id, cb.products_id, cb.customers_basket_quantity, cb.customers_basket_date_added, cus.customers_firstname, cus.customers_lastname, cus.customers_telephone, cus.customers_email_address, sc.datemodified FROM customers_basket cb LEFT JOIN customers cus ON (cb.customers_id = cus.customers_id) LEFT JOIN scart sc ON (cb.customers_id = sc.customers_id) WHERE cb.customers_basket_date_added >= '20101028' AND cb.customers_id NOT IN ('') ORDER BY cb.customers_id ASC, cb.customers_basket_date_added DESC]

This means that you either did not run the full patch to install the mod (which creates a new table called scart) or that when trying to run the patch it did not complete. In either case, your database does not have the scart table which is required to run the mod.

When you run the SQL patch what type of message do you get?

Could there be a permission issue on the live server that does not allow the user to create a table? If so, that will fail (but adding new settings to the configuration will work as the table(s) are already present for those.

Check with your host to see if there are some MySQL restrictions on creating a new table.

You could also try to run the patch through phpMyAdmin to see what occurs (just the portion that creates the scart table). But you'll need to make sure you alter the language to add the redlines_zen prefix before any table created.

If you can isolate what is different from the test server and the live server you'll have found the answer as to what is causing it not to install. There has to be a configuration difference between the two or it would work on both just fine (since it works on the test server.)

Could anyone help me pls?
When I import the sql patches had this note:

12 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

How can deal with this?

PS:This mod can work right in zencart 1.39h . I had tested in a new cart.

Yes, it should work with 1.3.9 versions.

You could safely ignore the error you got while installing. All that means is some config variable that was trying to be inserted with the patch was already present in your database (meaning it is there.)

Have you tried to see if the module is installed and working?

econcepts:

Yes, it should work with 1.3.9 versions.

You could safely ignore the error you got while installing. All that means is some config variable that was trying to be inserted with the patch was already present in your database (meaning it is there.)

Have you tried to see if the module is installed and working?

Thank you for your reply.It could not work with this error.

when click the tool--->recover cart sale,it will go to
http://www.mywebsite.us/admin/FILENAME_RECOVER_CART_SALES.php
page not find in the website.
when click the report-->recovered sales results,it will go to
http://www.mywebist.us/admin/FILENAME_STATS_RECOVER_CART_SALES.php
page not find in the website.

zyzlee:

Thank you for your reply.It could not work with this error.

when click the tool--->recover cart sale,it will go to
http://www.mywebsite.us/admin/FILENAME_RECOVER_CART_SALES.php
page not find in the website.
when click the report-->recovered sales results,it will go to
http://www.mywebist.us/admin/FILENAME_STATS_RECOVER_CART_SALES.php
page not find in the website.

This isn't a result of the SQL patch (that error will still have it work). You have not uploaded all files to the right locations. That is why you are getting this error. Specifically in this case, the define language files for pointing to the correct file locations is missing in your case.

My suggestion would be to go back and re-upload all files again making sure you put them in the correct locations. That should get you up and running.

:)

econcepts:

This isn't a result of the SQL patch (that error will still have it work). You have not uploaded all files to the right locations. That is why you are getting this error. Specifically in this case, the define language files for pointing to the correct file locations is missing in your case.

My suggestion would be to go back and re-upload all files again making sure you put them in the correct locations. That should get you up and running.

:)

Thank you for your reply.
I had checked all the file in right position before.
But I will try again.For this is really a good mod.

ok,I had reupload all the files and reinstalled the sql patch.
It still had some thing does not work:
1.admin-->configuration-->Recover Cart Sales has nothing to configurate.
2.after send mail to the test custom,admin-->reports-->Recover Cart Sales show:
1054 Unknown column 'RCS_PENDING_SALE_STATUS' in 'where clause'
in:
[SELECT o.orders_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value FROM orders o LEFT JOIN orders_total ot ON (o.orders_id = ot.orders_id) LEFT JOIN orders_status s ON (s.orders_status_id = o.orders_status AND s.language_id = 1) WHERE o.customers_id = 12 AND o.orders_status > RCS_PENDING_SALE_STATUS AND o.date_purchased >= '2011-01-01' AND ot.class = 'ot_total']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
3.after send mail to the test custom,admin-->tools-->Recover Cart Sales still show Uncontacted.

Thank you:Econcepts.
I just do the sql patch in th phpadmin.Now I think all the things work right.
Thank you again.
:clap::clap:
I had done all the things before,but it did not work.But today it work.
It's a very good beginning for the new year.

Happy new year!

I can't make it work. The install looks perfect -- all three menus in Admin look fine and all files are where they are supposed to be, but Admin Tools RCS shows nothing when something is sitting in my cart. I even checked the option for ignoring session data (set False) so that an active cart would get noticed, and still nothing. Any simple (or complicated) explanation for why this tool is not working for me after what appears to be a clean install?
many thanks.

finlander:

I can't make it work. The install looks perfect -- all three menus in Admin look fine and all files are where they are supposed to be, but Admin Tools RCS shows nothing when something is sitting in my cart. I even checked the option for ignoring session data (set False) so that an active cart would get noticed, and still nothing. Any simple (or complicated) explanation for why this tool is not working for me after what appears to be a clean install?
many thanks.

This contributing won't show 'active' carts (like you find in the "who's online tool"). It will only show those carts which have been abandoned (for those who have logged into the system.)

Depending on the session settings of your server (default is usually 20 mins) it would take that amount of time for an abandon to show.

Here's how it works:

1. Add something to your cart

2. Login to your account

3. Do not complete the purchase but leave the item in the cart (so you can leave the site.)

4. Don't return for say 20 mins (might be longer on your server but again, the default the session time limit is usually this).

5. Login to your admin (give it about an hour to be sure) and then check the recover carts tool. You should see the abandoned cart there on the screen with the email addy etc... of the person that left and the items that were in the cart. From here you can send them the email to follow-up.)

So basically, the cart is not considered abandoned until the session expires (or else it could still be active and therefore should not be sent a follow-up email.)

See if that works for you.

Thanks, Eric, I'll try that.

Could you please clarify the following setting? The wording is very confusing. The word 'ignore' is used to explain both options for the setting. Does True mean that customers with an active session **will **be listed in Tools RCS as an abandoned cart, and that False means that customers w/ active session **won't **be listed as having abandoned cart? Or is it all the other way (opposite) of that?

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

Seems to be working fine. Thanks again.

finlander:

Thanks, Eric, I'll try that.

Could you please clarify the following setting? The wording is very confusing. The word 'ignore' is used to explain both options for the setting. Does True mean that customers with an active session **will **be listed in Tools RCS as an abandoned cart, and that False means that customers w/ active session **won't **be listed as having abandoned cart? Or is it all the other way (opposite) of that?

Set this to true. It does take more resources, but if a user has an active session you certainly do NOT want them appearing in the 'abandoned carts' area (as they are still shopping.)

You only want them to show in there if their session has ended.

I don't know whether I've done something wrong when installing this great mod, but I've just noticed the email that is sent out to the potential customers gives out the link to my admin logon page.....not good to say the least.

The bug is in the copyright text at the bottom of the email.
I've had to change my EMAIL_FOOTER_COPYRIGHT define in admin/includes/languages/english/email_extras.php to hard code my website rather than use zen_href_link(FILENAME_DEFAULT)

Has anyone else come across this?
Looks like I now need to rename my admin folder again :(

That is really odd. I have never come across that with this. I'd be interested to know if others have or are experiencing the same thing?

You shouldn't have to hard code anything for it to work (without providing that url).

How is the link presented to them? (what type or terminology is used to present the link to them?

They should have a link to their login page (not the admin though.)

I just tested it on a few sites of mine and none of the emails that were generated include a link to the admin.

What other admin mods do you have installed? Could one of these made alterations to your language file etc??

In the meantime, if anyone else has experienced this same thing, please post it here (just that you have had the same thing occur.)

Hi Eric,
The link is presented just after the 'Login to your account' section as follows:

Copyright (c) 2011 Snow Republic.

The company name (Snow Republic) in the actual link.

When I send an email through recover cart sales, I just use the default settings. I don't type anything in the message text box.
I just select the people I want to message then hit the send button.

After a bit more digging, I realised it was all emails that had the link to my admin area not just the recover cart sales ones.

I found the solution here http://www.zen-cart.com/forum/showthread.php?t=131766

Looks like I wasn't the only one to make a mess of this!