rqcmt

Hi,@xue28

As a premise, this is a first time issue.
No problems have occurred before or since.
Would an update to the latest version help to find the cause of the one-time problem?

If this did not resolve the issue, please provide the fatal error logs (if any) under WooCommerce > Status > Logs.

No errors.

Screenshots are below.
https://snipboard.io/8dwDnu.jpg

The Order Notes in the screenshot are in Japanese, so I will supplement them.

1.System automatic processing
Square Payment Failed (Status code PAN_FAILURE: Authorization error: ‘PAN_FAILURE’) Order status changed from pending to failed.

The following is a coping action, so I don’t think it has anything to do with the issue.

2.Customer Operation
Cancellation of order by customer Order status changed from Failed to Pending.

3.Administrator Operation
Order status changed from pending to received (bank transfer).

Thank you.

@ihereira

There is a Square subsidiary in Japan where I am located, so I contacted them first.
However, Square support told me that if there is no payment record in the Square admin page, it is a problem on the Woocommerce side that the order was completed in that state.
Therefore, I think you should contact Woocommerce.

For example, I expected them to investigate whether there was an error on Square’s servers when I placed the order, but that was not accepted.

I looked at the system status log and found no errors.
Once again, I have created a topic in the Square forum.

Thank.

https://www.ads-software.com/support/topic/orders-are-approved-even-though-payment-has-not-been-made-in-square-woocommerc/

Self-help.
I found the explanation on this page and was able to retrieve it at.
https://woocommerce.github.io/code-reference/classes/WC-Product.html

$product = wc_get_product(get_the_ID());
echo $product->get_price();

In the explanation, the argument of “wc_get_product” is “$post_id”, but this gives “Warning: Undefined variable $post_id”.
To get the post ID, I used “get_the_ID()”.
Why doesn’t “$post_id” work?
However, this does not seem to be a phenomenon limited to Woocomerce, does it?

WP version: 6.0.3
PHP version: 8.1.12
WooCommerce Version: 7.2.0

Hi, @xue28

Here is a screenshot of Order Notes.
I would like to add a few more details since I am in a Japanese environment.
The red box is “Paid on”, but the payment is not settled by Square.
And the status shows “Pending payment”.
The System Status Report is here.
Thanks.

https://snipboard.io/So6Hl8.jpg

### WordPress Environment ###

WordPress address (URL): https://example.com/e-shop
Site address (URL): https://example.com/e-shop
WC Version: 7.1.0
REST API Version: ? 7.1.0
WC Blocks Version: ? 8.7.5
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.1.12
PHP Post Max Size: 30 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS/3.53.1

SUHOSIN Installed: –
MySQL Version: 10.5.15-MariaDB-log
Max Upload Size: 30 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 7.1.0
WC Database Prefix: wp_
Total Database Size: 69.51MB
Database Data Size: 36.59MB
Database Index Size: 32.92MB
wp_woocommerce_sessions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 1.52MB + Index: 0.31MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 6.52MB + Index: 6.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.25MB + Index: 0.34MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
wp_ahm_events: Data: 0.23MB + Index: 0.34MB + Engine InnoDB
wp_ahm_norm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ahm_pages: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_ahm_unread: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 2.52MB + Index: 1.69MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 2.20MB + Index: 0.11MB + Engine InnoDB
wp_postmeta: Data: 15.55MB + Index: 18.06MB + Engine InnoDB
wp_posts: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_users: Data: 0.11MB + Index: 0.08MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.14MB + Index: 0.08MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
wp_wc_order_stats: Data: 0.34MB + Index: 0.25MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.33MB + Index: 0.27MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_ywpar_points_log: Data: 0.20MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 1
acf-field-group: 1
attachment: 89
info: 17
lws-wre-event: 3
lws-wre-pool: 1
lws-wre-unlockable: 1
nav_menu_item: 5
page: 10
performance: 1
post: 1
product: 35
product_lineup: 41
product_variation: 20
revision: 85
shop_coupon: 11
shop_order: 3055
shop_order_refund: 1
user_request: 1
wpcf7_contact_form: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (15) ###

Advanced Custom Fields: by WP Engine – 6.0.4
Aurora Heatmap Premium: by R3098 – 1.5.6
Business Day Calendar: by R3098 – 2.0.1
Collapse Text on Mobile: by R3098 – v0.1
Confirm Theme Structure: by R3098 – 2.1.1
Contact Form 7: by Takayuki Miyoshi – 5.6.4
Really Simple CSV Importer + Columns Rename: by Takuro Hishikawa – 1.3
UpdraftPlus - バックアップ/復元: by UpdraftPlus.Com
DavidAnderson – 1.22.23

Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.3
Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.5
Japanized for WooCommerce: by 職人工房 – 2.5.3
WooCommerce Square: by WooCommerce – 3.3.0 (update to version 3.4.1 is available)
WooCommerce: by Automattic – 7.1.0 (update to version 7.1.1 is available)
YITH WooCommerce Points and Rewards: by YITH – 1.5.3
zipaddr-jp: by Tatsuro
Terunuma – 1.33

### Inactive Plugins (1) ###

Customer Reviews for WooCommerce: by CusRev – 5.7.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: JPY (￥)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ?
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: ? Page ID is set
but the page does not exist

Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #3 - /privacy-policy/

