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
  • Skirts 9 items
Styles
Styles
  1. Asymmetrical Dresses 2 items
  2. Blouses 10 items
  3. Body Suits 20 items
  4. Bodycon 63 items
  5. Cover Ups 4 items
  6. Crop Tops 63 items
  7. Cropped Jeans 1 item
  8. Flare Jeans 9 items
  9. Jumpsuits 23 items
  10. Maxi Dresses 33 items
  11. Maxi Skirts 9 items
  12. Midi Dresses 30 items
  13. Midi Skirts 22 items
  14. Nightdresses 33 items
  15. Nightwear Set 33 items
  16. Off Shoulder Tops 12 items
  17. Off-shoulder And Bandeau Dresses 19 items
  18. Pencil Dresses 12 items
  19. Pencil Skirts 2 items
  20. Playsuits And Rompers 16 items
  21. Sets 132 items
  22. Shift Dresses 7 items
  23. Shirt Dresses 2 items
  24. Shirts 5 items
  25. Short And Mini Skirts 11 items
  26. Skater Dresses 8 items
  27. Skater Skirts 12 items
  28. Skinny Jeans 1 item
  29. Straight Jeans 23 items
  30. Swimsuit 20 items
  31. T-shirts 129 items
  32. Tunic Dresses 0 items
  33. Vests And Camis 47 items
  34. Hipster 5 items
  35. Bikini 17 items
  36. Boyshort 7 items
  37. Thong 44 items
  38. Cycling Short 2 items
  39. Boyleg 1 item
  40. Sports 11 items
  41. T-Shirt Bra 1 item
  42. Padded 2 items
  43. Sports Bra 2 items
  44. Collars 2 items
  45. Wrap Dresses 1 item
  46. Baggy Jeans 2 items
  47. Wide Leg Jeans 6 items
  48. Corsets & Tube Tops 30 items
  49. Cold Shoulder Tops 2 items
  50. Corset Dresses 6 items
  51. Dressing Gowns & Robes 2 items
Colour
Colour
  1. Beige 26 items
  2. Black 135 items
  3. Blue 57 items
  4. Brown 37 items
  5. Gold 2 items
  6. Green 37 items
  7. Grey 13 items
  8. Maroon 1 item
  9. Multi 29 items
  10. Orange 9 items
  11. Pink 49 items
  12. Purple 16 items
  13. Red 45 items
  14. Silver 5 items
  15. White 72 items
  16. Yellow 8 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 5 items
  3. 3XL 5 items
  4. 4XL 1 item
  5. FS 3 items
  6. L 22 items
  7. M 22 items
  8. S 22 items
  9. XL 9 items
  10. XS 1 item
  11. XXL 3 items
  12. XXXL 2 items
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 5 items
  3. Rs. 1400 - 1600 3 items
  4. Rs. 1600 - 1800 3 items
  5. Rs. 1800 - 2000 3 items
  6. Rs. 2000 - 2500 6 items
  7. Rs. 2500 - 3000 7 items
  8. Rs. 3000 - 3500 1 item
  9. Rs. 3500 - 4000 3 items
  1. Tunic Dresses Remove This Item
  2. Skater Dresses Remove This Item
  3. Maxi Skirts Remove This Item
  4. Pencil Dresses Remove This Item
  5. Purple Remove This Item
  6. Grey 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_6605fbfd02da48_72162355` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` DESC, `e`.`entity_id` DESC LIMIT 24

Page
29 styles found
  1. 60% Off
    -60%
    Grey Printed Stand-up Collar Dress
  2. 60% Off
    -60%
    Short Cut-out Detail Purple Dress
  3. 60% Off
    -60%
    Purple Short Zip-back Skater Dress
  4. 60% Off
    -60%
    GREY KNITTED A-LINE SKATER DRESS
  5. 60% Off
    -60%
    COLLARED PURPLE KNITTED PENCIL DRESS
  6. 58% Off
    -58%
    PURPLE PLEAT-DETAIL PENCIL DRESS
  7. 60% Off
    -60%
    COLOURBLOCK PURPLE PENCIL DRESS
  8. 58% Off
    -58%
    SOLID DRAPED FRONT GREY PENCIL DRESS
  9. 60% Off
    -60%
    Flared Cuff Grey A-line Mini Dress
  10. 60% Off
    -60%
    GREY IRREGULAR LONG RUCHED SKIRT
  11. 59% Off
    -59%
    PRINTED PURPLE SLIT PENCIL DRESS
  12. 60% Off
    -60%
    Grey Spaghetti Strap Pleated Dress
  13. 59% Off
    -59%
    PURPLE FLAP FRONT PENCIL DRESS
  14. 60% Off
    -60%
    PURPLE BODY-PRINT PENCIL DRESS
  15. 60% Off
    -60%
    High-rise A-line Grey Maxi Skirt
  16. 60% Off
    -60%
    High-rise Dark Grey Maxi Skirt
  17. 60% Off
    -60%
    PURPLE CUT-OUT DETAIL PENCIL DRESS
Page