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 20 items
Styles
Styles
  1. Asymmetrical Dresses 18 items
  2. Blouses 16 items
  3. Body Suits 49 items
  4. Bodycon 96 items
  5. Crop Tops 24 items
  6. Cropped Jeans 4 items
  7. Culottes 1 item
  8. Denim Dresses 3 items
  9. Flare Jeans 30 items
  10. Jumpsuits 7 items
  11. Maxi Dresses 34 items
  12. Maxi Skirts 2 items
  13. Midi Dresses 17 items
  14. Midi Skirts 5 items
  15. Nightwear Set 11 items
  16. Off-shoulder And Bandeau Dresses 33 items
  17. Pencil Dresses 7 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 4 items
  20. Ripped Jeans 3 items
  21. Sets 61 items
  22. Shift Dresses 9 items
  23. Shirts 6 items
  24. Short And Mini Skirts 11 items
  25. Skater Dresses 27 items
  26. Skater Skirts 16 items
  27. Skinny Jeans 4 items
  28. Straight Jeans 75 items
  29. Swimsuit 21 items
  30. T-shirts 47 items
  31. Tunic Tops 1 item
  32. Vests And Camis 61 items
  33. Thong 6 items
  34. Bralette 7 items
  35. Wrap Dresses 2 items
  36. Mom Jeans 1 item
  37. Baggy Jeans 1 item
  38. Wide Leg Jeans 47 items
  39. Corsets & Tube Tops 121 items
  40. Corset Dresses 18 items
Colour
Colour
  1. Black 6 items
  2. Blue 2 items
  3. Brown 1 item
  4. Green 2 items
  5. Grey 1 item
  6. Pink 2 items
  7. Red 2 items
  8. Silver 1 item
  9. White 2 items
  10. Yellow 1 item
Less
Size
Size
  1. 1XL 2 items
  2. 29 0 items
  3. 2XL 44 items
  4. 3XL 29 items
  5. 4XL 7 items
  6. 5XL 5 items
  7. FS 39 items
  8. L 314 items
  9. M 305 items
  10. S 296 items
  11. XL 171 items
  12. XS 10 items
  13. XXL 28 items
  14. XXXL 7 items
Less
Price
Price
  1. Rs. 1600 - 1800 2 items
  2. Rs. 1800 - 2000 1 item
  3. Rs. 2000 - 2500 6 items
  4. Rs. 2500 - 3000 6 items
  5. Rs. 3000 - 3500 3 items
  6. Rs. 3500 - 4000 1 item
  7. Rs. 4000 - 4500 1 item
  1. Midi Dresses Remove This Item
  2. XS Remove This Item
  3. 29 Remove This Item
  4. 4XL 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_6605a1246c5ca7_52083241` 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

20 styles found
  1. 58% Off
    -58%
    PINK CUT-OUT-WAIST SLIT MIDI DRESS
  2. 58% Off
    -58%
    PINK DIAGONAL-RUFFLE MIDI DRESS
  3. 58% Off
    -58%
    JACQUARD WHITE MIDI A-LINE DRESS
  4. 58% Off
    -58%
    PRINTED BLUE MIDI SLIT DRESS
  5. 58% Off
    -58%
    SEQUIN MIDI SLIT BLACK DRESS
  6. 60% Off
    -60%
    RED PLUS SIZE PRINTED MAXI DRESS
  7. 58% Off
    -58%
    BLACK CRISS-CROSS FLARED MIDI DRESS
  8. 59% Off
    -59%
    CUT-OUT PLEATED A-LINE MIDI DRESS
  9. 58% Off
    -58%
    PLUS SIZE DEEP GREEN MIDI DRESS
  10. 58% Off
    -58%
    GREEN CUT-OUT-WAIST SLIT MIDI DRESS
  11. 60% Off
    -60%
    YELLOW IRREGULAR A-LINE MIDI DRESS
  12. 60% Off
    -60%
    Backless Lace-up Black Midi Dress
  13. 60% Off
    -60%
    METALIC EFFECT MIDI DRESS
  14. 60% Off
    -60%
    MOCK NECK SHEATH DRESS