Fast and Easy Checkout

30 Apr 2015, 1:13 AM

#1981

New Zenner

Join Date:: Aug 2014
Location:: Etobicoke
Posts:: 48
Plugin Contributions:: 0

Fast and Easy Checkout

Does anyone have Fast and Easy Checkout working with Zc 1.5.4? If so, could you let me know what needs to be done to get it to work.

30 Apr 2015, 2:21 AM

#1982

bislewl

Totally Zenned

Join Date:: Dec 2011
Location:: Wisconsin, USA
Posts:: 674
Plugin Contributions:: 12

Re: Fast and Easy Checkout

llmcdonald:

So I would need to go back to using zc 1.5.3 for Fast and Easy checkout to work.

It sounds like FEC for 1.5.4 should be coming shortly/very soon.

30 Apr 2015, 2:49 PM

#1983

ravynw34

Zen Follower

Join Date:: Feb 2007
Location:: Pennsylvania
Posts:: 112
Plugin Contributions:: 0

Re: Fast and Easy Checkout

Any idea of an ETA on this for 1.5.4? Just curious as some of us would love to be able to use this mod.
Also any tips to get this to work in a responsive template would be great.
Thanks.

30 Apr 2015, 3:18 PM

#1984

adb34

Totally Zenned

Join Date:: Mar 2008
Location:: Brampton, Cumbria, United Kingdom, United Kingdom
Posts:: 825
Plugin Contributions:: 0

Re: Fast and Easy Checkout

ravynw34:

Any idea of an ETA on this for 1.5.4? Just curious as some of us would love to be able to use this mod.
Also any tips to get this to work in a responsive template would be great.
Thanks.

And all the above on this page - I have it working on v1.5.4. What problems are you having? Here is my page

Learning Fast.
Eden Craft Supplies

30 Apr 2015, 4:23 PM

#1985

bislewl

Totally Zenned

Join Date:: Dec 2011
Location:: Wisconsin, USA
Posts:: 674
Plugin Contributions:: 12

Re: Fast and Easy Checkout

adb34:

And all the above on this page - I have it working on v1.5.4. What problems are you having? Here is my page

It could be a payment module issue, with the ZenCart 1.5.4 Ajax?

30 Apr 2015, 4:29 PM

#1986

llmcdonald

New Zenner

Join Date:: Aug 2014
Location:: Etobicoke
Posts:: 48
Plugin Contributions:: 0

Re: Fast and Easy Checkout

adb34:

And all the above on this page - I have it working on v1.5.4. What problems are you having? Here is my page

My checkout hangs on the following screen:

Home :: Checkout :: Confirmation
Your order is being processed, please wait...

Is there anything that you had to do differently to get it to work?

Here is a link to my site LHAL Sportscards & Collectibles

30 Apr 2015, 5:29 PM

#1987

ravynw34

Zen Follower

Join Date:: Feb 2007
Location:: Pennsylvania
Posts:: 112
Plugin Contributions:: 0

Re: Fast and Easy Checkout

Not a payment issue at all. Its the way it looks in mobile that is the issue.
Mobile side of fec is squished In portrait mode and useable in landscape only.
Any ideas. Thanks for the help.

30 Apr 2015, 5:40 PM

#1988

ravynw34

Zen Follower

Join Date:: Feb 2007
Location:: Pennsylvania
Posts:: 112
Plugin Contributions:: 0

Re: Fast and Easy Checkout

Here is a screenshot of how it looks

6 May 2015, 6:39 AM

#1989

pompidompie

Zen Follower

Join Date:: Mar 2015
Posts:: 105
Plugin Contributions:: 0

Re: Fast and Easy Checkout

bislewl:

You should be able to select force guest checkout in Configuration - > Fast and easy checkout. Also you will want to set it for customers to automatically be logged off upon checkout.
Thank you. I know where to find all that, but my question is, if I use only guest checkout, can I than remove the login button on the top of my website (which turns into logoff and my account when logged in) and the same thing under customer service. I would say, these buttons are not needed when only offering checkout as a guest, but i'm a little scared that I think to simple and still need them. Am I right that I can remove them when only using checkout as a guest?

I have a little (big) problem. For some reason when I add something to the shoppingcart, the checkout button loops.
When shopping I click "add to cart" it nicely goes to the shoppingcart. Clicking "checkout" also gives me the upportunity to login, after that it returns to the shoppingcart again, but clicking on the checkout button, keeps refreshing the page. It doesn't go forward.

In chrome elements I get this error:

Uncaught Reference
Error: $ is not definedzcJS.ajax @ index.php?main_page=shopping_cart:38(anonymous function) @ index.php?main_page=shopping_cart:147
jquery-1.11.1.min.js:4 Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check http://xhr.spec.whatwg.org/.

I don't know what that means :blush:

Language: Dutch
English: not so very good
Allready have a live shop, so building local/on my computer

9 May 2015, 10:35 AM

#1990

andy_c27

Zen Follower

Join Date:: Oct 2010
Location:: United Kingdom
Posts:: 477
Plugin Contributions:: 0

Re: Fast and Easy Checkout

Is it at all possible to use the split page on page 2/3 of the checkout as atm it can't be done on my responsive website so everything is in 1 long line ..still using 1.5.3 with latest fec

13 May 2015, 12:20 AM

#1991

jimmie

Totally Zenned

Join Date:: Jan 2013
Location:: New Port Richey, Florida
Posts:: 971
Plugin Contributions:: 0

