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 10 items
  • Tops 8 items
Styles
Styles
  1. Asymmetrical Dresses 5 items
  2. Blouses 6 items
  3. Body Suits 20 items
  4. Bodycon 38 items
  5. Crop Tops 23 items
  6. Jumpsuits 10 items
  7. Maxi Dresses 28 items
  8. Maxi Skirts 5 items
  9. Midi Dresses 12 items
  10. Midi Skirts 3 items
  11. Nightwear Set 5 items
  12. Off Shoulder Tops 4 items
  13. Off-shoulder And Bandeau Dresses 15 items
  14. Pencil Dresses 3 items
  15. Playsuits And Rompers 6 items
  16. Sets 79 items
  17. Shift Dresses 5 items
  18. Shirt Dresses 1 item
  19. Shirts 4 items
  20. Short And Mini Skirts 5 items
  21. Skater Dresses 10 items
  22. Skater Skirts 2 items
  23. Straight Jeans 2 items
  24. Swimsuit 1 item
  25. T-shirts 36 items
  26. Tunic Dresses 3 items
  27. Vests And Camis 31 items
  28. Hipster 1 item
  29. Bikini 1 item
  30. Boyshort 6 items
  31. Thong 15 items
  32. Cycling Short 1 item
  33. Sports 1 item
  34. T-Shirt Bra 1 item
  35. Bralette 1 item
  36. Sports Bra 1 item
  37. Corsets & Tube Tops 27 items
  38. Cold Shoulder Tops 1 item
  39. Corset Dresses 1 item
Colour
Colour
  1. Beige 18 items
  2. Black 100 items
  3. Blue 36 items
  4. Brown 27 items
  5. Green 26 items
  6. Grey 15 items
  7. Multi 39 items
  8. Orange 10 items
  9. Pink 41 items
  10. Purple 6 items
  11. Red 31 items
  12. Silver 2 items
  13. White 82 items
  14. Yellow 8 items
Less
Size
Size
  1. 2XL 2 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 2 items
  5. L 17 items
  6. M 18 items
  7. S 17 items
  8. XL 9 items
  9. XS 3 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 1000 - 1200 1 item
  3. Rs. 1200 - 1400 1 item
  4. Rs. 1400 - 1600 1 item
  5. Rs. 1600 - 1800 2 items
  6. Rs. 1800 - 2000 2 items
  7. Rs. 2000 - 2500 3 items
  8. Rs. 2500 - 3000 5 items
  9. Rs. 3000 - 3500 2 items
  1. Off Shoulder Tops Remove This Item
  2. Shirts Remove This Item
  3. Skater Dresses Remove This Item
  4. Beige Remove This Item
  5. S Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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_entity` 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_6605291bcf4e90_16113522` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

18 styles found
  1. 58% Off
    -58%
    WIDE STRIPE PRINT BEIGE SHIRT
  2. 58% Off
    -58%
    PALE-PINK EMBELLISH SKATER DRESS
  3. 58% Off
    -58%
    CASUAL PRINTED A-LINE MINI DRESS
  4. 60% Off
    -60%
    LAYERED FRILL BEIGE SKATER DRESS
  5. 95% Off
    -95%
    CASUAL SUMMER BEIGE SKATER DRESS
  6. 58% Off
    -58%
    OFF-WHITE RETRO SKATER DRESS
  7. 60% Off
    -60%
    Apricot Backless Tie-up A-line Dress
  8. 60% Off
    -60%
    Backless Tie-up Straps Mini Dress
  9. 60% Off
    -60%
    FRILL-TRIM APRICOT OFF-SHOULDER TOP