Fast and Easy Checkout

**jimmie** · 13 May 2015, 01:20 AM

if customer chooses another shipping option, other than defaulted selection, and than chooses confirm the order, before waiting for the new totals to refresh it will send the defaulted selection to the payment option.
How to fix this?
jimmie

**izar74** · 26 May 2015, 01:50 PM

Edited for errors

**izar74** · 26 May 2015, 01:56 PM

Originally Posted by jimmie

if customer chooses another shipping option, other than defaulted selection, and than chooses confirm the order, before waiting for the new totals to refresh it will send the defaulted selection to the payment option.
How to fix this?
jimmie

I got some error with paypal and the "one page checkout" set to true. Maybe it's related to this.
I've this HUGE debug error:

HTML Code:

It should be related to this:

HTML Code:

015-05-26 01:34:42
-------------------
(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 90
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(R) - PayPal/NVP
    [4] => X-VPS-VIT-Integration-Version: 1.5.4
)


Request Parameters: {DoExpressCheckoutPayment} 
Array
(
    [AMT] => 26.30
    [ITEMAMT] => 16.80
    [SHIPPINGAMT] => 9.50
    [L_NUMBER0] => ICPBA93210000
    [L_NAME0] => Bastoncini Palo Santo [210] Confezione: Semplice 30g
    [L_QTY0] => 1
    [L_AMT0] => 5.00
    [L_NUMBER1] => ICPBA98214000
    [L_NAME1] => Bastoncini Pino [214] Confezione: Semplice 30g
    [L_QTY1] => 1
    [L_AMT1] => 5.00
    [L_NUMBER2] => INCPIN3180000
    [L_NAME2] => Pino Resina Grezzo(Pinus pinaster) [117] QuantitÃ##: 50 grammi
    [L_QTY2] => 1
    [L_AMT2] => 3.30
    [L_NUMBER3] => INCOLI2490000
    [L_NAME3] => Olibano D'Etiopia (Boswellia rivae) [16] QuantitÃ##: 50 grammi
    [L_QTY3] => 1
    [L_AMT3] => 3.50
    [SHIPTONAME] => giulio yary piccarreta
    [SHIPTOSTREET] => caldopiano,42
    [SHIPTOCITY] => Roma
    [SHIPTOSTATE] => RM
    [SHIPTOZIP] => 00118
    [SHIPTOCOUNTRYCODE] => IT
    [BUTTONSOURCE] => IT_zencart-ECS
    [RETURNFMFDETAILS] => 0
    [CUSTOM] => EC-1623-1432640078
    [INVNUM] => 1623-1432640078-[LaViadellincenso]
    [TOKEN] => EC-2J485786GW343062M
    [PAYERID] => ME5VBKSUHGADJ
    [PAYMENTACTION] => Authorization
    [NOTIFYURL] => http://www.laviadellincenso.it/ipn_main_handler.php
    [METHOD] => DoExpressCheckoutPayment
    [CURRENCYCODE] => EUR
    [USER] => *****
    [PWD] => ****************
    [VERSION] => 61.0
    [SIGNATURE] => ****************************************************we-0
)


Response: 
Array
(
    [TIMESTAMP] => 2015-05-26T11:34:42Z
    [CORRELATIONID] => 50d0908b5e644
    [ACK] => Failure
    [VERSION] => 61.0
    [BUILD] => 16751317
    [L_ERRORCODE0] => 10486
    [L_SHORTMESSAGE0] => This transaction couldn't be completed.
    [L_LONGMESSAGE0] => This transaction couldn't be completed. Please redirect your customer to PayPal.
    [L_SEVERITYCODE0] => Error
    [CURL_ERRORS] => 
)


DoExpressCheckoutPayment, Elapsed: 3492ms -- Failure

TIMESTAMP=2015%2d05%2d26T11%3a34%3a42Z&CORRELATIONID=50d0908b5e644&ACK=Failure&VERSION=61%2e0&BUILD=16751317&L_ERRORCODE0=10486&L_SHORTMESSAGE0=This%20transaction%20couldn%27t%20be%20completed%2e&L_LONGMESSAGE0=This%20transaction%20couldn%27t%20be%20completed%2e%20Please%20redirect%20your%20customer%20to%20PayPal%2e&L_SEVERITYCODE0=Error&CURL_ERRORS=

I've seen tha on Numix site there is a 2.0 version availabe, i haven't test it yet so i don't know if it address some of this problems

**jimmie** · 26 May 2015, 04:16 PM

i get no errors, orders will go through, it is related to the cheapest (whatever, local pickup, check or money order, anything like that) being selected as default. the only time i get paypal errors are when customers bank doesnt authorize transaction or they put in a wrong address.

**bislewl** · 26 May 2015, 05:03 PM

Originally Posted by izar74

**Removed some of the quote to make reply shorter, and added bold to most important part**

