Eduard J

Member
  • Content count

    19
  • Joined

  • Last visited

  • Days Won

    1

Eduard J last won the day on November 3 2016

Eduard J had the most liked content!

Community Reputation

1 Neutral

About Eduard J

Recent Profile Visitors

943 profile views
  1. 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 ?
  2. 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.
  3. 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.
  4. 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
  5. 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.
  6. 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.
  7. 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.
  8. 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
  9. 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.
  10. Hi, Have you had any chance to puting it together. Thanks
  11. Hi, Outcome is good but thought there will be little bit more about how it has been done, any help on this ?
  12. Hi, can you update me with forums link to : "we solved the means of adding one or more additional tabs to the existing Description and Specification tabs displayed on the Product page"
  13. Hi, Is not what I'm looking for to do each product I sell has different specification table, so what I'm looking is to get under specification snippet : SPECIFICATION: Dimensions 2.23M Function(s) Static (ON / OFF ) Use Indoor & Outdoor Lead Cable to 1st LED 0.23M Number of LED 20 Power Source 3 x AA Batteries (not included) Size 2M ( 10cm between each LED) LED Colour Warm White Cable Colour Silver LED Size 3mm Warranty 1 Year hope this helps to be more specific.
  14. Hi, I'm new to forum but been using cubecart for some time now, thinking to upgrade from V4 to V6 and currently developing new skin for V6, my question will be how can I add new fields for product specification instead of UPC, EAN codes I would need colour, dimension, length etc. Any suggestions will be very appreciated.