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 25 items
  2. Blouses 17 items
  3. Body Suits 18 items
  4. Bodycon 139 items
  5. Crop Tops 27 items
  6. Cropped Jeans 1 item
  7. Denim Tops 4 items
  8. Dungarees 0 items
  9. Flare Jeans 3 items
  10. Jumpsuits 34 items
  11. Maxi Dresses 78 items
  12. Maxi Skirts 11 items
  13. Midi Dresses 44 items
  14. Midi Skirts 7 items
  15. Nightdresses 37 items
  16. Nightwear Set 18 items
  17. Off Shoulder Tops 22 items
  18. Off-shoulder And Bandeau Dresses 25 items
  19. Pencil Dresses 10 items
  20. Pencil Skirts 3 items
  21. Pinafore 0 items
  22. Playsuits And Rompers 19 items
  23. Sets 193 items
  24. Shift Dresses 14 items
  25. Shirts 8 items
  26. Short And Mini Skirts 21 items
  27. Skater Dresses 19 items
  28. Skater Skirts 2 items
  29. Straight Jeans 7 items
  30. Swimsuit 27 items
  31. T-shirts 66 items
  32. Tunic Dresses 3 items
  33. Vests And Camis 23 items
  34. Sports 11 items
  35. Sports Bra 8 items
  36. Vests 1 item
  37. Wide Leg Jeans 1 item
  38. Corsets & Tube Tops 29 items
  39. Cold Shoulder Tops 3 items
  40. Corset Dresses 6 items
Colour
Colour
  1. Beige 6 items
  2. Black 59 items
  3. Blue 16 items
  4. Brown 14 items
  5. Gold 1 item
  6. Green 9 items
  7. Grey 7 items
  8. Maroon 1 item
  9. Multi 1 item
  10. Orange 3 items
  11. Pink 10 items
  12. Red 15 items
  13. Silver 3 items
  14. White 10 items
  15. Yellow 1 item
Less
Size
Size
  1. 2XL 7 items
  2. FS 17 items
  3. L 142 items
  4. M 146 items
  5. M/10 0 items
  6. S 147 items
  7. S/M 0 items
  8. XL 44 items
  9. XS 17 items
Less
Price
Price
  1. Rs. 200 - 400 51 items
  2. Rs. 400 - 600 4 items
  3. Rs. 600 - 800 1 item
  4. Rs. 800 - 1000 28 items
  5. Rs. 1000 - 1200 77 items
  6. Rs. 1200 - 1400 107 items
  7. Rs. 1400 - 1600 194 items
  8. Rs. 1600 - 1800 149 items
  9. Rs. 1800 - 2000 156 items
  10. Rs. 2000 - 2500 268 items
  11. Rs. 2500 - 3000 212 items
  12. Rs. 3000 - 3500 99 items
  13. Rs. 3500 - 4000 29 items
  14. Rs. 4000 - 4500 10 items
  15. Rs. 4500 - 5000 3 items
  16. Rs. 5000 - 5500 1 item
  1. Pinafore Remove This Item
  2. Midi Skirts Remove This Item
  3. Pencil Skirts Remove This Item
  4. Dungarees Remove This Item
  5. Straight Jeans Remove This Item
  6. Bodycon Remove This Item
  7. S/M Remove This Item
  8. M Remove This Item
  9. M/10 Remove This Item
  10. XL Remove This Item
  11. L Remove This Item
  12. Rs. 1800 - 2000 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_6605c1273ff496_31205316` 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

156 styles found
  1. 58% Off
    -58%
    SHORT BLUE CORSETRY BODYCON DRESS
  2. 58% Off
    -58%
    MESH-WAIST BLACK BODYCON DRESS
  3. 60% Off
    -60%
    RUFFELED CLARET COLD-SHOULDER DRESS
  4. 60% Off
    -60%
    Black Mid-length Sheath Dress
  5. 60% Off
    -60%
    KHAKI SIDE SLIT PARACHUTE MIDI SKIRT
  6. 58% Off
    -58%
    BLACK CUT-OUT PU BODYCON DRESS
  7. 58% Off
    -58%
    BLACK PLEATED HEM BODYCON DRESS
  8. 58% Off
    -58%
    SHIRRED BLACK VELVET BODYCON DRESS
  9. 58% Off
    -58%
    SHIRRED WHITE CUT-OUT BODYCON DRESS
  10. 58% Off
    -58%
    SHIRRED BLACK CUT-OUT BODYCON DRESS
  11. 58% Off
    -58%
    PINK SATIN CUT-DETAIL BODYCON DRESS
  12. 58% Off
    -58%
    WHITE TIERED MID-LENGTH SKIRT
  13. 58% Off
    -58%
    GLITTERY HALTER PINK BODYCON DRESS
  14. 58% Off
    -58%
    GLITTERY HALTER SHORT BODYCON DRESS
  15. 60% Off
    -60%
    MESH-WAIST SILVER BODYCON DRESS
  16. 58% Off
    -58%
    SHIRRED RED VELVET BODYCON DRESS
  17. 58% Off
    -58%
    RIBBED DEEP-GREY BODYCON DRESS