Eduard J

Hi, I'm facing trouble to implement push data layer code for each page I want to track via GTM. Want to create funnel from add to basket ---> purchase through out the all stages. Here is so far what I have and it is showing as custom event in GTM, but I'm unable to get information such as product name, qty, item price etc. {literal} <script> window.dataLayer = window.dataLayer || []; dataLayer.push({ ecommerce: null }); // Clear the previous ecommerce object. dataLayer.push({ 'item': 'how to pull from page', 'quantity': 'how to pull from page', 'value': 'how to pull from page', 'event': 'begin_checkout' }); </script> {/literal} If anyone has experience with this I would appreciate sharing it. Thanks

Hi, I've updated cubecart to latest version 6.2.6 and PHP version to 7.3 , since than experiencing issue with google adwords tracker : Google_Adwords/hooks/class.gui.javascripts.php:37 - Function create_function() is deprecated Can anyone help me with this, is not recording my conversions for my adwords campaigns. Thanks

HI, The issue with an error on database is that i have prefix on tables, and in cubecart class code is writen to join 2 tables, so i had to manualy add prefix to the cubecart class.

Hi, I've done the check you have asked for and this is result code, this code comes up every time when i add item to basket : ReferenceError: jQuery is not defined 3f0e7.js_foot.foundation_20180425101121.js:1:5512 ReferenceError: $ is not defined www.superledlights.co.uk:9:1 Not sure what it means, any suggestion ? Thanks

Hi, That's what I thought, but my main issue is that 6.2.0 foundation skin has problem with basket not redirecting ( empty link), it seems there is java script problem but not sure where, even with an error i get on database i get orders through ok.

Hi, I've seen someone had same issue with updated to latest version, I followed instructions via FTP to update, when i add item to basket and try to click on it i get: /# instead of redirecting link. Currently i'm using faundation skin from 6.1.15 which seems to work but there is system error msg : File: [cubecart.class.php] Line: [1280] "SELECT `I`.`product_id`, `C`.`cat_name` FROM `CubeCart_category_index` AS `I` INNER JOIN `CubeCart_category` AS `C` ON `I`.`cat_id` = `C`.`cat_id` WHERE `I`.`product_id` IN (218) AND `primary` = 1 ;" - Table 'xxxxx.CubeCart_category_index' doesn't exist I guess it might be due to faundation skin used from previous version.

Hi, yes i've done exactly the same thing a while back, this option seems to work best. Thanks for your update it should help others too.

Hi, For some reason this queries don't work anymore : For 1st one to run i get error message Duplicate column name 'time' (ALTER TABLE `shop1_CubeCart_order_summary` ADD `time` DATE NULL;) than for 2nd part it says table does not exist, not sure what that could be, any idea ?

See noone had time to look into it, I spent some time on it and so far menaged to remove it for unregistered users but still having trouble with users who wants to register tried to edit content.addressbook.php with no luck maybe somebody can point me to right direction. Here is so far what i've done : order.class.php - removed 271 'state' => getStateFormat($order_summary['state']), 284 'state' => getStateFormat($order_summary['state_d']), content checkout.confirm.php - removed 21 {$DATA.state}, 39 {$address.state} 53 {$BILLING.state}, 69 {$DELIVERY.state}, 147 hidden 202 hidden content.address.php - removed 29 {$address.state},<br/> cubecart.class.php removed 963 'state_id' => $_POST['billing']['state'], 'state' => getStateFormat($_POST['billing']['state'], 'id', 'name'), 'state_abbrev' => getStateFormat($_POST['billing']['state'], 'id', 'abbrev'), 1000'state_id' => $_POST['delivery']['state'], 'state' => getStateFormat($_POST['delivery']['state'], 'id', 'name'), 'state_abbrev' => getStateFormat($_POST['delivery']['state'], 'id', 'abbrev'), Main issue is when customer has no state updated in his paypal account for express checkout it jumps to address book asking to ad it which delays whole and easy quick checkout.

