Recover Cart [Support Thread]

a_berezin:

What module you use? From download section or my edition?

recover_cart_sales_1.5.1 from the Zen downloads.

Which brings up a good point, is this the correct location for stable releases and updates thereto?

Test this one - http://zen-cart.spb.ru/freedownload.php?file=zc-contribution/recovercart.zip

Justwade:

change the store owners name and email address to someone else in the email
Test my variant.

a_berezin:

Test this one - http://zen-cart.spb.ru/freedownload.php?file=zc-contribution/recovercart.zip

We've been using Andrew's version since last year and it works flawlessly. The only problem with the mod is it doesn't automatically checkout for the customers in recovert cart:lookaroun Of course, I am kidding about that. It works great!

BlessIsaacola:

The only problem with the mod is it doesn't automatically checkout for the customers in recovert cart
What do you mean? More explanation need.

a_berezin:

What do you mean? More explanation need.

Isaac was making a joke. And that's no April Fools ;-)

a_berezin:

What do you mean? More explanation need.

Andrew, that was just a joke as Woody pointed out. I even stated I was just kidding and used a smiling icon for fear of been taken serious. I guess that didn't work.

The mod works just fine!

a_berezin:

Test my variant.

Yes, I am testing with your variant. But I don't know where or how.:dontgetit

Justwade:

Yes, I am testing with your variant. But I don't know where or how.:dontgetit

Download last variant

Yes, I downloaded your lastest varient, the additional fields was an excellant idea. Thank you for doing that extra code work!!! I tested it and it works flawlessly. I had not thought about the From or Subject lines, but this was a needed refinement.

But what some of us was hoping for a way to change the actual end of the produced email letter.

That is the;

Sincerely,

Store owners name
hhhhttp://www.mydomainname.com/catalog/index.php?main_page=index

I need to make Store Owner another name.
Some of us would like to make the above index be the store's name and have it hyperlinked to the store index. This latter would be nice but can be lived with as is.
For our site, the owners name needs to be changeable somehow.
Thanks again,

I understand you. It is necessary to use email templates. In a near future the similar changes are not planned. I quite accept existing version. :cool:

Regarding the version posted on http://zen-cart.spb.ru dated 2007-04-01:

I lack good understanding of sql commands, so cannot tell if this version can be installed over an existing installation.

Can this version be installed over the previously installed version by simply overwriting the old files and running the sql statements?

I am concerned that executing the rcs_install.sql file may choke when it attempts to create a new scart table while there is already an existing table of that name.

Has the sql been written to modify or to replace the scart table?

Should I remove the existing scart table before running the install sql commands? Removing will lose existing data stored there.

Ron

Hello Zinners,

I have installed recover cart and i uploaded everything to it relative path but when i go to the tool and on the dropdown i click recover cart i see some carts recovered but above the carts i get this message three times.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\inetpub\foxmar\FoxCart\admin\recover_cart_sales.php on line 395

Any thought as to what this means? Is there a solution to it?

Also i forgot to metion that when i go to reports tab and click the recover cart link i get this message at the top

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\inetpub\foxmar\FoxCart\admin\stats_recover_cart_sales.php on line 134

ronlee67:

Regarding the version posted on http://zen-cart.spb.ru dated 2007-04-01:

I lack good understanding of sql commands, so cannot tell if this version can be installed over an existing installation.

Can this version be installed over the previously installed version by simply overwriting the old files and running the sql statements?

I am concerned that executing the rcs_install.sql file may choke when it attempts to create a new scart table while there is already an existing table of that name.

Has the sql been written to modify or to replace the scart table?

Should I remove the existing scart table before running the install sql commands? Removing will lose existing data stored there.

Ron
I didn't get any response to this question, but tried to install over an existing install and it choked, so removed the contribution file by file and installed from scratch with latest version. Everything works fine now.

Ron

ronlee67:

removed the contribution file by file and installed from scratch with latest version. Everything works fine now.

Ron

That is generally the best method when installing mods. As you can never be certain if the updated mod version does or doesn't include the exact same file set as the previous version, it can be easy to miss deleting a no longer used previous version file (even when you follow the readme).

And when upgrading mods, I always open the provided SQL patch to compare SQL differences between previous versions, so I know what to expect when I view the relevant mod menus in the admin GUI.

Sometimes if I have trouble with a mod install I run the uninstaller SQL patch and reinstall the SQL from scratch (rather than running the updater SQL). But not all mods provide such ability. Note Andrew most often provides uninstaller and updater SQL patches with his mods. Very good service.

And thanks to Andrew for providing the RCS mod update.

Woody

Hi Andrew.

Installed Andrew's RCS mod update (Apr 1 2007).

Whenever a Recover Cart email is sent to a customer with an abandoned shopping cart and then customer returns and submits an order, as expected their order is displayed in Admin > Reports > Recovered Sales Reports

When order is in pending status report shows:

Examined Records: 	1
Recovered Sales: 	1 

SCart ID 	Date Added 	Customer Name 	Order Date 	Status 	Amount
2 	12/31/1969 	Joe Tester
		
Total Recovered:  	100% 	$0.00 

After the order status is updated (changed from pendng to to processing or shipped) the report shows:

Examined Records: 	1
Recovered Sales: 	1 

SCart ID  	Date Added  	Customer Name  	Order Date  	Status  	Amount
2 	12/31/1969 	Joe Tester 	04/28/2007 	Shipped 	$17.00

Total Recovered:  	100% 	$17.00 	

As can be observed above:

1. in both cases the 'Date Added' is incorrect.
2. when order is pending status the 'Order Date', 'Status', and 'Order Amounts' are NOT displayed.

Can anyone using this mod confirm similar behavior?

Thanks,
Woody

i keep getting the following error which i cant understand because everything has been running fine and i haven instaled any other add ons latelty:

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 'Callaghan') and o.orders_status > 1 and s.orders_s' at line 5
in:
[select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from modchipfittersorders o left join modchipfittersorders_total ot on (o.orders_id = ot.orders_id), modchipfittersorders_status s where (o.customers_id = 2235 OR o.customers_email_address = '' OR o.customers_name like 'Sean O'Callaghan') and o.orders_status > 1 and s.orders_status_id = o.orders_status and o.date_purchased >= '20070414' 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.
Recover Cart Sales Report v2.00
anyone got any ideas
its only from the report screen the other half of the mod works fine including emailing my customers

Download and try last variant.

a_berezin:

Download and try last variant.

Hi Andrew, found small issues with the 04-29-07 mod update (missing semi-colon in SQL updater and problem with data displaying report). PM'd you details.

Thanks,
Woody