Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 05/14/2018 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. The developer will probably / should be releasing a new version of the skin to take account of all of the skin changes included in this recent version. However, if you are using a modified version, then that update will not automatically apply to your store and you should chat to the developer about this. If you dont make all the front end skin changes then you wont be able to take advantage of any fixes / new functionality that has been added - you may say that you dont need this functionality but it is always best to stay fully up to date because the situation simply gets worse and worse with each upgrade that is released - this is the problem with having custom changes
    2 points
  3. From what I see, the CBurst "View Product" page will show a "Swipe Gallery" if there are more than one image assigned to the product. (This is not images assigned to options.) If there is only one main image assigned to the product, there is no gallery. (The images posted above suggest there is more than one image assigned to that product.) So, there are edits that need to be made to the skin so that "Images Assigned to Options" feature will work. But not on a Gallery. I will post what those edits are soon. (There also seems to be a problem with some CSS code bleeding over into the Short Description area.)
    1 point
  4. Yes please use SagePay-1.0.13.zip. It should be fine with PHP 7.2 but 7.4 would be safer.
    1 point
  5. The knowledgebase article that (sparsely) covers this is: https://cubecart.zendesk.com/hc/en-gb/articles/360003794038-How-do-I-create-a-new-front-end-dynamic-section-or-page (Ignore the mention about the encoded index file.) A deeper discussion can be had here on the forums.
    1 point
  6. Brilliant, I changed a few lines and now it all looks pukka! Thanks again for all the help!
    1 point
  7. 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
  8. 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
  9. 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
  10. Why, why, why you have to be so smart @bsmither? That's exactly what the issue was, since initially they both had the same route /powerball the system added a re-direct when leaving blank, creating the redirection. Is there a module, under product page, tab #product spec, to have custom stuff? I could jam everything into the actual product page but it would be cool to add some custom stuff, in our case we don't need to specify the code or if it's new or used. Thanks again kid, Happy Thanksgiving of whatever you celebrate today!
    1 point
  11. Another popular open source cart that brought v4 out recently had also taken PayPal Std out (and a few other things), has found a considerable number of its members have now reverted back to using the earlier v3, which also has a separate branch on Github, where developers have now upgraded it so it will run on PHP 8. Say what you will, but people like to have choices. Interestingly enough, whilst using another cart solution last week and going out to PayPal using Std PayPal on PayPal live site, that also brought up the option to pay later? That certainly not something that has ever shown up on there before. I will contact PayPal myself, to ask why they asking people to agree to an undisclosed partnership 'agreement' when signing up to PayPal Commerce (on any platform), as that just not right. Absolutely no mention of rates, extra charges, changes to seller responsibilities or anything else. Not good.!
    1 point
  12. Have done that for you on Github now. Hopefully that can be sorted, as those skins are a big plus.
    1 point
  13. 1 point
  14. 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
  15. You can check your "includes/global.inc.php" file it will have the link to the admin page in it, $glob['adminFile'] = 'admin_xxxxx.php';
    1 point
  16. You might be able to set identifier exists = false in the feed rules on Google's end:
    1 point
  17. Thank you. By way of a bit of background for you. In the early stages of our online shop journey we checked out many different platforms including some of the well known names such as ZenCart. We found the setup of these other platforms to be quite difficult and certainly not as well organised and intuitive as CubeCart. The ease of setup and the organised admin area were the main reasons for us deciding to go with CubeCart, a good decision and we look forward to using it for a long time to come. These forum pages have been a big help, we really appreciate you being there and the assistance you provide, keep up the good work because no doubt I'll be back
    1 point
  18. Hi, I upgraded to 6.4.6 and everything seems ok except the extra images aren't showing in admin/products Oh, and the word location is mispelled in the dropdown Nevermind it has something to do with my custom admin skin. I'll figure it out Thanks anyway
    1 point
  19. Brains suggestion is definately the way to go initially. Create a new file ini-custom.inc.php in the root of your store. I did have issues with the memory size when i did this, so you might want to play with this. <?php # Custom initialization commands # Filename: ini-custom.inc.php # File location: main CubeCart folder ini_set('memory_limit', '256M'); ini_set('max_execution_time', '60'); ini_set('error_log', 'error_log'); ini_set('log_errors', 'on'); ?> To add to this, Cubecart support is extermely fair. You'd be hard pushed to find dedicated product support at such a price anywhere else. https://www.cubecart.com/technical-support
    1 point
  20. Attached is a follow-on report for more edits needed to make CC645 run under PHP 8.1 - attempting to eliminate (at least minimize) the numerous error messages that PHP logs. Some of these edits assume that the edits and file replacements found in the prior report have already been made. PHP8.1_Changes2.txt.zip
    1 point
  21. 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
  22. 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
  23. The way I do it for now is... Post the video on youtube, then choose: share embed copy Then move over to your product page description press source (upper left) scroll down where you want the video paste press save enjoy Example https://vleesvoordier.nl/webshop/riverwood-snacks (done in the category for example)
    1 point
  24. 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
  25. I had issues with SendinBlue. I don't recall the exact scenario, but it went along the lines of them rejecting my mailing campaign half way through sending. I quickly spent my credits and went elsewhere. Moosend is perfect for our requirements, although they are fussy with certain address uploads.
    1 point
  26. Name: AA Basic Blue Price: $14.99 Category: Skins Homepage: https://www.cubecart.com/extensions/skins/basic-blue
    1 point
  27. Sorry for the delay. One option would be to use the HTML <video> element in your category description. So you would upload a mp4/webm or ogg video to your site then when writing your description click the source button on the text editor and use something like <video> <source src="catvideo.mp4" type="video/mp4"> Your browser does not support the video tag. </video> Only issue is you'd have to play around with adding some other html and styling to try and get the layout right. Alternatively you could add a button and have the video load in a pop-up modal.
    1 point
  28. Hi, Without knowing anything about the images (size ect) you intend to use i can only give a vague example. Assuming the images you plan on using are all the same size/dimensions then you could do something like: 1) Upload the 4 images to your site (for the example below i've used square images and uploaded them to root > images > source ) 2) Admin > Documents > Select the document which is your homepage 3) Select the "Content" tab and then click the "Source" button on the text editor. 4) Add some html to display your image "buttons" - For the example i am using square images so layout might need changing if you use rectangular images. <div class="home-blocks"> <div class="row"> <div class="col-xs-12 col-sm-3"> <a href="http://www.google.com"> <img class="img-responsive" src="images/source/mens_sale.png" title="Shop Mens Sale" /> </a> </div> <div class="col-xs-12 col-sm-3"> <a href="http://www.google.com"> <img class="img-responsive" src="images/source/womens_sale.png" title="Shop Womens Sale" /> </a> </div> <div class="col-xs-12 col-sm-3"> <a href="http://www.google.com"> <img class="img-responsive" src="images/source/childrens_sale.png" title="Shop Childens Sale" /> </a> </div> <div class="col-xs-12 col-sm-3"> <a href="http://www.google.com"> <img class="img-responsive" src="images/source/clearance.png" title="Clearance Sale - All Stock Must Go!" /> </a> </div> </div> </div> 5) Add a small bit of css When adding custom css styling i recommend you create a custom css file so that they don't get lost during any updates. To create a custom css file go to skins > basix > css and make a copy of the cubecart.default.css file and rename it cubecart.custom.css Open cubecart.custom.css and add the following .home-blocks{ text-align:center; } .home-blocks a { display:inline-block; margin: 10px 0px; } .home-blocks a img{ max-width:100%; } @media (max-width: 767px){ .home-blocks .col-xs-12 { width: 50%; } } then go to skins > basix > templates > element.css.php and add <link rel="stylesheet" href="{$ROOT_PATH}skins/{$SKIN_FOLDER}/css/cubecart.custom.css"> And clear your site cache via your admin panel.
    1 point
  29. Hi Lyd, If you edit the page/document via the admin panel "status" should be ticked and "Show link to document in storefront?" unticked. This should hide the link in the footer but leave the content accessible by the new nav link. If you are linking to a category, don't create a new page/document as stated in step 1. Simply just do step 2 and use the url for the category for the link. Thanks.
    1 point
  30. 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
  31. 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
  32. 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
  33. Please confirm that there are more than one image associated with a product being tested.
    1 point
  34. Hey @radman The W3W compatibility notice in the admin panel is cosmetic - Providing you enter your W3W info it will work as intended. It's just in the admin panel it looks for a certain skin file to determine whether or not its compatible, however for the updates i approached it differently so the certain skin file isn't there. As for the other issues, i can only assume something might have been edited incorrectly during your update, i can't seem to load your site (503 Service Unavailable) at the moment so i can't check whats going on.
    1 point
  35. @radman420 by data issue i mean that it would appear no data (in this case Products) is been supplied to the $POPULAR variable which is used to load the popular products section. Since it appears to happen in both the Foundation and Amzin skin that would suggest that it isn't caused by the skins. All i can suggest is pop a message in Technical Help section as this is beyond a skin issue. Perhaps something went wrong during the CubeCart Update or a setting has changed. I'm running 6.4.1 with Amzin and Foundation and the popular box is loading fine so i'm not sure whats causing yours to not load since you updated.
    1 point
  36. Hey @radman420 Just checked your site and theres no trace of the missing box so i can only assume that no data is been passed to $POPULAR used for it. Does it reappear if you switch to the foundation skin?
    1 point
  37. You can see the manual update guide for Amzin at http://nitefox.x10host.com/docs/ManualUpdates/amzinguide.html - The latest update (V1.03) is mainly a compatibility update for CubeCart 6.4.0/6.4.1
    1 point
  38. Hey, In relation to my answer to your previous question of "Can the core script be updated manually?" By "modified version of CubeCart" i mean if you have manually edited any of CubeCart's core script files. Using the upgrade option in the admin panel may cause the loss of any custom edits made to the core files. In relation to Extensions such as Skins, if you modify them (Change colours by editing the css files, manually add additional html etc) then it's advisable that you do not use "install tokens" to install new versions of the skin as you will lose any previous edits to the skin. CubeCarts Install Tokens basically pulls the full new version of the extension (skin) from CubeCart servers and extracts it over the existing version (replacing the existing files with new files - restoring the skin back to its default version) but also merges so any extra files are not lost. Which is why i now do a manual update guide for any updates to my skins as most people modify the colour scheme at the least. If that makes sense.
    1 point
  39. You can do if you're comfortable with it and familiar with github. You'd need to look over at cubecarts github and see what issues have been resolved and look at the code changes needed. Editing the core script can get messy if you lose track of what you're doing. Far more simpler to just update the normal way unless your site is running a modified version of cubecart and you don't want to lose those edits (not including 3rd party skins as those are unaffected by core updates).
    1 point
  40. Hi Rich, There will be an update for my skins at the weekend to cover changes in the latest version of CubeCart. As you have a modified version of the skin you can make use of the manual update guide to apply any front end updates you wish to add your site. As @havenswift-hosting says its best to keep upto date, especially with the cubecarts core script. However, ultimately that is your decision
    1 point
  41. Thanks @bsmither for helping out while i catch some Joys of timezones.
    1 point
  42. Thank's Al. I reinstalled and it seems to be fine now. Thanks for your help too Noodleman!
    1 point
  43. Congratulations Al
    1 point
  44. OH!!! Congratulations to both of you!! I was hoping you were offline because your baby had come!
    1 point
  45. Hi Coders! I am in the need of a couple of modifications. The website concerned is http://www.firstchoicemobility.com I currently have a large dropdown menu that works fine apart from when the web browser is resized. the text then gathers up on the left hand side. Apparently this is because the coding used (Isotope) for the menu should not be used like that so there is no fix. So I would like a new menu created the same without the browser resizing issue. The ability to print off or save a PDF of a product page (I have a sample of what i would like the layout to look like) The ability to re-order images to display on the product page in the order i wish. Please contact me if you are able to carry one or all of the modifications. Thank You Gary
    1 point
  46. Please delete the unique key 'custom_oid' on the CubeCart_order_summary table. And replace it with a standard key or normal index. This was a bug in the beta.
    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. 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
  49. Hi, I was just wondering if Cubecart is compatible with Apple's iPad and iPhone? I've had several customers tell me that they can not place orders using these devices... I also had a lady tell me that she couldn't email me using her iPhone either (it bounced back)...hmmm Thanks.
    1 point
×
×
  • Create New...