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 38 items
  • Tops 213 items
  • Jeans And Trousers 5 items
    • Jeans 5 items
  • Denim 5 items
    • Jeans 5 items
Styles
Styles
  1. Asymmetrical Dresses 13 items
  2. Blouses 35 items
  3. Body Suits 4 items
  4. Bodycon 42 items
  5. Crop Tops 24 items
  6. Cropped Jeans 3 items
  7. Dungarees 2 items
  8. Flare Jeans 1 item
  9. Jumpsuits 21 items
  10. Maxi Dresses 29 items
  11. Midi Dresses 57 items
  12. Midi Skirts 4 items
  13. Nightwear Set 63 items
  14. Off Shoulder Tops 2 items
  15. Off-shoulder And Bandeau Dresses 19 items
  16. Pencil Dresses 44 items
  17. Playsuits And Rompers 5 items
  18. Sets 84 items
  19. Shift Dresses 12 items
  20. Shirt Dresses 1 item
  21. Shirts 4 items
  22. Short And Mini Skirts 3 items
  23. Skater Dresses 18 items
  24. Skater Skirts 7 items
  25. Skinny Jeans 2 items
  26. Straight Jeans 29 items
  27. Swimsuit 24 items
  28. T-shirts 209 items
  29. Tunic Dresses 3 items
  30. Tunic Tops 1 item
  31. Vests And Camis 16 items
  32. Hipster 26 items
  33. Bikini 6 items
  34. Thong 18 items
  35. Sports 9 items
  36. Bralette 5 items
  37. Wrap Dresses 8 items
  38. Baggy Jeans 1 item
  39. Wide Leg Jeans 11 items
  40. Corsets & Tube Tops 16 items
  41. Cold Shoulder Tops 3 items
Colour
Colour
  1. Beige 11 items
  2. Black 72 items
  3. Blue 25 items
  4. Brown 17 items
  5. Green 18 items
  6. Grey 14 items
  7. Multi 3 items
  8. Orange 2 items
  9. Pink 15 items
  10. Purple 7 items
  11. Red 11 items
  12. White 55 items
  13. Yellow 6 items
Less
Size
Size
  1. 12 0 items
  2. 1XL 14 items
  3. 25 1 item
  4. 26 1 item
  5. 27 2 items
  6. 29 2 items
  7. 2XL 214 items
  8. 30 1 item
  9. 31 2 items
  10. 3XL 80 items
  11. 4XL 20 items
  12. 5XL 4 items
  13. FS 214 items
  14. L 1622 items
  15. M 1678 items
  16. S 1424 items
  17. XL 731 items
  18. XS 65 items
  19. XXL 161 items
  20. XXXL 4 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 11 items
  3. Rs. 400 - 600 7 items
  4. Rs. 600 - 800 18 items
  5. Rs. 800 - 1000 23 items
  6. Rs. 1000 - 1200 7 items
  7. Rs. 1200 - 1400 47 items
  8. Rs. 1400 - 1600 16 items
  9. Rs. 1600 - 1800 29 items
  10. Rs. 1800 - 2000 21 items
  11. Rs. 2000 - 2500 49 items
  12. Rs. 2500 - 3000 21 items
  13. Rs. 3000 - 3500 9 items
  14. Rs. 3500 - 4000 1 item
  15. Rs. 4000 - 4500 3 items
  16. Rs. 4500 - 5000 2 items
  17. Rs. 5000 - 5500 1 item
  1. Skinny Jeans Remove This Item
  2. T-shirts Remove This Item
  3. Tunic Dresses Remove This Item
  4. Maxi Dresses Remove This Item
  5. 12 Remove This Item
  6. 3XL Remove This Item
  7. XXL Remove This Item
  8. 29 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_66061c09123d67_21511311` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`created_at` ASC, `e`.`entity_id` DESC LIMIT 24

254 styles found
  1. 95% Off
    -95%
    CONNECT THE DOTS WHITE MIDI DRESS
  2. 95% Off
    -95%
    HOPPING IN BLUE JEANS
  3. 60% Off
    -60%
    WHO DOESN’T LOVE KHAKI WINTER DRESS
  4. 95% Off
    -95%
    MAKE YOU HAPPY GREY JEANS
  5. 95% Off
    -95%
    NARROW IT DOWN DEEP BLUE JEANS
  6. 90% Off
    -90%
    POPPING UP DEEP BLUE JEANS
  7. 95% Off
    -95%
    A SIMPLE TOUCH DEEP BLUE JEANS
  8. 95% Off
    -95%
    GOOD OLD DAYS ORANGE DRESS
  9. 60% Off
    -60%
    PLAYFULL EVERYDAY BLACK TOP
  10. 60% Off
    -60%
    PLAYFULL EVERYDAY WHITE TOP
  11. 60% Off
    -60%
    PLAYFULL EVERYDAY YELLOW TOP
  12. 60% Off
    -60%
    PLAYFULL EVERYDAY PINK TOP
  13. 60% Off
    -60%
    PLAYFULL EVERYDAY GREY TOP
  14. 60% Off
    -60%
    PLAYFULL EVERYDAY GREEN TOP
  15. 60% Off
    -60%
    THIS ONES FOR YOU YELLOW T-SHIRT
  16. 60% Off
    -60%
    EASY BREEZY GREY AND PINK T-SHIRT
  17. 60% Off
    -60%
    A GREEK VACAY WHITE DRESS