One-Page Checkout [Support Thread]

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.

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

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

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

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.

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?

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.

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

lat9:

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?

OJ_SIMON:

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?

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?
In answer to the first question: Yes, a payment module needs no knowledge of whether it's a guest or registered-customer checking our.

For the second, that's above the scope of this support thread.

lat9:

In answer to the first question: Yes, a payment module needs no knowledge of whether it's a guest or registered-customer checking our.
Understand that and thank you.
now with this payment module the customer will have to have set-up at least one Payment Method before being able to prossed (so very much the same as client would if they shopped say with Amazon) to pay,
from within there customer account the same place they will manage their own Payment Methods all done via API call and with a registered-customer they shall be redirected to this page if no payment method is available to listed, and there payment processors customer account will be making at point of registration which was my may resion of asking at what point is a guest-customer converted as this would be the point that I would use a notifier to create their account outside of the checkout_payment page so this makes for a much quicker checkout flow whichever checkout is used (if OPC plugin users don't wish to have that as an option for there guest-checkout user's then I will be more than happy to redirect this customer type to the step checkout. (Also this checkout flow has been authorized by the Payment Processing company and is fully compliant and within all T&C and they have actual supplied help on the coding flow of this solution).

Oj -Simon

I am getting this when going to checkout
This is currently the only shipping method available to use on this order.
and the field is blank, but in the order total it shows the shipping method when hitting confirm displays that error.
I am using zen 1.56c and advanced shipper with freeoptions activated

i was not suppose to touch this
/**

• The default title for the shipping module.
• Please Note: The module MUST have a title defined or it will not appear as an option at checkout.
• If it is preferred not to display a title for the module, please take a look at the FAQ
• "How can the overall title for the shipping be changed..."
  */
  define('MODULE_ADVANCED_SHIPPER_DEFAULT_TITLE', 'Shipping'); // DO NOT LEAVE BLANK!

jimmie:

i was not suppose to touch this
/**

• The default title for the shipping module.
• Please Note: The module MUST have a title defined or it will not appear as an option at checkout.
• If it is preferred not to display a title for the module, please take a look at the FAQ
• "How can the overall title for the shipping be changed..."
  */
  define('MODULE_ADVANCED_SHIPPER_DEFAULT_TITLE', 'Shipping'); // DO NOT LEAVE BLANK!
  contact the guy's at Advanced shipping they will fix it for you.

Customers have been experiencing issues while checking out.

After clicking "confirm order", the screen refresh with a red highlighted message: " Your order has changed. Please check value....and resubmit"

I tried a test order and i am getting the same message. If i try several times, the order eventually goes thru.

Any ideas on how to fix it please? Thank you

Site is royal-fleur.com with squarewebpay

ZC 1.5.7
OPC 2.5.1
PHP 7.4

I enable the debug and I am getting the follow files but they are too long to post on here

nicksab:

Customers have been experiencing issues while checking out.

After clicking "confirm order", the screen refresh with a red highlighted message: " Your order has changed. Please check value....and resubmit"

I tried a test order and i am getting the same message. If i try several times, the order eventually goes thru.

Any ideas on how to fix it please? Thank you

Site is royal-fleur.com with squarewebpay

ZC 1.5.7
OPC 2.5.1
PHP 7.4

I enable the debug and I am getting the follow files but they are too long to post on here
how long has this been happening for?
have you tried the ned upgrade?

OJ_SIMON:

how long has this been happening for?
have you tried the ned upgrade?

It has been happening since a couple month i believe. A customer mentioned a while back but never paid much attention to it thinking it could be internet connectivity, wifi, or operator error....

Thank you Simon for mentioning the update. I didn't know there was one honestly. I will give it a try and see if it fixes it. " finger crossed"

I fixed it by putting that option back in.

OJ_SIMON:

how long has this been happening for?
have you tried the ned upgrade?

How to fix this if running on zen version1.56c, I've I am on lastest opc for 1.56c version but support dropped for 1.56c, authorize. Net and paypal