Fast and Easy Checkout

[southshorepizza]

Hi

I would like to install thus but there is no install.sql in the zip file. There are loads of previous sql updates but I don't know which one to use.

I am using v1.5.1 - any help would be appreciated.

Thanks
Alan

You can find the SQL in the your_admin/includes/installers/fec folder. It automatically loads. You don't have to manually run it. Just install the module and it will run the SQL if needed.

[Pompidompie]

I have installed FEC and lets say that I will only use the checkout as a guest, than you have the login and create account buttons everywhere, for instance on the far top, next to the items and the shoppingcart, or under the customers service button, and so on.
Is it oke to remove of all these, or am I missing something and do still need them?

[bislewl]

I have installed FEC and lets say that I will only use the checkout as a guest, than you have the login and create account buttons everywhere, for instance on the far top, next to the items and the shoppingcart, or under the customers service button, and so on.
Is it oke to remove of all these, or am I missing something and do still need them?

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.

[Pompidompie]

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

[Andy-C27]

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

[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

[izar74]

Edited for errors

[izar74]

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:

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

[26-May-2015 09:59:00] PHP Fatal 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 <== in /var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php on line 155

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

[bislewl]

to get the SQL files out of there is quite difficult as it uses the $db->Execute, and you would have to change all the constants. Like the TABLE_CONFIGURATION would need to change to configuration, and the quotes would need to be removed as well as the $configuration_group would need to be found and then replaced in a similar matter.

Additionally there are several uses of the $sniffer class to determine if a column already exists. So to pull out the SQL is quite a difficult task.

Also it does not install until the admin page loads, and if already logged into the admin it will show a message in the message stack that it has install the version it has installed, and if it has added the configuration menu. Also it will check to see if there is a more recent version of the module on zen-cart.com