Recover Cart [Support Thread]

Stuff4Toys:

Any progress on making this 1.5 compatible???

canemasters:

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

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.

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!

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:ece5b925171ef7577e4923a0a71b685e

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.

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:

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.

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.

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:77ff19653324db0868353221feb6b9ad