function include_product_variations_in_search($query) { if (!is_admin() && $query->is_main_query() && $query->is_search()) { $query->set('post_type', array('product', 'product_variation')); add_filter('posts_clauses', 'handle_product_variation_search_clauses', 10, 2); } return $query; } add_action('pre_get_posts', 'include_product_variations_in_search'); function handle_product_variation_search_clauses($clauses, $query) { global $wpdb; if (is_array($query->get('post_type')) && in_array('product_variation', $query->get('post_type'))) { $clauses['join'] .= " LEFT JOIN {$wpdb->postmeta} as variation_meta ON ({$wpdb->posts}.ID = variation_meta.post_id AND variation_meta.meta_key LIKE 'attribute_%')"; $search_term = $query->get('s'); if (!empty($search_term)) { $like = '%' . $wpdb->esc_like($search_term) . '%'; $clauses['where'] = str_replace( "AND (((({$wpdb->posts}.post_title LIKE", "AND ((({$wpdb->posts}.post_title LIKE '$like') OR (variation_meta.meta_value LIKE '$like')) OR (({$wpdb->posts}.post_title LIKE", $clauses['where'] ); } $clauses['groupby'] = "{$wpdb->posts}.ID"; } return $clauses; } function display_variation_attributes_in_title($title, $id = null) { if (is_search() && get_post_type($id) === 'product_variation') { $variation = wc_get_product($id); if ($variation) { $attributes = $variation->get_variation_attributes(); $attr_display = array(); foreach ($attributes as $name => $value) { $taxonomy = str_replace('attribute_', '', $name); if (taxonomy_exists($taxonomy)) { $term = get_term_by('slug', $value, $taxonomy); if ($term && !is_wp_error($term)) { $value = $term->name; } } $attr_display[] = wc_attribute_label($taxonomy) . ': ' . $value; } if (!empty($attr_display)) { $parent = wc_get_product($variation->get_parent_id()); $parent_title = $parent ? $parent->get_title() : ''; $title = $parent_title . ' - ' . implode(', ', $attr_display); } } } return $title; } add_filter('the_title', 'display_variation_attributes_in_title', 10, 2);

FREE delivery on bank transfer orders over Rs.9,999/-.

Shopping Cart

No products in the cart.

© 2022 Enzian. DESIGNED BY LA-STUDIO

Vince Camuto – Mists

Vince Camuto – Mists

Sale!

Vince Camuto - Mists

Vince Camuto - Mists - Image 2

Original price was: ₨ 7,500.Current price is: ₨ 3,500.

What makes it special?

Skin is lightly scented

Body Spray

SKU: N/A Categories: Body Mist & Hair Mist, Body Spray, Fragrance, Women

What makes it special?

Skin is lightly scented

Body Spray

Scent	Amore, Fiori, Original

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related Products

Quick View Add to cart
Michael Kors – Gold Perfume – 50ml
Fragrance Perfume Women
₨ 20,500
Quick View Add to cart
Sale!
Quick View Add to cart
Bath & Body Works Candle – Georgia Peach
Candles Candles & Home Scents Fragrance
Original price was: ₨ 8,500.Current price is: ₨ 5,500.
Quick View Add to cart
Sale!
Quick View Add to cart
Bath & Body Works Candle – Strawberry Pound Cake
Candles Candles & Home Scents Fragrance
Original price was: ₨ 8,500.Current price is: ₨ 5,500.
Quick View Add to cart
Out of stock Sale!
Quick View Read more
Bath & Body Works Candle – Love Cotton Candy Champagne
Candles Candles & Home Scents Fragrance
Original price was: ₨ 8,500.Current price is: ₨ 5,500.
Quick View Read more
Out of stock Sale!
Quick View Read more
White Barn Candle – Cactus Blossom
Candles Candles & Home Scents Fragrance
Original price was: ₨ 8,500.Current price is: ₨ 5,500.
Quick View Read more
Quick View Add to cart
Michael Kors – SEXY Blossom – 30ml
Fragrance Perfume Women
₨ 8,800
Quick View Add to cart
Quick View Add to cart
Burberry – Touch – 100ml
Fragrance Perfume Women
₨ 12,000
Quick View Add to cart
Out of stock
Quick View Read more
Narciso Rodrigues – Bleu Noir – 50ml
Cologne Fragrance Men
₨ 17,500
Quick View Read more

Want something from USA?

Contact Form

Name Phone Email Message
WhatsApp