• Resolved svenms

    (@svenms)


    Hello,

    I’m trying to use the new tool added to Woocommerce to clean the old orders from post and postmeta, but unfortunately it displays an error :

    Error No se pudieron limpiar los datos heredados del pedido 93102 durante el proceso por lotes. Error: 93102 no es un ID de pedido válido.

    While checking in Backend Admin Orders, this order does not exist. But it does if I search it un Post table in the DB.

    best regards!

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Hi @svenms,

    Thank you for reaching out. The error message you’re encountering indicates that the order with ID 93102 is not recognized as a valid order within the WooCommerce system, even though it appears in the Post table in your database. This discrepancy can happen for various reasons, such as manual database entries or incomplete order deletions. To assist you further and ensure we provide the most accurate solution, could you please confirm a few details for us?

    1. Have you manually added or removed any order entries directly in the database?
    2. Have you used any database optimization or cleaning tools prior to this issue?
    3. Can you check if there are any residual entries related to order 93102 in other tables, such as woocommerce_order_items or woocommerce_order_itemmeta?

    Once we have this information, we’ll be better positioned to guide you through the next steps.

    Thread Starter svenms

    (@svenms)

    1. Have you manually added or removed any order entries directly in the database? NO
    2. Have you used any database optimization or cleaning tools prior to this issue? Yes, we have used some in the past but I do not remember their name.
    3. Can you check if there are any residual entries related to order 93102 in other tables, such as woocommerce_order_items or woocommerce_order_itemmeta? No, there ir no info in those tables.

    By the way there are more order numbers with this problem, at least 10 more that I could see in the logs Error.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello svenms

    Thank you for your reply.

    Could you please share screenshots of the search results in the tables woocommerce_order_items and woocommerce_order_itemmeta?

    Just to be sure, could you also search the wp_posts table for ID 93102?
    This will make sure whether there is an entry with this ID or not.

    Let me know about your results. 🙂

    Best regards.

    Thread Starter svenms

    (@svenms)

    Hello, sure!

    woocommerce_order_items: https://ibb.co/1Tg5YPC (nothing)

    woocommerce_order_itemmeta: https://ibb.co/Ytyk9gs and https://ibb.co/Y7LN56z

    wp_post: https://ibb.co/sgrYvBV

    wp_postmeta: https://ibb.co/82V2N4Z

    Thanks!

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @svenms,

    This could be due to the past use of database optimization or cleaning tools that might have deleted entries from some tables but not others. However, is the “Enable compatibility mode” enabled by any chance? Can you check whether this order ID is in the shop_order_placehold table or not?

    Looking forward to hearing from you soon.

    Thread Starter svenms

    (@svenms)

    Hello,

    • Enable compatibility mode is off
    • Post type is shop_order in wp_post table

    Best regards!

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @svenms,

    Since “Enable compatibility mode” is off and the post type is shop_order in the wp_post table, the order ID might be recognized in some parts of your database but not others.

    To resolve this issue, you might need to remove the problematic order ID from the database manually. However, please be aware that this should be done cautiously as it could affect other parts of your website.

    Before proceeding, please ensure to back up your website and database.

    Let us know how that goes. Looking forward to hearing from you!

    Hey there. We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘HPOS Cleaning Metadata Tool’ is closed to new replies.