Jump to content

Eduard J

  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by Eduard J

  1. 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.

    window.dataLayer = window.dataLayer || [];
    dataLayer.push({ ecommerce: null });  // Clear the previous ecommerce object.
    'item': 'how to pull from page',
    'quantity': 'how to pull from page',
    'value': 'how to pull from page',
    'event': 'begin_checkout'


    If anyone has experience with this I would appreciate sharing it. 

  2. I have latest version of cubecart 6.4.2 and creating products with product options, but when i choose price inc. VAT is calculated wrong in basket. when  price is set  without VAT than correct amount is added on top of option price and total is correct, also when main price is set to £0,  option prices are calculated correctly but I need to have Main price displayed.
    Main Price set £10  inc. VAT 
    Model A - £10 - absolute
    Model B - £20  - absolute 

    Basket total for Model A  is : £6.67 + VAT £1.13 = £8 ( this is if tax inc. is set in price tab)

    When I have 1 absolute price set it does not override main price in price tab which has to be £0 to calculate VAT correctly it will show product price still £0.

    Any advise would be great.


  3. 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.


  4. 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.

  5. On 27/10/2017 at 5:04 PM, Lastwolf said:

    The quicker way I found was to force a value of "N/A" on the state


             <div class="small-12 large-8 columns"><label for="delivery_state" class="show-for-medium-up">{$LANG.address.state}</label></span><input type="text" name="delivery[state]" id="delivery_state" value="No County"></div>


             <div class="small-12 large-8 columns"><label for="state">{$LANG.address.state}</label><input type="text" name="state" id="state-list" value="No County"></div>


    It seems like way to much work to make it not actually check what it's not supposed to check.

    I had to add the "no County" zone to the UK.

    Actually the whole problem can be sorted just by having a default value.

    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.

  6. 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 ?

  7. 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.

  8. 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.

  9. 15 minutes ago, Dirty Butter said:

    My install is so edited that I always merge with BeyondCompare and manually upgrade via ftp. I'll test in other browsers with my admin logged out.

    Tried it in Chrome with admin logged out. Registered a fake account and it is still working for me.

    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

  10. 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.

  11. 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.

  12. On 19/10/2016 at 3:13 PM, ayz1 said:

    Just had another look at this and something like SELECT FROM_UNIXTIME(`order_date`) FROM `CubeCart_order_summary`; does convert the timestamps to date/time values so wondering if worth creating a new column and converting the timestamps to real dates to see if it is easier to work with.

    Just tried this and cretaed a new column called time and something like SELECT * FROM `CubeCart_order_summary` WHERE `time` BETWEEN '2016-02-17 11:25:10' AND '2016-02-18 11:25:10'; works.


    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 :)

  13. 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',
           shop1_CubeCart_order_inventory.name AS 'Product Name',
    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. 

  14. 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>


             <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.

  15. 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.   

    ​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.

  16. 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.   

  • Create New...