Dresses Archives - Page 292 of 305 - Claire's Picks

/** * 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 Dresses Archives - Page 292 of 305 - Claire's Picks

22%
Buy product

Women’s Plain Dress Mini Dress Button Casual Halter Neck Long Sleeve Black Pink Blue Color
Original price was: $32.85.Current price is: $25.73.
17%
Buy product

Women’s Plus Size Curve Casual Dress Swing Dress Solid Color Long Dress Maxi Dress Long Sleeve Button Fake two piece V Neck Basic Daily Black White Summer Spri
Original price was: $31.59.Current price is: $26.32.
17%
Buy product

Women’s Plus Size Curve Casual Dress Swing Dress Solid Color Long Dress Maxi Dress Long Sleeve Button Fake two piece V Neck Basic Daily Black White Summer Spring L XL XXL 3XL 4XL
Original price was: $31.59.Current price is: $26.32.
32%
Buy product

Women’s Plus Size Curve Denim Dress Casual Dress Shift Dress Solid Color Long Dress Maxi Dress 3/4 Length Sleeve Button V Neck Fashion Daily Blue Summer Spring
Original price was: $49.75.Current price is: $33.99.
22%
Buy product

Women’s Plus Size Curve Party Dress Bodycon Sheath Dress Plain Midi Dress Long Sleeve Split Off Shoulder Fashion Party Pink Fall Winter XL XXL 3XL 4XL
Original price was: $56.31.Current price is: $43.99.
23%
Buy product

Women’s Plus Size Curve Party Dress Winter Dress Lace Dress Solid Color Long Dress Maxi Dress 3/4 Length Sleeve Lace Ruched Crew Neck Elegant Party Pink Blue S
Original price was: $47.83.Current price is: $36.79.
21%
Buy product

Women’s Plus Size Long Dress Maxi Dress Casual Dress Boho Dress Print Dress Peplum Dresses Romantic Classic Elegant Dress Puff Sleeve Vacation Daily Summer Dre
Original price was: $31.71.Current price is: $24.99.
33%
Buy product

Women’s Plus Size Midi Dress Dress Set Casual Dress Swing Dress Print Dress Fashion Streetwear Floral Print Long Sleeve Crew Neck Outdoor Vacation Burgundy Nav
Original price was: $44.12.Current price is: $29.63.
33%
Buy product

Women’s Plus Size Midi Dress Dress Set Casual Dress Swing Dress Print Dress Fashion Streetwear Floral Print Long Sleeve Crew Neck Outdoor Vacation Burgundy Navy Blue Blue Fall Winter Regular Fit
Original price was: $44.12.Current price is: $29.63.
29%
Buy product

Women’s Plus Size Velvet Dress Party Dress Cocktail Dress Ruched V Neck Long Sleeve Midi Dress Winter Dress Wedding Guest Black Wine Spring Fall
Original price was: $41.98.Current price is: $29.99.
22%
Buy product

Women’s Print Vintage Dress Long Dress Maxi Dress Elegant Polka Dot Crew Neck Sleeveless Daily Date Summer Spring Blue Dark Green
Original price was: $27.99.Current price is: $21.83.
50%
Buy product

Women’s Renaissance Dress Medieval Costume Velvet Trumpet Sleeve Queen Dresses Outlander Plus Size Retro Vintage Long Sleeve Floor Length
Original price was: $62.84.Current price is: $31.43.
50%
Buy product

Women’s Renaissance Dress Medieval Costume Velvet Trumpet Sleeve Queen Dresses Outlander Plus Size Retro Vintage Long Sleeve Floor Length
Original price was: $62.84.Current price is: $31.43.
29%
Buy product

Women’s Retro 1950s Vintage Tea Dresses Midi Dress Daily Date Ruched Print Note Crew Neck Sleeveless Slim Summer Spring 2023 Black And White Black S M L XL
Original price was: $42.78.Current price is: $30.41.
22%
Buy product

Women’s Retro 1950s Vintage Tea Dresses Midi Dress Daily Date Ruched Print Note Crew Neck Sleeveless Slim Summer Spring 2023 Black White S M L XL
Original price was: $27.99.Current price is: $21.83.