Woocommerce Question posted in
The official Woocommerce documentation can be found here.

WooCommerce wrong product item counts and meta data added in order

For about two weeks now I have the surreal problem that almost every order has the correct items but wrong meta datas and the ordered number of items are changed like 3-20 instead of just one.

I had a bloated database on my shared server and it was full. I cleared the wp_actionscheduler_logs to get enough space back and cleared the wp_actionscheduler_actions entries (completed, failed, aborted).

Since that I have the problem. Already made a staging testsite but it still continues. Debugging is active but it only shows problem with the Pixelyoursite plugin which I deactivated but nothing changed.

Is there any chance to check the database for double entries or something like that?

Already tested a different theme
Already deactivated all plugins (one by one)
Tested with existing and completely new products
Tested as a guest and test account
Same effect by using coupons

WC version 8.1.1
WP version 6.3.1
WC payment solution (only Paypal Checkout)
Theme Jupiter X (5.3.1)
PHP version 8.1 (currently 7.4 for testing)

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I had to completely shut off the whole shop and build it from scratch by using a backup some weeks before the mess started.

    After the database bloat there where 27 failed orders I couldn't see, because they where kind of lost and nowhere listed. I only noticed it by checking the gap in the order numbers between WooCommerce and PayPal. Because of that, I assume that the numbers of the failed orders where given to other, later incoming, orders after I deleted the wp_actionscheduler_actions and wp_actionscheduler_log databases.

    The new orders with these 27 order numbers where visible but not the old orders with the same numbers. After the customer paid with PayPal, there must have been a mix-up between these numbers and it went on...like all orders get there stuff PLUS each the stuff from the previous 27th order.

    Why? Because Paypal counts every order on its own. It's an ongoing process. Again, it's a supposition but that's the only plausible thing I could find out.

    What I did beside rebuilding the shop: I used a small plugin that allowed me to start with a new order number and since then everything works. The mess ended with order number 76224 and I continued with the order number 100000 .


  2. 0

    I think I found a simple fix for this…
    I did try this first but it didn’t seem to work:-
    woocommerce/status/tools/ then transients/ ; expired transients ; term counts
    AND clearing all cache, so then I tried this…

    • go into one of the wrong counted categories via the ‘wrong count number" in order to see the list of items in the said list, then
    • go into the top couple** of products via quick view and press SAVE then
    • go back to the count screen and refresh

    Worked for me (hope it works for you)

    ** could even be one product

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search