Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 12/08/2020 in all areas

  1. In the skin's config.xml, find the <image reference="category">. It is set for 800 pixels on the longest dimension. Change this to 900. It will auto-scale down to fit the container (which is 848 px wide). Next, you will need to find the CSS rule (I do not know where it would be.): .cat-hdr-img img { margin: 0px auto 5px; } Change to: .cat-hdr-img img { margin: 0 0 5px; } This CSS change will remove the margin that the browser adds to either side of the image, in equal part, to center the image in the slightly wider container. Be sure to clear Cubecart's cache.
    2 points
  2. You were absolutely correct @Al Brookbanks Yesterday - I tried to fix this by reinstalling 1.9.6 and got the same errors but 1.9.7 from today has solved it! Many thanks. Really helpful
    1 point
  3. you are a hero! - Thanks works perfectly under SMTP!
    1 point
  4. I have read that CC650+ works with PHP 8.3. (Currently, I cannot experiment with PHP 8.3 because my server's operating system is too old.)
    1 point
  5. Hey everyone, I recently discovered a fantastic way to elevate your gift-giving game: custom gift packaging! Whether it's for birthdays, weddings, or any special occasion, adding a personal touch to the packaging can make your gift stand out. I've been experimenting with different materials, designs, and embellishments, and it's been so much fun! Not only does it make the recipient feel extra special, but it also shows that you've put thought and effort into the presentation. Do you have any creative packaging ideas or tips to share? Let's inspire each other to spread joy through beautifully wrapped gifts!
    1 point
  6. I tried uploading a sscreenshot but server rejects it, error code 200. Instead: Product with webp image: https://cavalier-gift-shop.org/magic-puppy-valentine-s-card.html (fails) Product with a jpeg (any other product): https://cavalier-gift-shop.org/best-cavalier-mum-mug.html (all ok)
    1 point
  7. Brilliant, I changed a few lines and now it all looks pukka! Thanks again for all the help!
    1 point
  8. There are three phases to CubeCart's search function (four for CC650+). For short words, the last two phases will be the only ones to find that one short word: the whole word man, or the part of the word commander. (The first phase(s) will not look for a word with less than four letters.) CubeCart's search will look at the product's Name (Title), the Product Code, and the product's description. Therefore, if the last phase was the phase that actually found something, the irrelevant product shown might have had a word with the search term as part of it contained in its description. There was another conversation on the forums asking if it is possible to have CubeCart ignore looking at the product description for the search term. That can be done, but would require a code edit. As for the strange missing products that have "man" in the Name (or Title), perhaps we can explore why that is happening.
    1 point
  9. I am going to ignore the lines that appear to come from an SSL Cert manager. I just wanted to make sure there is an appropriate RewriteBase directive. It will be interesting as to what would be found in the web access logs.
    1 point
  10. Great! Thank you very much. It is working, I used the database credential and host localhost:9200. In the search box, to get the drop down list product, need to use mouse cursor. Can we add keyboard up,down to reach to the downward list instead of mouse cursor. Even after click outside of the search box, ES search dropdown list wont disappear. Need to used ESC key. It would be good idea to add one click functionality to clear search dropdown list like ESC key.
    1 point
  11. Did this transaction pass 3D secure? If so I believe it should be protected and you shouldn't be liable to chargeback fees. Our PayPal integration has much more granular settings. If you want to you can choose to only accept payments that pass 3D secure. With that setting enabled you are never liable to chargeback fees. The square extension could have this feature added.
    1 point
  12. In shipping.class.php: Find near lines 237-240: $this->debug(sprintf('<strong>&gt;&gt;&gt; Shipping zone [ID %s] matches the delivery address! Use this zone for shipping calculations.</strong>', $this->_all_zones[$i]['id'])); if ($this->_settings['multiple_zones'] == 'first') { $this->debug('Looking for first matching zone of best match (instead of searching for all matching zones - see AIOS module settings)'); } else { Change to: $this->debug(sprintf('<strong>&gt;&gt;&gt; Shipping zone [ID %s] matches the delivery address! Use this zone for shipping calculations.</strong>', $this->_all_zones[$i]['id'])); if ($this->_settings['multiple_zones'] == 'first') { $this->debug('Looking for first matching zone of best match (instead of searching for all matching zones - see AIOS module settings)'); $closest_match_zone_id = $this->_all_zones[$i]['id']; break; } else { The above is the exact same edit as was posted earlier, just the line numbers have changed.
    1 point
  13. Please reload this forum conversation. I made a mistake on the last line of the new code.
    1 point
  14. Yes, you can. Having different content implies having a distinct and separate database - or, at least a distinct table prefix (can be on the same database server).
    1 point
  15. I'm only running All in One Shipping v 1.0.24, Card Capture v 1.0.12, and Google Base v 1.0.3. So far, so good, but I'll keep an eye on them.
    1 point
  16. Image compression? CubeCart takes a source image, typically PNG or JPG, 750x750 pixels for example, then creates sized variants specific to the intended layout area and page. The source is uploaded to /images/source/, and CubeCart's variants are saved in /images/cache/. The specific variants are coded in the skin's config.xml file. Take a look a Foundation's config.xml file in a programmer's text editor. Here, you will find image nodes with the reference attribute indicating where the image is used. The product page uses 'medium' and 'gallery'. The maximum attribute specifies the length of the longest side, maintaining proportionality, but never longer than the original. (That is, if the source is 450x450 pixels, variants could be smaller, but will never be larger than that.) And, of course, the browser can scale the image to fit the layout's placement if the HTML coding allows it. Note also the quality attribute. For many image formats, there is the 'compression ratio', expressed as a 'quality' -- 100 being very lightly compressed, if at all, and 10 looking like crap. I have visited web pages that initially show a super-blurry image (high compression), then eventually, under javascript control, fetches a high-quality (large filesize) image to replace the blurry one. Currently, CubeCart does not do this.
    1 point
  17. Even though CC651 says it will run under PHP7.1+ (that statement is a bug), we very much recommend running PHP7.4, and highly recommend PHP8.1. That "unexpected =" error is from the new (as of PHP7.4) 'null coalescing assignment' operator. https://www.php.net/manual/en/migration74.new-features.php#migration74.new-features.core.null-coalescing-assignment-operator
    1 point
  18. You are getting the address items from the admin, Order Summary page? If so, try the following: In the admin /sources/orders.index.inc.php: Near line 419, find: $overview_summary['country'] = is_numeric($overview_summary['country']) ? getCountryFormat($overview_summary['country'], 'numcode', 'name') : $overview_summary['country']; After that, add: $overview_summary['state_abbrev_d'] = is_numeric($overview_summary['state_d']) ? getStateFormat($overview_summary['state_d'], 'id', 'abbrev') : $overview_summary['state_d']; $overview_summary['state_abbrev'] = is_numeric($overview_summary['state']) ? getStateFormat($overview_summary['state'], 'id', 'abbrev') : $overview_summary['state']; In the admin template orders.index.php: Near lines 163-164, from: {$OVERVIEW_SUMMARY.town_d|upper}<br> {if !empty($OVERVIEW_SUMMARY.state_d)}{$OVERVIEW_SUMMARY.state_d|upper}, {/if}{$OVERVIEW_SUMMARY.postcode_d}<br> To: {$OVERVIEW_SUMMARY.town_d|upper}&nbsp; {if !empty($OVERVIEW_SUMMARY.state_abbrev_d)}{$OVERVIEW_SUMMARY.state_abbrev_d|upper}, {/if}{$OVERVIEW_SUMMARY.postcode_d}<br> Near lines 174-175, from: {$OVERVIEW_SUMMARY.town|upper}<br> {if !empty($OVERVIEW_SUMMARY.state)}{$OVERVIEW_SUMMARY.state|upper}, {/if}{$OVERVIEW_SUMMARY.postcode}<br> To: {$OVERVIEW_SUMMARY.town|upper}&nbsp; {if !empty($OVERVIEW_SUMMARY.state_abbrev)}{$OVERVIEW_SUMMARY.state_abbrev|upper}, {/if}{$OVERVIEW_SUMMARY.postcode}<br>
    1 point
  19. Nice idea! In admin, Maintenance, Rebuild tab, there is a means to "Reset all product view counts". "Views" is one of the choices on what criteria to base a query for "Best Sellers" (aka Popular Products). But resetting Views might be overkill for some. I have in mind a text box next to Store Settings, Layout tab, "Source data for popular products" saying, "Within the past [###] days." This won't be a date range, but will this suffice for your needs?
    1 point
  20. I added more to my post above. Please reload this forum page. There is no urgency in removing the debugging code. It does not affect how CubeCart runs.
    1 point
  21. Please create the error log: https://forums.cubecart.com/topic/51550-how-to-create-the-error-log/ There may be clues to what is happening.
    1 point
  22. For version 1.05, there is a bug in the template box.template.php, near line 17: From: {if count($POPULAR > 1)} To: {if count($POPULAR) gt 1}
    1 point
  23. Please try this edit: In /classes/language.class.php, line 106: From: if(ADMIN_CP == false && isset($d[$url['host']]) && !empty($d[$url['host']])) { To: if( (!defined('ADMIN_CP') || ADMIN_CP == false) && isset($d[$url['host']]) && !empty($d[$url['host']])) {
    1 point
  24. Did you follow the steps in method 1? https://support.cubecart.com/hc/en-gb/articles/360003794198-How-do-I-upgrade-from-CubeCart-v6-to-latest-v6-
    1 point
  25. As per Al's comments on the github issue you raised, this is almost certainly down to a faulty or partially completed upgrade
    1 point
  26. Currently, no. But, CubeCart has the ability to respect a custom API call that a "cron job" would execute on schedule, as well as hooks that could be used every time that a web page is requested to update if a specified amount of time has elapsed since the last update.
    1 point
  27. Configuring Mod Security is a server administrator's responsibility. As best I know, Mod Security is configurable on a per site basis. Therefore, it may be the case that your other website may (or may not) have Mod Security installed, and/or configured differently. We would encourage you to contact your hosting provider for assistance.
    1 point
  28. If there is a blank page, then there could be error messages in admin, System Error Log.
    1 point
  29. In admin, Currencies, uncheck all currencies Status except INR. Save. In admin, Store Settings, General tab, Default Currency, choose INR. Save. Have CubeCart clear its internal cache.
    1 point
  30. Chaps.. This situation is embarrasing, I'm getting female members of my team telling me that they are receiving explicit messages from one of our contact forms. Can anyone suggest how I get invisible working, failing that I'll have to employ the services of a dev to write something which works.
    1 point
  31. Recently had to change the password on a friend's Outlook 2013 (which does not do OAuth like Thunderbird). Now, I have not actually done this for my development installations of CubeCart yet, but I have every expectation that this will work. What you need to do is to acquire an "app password" for your "less-than-secure" app (as Google puts it). See: https://support.google.com/accounts/answer/185833 To do this, you will need a cell-phone. In your GMail account settings page, find the Security section. Enable "Two-step Verification". (This is not as bad as it sounds.) This is only to verify that the person doing this process is, in fact, you. Google will text a code when you begin the process of generating an app password. There should now be a new option in the "Signing in to Google" section for App Passwords. Select this option. On the App Password page, choose Select App, and for the name of the app, choose something like FettleBox Store (something in one or two words to describe what you are to use this app password for). Then choose Generate. The 16-digit number in a yellow banner is what you will enter in CubeCart's SMTP Password field (the banner shows spaces between each set of four digits that are not part of the password - do not include the spaces). This is all how it worked for Outlook 2013. I expect it to also work when wanting to use GMail as the SMTP server for CubeCart.
    1 point
  32. Hi, I just tried this again with with PayPal Commerce 1.6.2 and still no joy, therefore I downloaded the 1.6.2 code to get a better look .. And this is what I found - /** * CubeCart v6 * ======================================== * CubeCart is a registered trade mark of CubeCart Limited * Copyright CubeCart Limited 2019. All rights reserved. * UK Private Limited Company No. 5323904 * ======================================== * Web: http://www.cubecart.com * Email: [email protected] * License: GPL-3.0 http://opensource.org/licenses/GPL-3.0 */ function ppcp_body_js($tpl_output, Smarty_Internal_Template $template) { $skins = $GLOBALS['gui']->getSkinData()['info']; // $skin = $GLOBALS['gui']->getSkinData(); if (($pp_config = $GLOBALS['cache']->read('pp_config.'.$skins['name'])) === false) { if(file_exists('modules/plugins/paypal_commerce/config.custom.json')) { $pp_config = file_get_contents('modules/plugins/paypal_commerce/config.custom.json'); } else if(file_exists('modules/plugins/paypal_commerce/config.'.$skins['name'].'.json')) { $pp_config = file_get_contents('modules/plugins/paypal_commerce/config.'.$skins['name'].'.json'); } else { $pp_config = file_get_contents('modules/plugins/paypal_commerce/config.foundation.json'); } $GLOBALS['cache']->write($pp_config, 'pp_config.'.$skins['name']); } if(isset($GLOBALS['cart']->basket['total']) && $GLOBALS['cart']->basket['total'] > 0) { $pp_amount = $GLOBALS['cart']->basket['total']; } else { $pp_amount = "null"; } return preg_replace('/\<\/body\>/i','<script id="pp_config" type="application/json">'.$pp_config.'</script><script> var pp_config = JSON.parse(document.getElementById(\'pp_config\').textContent) var pp_amount = '.$pp_amount.';</script></body>', $tpl_output); return $tpl_output; } $GLOBALS['smarty']->registerFilter("output","ppcp_body_js"); On about the third line of code you can see I have replaced a line. Now the thing is that this was never going to work the variable '$skin' is never referenced in the code so its clearly in error. The question is why did nobody else experience the same ? Its probably because, and this is just a guess, many other skins are strongly based upon the foundation skin, but as I say that's only a guess .. Anyway it seems to be working now but no production test yet.. Chris.
    1 point
  33. Thanks, I realised it but forgot to hide it!
    1 point
  34. In a stock install of CC6, the list of images to play in the slider is part of the HomePage document. In admin, Documents, click the Edit icon of the document shown as having the HomePage button selected. You may have an easier time of it by using the editor's Source mode. The slider is optimized to show 1000x300 pixel images.
    1 point
  35. That would be in the AIOS module's control panel. On the admin Navigation pane, click the Manage Extensions. From the list of extensions shown, click the Edit icon for All in One Shipping. On the module's administration control panel, General tab, Debugging, select "Debug Enabled (Verbose)".
    1 point
  36. I would say it is not the POF module contributing to this. Rather, the 'verification code' is CubeCart complaining that the reCaptcha gadget is not agreeing with the solution provided. It might not be displaying when it should be, or the customer worked out the puzzle, but the solution is not correct. Please verify that, in admin, Store Settings, Features tab, Bot Protection section, the reCaptcha is enabled as desired. Then, assure yourself that your browser is not blocking the javascript needed to fetch the reCaptcha gadget from Google.
    1 point
  37. Determine if the following statement already exists in the templates 'main.php' and 'main.checkout.php': <link href="{$ROOT_PATH}favicon.ico" rel="shortcut icon" type="image/x-icon"> If it is not there, add it just before the </head> tag. Next, acquire a square image you want to use. Upload it to a free online ICO file maker, such as: https://www.icoconverter.com/ Place the .ico file in CubeCart's main folder.
    1 point
  38. Hi Lyd, It is possible to add to the area you mention, however anymore than 3 can cause a layout issue on screens between 768px and 991px (the joys of responsive websites ) you can free up a bit of space by removing the "register" link and just have a login link (theres a register link on the login page and register options during checkout so no biggy) To Add A Page 1) Create a page (Admin > Documents > Create Document) When you create the document a link should appear in the footer of your site. Make a note of the link. 2) Open basix > templates > box.navigation.php Add your link (i've used Affiliates as an example) to the bottom of the list. <li itemprop="name"> <a itemprop="url" href="http://exmaple.com/CubeCart/affiliates">Affiliates</a> </li> and save. NOTE! The navigation file gets cached so you will need to clear your sites cache if you have the cache enabled. (You should have a Clear Cache button in your admin header) Remove Register Link (OPTIONAL - Upto you if you want to) basix > templates > box.session.php Find and remove <li itemprop="name"><a itemprop="url" class="parent-link" href="{$STORE_URL}/register{$CONFIG.seo_ext}">{$LANG.account.register}</a></li>
    1 point
  39. My bad. Replace that other new code with this new code: if (!empty($item['product_options'])) { $product['product_options'] = array(); if (($list = unserialize($item['product_options'])) !== false) { foreach ($list as $value) { $product['product_options'][] = $value; } } else { if(method_exists($order,'unSerializeOptions')) { $options = $order->unSerializeOptions($item['product_options']); } else { if(empty($item['product_options'])) { $options = array(); } else if(($options = cc_unserialize($item['product_options'])) !== false) { } else if (($options = cc_unserialize(base64_decode($item['product_options']))) !== false) { } else { $options = explode("\n", $item['product_options']); } } foreach ($options as $option) { $value = trim($option); if (empty($value)) continue; $product['product_options'][] = $value; } } $product['product_options'] = implode("\n", $product['product_options']); }
    1 point
  40. The POF module prior to 1.2.2 had its own code to email a courtesy email confirming the order was placed. Version 1.2.2 now is supposed to use the established code in CubeCart's core codebase. Looking at 1.2.2 (version 1.3.0 is the same), it seems more work needed was mentioned to the programmers, but didn't get done. So, please make this edit: In the Print Order Form module, gateway.class.php, near line 206, find: if (!empty($item['product_options'])) $product['product_options'] = implode(' ',unserialize($item['product_options'])); Change to: if (!empty($item['product_options'])) { if (($list = unserialize($item['product_options'])) !== false) { foreach ($list as $value) { $item['options'][] = $value; } } else { if(method_exists($order,'unSerializeOptions')) { $options = $order->unSerializeOptions($item['product_options']); } else { if(empty($item['product_options'])) { $options = array(); } else if(($options = cc_unserialize($item['product_options'])) !== false) { } else if (($options = cc_unserialize(base64_decode($item['product_options']))) !== false) { } else { $options = explode("\n", $item['product_options']); } } foreach ($options as $option) { $value = trim($option); if (empty($value)) continue; $item['options'][] = $value; } } }
    1 point
  41. I am wondering if, somehow perhaps a bug in the code, installing de-DE "over" the existing de-DE language pack, didn't actually overwrite the existing databased content of the email-contents with the contents of the new file of that incoming language pack. (Unlike the language phrases that exist in a file in a language pack, the phrases of the email-contents file of the language pack are all databased.) I will check on that. In the meantime, you can sort the above listing and delete all rows having 'content_id' equal to or greater than 26.
    1 point
  42. He is also trying to fix the "remove item" bug.
    1 point
  43. @radman bare with me, i'll pop @havenswift-hosting a message to get his take on it. If it is a caching issue he'll know more about it.
    1 point
  44. We don't have a partnership with Adyen but it's not required. They have exceptional documentation and the integration has been tested under their sandbox. Please do let us know how you get on. Where are you referring to when you say no documents on the CubeCart page? We will reach out to Adyen to see if we can get our integration certified.
    1 point
  45. I found it! was in navigation.ss and .top-bar-section! I am so rusty on this kind of work! Thanks for the help
    1 point
  46. Seems like I got this working now! This is how I made my filemanager.class.php file to look like: class FileManager { private $_directories; private $_mode; private $_manage_cache; private $_manage_dir; private $_manage_root; private $_recently_uploaded = array(); private $_sub_dir; private $_sendfile = false; //private $_max_upload_image_size = 350000; private $_max_upload_image_size = 6291456; // 6MB public $form_fields = false; Thanks!
    1 point
  47. Hi, Wish to make the sales report with the product details, which sql should I edit on? "product_code" is a new attributes that I add in, since it is not inside the table "CubeCart_order_summary". Actually, it is from table "CubeCart_order_inventory". And, How to sum the product_code? As the product code is in integer, digit form. The below code is from admin_LsSCSi/sources/reports.index.inc.php $fields = array( 'title', 'cart_order_id', 'product_code', 'order_date', 'status', 'subtotal', 'discount', 'shipping', 'total_tax', 'total', 'customer_id', 'first_name', 'last_name', 'company_name', 'line1', 'line2', 'town', 'state', 'country', 'postcode', 'title_d', 'first_name_d', 'last_name_d', 'company_name_d', 'line1_d', 'line2_d', 'town_d', 'state_d', 'country_d', 'postcode_d', 'phone', 'email', 'gateway' ); foreach ($GLOBALS['hooks']->load('admin.reports.order.pre') as $hook) include $hook; $orders = $GLOBALS['db']->select('CubeCart_order_summary', $fields, $where); foreach ($GLOBALS['hooks']->load('admin.reports.order.post') as $hook) include $hook; if ($orders) { ## If we are wanting an external report start new External class if (isset($_POST['external_report']) && is_array($_POST['external_report'])) { $module_name = array_keys($_POST['external_report']); $external_class_path = 'modules/external/'.$module_name[0].'/external.class.php'; if (file_exists($external_class_path)) { include $external_class_path; $external_report = new External($GLOBALS['config']->get($module_name[0])); } } ## Tally up totals $tally = array(); $i = 0; foreach ($orders as $order_summary) { $order_summary['status'] = $lang['order_state']['name_'.(int)$order_summary['status']]; foreach ($order_summary as $field => $value) { if (in_array($field, array('subtotal', 'discount', 'shipping', 'total_tax', 'total'))) { if (!isset($tally[$field])) $tally[$field] = 0; $tally[$field] += $value; } } $order_summary['country'] = (is_numeric($order_summary['country'])) ? getCountryFormat($order_summary['country']) : $order_summary['country']; $order_summary['state'] = (is_numeric($order_summary['state'])) ? getStateFormat($order_summary['state']) : $order_summary['state']; $order_summary['country_d'] = (is_numeric($order_summary['country_d'])) ? getCountryFormat($order_summary['country_d']) : $order_summary['country_d']; $order_summary['state_d'] = (is_numeric($order_summary['state_d'])) ? getStateFormat($order_summary['state_d']) : $order_summary['state_d']; $order_summary['date'] = formatTime($order_summary['order_date'],false,true); ## Run line of external report data if (isset($external_report) && is_object($external_report)) $external_report->report_order_data($order_summary); unset($order_summary['order_date'], $values); foreach ($order_summary as $field => $value) { if ($i == 0) $headers[] = $field; $values[] = (is_numeric($value) || !strpos($value, ',')) ? $value : sprintf('"%s"', addslashes($value)); } if ($i == 0 && $add_headers) $data[] = implode(',', $headers); $data[] = implode(',', $values); $smarty_data['report_date'][] = $order_summary; $i++; } $GLOBALS['smarty']->assign('REPORT_DATE', $smarty_data['report_date']); if (isset($_POST['download']) || (isset($_POST['external_report']) && is_array($_POST['external_report']))) { $GLOBALS['debug']->supress(true); if (isset($_POST['download'])) { $file_content = implode("\r\n", $data); $file_name = $lang['reports']['sales_data'].' '.$download_range; } else { $file_content = $external_report->_report_data; $file_name = ucfirst($module_name[0]).' '.$lang['reports']['data'].' '.$download_range; } deliverFile(false, false, $file_content, $file_name.'.csv'); exit; } ## Show table footer $tally['orders'] = count($orders); foreach ($tally as $key => $value) { $tallyformatted[$key] = ($key=='orders') ? $value : sprintf('%.2F', $value); } $smarty_data['tally'] = $tallyformatted; $GLOBALS['smarty']->assign('DOWNLOAD', true); ## Get external module export code $where = array('module' => 'external', 'status' => '1'); ## Start classes for external reports if (($module = $GLOBALS['db']->select('CubeCart_modules', 'folder', $where)) !== false) { foreach ($module as $module_data) { if(file_exists(CC_ROOT_DIR.'/modules/external/'.$module_data['folder'])) { $module_data['description'] = ucfirst(str_replace('_',' ',$module_data['folder'])); $smarty_data['export'][] = $module_data; } } $GLOBALS['smarty']->assign('EXPORT', $smarty_data['export']); } } else { if (isset($_POST['download'])) httpredir(currentPage()); $smarty_data['tally'] = array('orders' => 0); } $GLOBALS['smarty']->assign('TALLY', $smarty_data['tally']); $GLOBALS['smarty']->assign('POST', $report_filter); foreach ($GLOBALS['hooks']->load('admin.reports.order.filter') as $hook) include $hook; Thanks~
    1 point
  48. If i enter in to admin > products and bring up a list of products, there's no indication which items are discounted or on sale. So the only way to see which items we have listed on sale is via the customer side. Am i missing something obvious ?
    1 point
  49. im coming in late on this...but I do this every 6 months. First time I did it there were like 8,000 of those 'fake' customers. Here is the SQL command I used in phpmyadmin on my granny version 3.0 store: DELETE FROM `CubeCart_customer` WHERE noOrders = 0 AND regTime < 1454012330; Since you are running 6.0 then you would probably run it like this: DELETE FROM `CubeCart_customer` WHERE order_count = 0 AND registered < 1460000000; or even better: DELETE FROM `CubeCart_customer` WHERE order_count = 0; It will clean house in a second! i like to put a timestamp on it so that if someone has been shopping in the past two weeks and havent donea checkout yet and are still thinking...then they wont be lost and end up having to reregister.
    1 point
×
×
  • Create New...