Square WebPay support thread.

[wtfbbq]

Those of you who were already using Square prior to carlwhat's update to WebPay may want to check your ADMIN >> Customers >> Orders for orders made in late March or earlier that have square under the Payment/Shipping header versus square_webPay.

We (myzencarthostDOTcom) updated several of our customers while some did 1.0.0 and 1.0.1 on their own. Both groups have shown cases where the Payment/Shipping was not changed to square_webPay on orders made with the old square.

If you are using WebPay and the Payment/Shipping shows square, you will not be able to access the full details for the order. IOW, you will not see anything AFTER the payment method. A partial blank screen with no log created and no way to see comments on the order.

NOTE: Some sites with Edit Orders are able to access the data with that mod. Still, the fix needs to be made.

Somehow, the upgrades did not modify the orders table in the database for any existing square orders. Specifically, the payment_module_code field. Some sites had a DB prefix and others did not so, I don't think that's the problem.

There's a quick fix if you find this happening. Go to ADMIN >> Tools >> Install SQL Patcches (it shows up as SQL Query Executor on the page).

Please read the instructions on that page that are in RED.

Enter the following code.

UPDATE orders
SET payment_module_code = 'square_webPay'
WHERE payment_module_code = 'square';

Then click on send.

You'll be good to go

Is this still the method to fix the order details not showing up? Tried it and doesn't work.