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 66 items
  2. Blouses 59 items
  3. Body Suits 188 items
  4. Bodycon 458 items
  5. Cover Ups 8 items
  6. Crop Tops 203 items
  7. Denim Dresses 1 item
  8. Denim Tops 3 items
  9. Dungarees 1 item
  10. Flare Jeans 19 items
  11. Jumpsuits 115 items
  12. Maxi Dresses 266 items
  13. Maxi Skirts 27 items
  14. Midi Dresses 113 items
  15. Midi Skirts 18 items
  16. Nightdresses 5 items
  17. Nightwear Set 33 items
  18. Off Shoulder Tops 38 items
  19. Off-shoulder And Bandeau Dresses 158 items
  20. Pencil Dresses 61 items
  21. Pencil Skirts 8 items
  22. Playsuits And Rompers 72 items
  23. Ripped Jeans 1 item
  24. Sets 536 items
  25. Shift Dresses 36 items
  26. Shirt Dresses 8 items
  27. Shirts 25 items
  28. Short And Mini Skirts 48 items
  29. Skater Dresses 90 items
  30. Skater Skirts 14 items
  31. Skinny Jeans 1 item
  32. Straight Jeans 30 items
  33. Swimsuit 38 items
  34. T-shirts 302 items
  35. Tunic Dresses 9 items
  36. Vests And Camis 196 items
  37. Hipster 3 items
  38. Bikini 14 items
  39. Boyshort 21 items
  40. Thong 43 items
  41. Cycling Short 2 items
  42. Sports 24 items
  43. T-Shirt Bra 4 items
  44. Bralette 10 items
  45. Sports Bra 7 items
  46. Wrap Dresses 10 items
  47. Mom Jeans 1 item
  48. Baggy Jeans 2 items
  49. Wide Leg Jeans 15 items
  50. Thongbody 1 item
  51. Corsets & Tube Tops 207 items
  52. Cold Shoulder Tops 9 items
  53. Corset Dresses 46 items
Colour
Colour
  1. Beige 41 items
  2. Black 229 items
  3. Blue 56 items
  4. Brown 78 items
  5. Green 41 items
  6. Grey 71 items
  7. Maroon 1 item
  8. Multi 27 items
  9. Orange 3 items
  10. Pink 74 items
  11. Purple 9 items
  12. Red 25 items
  13. Silver 1 item
  14. White 160 items
  15. Yellow 10 items
Less
Size
Size
  1. 1XL 5 items
  2. 2XL 68 items
  3. 3XL 27 items
  4. 4XL 6 items
  5. FS 66 items
  6. L 347 items
  7. M 369 items
  8. S 287 items
  9. XL 193 items
  10. XS 13 items
  11. XXL 56 items
Less
Price
Price
  1. Rs. 200 - 400 8 items
  2. Rs. 400 - 600 2 items
  3. Rs. 600 - 800 5 items
  4. Rs. 800 - 1000 20 items
  5. Rs. 1000 - 1200 51 items
  6. Rs. 1200 - 1400 78 items
  7. Rs. 1400 - 1600 45 items
  8. Rs. 1600 - 1800 37 items
  9. Rs. 1800 - 2000 21 items
  10. Rs. 2000 - 2500 26 items
  11. Rs. 2500 - 3000 20 items
  12. Rs. 3000 - 3500 4 items
  1. Skinny Jeans Remove This Item
  2. T-shirts Remove This Item
  3. Tunic Dresses Remove This Item
  4. Purple Remove This Item
  5. Pink Remove This Item
  6. Black Remove This Item
  7. 3XL Remove This Item
  8. S 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_66065fe36e1182_49532751` 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

307 styles found
  1. 58% Off
    -58%
    BLINGY PINK NETTED MESH T-SHIRT
  2. 58% Off
    -58%
    RETRO BLACK SKINNY SLIT JEANS
  3. 60% Off
    -60%
    Black A-line Tiered Casual Dress
  4. 60% Off
    -60%
    Black Washed-effect Printed T-shirt
  5. 60% Off
    -60%
    BLACK PUFF PRINT CREW NECK T-SHIRT
  6. 60% Off
    -60%
    KNITTED SLIM BLACK POLYESTER TOP
  7. 60% Off
    -60%
    BLACK HALTER NECK SLIM FIT TOP
  8. 60% Off
    -60%
    PINK ZIP-UP LACE TRIM HOODED TOP
  9. 60% Off
    -60%
    KNITTED BLACK HOLLOW-LACE CUFF TOP
  10. 60% Off
    -60%
    Black Loose Fit Long-sleeved T-shirt
  11. 60% Off
    -60%
    BLACK BUTTON-DOWN CARDIGAN STYLE TOP
  12. 60% Off
    -60%
    BLACK KNITTED GRAPHIC PRINT T-SHIRT
  13. 60% Off
    -60%
    BLACK FLORAL PRINT COTTON T-SHIRT
  14. 60% Off
    -60%
    BLACK GRAPHIC SHORT SLEEVES T-SHIRT