There is an issue because you are missing "COWOA_order" in the orders table. The "best" solution as I suspect there are other issues is to leave the files in place however in the tools->install SQL patches run the uninstall.sql from the module. That will uninstall the DB changes in the module, and then upon next admin page load re-install the module. I suspect that somehow that column was missed, however the $sniffer class allows it to check the column and add if needed.

**izar74** · 26 May 2015, 05:19 PM

Sorry bislew i've made e quite stupid VERY LONG reply, just addint that bold line would be enough.

Your suggestion make sense but i've checked the uninstall that is as follow:

PHP Code:


SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;

From what i see it completly ignore the order table. I've also checked the installation and there is no modification to the Order table either.
Does it have any meaning after seeing this to do as You suggested?

The last thing you wrote "the $sniffer class allows it to check the column and add if needed" how should i use this suggestion?

**bislewl** · 26 May 2015, 05:37 PM

Ok, let's step back you should be using Fast & easy Check version 1.16.8.

in there the uninstall.sql should look like

PHP Code:


SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;

#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FEAC_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;

And in the YOUR_ADMIN/includes/installers/fec/1_12_0.php there is a snippet:

PHP Code:


global $sniffer;
if (!$sniffer->field_exists(TABLE_CUSTOMERS, 'COWOA_account'))  $db->Execute("ALTER TABLE " . TABLE_CUSTOMERS . " ADD COWOA_account tinyint(1) NOT NULL default 0;");
if (!$sniffer->field_exists(TABLE_ORDERS, 'COWOA_order')) $db->Execute("ALTER TABLE " . TABLE_ORDERS . " ADD COWOA_order tinyint(1) NOT NULL default 0;");

So, upgrade the module. THEN run the uninstall.sql that looks like the one above. Then load the admin, and it should resolve the issue.

The uninstall.sql doesn't touch the TABLE_ORDERS however the installer for version 1.12.0 does. And it uses the sniffer class to make sure the column is there.

**izar74** · 26 May 2015, 08:41 PM

Originally Posted by bislewl

Ok, let's step back you should be using Fast & easy Check version 1.16.8.

So, upgrade the module. THEN run the uninstall.sql that looks like the one above. Then load the admin, and it should resolve the issue.

The uninstall.sql doesn't touch the TABLE_ORDERS however the installer for version 1.12.0 does. And it uses the sniffer class to make sure the column is there.

Ohhh my my... i've litterally lost the compass... where the 1.16.8 came from?

on the plugin it is at 1.15.3 (https://www.zen-cart.com/downloads.php?do=file&id=594)

and on the Numix site it goes from 1.15.3 to 2.0 directly.. this last one would do fine? (https://www.numinix.com/downloads/ze...-easy-checkout)

**izar74** · 29 May 2015, 03:41 PM

Hi again,

thanks to bislewl help i was able to fix the problem, at least i hope so. I used the plugin from numix site.

Now i'm trying to add a little modification, i would like to have add a column in the order page in admin, after status, thas swow if a order is COWOA.
The simpliest way i thought is to add some line to the /admin/orders.php, first i followed the instruction in the readme where it state: 8. OPTIONAL TO SEE IF AN ORDER WAS PLACED BY GUEST. It add some lines but not to diplay if the order is placed by guest (like the X shown in the customer page).
So i added this line:

around line 845 after the <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>

PHP Code:


<td class="dataTableHeadingContent" align="center"><?php echo TABLE_ORDER_HEADING_COWOA; ?></td>

I added also the define for the TABLE_ORDER_HEADING_COWOA

around line 969 after <td class="dataTableContent" align="right"><?php echo $orders->fields['orders_status_name']; ?></td>

PHP Code:


<td class="dataTableContent" align="center"><?php echo ($orders->fields['COWOA_order'] == 1 ? 'x' : ''); ?></td>

The problem is that it doesn't work

What did i fortget?

**izar74** · 4 Jun 2015, 07:05 PM

I did IT!!

First you need not to edit any ../class/order.php file, simply find the lines in /admin/orders.php:

PHP Code:


// eof: search orders or orders_products
$new_fields = ", o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address ";

and add the field you need to be searched at the end, for me it is:

PHP Code:


// eof: search orders or orders_products
    $new_fields = ", o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address, o.COWOA_order ";

Thread: Fast and Easy Checkout

Thread Tools

Search Thread

Display

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Re: Fast and Easy Checkout for Zen Cart

Similar Threads

v137 Cannot Proceed Past Step 2 of Checkout after trying Fast and Easy Checkout

Fast and Easy Checkout - Checkout Without Account not showing

Go To Checkout Error - with Fast and Easy Checkout installed

checkout page not redirect (Fast and Easy Checkout module)

Fast and Easy Checkout

Bookmarks

Bookmarks

Posting Permissions