Goto your wordpress phpmyadmin open database
1.All Woocommerce orders save in table-prefix_posts table
2.and Woocommerce order’s meta info like :billing-addres,customer-name store in table-prefix_postmeta table
run SQL command in phpmyadmin
SELECT *
FROM `table-prefix_postmeta`
WHERE `post_id` = any order-id
LIMIT 0 , 30
you get list of product meta info.
_order_items
this meta-key store all product info which your customer order
Logic:
1.Retrieve all meta info in WordPress Loop(WP_Query).
2.check if your required product id in _order_items
.if it is their, then print your customer name _billing_first_name
or other info.
Important Link:
Related Posts:
- Categories and products in random order
- WordPress Query wp-terms SLOW
- How can I create a meta_query with an array as meta_field?
- Query multiple meta key values?
- How to get comments by post ID?
- Is there a way of increasing the speed of this query?
- How can I query all users who registered today?
- Reversing the order of posts AFTER the query is performed
- what are the numbers between curly brackets in search query
- When/why does ‘$query->get( ‘tax_query’ );’ return empty?
- How to get link and title of next and previous post on single page
- How to display Section for certain time
- Search custom post type by meta data
- Multipart/formatted MySQL query problem
- Remove [gallery] shortcode altogether
- query multiple taxonomy and show post count
- add_query_arg() XSS Vulnerability
- Query set using tax_query with relation ‘OR’ modifies category object?
- When add_query_arg() is necessary?
- Filter query posts by the count of metas for a meta key
- Save default value for empty or missing post meta
- Listing posts by grouping dates
- Query posts by content lenght
- $wpdb doesn’t appear to work on page inside of a plugin
- Change searched term
- Query Posts By Post Publish Date, but sort by Custom Meta Key
- How to export current year posts from WordPress?
- MySQL variable in query
- Search query -> Show all pages except certain template
- How to execute a SQL-query which contains multiple queries using $wpdb->query?
- Only show upcoming event or current events
- Why a URL with a query is always slower than that without a query?
- Maintaining Queries in URL
- How to orderby multiple meta fields with another meta query
- Query posts using meta_key
- Modify users.php query with multiple taxonomies
- MySql Query very slow
- wpdb query problem to access previous 3 days posts
- I can’t figure out what’s wrong with this statement. $wpdb->query update
- Different values for get_author_posts_url and get_the_author (posts 2 posts)
- How to change the amount of posts previewed on a page?
- query statement containing variable won’t execute
- How to get events using multiple custom meta fields?
- Create a post builder skin in a plugin
- Always get creating a new table with foreign key
- Get posts from category with custom query
- Related post based on content
- Random Page Rewrite
- How to interfere to default search to make it search in custom fields?
- How to pull posts into two columns with different image sizes using $counter variable?
- WP_User_Query with more than two custom meta values
- Declaring a var, placing it in a query and using the output of the query?
- Select column name dynamically mySQL Query
- WordPress Mysql query and Duplicate
- How to “orderby” the first array in a meta_query that uses multiply keys?
- Target a page with query
- List only parent attributes on woocommerce admin atrributes page
- How to search post titles with whole words only, but not the exact word only?
- Order posts ascending from posts in array
- Display data from phpMyAdmin with WordPress
- Add rewrite rule for archive search
- custom sorting media with multiple filters – error: not unique table/alias: wp_postmeta
- How can I get posts by 2 meta keys, prioritising one of them?
- SQL query to list all posts of specific post type with a specific set of associated postmeta values as a column
- My custom pagination not displaying
- Wpdb->last_query returns bad query
- implementing my wp_query using $wpdb class
- Category_in return empty
- WP search exclude last letter from string
- Query reversed when I use “category__not_in”
- modifying main query to query for ranges e.g. from 1999 to 2016
- How to reduce the load / no of queries on MySql Database
- Querying users by meta value and getting a strange answer
- Display result from custom post meta query
- Show certain number of post from tags
- Wpdb empty result only if language is Russian
- Display Upload Author & Get Uploaded Post ID
- Display list of most recent grandchild (third tier) pages
- How can I display a number to represent the order of post?
- Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
- Sort order in get_posts [closed]
- Query unique author ids with published post of type job
- Sort loop with query in the link
- About WP’s save_post action
- $wpdb: how to use a query as a base for another query?
- Wpdb generates too many queries
- Multilingual WordPress page – using URL to determine language?
- WP-Snap too slow (caused by WP_Query?)
- list or get meta_key where meta_value is ‘something’
- Query posts alphabetically within this function
- Conditional Tag Custom Querys?
- WP_Query with checkbox meta_query – WordPress [duplicate]
- query posts only works on the first page
- Custom Query for wp_posts using wp_postmeta
- WP Query outputs three items within a div
- How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
- update $wpdb one query
- Admin Post List table Query filtering “WHERE” for custom post type
- Prevent executing query for wp_global_styles
- How to use a dynamic term id for the query block