Recover Cart [Support Thread]

[limelites]

I always wondered what that gobblydeegook was at the end of some of the URL's we get sent.... Is there a way to switch them off at all?

[Ajeh]

Probably, but I do not use this add on so I cannot speculate on the customization that you would need ...

[limelites]

Probably, but I do not use this add on so I cannot speculate on the customization that you would need ...

If you have ecommerce stores then I'd recommend this mod. It's definitely a good sale clincher as it gets you back in contact with any bailed cart customers. I find that nine times out of ten they'll get back in touch because of this mod. Definitely a good add-on to use...... If you do decide to download it, maybe you can have a look at the weird URL with attributes selected issue :)

[limelites]

Probably just a simple swith in this code:

            // BEGIN OF ATTRIBUTE DB CODE
            $prodAttribs = ''; // DO NOT DELETE
            if (RCS_SHOW_ATTRIBUTES == 'true') {
                $attribrecs = $db->Execute("SELECT cba.products_id,
                                                                                     po.products_options_name poname,
                                                                                     pov.products_options_values_name povname
                                                                        FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " cba,
                                                                                 " . TABLE_PRODUCTS_OPTIONS . " po,
                                                                                 " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov,
                                                                                 " . TABLE_LANGUAGES . " l
                                                                        WHERE cba.products_id ='" . (int)$basket->fields['products_id'] . "'
                                                                            AND cba.customers_id = " . $curcus . "
                                                                            AND po.products_options_id = cba.products_options_id
                                                                            AND pov.products_options_values_id = cba.products_options_value_id
                                                                            AND po.language_id =" . (int)$_SESSION['languages_id'] . "
                                                                            AND pov.language_id =" . (int)$_SESSION['languages_id']);
                $hasAttributes = false;
                if ($attribrecs->RecordCount() > 0){
                    $hasAttributes = true;
                    $prodAttribs = '<br />';
                    while (!$attribrecs->EOF){
                        $prodAttribs .= '<small><i> - ' . $attribrecs->fields['poname'] . ' ' . $attribrecs->fields['povname'] . '</i></small><br />';
                        $attribrecs->MoveNext();
                    }
                }
            }
            // END OF ATTRIBUTE DB CODE 

If I was any good with PHP I'm sure I'd see how to turn it off, but I amn't and I can't :)

[Ajeh]

See what happens if you change the references on $cline and $mline for:
$basket->fields['products_id']

to be:
(int)$basket->fields['products_id']

[limelites]

Well, I wasn't 100% sure what you meant about the $cline and $sline so I just replaced all eleven instances with the new (int)$basket->fields['products_id'] and it seems to have done the trick.... Thank you Ajeh, your genious is inspiring!

[Ajeh]

You really do not want to do that ...

Looking further at this file, I would first try a ...

Search of the file:
/your_secret_admin/recover_cart_sales.php

and search for:
$mline

and only on references to this $mline make the change ...

I am pretty sure if you do make this change in other places that you may actually break things on this program ...

[limelites]

Hi Ajeh,

I've taken your advice, gone back to the original file and replaced only the two instances with the $mline. It was only this line then:

            $mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
            $mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id'] ) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id'] ) . "</a></blockquote>\n\n";
            $basket->MoveNext(); 

Just need to run some tests and make sure it's still picking up on bailed carts.

[limelites]

OK, how did you simulate a bailed cart? It's just that when I simulate a bailed cart by logging in and adding an item to cart as a customer.... when I cose the browser (bail) and go back to recover cart sales... it doesn't appear there as a recoverable record. It used to :)

[limelites]

Hang on, it's working! It just seems to take quite a while to propagate bailed carts into the recover cart area! It's working!!