app-download-header
24 Hours Sale - 95% Off on Everything
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Women

Filter
Shopping Options
Category
Category
  • Dresses 114 items
Styles
Styles
  1. Asymmetrical Dresses 39 items
  2. Blouses 19 items
  3. Body Suits 10 items
  4. Bodycon 217 items
  5. Crop Tops 29 items
  6. Denim Dresses 2 items
  7. Denim Tops 1 item
  8. Flare Jeans 10 items
  9. Jumpsuits 55 items
  10. Maxi Dresses 201 items
  11. Maxi Skirts 19 items
  12. Maxi Tops 1 item
  13. Midi Dresses 75 items
  14. Midi Skirts 15 items
  15. Nightdresses 1 item
  16. Nightwear Set 13 items
  17. Off Shoulder Tops 6 items
  18. Off-shoulder And Bandeau Dresses 92 items
  19. Pencil Dresses 61 items
  20. Pencil Skirts 2 items
  21. Playsuits And Rompers 17 items
  22. Ripped Jeans 1 item
  23. Sets 294 items
  24. Shift Dresses 22 items
  25. Shirt Dresses 23 items
  26. Shirts 13 items
  27. Short And Mini Skirts 19 items
  28. Skater Dresses 62 items
  29. Skater Skirts 4 items
  30. Straight Jeans 31 items
  31. Swimsuit 27 items
  32. T-shirts 79 items
  33. Tunic Dresses 3 items
  34. Vests And Camis 16 items
  35. Sports Bra 12 items
  36. Wrap Dresses 7 items
  37. Mom Jeans 1 item
  38. Wide Leg Jeans 6 items
  39. Corsets & Tube Tops 26 items
  40. Corset Dresses 34 items
Colour
Colour
  1. Beige 7 items
  2. Black 29 items
  3. Blue 12 items
  4. Brown 3 items
  5. Gold 1 item
  6. Green 9 items
  7. Multi 6 items
  8. Orange 2 items
  9. Pink 11 items
  10. Purple 1 item
  11. Red 13 items
  12. Silver 1 item
  13. White 16 items
  14. Yellow 3 items
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 5 items
  3. 4XL 5 items
  4. 5XL 5 items
  5. F-S 0 items
  6. L 106 items
  7. M 106 items
  8. S 110 items
  9. XL 35 items
  10. XS 9 items
Less
Price
Price
  1. Rs. 200 - 400 35 items
  2. Rs. 400 - 600 1 item
  3. Rs. 600 - 800 1 item
  4. Rs. 800 - 1000 6 items
  5. Rs. 1000 - 1200 13 items
  6. Rs. 1200 - 1400 30 items
  7. Rs. 1400 - 1600 53 items
  8. Rs. 1600 - 1800 71 items
  9. Rs. 1800 - 2000 39 items
  10. Rs. 2000 - 2500 114 items
  11. Rs. 2500 - 3000 104 items
  12. Rs. 3000 - 3500 8 items
  13. Rs. 3500 - 4000 9 items
  14. Rs. 4000 - 4500 3 items
  15. Rs. 4500 - 5000 1 item
  1. Shift Dresses Remove This Item
  2. Off-shoulder And Bandeau Dresses Remove This Item
  3. F-S Remove This Item
  4. S Remove This Item
  5. XS Remove This Item
  6. Rs. 2000 - 2500 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=469 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_6605d1efd5b944_84598591` 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

114 styles found
  1. 59% Off
    -59%
    PINK IRREGULAR HEM BANDEAU DRESS
  2. 58% Off
    -58%
    CORSETRY SEQUINNED BANDEAU DRESS
  3. 58% Off
    -58%
    PUFF SLEEVE GREEN SATIN SHIFT DRESS
  4. 58% Off
    -58%
    CORSETRY LAKE-BLUE BANDEAU DRESS
  5. 58% Off
    -58%
    PUFF SLEEVE BLACK SATIN SHIFT DRESS
  6. 58% Off
    -58%
    PRINTED PINK PLEAT BANDEAU DRESS
  7. 58% Off
    -58%
    MULTICOLOUR Y2K FLORAL BANDEAU DRESS
  8. 58% Off
    -58%
    ROSE-RED OFF-SHOULDER SLIM DRESS
  9. 59% Off
    -59%
    LIGHT GREEN RUFFLY SHIFT DRESS