Close Extra 5% OFF* On App Only
Use Code: APP5

Dresses

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 2 items
  2. Bodycon 11 items
  3. Maxi Dresses 7 items
  4. Maxi Skirts 0 items
  5. Midi Dresses 9 items
  6. Mini Skirts 0 items
  7. Off-shoulder And Bandeau Dresses 7 items
  8. Pencil Dresses 1 item
  9. Shift Dresses 5 items
  10. Shirt Dresses 6 items
  11. Skater Dresses 9 items
  12. Tunic Dresses 8 items
Colour
Colour
  1. Beige 1 item
  2. Black 11 items
  3. Blue 5 items
  4. Gold 2 items
  5. Green 1 item
  6. Grey 1 item
  7. Pink 4 items
  8. Red 5 items
  9. White 8 items
  10. Yellow 6 items
Less
Size
Size
  1. L 7 items
  2. M 7 items
  3. S 6 items
  4. XL 9 items
  5. XXL 3 items
Less
Price
Price
  1. Rs. 0 - 1,500 11 items
  1. Mini Skirts Remove This Item
  2. Pencil Dresses Remove This Item
  3. Maxi Skirts Remove This Item
  4. Bodycon Remove This Item
  5. Beige Remove This Item
  6. Red Remove This Item
  7. Grey Remove This Item
  8. Blue Remove This Item

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`size`, `e`.`size_value`, `e`.`eancode`, `e`.`wallet_credit_based_on`, `e`.`wallet_credit_based_on_value`, `e`.`wallet_cash_back`, `e`.`hsn_code`, `e`.`dateofupload`, `e`.`heel_size`, `e`.`heel_size_value`, `e`.`product_color`, `e`.`price_filter`, `e`.`price_filter_value`, `e`.`styles`, `e`.`app_special_price`, `e`.`swatch_image`, `e`.`disable_cod`, `e`.`product_tag`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=470 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `search_tmp_61ef2e6b85ed54_10837035` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

12 styles found
  1. 95% Off
    -95%
    Lead The Season On Red Bodycon Dress
    New
    Lead The Season On Red Bodycon Dress
    ₹3,649
    ₹182 (95% Off)
  2. 89% Off
    -89%
    CHECK IT OUT RED CHECK DRESS
    New
    Check It Out Red Check Dress
    ₹3,699
    ₹425 (89% Off)
  3. 90% Off
    -90%
    HALTING MY PACE RED BODYCON DRESS
    New
    Halting My Pace Red Bodycon Dress
    ₹3,049
    ₹305 (90% Off)
  4. 88% Off
    -88%
    LANGUISH IN LACE BLUE DRESS
    New
    Languish In Lace Blue Dress
    ₹5,249
    ₹604 (88% Off)
  5. 88% Off
    -88%
    BOSSY SIDE DARK BLUE DRESS
    New
    Bossy Side Dark Blue Dress
    ₹5,249
    ₹604 (88% Off)
  6. 88% Off
    -88%
    EDGY DELIGHT BLUE DRESS
    New
    Edgy Delight Blue Dress
    ₹5,449
    ₹627 (88% Off)
  7. 89% Off
    -89%
    BRIGHT SCENES WINE BODYCON DRESS
    New
    Bright Scenes Wine Bodycon Dress
    ₹5,499
    ₹632 (89% Off)
  8. 88% Off
    -88%
    BOSS ON THE WAY GREY DRESS
    New
    Boss On The Way Grey Dress
    ₹5,649
    ₹650 (88% Off)
  9. 88% Off
    -88%
    BLOOM WHEREVER YOU GO TWIST KNOT DRESS
    New
    Bloom Wherever You Go Twist Knot Dress
    ₹5,999
    ₹690 (88% Off)
  10. 89% Off
    -89%
    BLOSSOM FOR YOUR OWN JOY BODYCON DRESS IN RED
    New
    Blossom For Your Own Joy Bodycon Dress In Red
    ₹6,349
    ₹730 (89% Off)
  11. 89% Off
    -89%
    THE FLORAL REGION NAVY DRESS
    New
    The Floral Region Navy Dress
    ₹6,499
    ₹747 (89% Off)
  12. 85% Off
    PREMIUM
    LACE UP OFF-WHITE PENCIL DRESS
    New
    Lace Up Off-white Pencil Dress
    ₹13,152
    ₹1,973 (85% Off)