Hi, I've been trying to remove state/county from checkout form page, up until now all i had to do is change cubecart/validate.js file for state from true to false and it has been working fine, but when i change it now i get stuck on checkout page. When i hit the checkout button for few seconds it will redirect me to next page and jumps back. Also tried to hide it from checkout.confirm.php file but get same result. It would be really helpfull to resolve this, choosing from dropdown list makes customers not friendly experience at checkout. I'm using foundtation skin and also lookup address,county in UK is no longer required. Any advise will be appreciated.

strange not sure than what it could be is not just me having trouble to checkout is customers also as a guest not registered customer. PS: i'm always logged out from admin when testing + always in different browsers too to see result. will have to give it a go and play arround. thanks anyway

yes, i thought the same, it worked for me when i forced make a payment button on mobile and pc, I use livechat where i can monitor traffic and just this moring had arround 10 orders where they've been stucked on make a payment page. than i tried it in incognito page my self (chrome) and could not checkout. so there must be still something causing an issue. have removed coupon and my orders are getting through just fine. PS: were you able to update to 6.1.1 via admin page ? as i tried it on 2 sites i have and when i got to update page in admin 6.1.1 disappeared so I did manual update via FTP.

Hi, tested new version 6.1.1 where coupon code should be fixed, but i'm still getting same problem customers cannot checkout using paypal or sagepay, it just reloads make a payment page. doeas anyone has same problem ? tried to revert code as dirty butter suggested to 6.0.12 and still same error.

HI, Great it works just a treat. Is there any chance I only pull out 'Order Complete' orders instead of all of them pending, cancelled etc. Many thanks for your help, made my life much easier.

Hi, Thanks for update, not sure where to update above, is there any chance you can update it to my query above so I see where " FROM_UNIXTIME" goes same for date range. Not very good at databases

I need a little help with final touch on mysql query, I managed to get report as i need but I'm unable to work out how to add date range for the report, tried so many varieties and still no luck, any help would be really appreciated. Here is so far what I've done : SELECT order_date, shop1_CubeCart_order_inventory.cart_order_id AS 'Order ID', first_name AS 'Name', last_name AS 'Surname', email, shop1_CubeCart_order_inventory.name AS 'Product Name', quantity, price, discount, shipping FROM shop1_CubeCart_order_summary INNER JOIN shop1_CubeCart_order_inventory ON shop1_CubeCart_order_inventory.cart_order_id = shop1_CubeCart_order_summary.cart_order_id; Also tried by order ID as it is actually a date and time when order was placed but with same error.

Hi, Thanks for reply, already done that what it will do is make grid view product only one per line when it loads the page messes up the style of the grid. Not sure why. also where do i delete the cookie product_view from ?

I'm having some troubles to make grid view as default in category page, changed following code in content.category.php : From : <dd><a href="#" class="grid_view"><i class="fa fa-th-large"></i></a></dd> <dd class="active"><a href="#" class="list_view"><i class="fa fa-th-list"></i></a></dd> To: <dd class="active"><a href="#" class="grid_view"><i class="fa fa-th-large"></i></a></dd> <dd><a href="#" class="list_view"><i class="fa fa-th-list"></i></a></dd> this only changes to icon of grid view but still displaying list vew of the products. ​Also have checked JavaScript in /js/2.cubecart.js but cannot locate default setting to change from list view to grid view.

​Ok so no one seems to have issue with that, I have played around and turned whole store to SSL, after that secure checkout worked just fine, when I got to payment page and cancelled transaction there was no return call for order to show up as cancelled in admin section. Switching back to SSL only on sensitive pages update basket and secure checkout does not work. I'm not sure what causing this issue, but I think it should be look into.

I have a latest V6 store currently in offline mode for testing and payment getaways paypal express and sagepay in testing modes as well, express checkout seems to work fine but when trying to checkout with sage pay after entering all billing details and verifying recaptcha it won't allow me to do so, nothing happens when I click secure checkout button. one more thing when I add allowed zone UK it won't show payment method on checkout page. Any suggestions will be appreciated.

Hi, I'm trying to move from V4 to V6 so far what I come up with is this : //Rewrite to www Options +FollowSymLinks RewriteEngine on RewriteCond %{HTTP_HOST} ^yourdomain.com[nc] RewriteRule ^(.*)$ https://www.yourdomain.com/$1[r=301,nc] Let me know if it helped.