One-Page Checkout [Support Thread]

[wsworx]

1.5.8a PHP 8
edit_orders-4.7.1
one_page_checkout-2.5.1
Twitch_SPOON_for_157c
usps-USPS_2024_02_14_K11j
zen_TyPackageTracker-4.1.0

Can someone explain this to me?
I loaded One page Checkout 2.5.1 and now when I try to access the orders page in admin I get this error and none of the orders show up.
The 'o.is_guest_order' is on line 37 of 'OnePageCheckoutAdminObserver.php' but I do not know why it is not present in the database.

Debug Error File
/admin/index.php?cmd=orders, IP address: , Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 admin/includes/classes/split_page_results.php(220): queryFactory->Execute()
#5 admin/includes/classes/split_page_results.php(131): splitPageResults->numberRows()
#6 admin/orders.php(1225): splitPageResults->__construct()
#7 admin/index.php(11): require('/home2/wildstee...')
--> PHP Fatal error: 1054:Unknown column 'o.is_guest_order' in 'field list' :: SELECT count(*) as total FROM (SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, o.order_total, 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.orders_status, o.ip_address, o.language_code , o.is_guest_order FROM (orders o ) LEFT JOIN orders_status s ON (o.orders_status = s.orders_status_id AND s.language_id = 1) ORDER BY o.orders_id DESC) countresults ==> (as called by) admin/includes/classes/split_page_results.php on line 220 <== in includes/classes/db/mysql/query_factory.php on line 667.

[lat9]

FWIW, that field should have been added to the database when OPC was initially installed.

[richard7315]

Hi lat9
We have been trying to integrate the stripe payment module with OPC so we can offer guest checkout with payment via digital wallets (Apple pay or Google pay). Unfortunately we have been unable to get the stripe form to display on the OPC checkout page.

I have posted on the stripe forum for advice – please see my posts for more details.

It would be much appreciated if you could check the stripe code and offer any advice on how to make it compatible with OPC.
Many thanks
Richard

[lat9]

Hi lat9
We have been trying to integrate the stripe payment module with OPC so we can offer guest checkout with payment via digital wallets (Apple pay or Google pay). Unfortunately we have been unable to get the stripe form to display on the OPC checkout page.

I have posted on the stripe forum for advice – please see my posts for more details.

It would be much appreciated if you could check the stripe code and offer any advice on how to make it compatible with OPC.
Many thanks
Richard

Richard, I have no clients that use Stripe so I'm unfamiliar with the operation of that payment module. I took a quick look at the code and I don't have a clue as to where the module is failing.

Does Stripe have a debug setting? If so, enable its debug and OPC's debug and you can send me the logs to my private email (which I'll give you via PM).

[lat9]

v2.5.2 of One-Page Checkout is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2095

This release contains updates for these GitHub issues:

#412: Remove no-longer-used (and problematic) CHECKOUT_ONE_OTTOTAL_SELECTOR setting.
#414: Further simplification of the transition from the checkout_one page to checkout_confirmation, ensuring only that the order's total-value hasn't changed.

[OJ_SIMON]

Hi,

Can someone let me know which notifier I need to use to make an action happen after converting gest visiter (not logged-in or registered) to guest account (purchase without account but equal to a logged-in and registered customer) please?
So I can carry out the action I need too at the earliest point possible.

OJ - Simon

[OJ_SIMON]

Hi,

Can someone let me know which notifier I need to use to make an action happen after converting gest visiter (not logged-in or registered) to guest account (purchase without account but equal to a logged-in and registered customer) please?
So I can carry out the action I need too at the earliest point possible.

OJ - Simon

Would this be the one to use: 'NOTIFY_ZEN_IN_GUEST_CHECKOUT' is this the first notifyee?

[OJ_SIMON]

As I need the customer's:
name - first and last name,
email,
PostCode,
country - iso_code_2,
ID,

so that I can send it with the payment request in the API call and save the response to DB else I can only offer wallets to your customer within the Payment plugin I am making.

[lat9]

As I need the customer's:
name - first and last name,
email,
PostCode,
country - iso_code_2,
ID,

so that I can send it with the payment request in the API call and save the response to DB else I can only offer wallets to your customer within the Payment plugin I am making.

That information is stored in the $order object's information by OPC's observer, so you can check the notifications issued at various points within the order's creation to determine the best 'point' at which to gather that information.

If you're checking within a payment module, that data will already be in the order's information when the checkout process calls any of its functions.

[OJ_SIMON]

That information is stored in the $order object's information by OPC's observer, so you can check the notifications issued at various points within the order's creation to determine the best 'point' at which to gather that information.

Ok, so are you saying as fare as a payment module is concerned it doesn't have to deal with a "guest checkout" of OPC any different then a normal registered customer who has a customer account made at the payment processor just before the payment request is made?

If you're checking within a payment module, that data will already be in the order's information when the checkout process calls any of its functions.

The only functions available within a payment module/plugin for any point at checkout process are:
before_process() - this is where I'm thinking the request is API is send but what I can't seem to workout is, is the discount coupons if applied to the order, applied by this point if not then I just have the after_process that i can use?
after_process() - which I'm working on this is the API response and if needed redirect back to payment?