add_action('wp_footer', 'myprices_full_diagnostic'); function myprices_full_diagnostic() { if ( ! current_user_can( 'manage_options' ) ) return; global $wpdb; echo '

'; echo '

MyPrices Full Diagnostic

'; // 1. Get all shop_order_placehold posts $placehold_posts = $wpdb->get_results("SELECT ID, post_status, post_date FROM {$wpdb->posts} WHERE post_type = 'shop_order_placehold'"); echo "

Number of shop_order_placehold posts: " . count($placehold_posts) . "

"; if ( ! empty( $placehold_posts ) ) { echo "

First 3 posts:\n"; print_r( array_slice( $placehold_posts, 0, 3 ) ); echo "

"; } // 2. Check order_items table for any rows linked to these post IDs $post_ids = array(); foreach ( $placehold_posts as $p ) $post_ids[] = $p->ID; if ( ! empty( $post_ids ) ) { $post_ids_sql = implode( ',', $post_ids ); $order_items = $wpdb->get_results( " SELECT * FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id IN ($post_ids_sql) " ); echo "

Order items found for these posts: " . count( $order_items ) . "

"; if ( ! empty( $order_items ) ) { echo "

Sample order items:\n"; print_r( array_slice( $order_items, 0, 3 ) ); echo "

"; } else { echo "

No order items found! Your shopping list plugin may not be inserting order items correctly.

"; } } // 3. Check if there are any order items at all for any post_type $all_order_items = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}woocommerce_order_items"); echo "

Total rows in woocommerce_order_items table: $all_order_items

"; // 4. Show a sample of what's in order_itemmeta for product 202 (if any) $meta_for_202 = $wpdb->get_results(" SELECT * FROM {$wpdb->prefix}woocommerce_order_itemmeta WHERE meta_key = '_product_id' AND meta_value = '202' "); echo "

Order item meta entries for product 202: " . count( $meta_for_202 ) . "

"; // 5. Check if there are any orders with status 'completed' (or any status) in shop_order_placehold $statuses = $wpdb->get_col("SELECT DISTINCT post_status FROM {$wpdb->posts} WHERE post_type = 'shop_order_placehold'"); echo "

Distinct statuses in shop_order_placehold: " . implode( ', ', $statuses ) . "

"; echo '