### Theme ###

Name: EnoughOne ECommerce Rev202112
Version: 1.1.3
Author URL: https://seous.info/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: enoughone-e-commerce-rev202112/woocommerce/cart/cart-empty.php version 3.5.0 is out of date. The core version is 7.0.1
enoughone-e-commerce-rev202112/woocommerce/cart/cart-totals.php
enoughone-e-commerce-rev202112/woocommerce/checkout/form-shipping.php
enoughone-e-commerce-rev202112/woocommerce/content-single-product.php
enoughone-e-commerce-rev202112/woocommerce/emails/plain/admin-new-order.php
enoughone-e-commerce-rev202112/woocommerce/emails/plain/customer-completed-order.php
enoughone-e-commerce-rev202112/woocommerce/emails/plain/customer-invoice.php
enoughone-e-commerce-rev202112/woocommerce/emails/plain/customer-new-account.php version 3.7.0 is out of date. The core version is 6.0.0
enoughone-e-commerce-rev202112/woocommerce/emails/plain/customer-on-hold-order.php
enoughone-e-commerce-rev202112/woocommerce/emails/plain/customer-processing-order.php
enoughone-e-commerce-rev202112/woocommerce/emails/plain/customer-reset-password.php

Outdated Templates: ?
					
					
						Learn how to update

### Square ###

Environment: Production
Tokenization Enabled: –
Debug Mode: Off

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
settings

Daily Cron: ? Next scheduled: 2022-12-13 12:31:30 +09:00
Options: ?
Notes: 115
Onboarding: completed

### Action Scheduler ###

Complete: 795
Oldest: 2022-11-12 21:21:05 +0900
Newest: 2022-12-13 19:15:01 +0900

Failed: 1
Oldest: 2020-12-01 16:10:58 +0900
Newest: 2020-12-01 16:10:58 +0900

Pending: 2
Oldest: 2022-12-14 15:29:53 +0900
Newest: 2022-12-14 18:34:10 +0900

### Status report information ###

Generated at: 2022-12-13 19:28:52 +09:00

Hi,@anastas10s
Sorry for the late reply.
We use Square for our card payments and have been operating this system for about 3 years already.
We have received thousands of orders with card payments and have never had a problem.
Normally, if there is an error in the card information, for example, the order itself will not be completed.
In other words, if you choose to pay by card, the order will not be recorded as an order in the database on the Woocommerce side unless the payment is completed on the Square side.
As I mentioned earlier, in this case, the order has been established with the card payment selected but not yet settled on the Square side.
What information do I need to provide?

@nlpro.
Thank you.
Resolved.
By the way, what is this line referring to?

Hello.
I changed the permissions of the updraft folder in wp-content and that solved the problem.
Thanks for the tip.

Thanks, @bcrodua.

>Please could you also send us a copy of the backup log?

Understood.
However, I didn’t tell you something important before that.
This phenomenon is triggered by the server relocation.
Before that, there was no problem.
If you check, there are no logs after the relocation.
However, we are able to back up the data to the remote.
Could this be due to improper permissions on the folder used to store the logs?

Hi @oaoyadeyi

Roger that.
I will check each case individually the next time it occurs.
I thought that asking the question here would give me some clue, but I don’t see such a case.
I actually tested this in an environment that does not allow Javascript.
I can press the button to add to cart without selecting an option.
However, an error message appears afterwards asking me to select an option.
This means that I am skipping these two steps in order for the order to be fulfilled without options.
It’s not just a javascript problem.

So it’s possible that you are correctly selecting the options and placing the order, but that information is lost.

Should I not ask any more questions in this resolved topic?

I understand that this does not usually happen.
It only happens under certain conditions.
But I don’t know what the conditions are.
So, no matter how many times I try, I cannot reproduce the problem.
Therefore, the common troubleshooting methods do not work.
Do you understand?
I do use debug mode in WordPress.

>As mentioned above we can’t replicate the issue you’re describing. When a variation is not selected, the product can’t be added to the cart as the “Add to Cart” button is disabled and won’t work giving a warning message on the screen.

Is this behavior controlled by Javascript?
If so, then it is likely that the script is not working well when the client is on a particular device or condition.

It is a shame that the topic can be closed without any resolution and without any methodology for resolution being presented.

Thanks, @margaretwporg
We have already prepared and tested the clone environment.
However, the problem is not reproduced by our own access.
As we have told you many times, there is no use of testing as it is only reproduced less than 1% of the time.

Hi, @margaretwporg
Hmmm… I’m reasonably familiar with problem solving in WordPress, but this case is a running site and that’s hard to do.
Moreover, it’s mostly working fine and only happens very rarely.
There is no way to verify this.
I believe it is caused by the type of device, but without such a case study, I can’t help you.

Hi, @margaretwporg
I will try to use the recommended version of PHP.
If the problem still occurs after changing the theme and setup, I can say it’s a WooCommerce problem, but it’s hard to prove it since it only happens about 1% of the time.

Thanks, @rainfallnixfig
This is happening with the current version of WordPress and WooCommerce 5.9.0 .
Are you saying that you will wait and see if the problem occurs with WooCommerce 6.0.0 ?

• This reply was modified 3 years, 2 months ago by rqcmt.