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
Styles
Styles
  1. Asymmetrical Dresses 42 items
  2. Blouses 38 items
  3. Body Suits 62 items
  4. Bodycon 200 items
  5. Cover Ups 6 items
  6. Crop Tops 84 items
  7. Jumpsuits 46 items
  8. Maxi Dresses 155 items
  9. Maxi Skirts 10 items
  10. Midi Dresses 72 items
  11. Midi Skirts 9 items
  12. Nightdresses 35 items
  13. Nightwear Set 95 items
  14. Off Shoulder Tops 16 items
  15. Off-shoulder And Bandeau Dresses 82 items
  16. Pencil Dresses 32 items
  17. Pencil Skirts 3 items
  18. Playsuits And Rompers 23 items
  19. Sets 380 items
  20. Shift Dresses 25 items
  21. Shirt Dresses 4 items
  22. Shirts 17 items
  23. Short And Mini Skirts 17 items
  24. Skater Dresses 55 items
  25. Skater Skirts 6 items
  26. Straight Jeans 8 items
  27. Swimsuit 36 items
  28. T-shirts 142 items
  29. Tunic Dresses 10 items
  30. Tunic Tops 0 items
  31. Vests And Camis 95 items
  32. Hipster 17 items
  33. Bikini 36 items
  34. Boyshort 35 items
  35. Thong 131 items
  36. Cycling Short 1 item
  37. Sports 10 items
  38. T-Shirt Bra 4 items
  39. Bralette 5 items
  40. Sports Bra 4 items
  41. Collars 1 item
  42. Wide Leg Jeans 2 items
  43. Corsets & Tube Tops 130 items
  44. Cold Shoulder Tops 3 items
  45. Corset Dresses 15 items
Colour
Colour
  1. Beige 46 items
  2. Black 307 items
  3. Blue 101 items
  4. Brown 85 items
  5. Gold 4 items
  6. Green 94 items
  7. Grey 59 items
  8. Maroon 1 item
  9. Multi 45 items
  10. Orange 16 items
  11. Pink 72 items
  12. Purple 38 items
  13. Red 80 items
  14. Silver 8 items
  15. White 172 items
  16. Yellow 19 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 28 items
  3. 3XL 20 items
  4. 4XL 2 items
  5. 5XL 1 item
  6. FS 22 items
  7. L 178 items
  8. M 180 items
  9. PLUS 1 item
  10. S 176 items
  11. XL 90 items
  12. XS 9 items
  13. XXL 10 items
  14. XXXL 7 items
Less
Price
Price
  1. Rs. 200 - 400 3 items
  2. Rs. 400 - 600 1 item
  3. Rs. 600 - 800 4 items
  4. Rs. 800 - 1000 27 items
  5. Rs. 1000 - 1200 25 items
  6. Rs. 1200 - 1400 14 items
  7. Rs. 1400 - 1600 18 items
  8. Rs. 1600 - 1800 18 items
  9. Rs. 1800 - 2000 16 items
  10. Rs. 2000 - 2500 38 items
  11. Rs. 2500 - 3000 41 items
  12. Rs. 3000 - 3500 7 items
  13. Rs. 3500 - 4000 2 items
  1. Pencil Dresses Remove This Item
  2. Maxi Skirts Remove This Item
  3. Crop Tops Remove This Item
  4. Tunic Tops Remove This Item
  5. Midi Dresses Remove This Item
  6. Beige Remove This Item
  7. Red Remove This Item
  8. Pink Remove This Item
  9. L 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_6605ae55c7cd26_27288597` 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

197 styles found
  1. 60% Off
    -60%
    A LITTLE SYNCH PINK DRESS
  2. 58% Off
    -58%
    HIGH-NECK RED CUT-OUT PENCIL DRESS
  3. 58% Off
    -58%
    FIELDS OF ROSES MIDI DRESS
  4. 58% Off
    -58%
    ROSE-RED HALTER-PLUNGE PENCIL DRESS
  5. 58% Off
    -58%
    ROSE-RED CRISS-CROSS PENCIL DRESS
  6. 60% Off
    -60%
    Red Mid Length Fishtail Dress
  7. 60% Off
    -60%
    ROS RED SQUARE NECK MIDI SLIP DRESS
  8. 60% Off
    -60%
    Halter Neck Cut-out Slit Midi Dress
  9. 95% Off
    -95%
    I MEAN BUSINESS RED DRESS
  10. 60% Off
    -60%
    Pink Cap Sleeve Printed Crop Top
  11. 59% Off
    -59%
    RED DRAWSTRING DETAIL CROP TOP
  12. 60% Off
    -60%
    RUCHED-AND-SO RED PENCIL DRESS
  13. 59% Off
    -59%
    PLEATED V-NECK CHIFFON MIDI DRESS
  14. 58% Off
    -58%
    PINK CUT-OUT-WAIST SLIT MIDI DRESS
  15. 59% Off
    -59%
    SQUARE NECK RIBBED PINK CROP TOP
  16. 58% Off
    -58%
    RED ROUND-NECK A-LINE MIDI DRESS
  17. 59% Off
    -59%
    OFF-WHITE DRAWSTRING CROP TOP
  18. 58% Off
    -58%
    ROSE-RED SLIT SUSPENDER MIDI DRESS
  19. 60% Off
    -60%
    Printed Pink Full Sleeved Crop Top
  20. 60% Off
    -60%
    SIMPLE TASSEL-DETAIL RIBBED CROP TOP
  21. 59% Off
    -59%
    PRINTED SQUARE NECK RED MIDI DRESS