Chunky Sole Shoes Archives - Page 7 of 7

/** * Get products based on search query with merchant filtering */ private function get_search_products($atts) { global $wpdb; $search_term = $atts['search']; $search_mode = isset($atts['search_mode']) ? $atts['search_mode'] : 'comprehensive'; $product_ids = array(); // Mode 1: Basic WordPress search (fastest but limited) if ($search_mode === 'basic') { $args = array( 'post_type' => 'product', 'post_status' => 'publish', 's' => $search_term, 'posts_per_page' => -1, 'fields' => 'ids' ); $query = new WP_Query($args); $product_ids = $query->posts; } // Mode 2: Title only search using LIKE elseif ($search_mode === 'title_only') { $product_ids = $wpdb->get_col($wpdb->prepare(" SELECT ID FROM {$wpdb->posts} WHERE post_type = 'product' AND post_status = 'publish' AND post_title LIKE %s ", '%' . $wpdb->esc_like($search_term) . '%')); } // Mode 3: Comprehensive search (default) else { // Direct SQL search for maximum compatibility $search_like = '%' . $wpdb->esc_like($search_term) . '%'; // Search in titles and content $title_content_ids = $wpdb->get_col($wpdb->prepare(" SELECT ID FROM {$wpdb->posts} WHERE post_type = 'product' AND post_status = 'publish' AND (post_title LIKE %s OR post_content LIKE %s OR post_excerpt LIKE %s) ", $search_like, $search_like, $search_like)); if (!empty($title_content_ids)) { $product_ids = array_merge($product_ids, $title_content_ids); } // Search by SKU $sku_ids = $wpdb->get_col($wpdb->prepare(" SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key='_sku' AND meta_value LIKE %s ", $search_like)); if (!empty($sku_ids)) { $product_ids = array_merge($product_ids, $sku_ids); } // Search in product categories $cat_ids = $wpdb->get_col($wpdb->prepare(" SELECT tr.object_id FROM {$wpdb->term_relationships} tr JOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id JOIN {$wpdb->terms} t ON tt.term_id = t.term_id WHERE tt.taxonomy = 'product_cat' AND t.name LIKE %s ", $search_like)); if (!empty($cat_ids)) { $product_ids = array_merge($product_ids, $cat_ids); } } // Remove duplicates $product_ids = array_unique($product_ids); if (empty($product_ids)) { return array(); } // Filter out hidden products $visible_product_ids = array(); foreach ($product_ids as $product_id) { $product = wc_get_product($product_id); if ($product && $product->is_visible()) { $visible_product Chunky Sole Shoes Archives - Page 7 of 7 - Claire's Picks

20%
Buy product

Women’s Vintage Green Mary Jane Faux Leather Heels with Cutout Design and Adjustable Strap – Comfortable Retro Block Heel Shoes for Casual and Formal Occasions
Original price was: $36.58.Current price is: $29.26.
12%
Buy product

Women’s Vintage Green Suede Loafers with Gold Buckle and Fringe Detailing – Block Heel Shoes for Formal and Casual Occasions
Original price was: $33.62.Current price is: $29.64.
6%
Buy product

Women’s Vintage Green Suede Loafers with Gold Buckle and Fringe Detailing – Block Heel Shoes for Formal and Casual Occasions
Original price was: $45.86.Current price is: $42.99.
43%
Buy product

Women’s White Fisherman Sandals with Chunky Lug Sole and Buckle Strap, Vintage Closed-Toe Faux Leather Shoes for Summer, Daily Wear, and Casual Outfits
Original price was: $57.70.Current price is: $32.99.
27%
Buy product

Women’s White Lace Floral Embroidered Kitten Heel Shoes with Ankle Strap – Elegant Bridal Wedding Shoes
Original price was: $51.38.Current price is: $37.65.
30%
Buy product

Women’s White Platform Lace-Up Sneakers with Chunky Sole – Trendy Casual Shoes for Streetwear and Everyday Style
Original price was: $24.26.Current price is: $16.87.
24%
Buy product

Women’s White Platform Lace-Up Sneakers with Chunky Sole – Trendy Casual Shoes for Streetwear and Everyday Style
Original price was: $33.09.Current price is: $24.99.
13%
Buy product

Women’s White Platform Sandals with Adjustable Straps – Chunky Sole Open-Toe Summer Shoes
Original price was: $28.77.Current price is: $24.99.
28%
Buy product

Youth Womens Kenzi MJ Leather Shoes Black
Original price was: $62.00.Current price is: $44.80.