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 10 items
  2. Blouses 7 items
  3. Body Suits 4 items
  4. Bodycon 75 items
  5. Cover Ups 16 items
  6. Crop Tops 18 items
  7. Denim Dresses 1 item
  8. Denim Tops 1 item
  9. Flare Jeans 5 items
  10. Jumpsuits 20 items
  11. Maxi Dresses 59 items
  12. Maxi Skirts 3 items
  13. Midi Dresses 36 items
  14. Midi Skirts 3 items
  15. Nightdresses 3 items
  16. Nightwear Set 28 items
  17. Off-shoulder And Bandeau Dresses 24 items
  18. Pencil Dresses 23 items
  19. Pencil Skirts 1 item
  20. Playsuits And Rompers 15 items
  21. Sets 166 items
  22. Shift Dresses 14 items
  23. Shirt Dresses 14 items
  24. Shirts 31 items
  25. Short And Mini Skirts 3 items
  26. Skater Dresses 22 items
  27. Straight Jeans 28 items
  28. Swimsuit 103 items
  29. T-shirts 161 items
  30. Tunic Dresses 2 items
  31. Vests And Camis 12 items
  32. Sports Bra 12 items
  33. Wrap Dresses 5 items
  34. Mom Jeans 1 item
  35. Wide Leg Jeans 5 items
  36. Corsets & Tube Tops 7 items
  37. Cold Shoulder Tops 1 item
  38. Corset Dresses 7 items
Colour
Colour
  1. Beige 64 items
  2. Black 229 items
  3. Blue 156 items
  4. Brown 73 items
  5. Gold 2 items
  6. Green 94 items
  7. Grey 47 items
  8. Maroon 2 items
  9. Multi 72 items
  10. Orange 25 items
  11. Pink 85 items
  12. Purple 34 items
  13. Red 66 items
  14. White 126 items
  15. Yellow 20 items
Less
Size
Size
  1. 14 0 items
  2. 1XL 36 items
  3. 26 3 items
  4. 27 3 items
  5. 28 2 items
  6. 2XL 170 items
  7. 30 2 items
  8. 32 2 items
  9. 36G 1 item
  10. 3XL 72 items
  11. 4XL 54 items
  12. 5XL 25 items
  13. 6XL 3 items
  14. 70B 13 items
  15. 70C 15 items
  16. 75B 18 items
  17. 75C 18 items
  18. 75D 17 items
  19. 80B 18 items
  20. 80C 18 items
  21. 80D 17 items
  22. 85B 18 items
  23. 85C 18 items
  24. 85D 18 items
  25. FS 83 items
  26. L 1876 items
  27. M 1899 items
  28. S 1664 items
  29. XL 966 items
  30. XS 100 items
  31. XXL 94 items
  32. XXXL 5 items
  33. 0XL 16 items
Less
Price
Price
  1. Rs. 0 - 200 57 items
  2. Rs. 200 - 400 165 items
  3. Rs. 400 - 600 114 items
  4. Rs. 600 - 800 75 items
  5. Rs. 800 - 1000 191 items
  6. Rs. 1000 - 1200 244 items
  7. Rs. 1200 - 1400 369 items
  8. Rs. 1400 - 1600 429 items
  9. Rs. 1600 - 1800 464 items
  10. Rs. 1800 - 2000 424 items
  11. Rs. 2000 - 2500 1016 items
  12. Rs. 2500 - 3000 905 items
  13. Rs. 3000 - 3500 368 items
  14. Rs. 3500 - 4000 178 items
  15. Rs. 4000 - 4500 54 items
  16. Rs. 4500 - 5000 12 items
  17. Rs. 5000 - 5500 7 items
  18. Rs. 5500 - 6000 1 item
  19. Rs. 6000 - 6500 2 items
  1. XL Remove This Item
  2. 14 Remove This Item
  3. 2XL Remove This Item
  4. 1XL Remove This Item
  5. Rs. 2000 - 2500 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_662ca980c95ed6_06514805` 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

1095 styles found
  1. 60% Off
    -60%
    CHECKERED HALTERNECK BLUE SWIMSUIT
  2. 60% Off
    -60%
    BROWN BELT-TIE MIDI SHIRT DRESS
  3. 58% Off
    -58%
    CUT-OUT RING-DETAIL MAXI DRESS
  4. 58% Off
    -58%
    RUFFLY TEIRED OFF-WHITE MAXI DRESS
  5. 58% Off
    -58%
    SLIMMING ORANGE CORSET DRESS
  6. 59% Off
    -59%
    BLUE ONE-SHOULDER ASYMMETRICAL DRESS
  7. 58% Off
    -58%
    ABSTRACT PRINT GREEN WRAP DRESS
  8. 58% Off
    -58%
    HIGH-WAIST LIGHT BLUE STRAIGHT JEANS