Re: Fast and Easy Checkout

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

26 May 2015, 12:50 PM

#1992

izar74

Zen Follower

Join Date:: Mar 2009
Location:: Italy
Posts:: 155
Plugin Contributions:: 0

Re: Fast and Easy Checkout

Edited for errors

26 May 2015, 12:56 PM

#1993

izar74

Zen Follower

Join Date:: Mar 2009
Location:: Italy
Posts:: 155
Plugin Contributions:: 0

Re: Fast and Easy Checkout

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:

It should be related to this:

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

26 May 2015, 3:16 PM

#1994

jimmie

Totally Zenned

Join Date:: Jan 2013
Location:: New Port Richey, Florida
Posts:: 971
Plugin Contributions:: 0

Re: Fast and Easy Checkout

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.

26 May 2015, 4:03 PM

#1995

bislewl

Totally Zenned

Join Date:: Dec 2011
Location:: Wisconsin, USA
Posts:: 674
Plugin Contributions:: 12

Re: Fast and Easy Checkout

izar74:

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][26-May-2015 09:59:00] #1 trigger_error(1054:Unknown column 'COWOA_order' in 'field list' :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1') ==> (as called by) /var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php on line 965 <==, 256) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:155]
#2 queryFactory->show_error() called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:132]
#3 queryFactory->set_error(1054, Unknown column 'COWOA_order' in 'field list', 1) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:262]
#4 queryFactory->Execute(INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1')) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php:965]
#5 zen_db_perform(orders, Array ([customers_id] => 1692,[customers_name] => Sergio RICCIO,[customers_company] => ,[customers_street_address] => Trav. Fiume Savuto, 9,[customers_suburb] => ,[customers_city] => CATANZARO,[customers_postcode] => 88100,[customers_state] => Catanzaro,[customers_country] => Italy,[customers_telephone] => 3286486400,[customers_email_address] => [email protected],[customers_address_format_id] => 5,[delivery_name] => Sergio RICCIO,[delivery_company] => ,[delivery_street_address] => Trav. Fiume Savuto, 9,[delivery_suburb] => ,[delivery_city] => CATANZARO,[delivery_postcode] => 88100,[delivery_state] => Catanzaro,[delivery_country] => Italy,[delivery_address_format_id] => 5,[billing_name] => Sergio RICCIO,[billing_company] => ,[billing_vat] => ,[billing_cf] => ,[billing_street_address] => Trav. Fiume Savuto, 9,[billing_suburb] => ,[billing_city] => CATANZARO,[billing_postcode] => 88100,[billing_state] => Catanzaro,[billing_country] => Italy,[billing_address_format_id] => 5,[payment_method] => Contrassegno,[payment_module_code] => cod,[shipping_method] => Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.),[shipping_module_code] => tnt,[coupon_code] => ,[cc_type] => ,[cc_owner] => ,[cc_number] => ,[cc_expires] => ,[date_purchased] => now(),[orders_status] => 1,[order_total] => 51.5,[order_tax] => 0,[currency] => EUR,[currency_value] => 1.00000000,[ip_address] => 79.56.112.118 - 79.56.112.118,[COWOA_order] => 1)) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/order.php:796]
#6 order->create(Array ([0] => Array ([code] => ot_subtotal,[title] => Totale parziale:,[text] => â‚¬41.00,[value] => 41,[sort_order] => 100),[1] => Array ([code] => ot_shipping,[title] => Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.):,[text] => â‚¬10.50,[value] => 10.5,[sort_order] => 200),[2] => Array ([code] => ot_total,[title] => Totale:,[text] => â‚¬51.50,[value] => 51.5,[sort_order] => 999),[3] => Array ([code] => ot_reward_points_display,[title] => Punti guadagnati:,[text] => 20,[value] => 0,[sort_order] => 1000)), 2) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/checkout_process.php:86]
#7 require(/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/checkout_process.php) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/pages/checkout_process/header_php.php:14]
#8 require(/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/pages/checkout_process/header_php.php) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/index.php:36]

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

26 May 2015, 4:19 PM

#1996

izar74

Zen Follower

Join Date:: Mar 2009
Location:: Italy
Posts:: 155
Plugin Contributions:: 0

Re: Fast and Easy Checkout

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:

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? :P

26 May 2015, 4:37 PM

#1997

bislewl

Totally Zenned

Join Date:: Dec 2011
Location:: Wisconsin, USA
Posts:: 674
Plugin Contributions:: 12

Re: Fast and Easy Checkout

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

in there the uninstall.sql should look like

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:

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.

26 May 2015, 7:41 PM

#1998

izar74

Zen Follower

Join Date:: Mar 2009
Location:: Italy
Posts:: 155
Plugin Contributions:: 0

Re: Fast and Easy Checkout

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/zen-cart-plugins/checkout/fast-and-easy-checkout)

29 May 2015, 2:41 PM

#1999

izar74

Zen Follower

Join Date:: Mar 2009
Location:: Italy
Posts:: 155
Plugin Contributions:: 0

Re: Fast and Easy Checkout

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>

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

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

The problem is that it doesn't work :P

What did i fortget? :D

4 Jun 2015, 6:05 PM

#2000

izar74

Zen Follower

Join Date:: Mar 2009
Location:: Italy
Posts:: 155
Plugin Contributions:: 0

Re: Fast and Easy Checkout

I did IT!! :P

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

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

// 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 ";

:D