webinize

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Forum: Plugins
    In reply to: [WooCommerce] How to find order quantity in SQL database
    Thread Starter webinize

    (@webinize)

    5 years, 12 months ago

    @lorro

    I realized a really silly mistake which I think beginners like me tend to overlook.

    I missed the pagination in phpMyAdmin, therefore I thought that some of my tables are missing when I could have went to the next page and find the tables you mentioned above.

    I managed to establish the link between the tables and I will proceed to run my SQL Query accordingly.

    Thank you so much my friend. God bless and take care

    Forum: Plugins
    In reply to: [WooCommerce] How to find order quantity in SQL database
    Thread Starter webinize

    (@webinize)

    5 years, 12 months ago

    @lorro thank you for your reply!

    Perhaps it is due to the new database update by woocommerce as of 4.0, but I am unable to find table wp_woocommerce_order_itemsmeta that corresponds to wp_posts WHERE post_type=’shop_order’

    Could it be due to the new database update? Or is there an issue with my phpMyAdmin where my database tables are not showing properly?

    Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)