Recover Cart [Support Thread]

[kelvyn]

the delete button works.. however it works in a weird way (just found this out a few days ago so there might be another way)

you have to delete from most recent to oldest in order to get rid of stuff. so if someone abandoned a cart today, and there are 4 abandoned carts on RCS, and you want to delete #2, you'll have to delete todays and the one before in order to delete #2

not sure if that fix above works for you or not.. i haven't tried it yet

Phew - wish I'd searched for this bug before spending 90 mins on it! Oh well, thanks for the note anyway.

[samad64]

Phew - wish I'd searched for this bug before spending 90 mins on it! Oh well, thanks for the note anyway.

No prob! The latest version works like a charm though.. you can delete whichever cart you want to.. very useful:)

One bug, howver this is probably a ZC bug instead of a RCS bug. When a customer has a cart, but the customer is deleted.. the cart remains in the database.. and RCS pulls the data without a customer, resulting in stuff that can't be deleted through the admin panel. You can go back into the DB and drop it though, and its removed from RCS

[kelvyn]

No prob! The latest version works like a charm though.. you can delete whichever cart you want to.. very useful:)

One bug, howver this is probably a ZC bug instead of a RCS bug. When a customer has a cart, but the customer is deleted.. the cart remains in the database.. and RCS pulls the data without a customer, resulting in stuff that can't be deleted through the admin panel. You can go back into the DB and drop it though, and its removed from RCS

Hmm, I thought I had latest download, I only got it two days ago. Where should I get it from? I got mine from Zen downloads

[Ajeh]

Note: the code for deleting customer carts is in Zen Cart code for when a customer is deleted ...

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "
                      where customers_id = '" . (int)$customers_id . "'"); 

[a_berezin]

One bug, howver this is probably a ZC bug instead of a RCS bug. When a customer has a cart, but the customer is deleted.. the cart remains in the database.. and RCS pulls the data without a customer, resulting in stuff that can't be deleted through the admin panel. You can go back into the DB and drop it though, and its removed from RCS

What version of zen-cart you use?
Whow you delete customer? From admin->customers?
In zen-cart 1.3.7 when you delete customer all customers basket deleted.

[Woodymon]

Hi Andrew,

I see you updated your RCS version on Feb 27, 2007.

Can you confirm if the fixes employed in previous versions released by both Quentin and Brent Friar (and available in ZC Downloads area) are also implemented in your most recent RCS version available on your website?

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

Thanks for the upgrades!

Woody

[Woodymon]

Hi Andrew-

I forgot to ask in my last post what is best method to indentify your recovercart version installed? My file dates get messed around all the time so not a good method to use to identify anything.

the current recover_cart_sales.php shows:

 * @version $Id: recover_cart_sales.php 2.12 17.09.2006 22:25 Andrew Berezin $

The ID string appears to remain the same since September even though several updates have been released since? Are there version numbers located somewhere else or some other method used to identify your versions? Thanks.

Woody

[samad64]

Hm.. I use 1.3.7.. I was speaking from prior experience to the cart that was patched up to 1.3.7. I'm running on a fresh install now and I haven't had to do anything like that yet.. I'll give it a test to see if its still doing it. I checked the admin/customers.php file on my old site and its exactly the same one thats on my new site.. with this in the header comments:

 * @version $Id: customers.php 4280 2006-08-26 03:32:55Z drbyte $

[a_berezin]

So am I:

 * @version $Id: customers.php 4280 2006-08-26 03:32:55Z drbyte $

Lines 252-299

      case 'deleteconfirm':
        // demo active test
        if (zen_admin_demo()) {
          $_GET['action']= '';
          $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
          zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
        }

        if (isset($_POST['delete_reviews']) && ($_POST['delete_reviews'] == 'on')) {
          $reviews = $db->Execute("select reviews_id
                                   from " . TABLE_REVIEWS . "
                                   where customers_id = '" . (int)$customers_id . "'");
          while (!$reviews->EOF) {
            $db->Execute("delete from " . TABLE_REVIEWS_DESCRIPTION . "
                          where reviews_id = '" . (int)$reviews->fields['reviews_id'] . "'");
            $reviews->MoveNext();
          }

          $db->Execute("delete from " . TABLE_REVIEWS . "
                        where customers_id = '" . (int)$customers_id . "'");
        } else {
          $db->Execute("update " . TABLE_REVIEWS . "
                        set customers_id = null
                        where customers_id = '" . (int)$customers_id . "'");
        }

        $db->Execute("delete from " . TABLE_ADDRESS_BOOK . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_INFO . "
                      where customers_info_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_WHOS_ONLINE . "
                      where customer_id = '" . (int)$customers_id . "'");


        zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
        break;
      default:

[modchipfitters.co.uk]

did anyone get the email thing working cause i have tried it out and none seems to be recieving any emails when i try to contact them