Product details missing from orders

  • Resolved kalytheo

    (@kalytheo)


    4 years, 1 month ago

    Hi there!

    We have a problem after updating to woocommerce 5. Order items are stored in the db but not showing anywhere in the order details (order page confirmation, emails, admin). Taxes and Totals are shown.

    We tried disabling all the plugins except wc and also installed the storefronte template, but nothing changed.

    We also deleted the wc plugin and re-installed it but the problem remains.

    No errors in the status logs.

    Can you please help?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter kalytheo

    (@kalytheo)

    It seems that the woocommerce_order_itemmeta table is empty! No records are added when a new order is placed!

    Hi @kalytheo,

    Yikes! Have you checked to see if WordPress’s database user has all priveledges on the woocommerce_order_itemmeta table?

    permissions

    If it doesn’t then that could explain why rows aren’t being added to the table.

    Thread Starter kalytheo

    (@kalytheo)

    Hi @3sonsdevelopment
    thank you for your reply.

    We managed to resolved the issue by creating a staging environment in which we deleted woocommerce and then re-installed it. We then copied the wc tables to the original db and the problem was solved. Still we do not know what caused the issue in the first place. Maybe there was a problem with the db.

    I’m glad you were able to get that working. It does sound like something was not quite right with the tables. Good way to replace them with some you know are working.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Product details missing from orders’ is closed to new replies.