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 107 items
  • Skirts 33 items
Styles
Styles
  1. Asymmetrical Dresses 43 items
  2. Blouses 73 items
  3. Body Suits 74 items
  4. Bodycon 263 items
  5. Cover Ups 19 items
  6. Crop Tops 154 items
  7. Flare Jeans 1 item
  8. Jumpsuits 66 items
  9. Maxi Dresses 195 items
  10. Maxi Skirts 33 items
  11. Midi Dresses 103 items
  12. Midi Skirts 64 items
  13. Nightdresses 70 items
  14. Nightwear Set 103 items
  15. Off Shoulder Tops 28 items
  16. Off-shoulder And Bandeau Dresses 94 items
  17. Pencil Dresses 41 items
  18. Pencil Skirts 5 items
  19. Playsuits And Rompers 29 items
  20. Ripped Jeans 1 item
  21. Sets 548 items
  22. Shift Dresses 34 items
  23. Shirt Dresses 6 items
  24. Shirts 27 items
  25. Short And Mini Skirts 29 items
  26. Skater Dresses 57 items
  27. Skater Skirts 20 items
  28. Straight Jeans 12 items
  29. Swimsuit 71 items
  30. T-shirts 303 items
  31. Tunic Dresses 9 items
  32. Tunic Tops 1 item
  33. Vests And Camis 165 items
  34. Hipster 17 items
  35. Bikini 51 items
  36. Boyshort 34 items
  37. Thong 237 items
  38. Cycling Short 1 item
  39. Boyleg 2 items
  40. Full Figure 2 items
  41. Sports 26 items
  42. T-Shirt Bra 25 items
  43. Bralette 5 items
  44. Padded 4 items
  45. Non Padded 17 items
  46. Sports Bra 9 items
  47. Wrap Dresses 3 items
  48. Mom Jeans 1 item
  49. Wide Leg Jeans 11 items
  50. Corsets & Tube Tops 120 items
  51. Cold Shoulder Tops 6 items
  52. Sarong 8 items
  53. Corset Dresses 19 items
  54. 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 6 items
  2. 2XL 22 items
  3. 3XL 16 items
  4. 4XL 2 items
  5. FS 11 items
  6. L 109 items
  7. M 107 items
  8. S 109 items
  9. XL 54 items
  10. XS 4 items
  11. XXL 8 items
  12. XXXL 6 items
Less
Price
Price
  1. Rs. 200 - 400 6 items
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 1 item
  4. Rs. 1000 - 1200 2 items
  5. Rs. 1200 - 1400 17 items
  6. Rs. 1400 - 1600 8 items
  7. Rs. 1600 - 1800 20 items
  8. Rs. 1800 - 2000 6 items
  9. Rs. 2000 - 2500 32 items
  10. Rs. 2500 - 3000 40 items
  11. Rs. 3000 - 3500 9 items
  12. Rs. 3500 - 4000 4 items
  13. Rs. 4000 - 4500 3 items
  14. Rs. 5000 - 5500 1 item
  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. Pink Remove This Item
  7. Brown Remove This Item
  8. Maroon Remove This Item
  9. Green 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_6605f813ce9f08_67976678` 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

140 styles found
  1. 60% Off
    -60%
    BROWN FAUX LEATHER SLIT MAXI SKIRT
  2. 59% Off
    -59%
    PURPLE TIE-DYE HALTER SKATER DRESS
  3. 60% Off
    -60%
    LAYERED RUFFLE TRIM BROWN MAXI SKIRT
  4. 60% Off
    -60%
    Pink Lace-up Back Skater Dress
  5. 60% Off
    -60%
    Light Pink Floral Print V-neck Dress
  6. 60% Off
    -60%
    LAYERED FRILL PINK SKATER DRESS
  7. 58% Off
    -58%
    PINK EMBELLISH SKATER DRESS
  8. 58% Off
    -58%
    BROWN LACE-UP DETAIL PENCIL DRESS
  9. 60% Off
    -60%
    Khaki Mesh Sweetheart Short Dress
  10. 58% Off
    -58%
    SWEETHEART PINK DRESS
  11. 58% Off
    -58%
    GREEN SQUARE NECK SKATER DRESS
  12. 58% Off
    -58%
    PINK SWEETHEART-NECK SKATER DRESS
  13. 58% Off
    -58%
    CERISE FORMAL SLIT PENCIL DRESS
  14. 58% Off
    -58%
    PRINTED GREEN LACE-TRIM PENCIL DRESS
  15. 58% Off
    -58%
    GREEN HALTER-PLUNGE PENCIL DRESS
  16. 60% Off
    -60%
    GREEN PLEATED CHIFFON FS MAXI SKIRT
  17. 58% Off
    -58%
    GREEN PRINTED A-LINE MINI DRESS
  18. 60% Off
    -60%
    PINK BALLOON HEM SKATER DRESS