{"flag":true,"single":true,"pageTitle":"WooCommerce Order Items and Meta Data extract using SQL Command","post":{"id":241,"user_id":1,"slug":"woocommerce-order-items-and-meta-data-extract-using-sql-command-s36j","title":"WooCommerce Order Items and Meta Data extract using SQL Command","body":"<pre class=\"language-markup\"><code>SELECT * FROM `wp_posts` where ID='123';\r\nSELECT * FROM `wp_postmeta` where post_id='123';\r\nSELECT * FROM `wp_woocommerce_order_items` where order_id=123; \/\/ it will return meta id use in below query\r\nSELECT * FROM `wp_woocommerce_order_itemmeta` where order_item_id=456;<\/code><\/pre>\r\n<p>OR<\/p>\r\n<p>&nbsp;<\/p>\r\n<p>SET @order_id = 123;<\/p>\r\n<p>SELECT * FROM wp_posts WHERE ID = @order_id;<br>SELECT * FROM wp_postmeta WHERE post_id = @order_id;<br>SELECT * FROM wp_woocommerce_order_items WHERE order_id = @order_id;<\/p>\r\n<p>-- gets itemmeta for ALL line items in one shot, no manual ID copying<br>SELECT oi.order_item_id, oi.order_item_name, oim.meta_key, oim.meta_value<br>FROM wp_woocommerce_order_items oi<br>JOIN wp_woocommerce_order_itemmeta oim ON oim.order_item_id = oi.order_item_id<br>WHERE oi.order_id = @order_id;<\/p>\r\n<p>&nbsp;<\/p>\r\n<p>https:\/\/stackoverflow.com\/questions\/38743011\/sql-select-query-for-retrieving-woocommerce-order-items-and-meta-data<\/p>","category_id":23,"is_private":0,"created_at":"2024-05-18T11:20:48.000000Z","updated_at":"2026-08-06T17:47:57.000000Z","category":{"id":23,"user_id":1,"name":"DATABASE","slug":"database-j4ss","parent_id":null,"created_at":"2023-05-26T03:25:05.000000Z","updated_at":"2023-05-26T03:25:05.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":1,"profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"SELECT * FROM `wp_posts` where ID='123'; SELECT * FROM `wp_postmeta` where post_id='123'; SELECT * FROM `wp_woocommerce_order_items` where o - WooCommerce Order Items and Meta Data extract using SQL Command (Updated: August 6, 2026) - Read more about WooCommerce Order Items and Meta Data extract using SQL Command at my programming site [SITE]","categories":[]}