Wednesday, March 18, 2015

raw query plan to get woocommerce order by specific user


First go to postmeta table with user id then you will get order id as post id then with those post id go to order_itemmeta table to get order details in row then with that order_itemmeta table you will get order_item_id with meta value, this meta value is your product id you can now get that product info by that product id in posts table now make a join query to get all those thing in one table :) Good luck!
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Wordpress debug log function

Wordpress error log code: if ( ! function_exists ( 'write_log' ) ) { function write_log ( $data ) { if ( defined ( '...

  • Suomen Kieli (Kello)
    In Finnish, telling time follows a specific structure, and understanding it can help you get the hang of the language. Here’s a guide with e...
  • Suomen Kieli (Vuorokausi)
    Suomen Kieli (Vuorokausi): 1. Aamu (Morning): This refers to early morning, usually around 6:00 AM to 9:00 AM . 2. Aamupäivä (Before noon)...
  • Suomen Kieli (Taalla, Tuolla, Siella)
    In Finnish, location-based words like "täällä," "tuolla," and "siellä" help describe where something is rela...