Recover Cart Sales show attributes

[jwlamb]

Good day all. I've been searching everywhere to add the attributes to the Tools>Recover Cart Sales. Other than broken links, the only thing I can find is to change the SQL 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false' to 'true'. But when I do this and re-run the SQL, nothing happens. Same for showing logged in shoppers ('Ignore Customers with Sessions').

Am I missing something? Thank you.

[bislewl]

If i'm understanding your question correctly your aren't able to load the page int he admin? If that is correct consider the information below

there are a copy things you can do.
1.) Try running the uninstall.sql file and then the install.sql file Sometimes this helps "shake" out the issues
2.) Take a look in the DB in the TABLE_ADMIN_PAGES table and see if it is registered there
3.) Basically the same as #2 try this module to modify your menus http://www.zen-cart.com/downloads.php?do=file&id=1878

[jwlamb]

Thank you for the reply. However
1.) Didn't come with an uninstall.sql and I'm not familiar with programing php/sql/etc. (html, I rock)
2.) Not sure where to find the table
3.) Don't think that will help since the menus are there and I'm fine with where they are.

I've done some more reading on this and it looks there is a third menu option that I did not notice before and that is Configuration>Configure RCS. But when I open it, there is nothing listed, just a blank table.

[jwlamb]

I found an uninstall.sql thanks to lat9

DELETE FROM configuration_group WHERE configuration_group_title = 'Recover Cart Sales';
DELETE FROM configuration WHERE configuration_key LIKE 'RCS_%';
DELETE FROM admin_pages WHERE page_key IN ('recover_cart_sales', 'stats_recover_cart_sales', 'config_recover_cart_sales');
DROP TABLE IF EXISTS scart;

Then reinstalled the install.sql. The Configuration>Configure RCS now populates with information in the table, but when I change show attributes from false to true and same for ignore customers with sessions, nothing changes when I run Tools>Recover Cart Sales.

I even tried to trick the sql and uninstalled again, changed the false/true settings in the patch, and then reinstalled. Still doesn't show the attributes and still missing logged in customers.

Please help!

[jwlamb]

Thanks Datax in another post:

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

Now this only solved half the issue. The attributes are showing now (YEA!!) but some of the attributes add a cost to the total. This additional cost is not being reflected in the Cart Total.

We shall continue searching....