Page 32 of 67 FirstFirst ... 22303132333442 ... LastLast
Results 311 to 320 of 663
  1. #311
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Recover Cart

    @tmdelia,

    A few questions.

    1) Do you know when it stopped working?
    2) Where any upgrades etc... added that may have made it stop?
    3) Did anything on your server change (php verison, etc...)?

    Typically code doesn't just stop working when it was previously unless something else changed outside the code to make it stop.

    Let me know that and I'll see if I can find out why it quit on you.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  2. #312
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Recover Cart

    Another thing to consider. It looks like the actual processing part of the script refers to a function. That function is not defined in the script. Is there a "extra functions" file hanging out there somewhere as well that this refers to?

    Can you set your mail server up to send you a log of the CRON job when it runs? This should provide you with an error message if there are problems anywhere.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  3. #313
    Join Date
    May 2005
    Posts
    75
    Plugin Contributions
    0

    Default Re: Recover Cart

    econcepts,

    Thanks so much for replying. Your post led me to track down the missing admin/includes/functions/extra_functions file. I'm posting it here for other users interested in the rcs_cron functionality. I had to comment out lines 38-50 and 52-57 because the functions zen_cart_date_short and zen_GetCustomerOnline because they are already defined in admin/includes/functions/extra_functions/functions_recover_cart_sales.php. Working perfectly now! Thanks for your help.

    Here's the functions_recover_cart_sales.php code:

    Code:
    <?php
    /**
     * stems from:
     * @version $ Id: recover_cart_sales.php 2.12 17.09.2006 22:25 Andrew Berezin $
     */
    
    function rcs_delete_entry($custID) {
    // Delete Entry Begin
      if ($_GET['action'] == 'delete') {
    	$customer = $db->Execute("SELECT customers_firstname, customers_lastname
    														FROM " . TABLE_CUSTOMERS . "
    														WHERE customers_id ='" . (int)$custID. "' LIMIT 1");
    	$db->Execute("DELETE FROM " . TABLE_CUSTOMERS_BASKET . " WHERE customers_id='" . (int)$custID . "'");
    	$db->Execute("DELETE FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " WHERE customers_id='" . (int)$custID . "'");
    	$messageStack->add(MESSAGE_STACK_CART_CUSTOMER . $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname'] . ' (ID ' . $custID . ')' . MESSAGE_STACK_DELETE_SUCCESS, 'success');
      }
    // Delete Entry End
    }
    
    // Set Contacted Begin
    function rcs_set_contacted($custID, $displayMsgs = TRUE) {
      if (!is_array($custID)) $custID = array($custID);
      foreach($custID as $customer) {
    	$customer = $db->Execute("SELECT customers_firstname, customers_lastname
    														FROM " . TABLE_CUSTOMERS . "
    														WHERE customers_id ='" . (int)$customer . "' LIMIT 1");
    	// See if a record for this customer already exists; if not create one and if so update it
    	$donequery = $db->Execute("SELECT * FROM ". TABLE_SCART ." WHERE customers_id = '" . (int)$customer . "'");
    	if ($donequery->RecordCount() == 0)
    		$db->Execute("INSERT INTO " . TABLE_SCART . " (customers_id, dateadded, datemodified) VALUES ('" . (int)$customer . "', '" . date('Ymd') . "', '" . date('Ymd') . "')");
    	else
    		$db->Execute("UPDATE " . TABLE_SCART . " SET datemodified = '" . date('Ymd') . "' WHERE customers_id = " . (int)$customer);
    	if ($displayMsgs) $messageStack->add(MESSAGE_STACK_CUSTOMER . $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname'] . ' (ID ' . $customer . ')' . MESSAGE_STACK_SETCONACTED, 'success');
      }
    }
    // Set Contacted End
    
    //This function already in admin/includes/functions/extra_functions/functions_recover_cart_sales.php
    // function zen_cart_date_short($raw_date) {
    //	if ($raw_date <= 0)
    //		return false;
    //	$year = substr($raw_date, 0, 4);
    //	$month = (int)substr($raw_date, 4, 2);
    //	$day = (int)substr($raw_date, 6, 2);
    //	if (@date('Y', mktime(0, 0, 0, $month, $day, $year)) == $year) {
    //		return date(DATE_FORMAT, mktime(0, 0, 0, $month, $day, $year));
    //	} else {
    //		return ereg_replace('2037' . '$', $year, date(DATE_FORMAT, mktime(0, 0, 0, $month, $day, 2037)));
    //	}
    //}
    
    //This function already in admin/includes/functions/extra_functions/functions_recover_cart_sales.php
    // This will return a list of active customers
    //function zen_GetCustomerOnline() {
    //	global $db;
    //  $members = array();
    // Set expiration time, default is 1200 secs (20 mins)
      $xx_mins_ago = (time() - 1200);
      $whos_online_query = $db->Execute("SELECT customer_id
                                         FROM " . TABLE_WHOS_ONLINE . "
                                         WHERE time_last_click > '" . $xx_mins_ago . "'");
      while (!$whos_online_query->EOF) {
        if ($whos_online_query->fields['customer_id'] != 0) {
        	$members[] = $whos_online_query->fields['customer_id'];
        }
        $whos_online_query->MoveNext();
      }
      return $members;
    //
    function rcs_send_recover_cart_emails($emails_array, $tdate, $messageHTML = '', $messageTEXT = '', $subject = '', $from = '') {
      global $db, $currencies;
        $file = DIR_FS_SQL_CACHE . '/' . 'RecoverCartSales-' . date('Ymd-His') . '-log.html';
    
        $fp = @fopen($file, 'a');
        @fwrite($fp, '<table><tr><td>Recover Cart Sales - LOG</td></tr><tr><td>' . date('M-d-Y h:i:s') . '</td></tr></table><hr>');
        @fwrite($fp, '<table border="0" width="100%" cellspacing="2" cellpadding="2">
      <tr>
        <td class="pageHeading" align="left" colspan=6>'. HEADING_EMAIL_SENT.'</td>
      </tr>
      <tr class="dataTableHeadingRow">
        <td class="dataTableHeadingContent" align="left" colspan="1" width="15%">'.TABLE_HEADING_CUSTOMER.'</td>
        <td class="dataTableHeadingContent" align="left" colspan="1" width="30%">&nbsp;</td>
        <td class="dataTableHeadingContent" align="left" colspan="1" width="25%">&nbsp;</td>
        <td class="dataTableHeadingContent" align="left" colspan="1" width="10%">&nbsp;</td>
        <td class="dataTableHeadingContent" align="left" colspan="1" width="10%">&nbsp;</td>
        <td class="dataTableHeadingContent" align="left" colspan="1" width="10%">&nbsp;</td>
      </tr>
      <tr class="dataTableHeadingRow">
        <td class="dataTableHeadingContent" align="left"   colspan="1"  width="15%">'. TABLE_HEADING_MODEL.'</td>
        <td class="dataTableHeadingContent" align="left"   colspan="2"  width="55%">'. TABLE_HEADING_DESCRIPTION.'</td>
        <td class="dataTableHeadingContent" align="center" colspan="1"  width="10%"> '. TABLE_HEADING_QUANTY.'</td>
        <td class="dataTableHeadingContent" align="right"  colspan="1"  width="10%">'. TABLE_HEADING_PRICE.'</td>
        <td class="dataTableHeadingContent" align="right"  colspan="1"  width="10%">'. TABLE_HEADING_TOTAL.'</td>
      </tr>');
        @fclose($fp);
    
    
    	$messageHTML = ($messageHTML == '') ? zen_db_prepare_input($_POST['message_html']) : $messageHTML;
    	$messageTEXT = ($messageTEXT == '') ? zen_db_prepare_input($_POST['message']) : $messageTEXT;
    	$from = ($from == '') ? zen_db_prepare_input($_POST['from']) : $from; // STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS
    	$subject = ($subject == '') ? zen_db_prepare_input($_POST['subject']) : $subject; // EMAIL_TEXT_SUBJECT
    
    	foreach ($emails_array as $cid) {
    		$mline = '';
    		$cline = '';
    		$lastcid = 0;
    		$tprice = 0;
    
    		$basket = $db->Execute("SELECT    cb.products_id,
    																			cb.customers_basket_quantity,
    																			cb.customers_basket_date_added,
    																			cus.customers_firstname fname,
    																			cus.customers_lastname lname,
    																			cus.customers_email_address email
    														FROM      " . TABLE_CUSTOMERS_BASKET . " cb,
    																			" . TABLE_CUSTOMERS . " cus
    														WHERE     cb.customers_id = cus.customers_id AND
    																			cus.customers_id ='" . $cid . "'
    														ORDER BY  cb.customers_basket_date_added DESC ");
    		while (!$basket->EOF) {
    
    		// set new cline and curcus
    			if ($lastcid != $cid) {
    				if ($lastcid != "") {
    					$cline .= "
    					<tr>
    						<td class='dataTableContent' align='right' colspan='6'><b>" . TABLE_CART_TOTAL . "</b>" . $currencies->format($tprice) . "</td>
    					</tr>
    					<tr>
    						<td colspan='6' align='right'><a href=" . zen_href_link(FILENAME_RECOVER_CART_SALES, "action=delete&customer_id=" . $cid . "&tdate=" . $tdate) . ">" . zen_image_button('button_delete.gif', IMAGE_DELETE) . "</a></td>
    					</tr>\n";
    					echo $cline;
    				}
    				$cline .= "<tr> <td class='dataTableContent' align='left' colspan='6'><a href='" . zen_href_link(FILENAME_CUSTOMERS, 'search=' . $basket->fields['lname']) . "'>" . $basket->fields['fname'] . " " . $basket->fields['lname'] . "</a>".$customer."</td></tr>";
    				$tprice = 0;
    			}
    			$lastcid = $cid;
    
    			$products = $db->Execute("SELECT p.products_model model,
    																				pd.products_name name
    																FROM " . TABLE_PRODUCTS . " p,
    																		 " . TABLE_PRODUCTS_DESCRIPTION . " pd
    																WHERE p.products_id = '" . $basket->fields['products_id'] . "'
    																  AND pd.products_id = p.products_id
    																  AND pd.language_id = " . (int)$_SESSION['languages_id']);
    
    			$sprice = zen_get_products_actual_price($basket->fields['products_id']);
    
    			$tprice += $basket->fields['customers_basket_quantity'] * $sprice;
    
    			$cline .= "<tr class='dataTableRow'>
    									 <td class='dataTableContent' align='left' width='15%'>" . $products->fields['model'] . "</td>
    											<td class='dataTableContent' align='left' colspan='2' width='55%'><a href='" . zen_href_link(FILENAME_CATEGORIES, 'action=new_product_preview&read=only&pID=' . $basket->fields['products_id'] . '&origin=' . FILENAME_RECOVER_CART_SALES . '?page=' . $_GET['page']) . "'>" . $products->fields['name'] . "</a></td>
    											<td class='dataTableContent' align='center' width='10%'>" . $basket->fields['customers_basket_quantity'] . "</td>
    											<td class='dataTableContent' align='right' width='10%'>" . $currencies->format($sprice) . "</td>
    											<td class='dataTableContent' align='right' width='10%'>" . $currencies->format($basket->fields['customers_basket_quantity'] * $sprice) . "</td>
    									 </tr>";
    
    			$mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
    			$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";
    			$basket->MoveNext();
    		}
    
    		$cline .= "</td></tr>";
    
    		// E-mail Processing - Requires EMAIL_* defines in the
    		// includes/languages/english/recover_cart_sales.php file
    		$email = '';
    
    		if (RCS_EMAIL_FRIENDLY == 'true'){
    			$email .= EMAIL_TEXT_SALUTATION . $basket->fields['fname'] . ' ' . $basket->fields['lname'] . ",";
    		} else {
    			$email .= STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n";
    		}
    
    		$cquery = $db->Execute("SELECT * FROM " . TABLE_ORDERS . " WHERE customers_id = '" . $cid . "'" );
    		if ($cquery->RecordCount() < 1) {
    			$email .= sprintf(EMAIL_TEXT_NEWCUST_INTRO, $mline);
    		} else {
    			$email .= sprintf(EMAIL_TEXT_CURCUST_INTRO, $mline);
    		}
    
    		$email .= EMAIL_TEXT_BODY_HEADER . $mline . EMAIL_TEXT_BODY_FOOTER;
    
    		if( EMAIL_USE_HTML == 'true' )
    			$email .= '<a href="' . zen_catalog_href_link(FILENAME_DEFAULT) . '">' . STORE_OWNER . "\n" . zen_catalog_href_link(FILENAME_DEFAULT)  . '</a>';
    		else
    			$email .= STORE_OWNER . "\n" . zen_catalog_href_link(FILENAME_DEFAULT);
    
    		$email .= "\n\n";
    
    		$email .= "\n" . EMAIL_SEPARATOR . "\n\n";
    		$email .= EMAIL_TEXT_LOGIN;
    
    		if( EMAIL_USE_HTML == 'true' )
    			$email .= '  <a href="' . zen_catalog_href_link(FILENAME_LOGIN, '', 'SSL') . '">' . zen_catalog_href_link(FILENAME_LOGIN, '', 'SSL') . '</a>';
    		else
    			$email .= '  (' . zen_catalog_href_link(FILENAME_LOGIN, '', 'SSL') . ')';
    
    		$custname = $basket->fields['fname']." ".$basket->fields['lname'];
    		$outEmailAddr = '"' . $custname . '" <' . $basket->fields['email'] . '>';
    		if( zen_not_null(RCS_EMAIL_COPIES_TO) )
    			$outEmailAddr .= ', ' . RCS_EMAIL_COPIES_TO;
    $html_msg['EMAIL_MESSAGE_HTML'] = $email;
    
    		$email = strip_tags($email . "\n\n" . zen_db_prepare_input($messageTEXT));
    		zen_mail('', $outEmailAddr, $subject, $email, '', $from, $html_msg);
    
    
    // LOGGING INSTEAD OF EMAIL
    $fp = @fopen(DIR_FS_SQL_CACHE . '/RCSmessages-'.time().'.txt', 'a');
    @fwrite($fp, date("Y-m-d h:m:s") . ' - RCS Message to: ' . $outEmailAddr . "\n\tSubject: " . $subject . "\n\tFrom: " . $from . "\n\t Message: " . $email . "\n\n");
    @fclose($fp);
    
    
    
    		$mline = "";
    
    		// See if a record for this customer already exists; if not create one and if so update it
    		$donequery = $db->Execute("SELECT * FROM ". TABLE_SCART ." WHERE customers_id = '" . $cid . "'");
    		if ($donequery->RecordCount() == 0)
    			$db->Execute("INSERT INTO " . TABLE_SCART . " (customers_id, dateadded, datemodified) VALUES ('" . $cid . "', '" . date('Ymd') . "', '" . date('Ymd') . "')");
    		else
    			$db->Execute("UPDATE " . TABLE_SCART . " SET datemodified = '" . date('Ymd') . "' WHERE customers_id = " . $cid );
    
    
            $fp = @fopen($file, 'a');
            @fwrite($fp, $cline . "\n\n");
            @fclose($fp);
    
    	//	echo $cline;
    	//	$cline = "";
    	}
        $fp = @fopen($file, 'a');
        @fwrite($fp, '          <tr><td colspan=8 align="right" class="dataTableContent"><b>' .  TABLE_CART_TOTAL  . $currencies->format($tprice) . '</td> </tr>
              <tr><td colspan=6 align="right"><a href="'. zen_href_link(FILENAME_RECOVER_CART_SALES, "action=delete&customer_id=" . $cid . "&tdate=" . $tdate).'">'. zen_image_button('button_delete.gif', IMAGE_DELETE).'</a></td></tr>
              <tr><td colspan=6 align=center><a href="'. zen_href_link(FILENAME_RECOVER_CART_SALES).'">'. TEXT_RETURN.'</a></td></tr>
            </table>');
        @fwrite($fp, '<div>Finished: '. date('Y-m-d h:m:s') . '</div>');
        @fclose($fp);
    
      return $cline;
    }
    
    
    function doUnattendedRCS($tdate = '') {
      global $db;
      $tdate = ($tdate == '') ? RCS_BASE_DAYS : $tdate;
      $custArray = array();
    	$cust_ses_ids = zen_GetCustomerOnline();
    	$basket = $db->Execute("SELECT cb.customers_id,
    																 cb.products_id,
    																 cb.customers_basket_quantity,
    																 cb.customers_basket_date_added,
    																 cus.customers_firstname,
    																 cus.customers_lastname,
    																 cus.customers_telephone,
    																 cus.customers_email_address,
    																 sc.datemodified
    													FROM " . TABLE_CUSTOMERS_BASKET . " cb
    														LEFT JOIN " . TABLE_CUSTOMERS . " cus ON (cb.customers_id = cus.customers_id)
    														LEFT JOIN " . TABLE_SCART . " sc ON (cb.customers_id = sc.customers_id)
    													WHERE cb.customers_basket_date_added >= '" . date('Ymd', time()-$tdate*24*60*60) . "'
    														AND cb.customers_id NOT IN ('" . implode(", ", $cust_ses_ids) . "')
    													ORDER BY cb.customers_id ASC, cb.customers_basket_date_added DESC");
    	$curcus = 0;
    	$skip = false;
    
    	while (!$basket->EOF) {
    
    	// If this is a new customer, create the appropriate HTML
    		if ($curcus != $basket->fields['customers_id']) {
    
    			$curcus = $basket->fields['customers_id'];
    
    			$checked = 1; // assume we'll send an email
    			$skip = false;
    			$sentdate = "";
    			$customer = $basket->fields['customers_firstname'] . " " . $basket->fields['customers_lastname'];
    			if ((time()-(RCS_EMAIL_TTL*24*60*60)) <= strtotime($basket->fields['datemodified'])) {
    				$sentdate = $basket->fields['datemodified'];
    				$checked = 0;
    			}
    			// See if the customer has purchased from us before
    			// Customers are identified by either their customer ID or name or email address
    			// If the customer has an order with items that match the current order, assume
    			// order completed, bail on this entry!
    			$orec = $db->Execute('SELECT orders_id, orders_status
    														FROM ' . TABLE_ORDERS . '
    														WHERE (customers_id = ' . (int)$curcus . '
    																		OR customers_email_address like "' . $basket->fields['customers_email_address'] .'"
    																		OR customers_name like "' . $basket->fields['customers_firstname'] . ' ' . $basket->fields['customers_lastname'] . '")
    															AND date_purchased >= "' . $basket->fields['customers_basket_date_added'] . '"' );
    			if ($orec->RecordCount() > 0) {
    				// We have a matching order; assume current customer but not for this order
    				// Now, look to see if one of the orders matches this current order's items
    				while(!$orec->EOF) {
    					$ccquery = $db->Execute('SELECT products_id
    					                         FROM ' . TABLE_ORDERS_PRODUCTS . '
    					                         WHERE orders_id = ' . (int)$orec->fields['orders_id'] . '
    					                           AND products_id = ' . (int)(int)$basket->fields['products_id'] );
    					if( $ccquery->RecordCount() > 0 ) {
    						if( $orec->fields['orders_status'] > RCS_PENDING_SALE_STATUS )
    							$checked = 0;
    						// OK, we have a matching order; see if we should just skip this or show the status
    						if( RCS_SKIP_MATCHED_CARTS == 'true' && !$checked ) {
    							$skip = true; // reset flag & break us out of the while loop!
    							break;
    						}
    					}
    					$orec->MoveNext();
    				}
    				if( $skip )
    					continue; // got a matched cart, skip to next one
    			}
    			// flag this customer to be auto-processed
          if ($checked) $custArray[] = $curcus;
    		}
    
    		$basket->MoveNext();
    	}
      if (sizeof($custArray) > 0) {
        echo 'Preparing to send emails to ' . sizeof($custArray) . ' recipients ...' . "\n";
        rcs_send_recover_cart_emails($custArray, RCS_BASE_DAYS, ' ', ' ', EMAIL_TEXT_SUBJECT, STORE_OWNER_EMAIL_ADDRESS);
        // rcs_set_contacted($custArray, FALSE);
      } else {
        echo 'No recipients to process.' . "\n";
      }
    
    }
    
    define('RCS_TEXT_MESSAGE_SAMPLE', 'Please pardon the interruption.  We noticed that you began a shopping session at our store, but did not complete your checkout.  If you encountered a technical problem, please telephone us at the number below so we can help you finish your purchase or answer any questions you may have about our products. ' . "\n\n" . 'If you abandoned your shopping cart in favor of better prices elsewhere, please let us know so we can have an opportunity to match or better those prices.' . "\n\n" . 'If you left your shopping cart for a more opportune time, we invite you to come back and complete your shopping session. We understand that sometimes it\'s not convenient to complete a purchase because of distractions or not having payment details handy.  If that\'s the case for you, please consider this just a friendly reminder that  your shopping cart is still sitting here waiting for you. ' . "\n\n" . 'Once again, please pardon us for sending you this email. We simply want to make sure your shopping experience with us is as efficient as possible.  We will not be bothering you about this particular shopping session again.' . "\n\n" . 'Have a great day!');

  4. #314
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Recover Cart

    tmdelia,

    So are those the only files (2 total) that are used? I noticed the addition to the admin auth file for bypassing the authentication but was curious as to where that was placed in the file?

    This is an interesting mod that I have been looking at using for sometime but wanted to make sure I have all the components in place.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  5. #315
    Join Date
    Dec 2008
    Location
    California
    Posts
    102
    Plugin Contributions
    0

    Default Re: Recover Cart

    Hello

    First let me say I love this mod. Thank you for it.

    I have a store built with 1.3.9d. I installed Recover Cart and it did not work. So I found the Upgrade Sql. I have tried running it from the Admin Install Sql Patches both using the upload and then just pasting the Sql Statement into the box. Both times I received this error

    "1062 Duplicate entry 'RCS_CHECK_REPEAT' for key 'unq_config_key_zen'
    in:
    [INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Ignore Repeat Customers', 'RCS_CHECK_REPEAT', 'false', 'Setting this to true will cause recover cart sales to ignore abandoned carts by repeat customers', @configuration_group_id, 45, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
    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."

    I dont know anything about SQL. Can someone point me in the correct direction to fix this issue.

    Thanks in advance

  6. #316
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Recover Cart

    Quote Originally Posted by danilyn22 View Post
    Hello

    First let me say I love this mod. Thank you for it.

    I have a store built with 1.3.9d. I installed Recover Cart and it did not work. So I found the Upgrade Sql. I have tried running it from the Admin Install Sql Patches both using the upload and then just pasting the Sql Statement into the box. Both times I received this error

    "1062 Duplicate entry 'RCS_CHECK_REPEAT' for key 'unq_config_key_zen'
    in:
    [INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Ignore Repeat Customers', 'RCS_CHECK_REPEAT', 'false', 'Setting this to true will cause recover cart sales to ignore abandoned carts by repeat customers', @configuration_group_id, 45, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
    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."

    I dont know anything about SQL. Can someone point me in the correct direction to fix this issue.

    Thanks in advance
    This just means that you already ran that portion of SQL and that it won't re-add that item to the database. No need to worry about the error, it shouldn't affect the performance of the mod.

    So, you say it doesn't work. To help you better let me know what seems to not work with the mod and I'll see if I can get you up and running. It should work on 1.3.9 just fine (got it running on that version on a few sites.)
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  7. #317
    Join Date
    Dec 2008
    Location
    California
    Posts
    102
    Plugin Contributions
    0

    Default Re: Recover Cart

    Thank for helping. I am not getting an error but I am not getting anything showing up. I placed an order for myself and abandoned the cart, and it did not show up in Tools/Recover Cart Sales. I use it for a different ZenCart Store (1.3.8) and it works great but on this one I am getting nothing.

    How can I tell if the sql Update actually took?

  8. #318
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Recover Cart

    A couple things to look at (comparing the two sites).

    1) Are PHP versions the same on both sites?
    2) Is the MySQL version the same on both sites?

    In response to your question:

    If you look in your DB and see the table 'scart' AND if you log into your admin and look at the "Configuration" menu item (you should see a "recover cart sales" option) then the SQL took ok.

    I don't think that is your issue. If the SQL did not take you would be getting other errors when it tried to run saying "tables were missing etc..." and that is not the case.

    Did you make sure that you in fact did upload all files and that they are in the correct directories? I would double check that as another alternative just to cover all the bases.

    Try this (if you already haven't).

    Add an item to your cart ... login to your test account and then exit the page (close the browser.) I just want to see if it is indeed going to catch the abandon this way. You'll have to wait a while (up to 20 minutes possibly) for the record to show in the abandon carts area. This is because the session has to die for it to be placed in the abandoned carts area.


    Check the abandoned carts tolls area to see if the record shows. make sure you have the days set to something that will pick it up (something other than "0" of course).

    As a final test, check your settings in the Configuration > Recover Cart Sales section.

    For testing set the following:

    Ignore Customers with Sessions = FALSE

    Skip carts w/Matched Orders = FALSE (I recommend you set this to "true" in a live environment after testing is complete.)

    And if you really want to see if it is recording data, look into the "scart" table mentioned earlier to see if it contains records. If so the system is working ... you just have to find the right settings to make it show.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  9. #319
    Join Date
    Dec 2008
    Location
    California
    Posts
    102
    Plugin Contributions
    0

    Default Re: Recover Cart

    Thanks econcepts

    I went through all your steps and checked everything. Finding nothing wrong I redownloaded and reinstalled the whole Mod and IT WORKED!! Yippee. Thanks for taking the time to help me.

  10. #320
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Recover Cart

    Quote Originally Posted by danilyn22 View Post
    Thanks econcepts

    I went through all your steps and checked everything. Finding nothing wrong I redownloaded and reinstalled the whole Mod and IT WORKED!! Yippee. Thanks for taking the time to help me.
    Super. It sounds like there may have been some missing or corrupt files from the original install.

    Glad you got it working.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

 

 
Page 32 of 67 FirstFirst ... 22303132333442 ... LastLast

Similar Threads

  1. Shipping Rates in Cart [support thread]
    By Steven300 in forum Addon Shipping Modules
    Replies: 95
    Last Post: 12 May 2023, 02:39 AM
  2. Shopping Cart Steps Images [Support Thread]
    By Trinity14 in forum Addon Templates
    Replies: 21
    Last Post: 11 Apr 2021, 05:35 AM
  3. v151 AJAX Add to Cart [Support Thread]
    By balihr in forum All Other Contributions/Addons
    Replies: 133
    Last Post: 20 Oct 2020, 02:16 AM
  4. Empty Cart Manager [support thread]
    By Steven300 in forum All Other Contributions/Addons
    Replies: 49
    Last Post: 26 May 2010, 10:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR