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

New

Filter
Shopping Options
Category
Category
  • Clothing 278 items
Styles
Styles
  1. Asymmetrical Dresses 20 items
  2. Blouses 15 items
  3. Body Suits 78 items
  4. Bodycon 180 items
  5. Cover Ups 20 items
  6. Crop Tops 62 items
  7. Dungarees 1 item
  8. Flare Jeans 7 items
  9. Jumpsuits 43 items
  10. Maxi Dresses 112 items
  11. Maxi Skirts 15 items
  12. Midi Dresses 44 items
  13. Midi Skirts 10 items
  14. Necklace 1 item
  15. Nightdresses 11 items
  16. Nightwear Set 19 items
  17. Off Shoulder Tops 12 items
  18. Off-shoulder And Bandeau Dresses 50 items
  19. Pencil Dresses 24 items
  20. Pencil Skirts 4 items
  21. Playsuits And Rompers 30 items
  22. Sets 168 items
  23. Shift Dresses 9 items
  24. Shirt Dresses 2 items
  25. Shirts 13 items
  26. Short And Mini Skirts 22 items
  27. Skater Dresses 35 items
  28. Skater Skirts 6 items
  29. Skinny Jeans 1 item
  30. Straight Jeans 12 items
  31. Swimsuit 49 items
  32. T-shirts 95 items
  33. Tunic Dresses 1 item
  34. Vests And Camis 65 items
  35. Wayfarers And Square Frame Sunglasses 2 items
  36. Bikini 4 items
  37. Boyshort 1 item
  38. Thong 28 items
  39. Boyleg 1 item
  40. Sports 3 items
  41. Bralette 9 items
  42. Padded 1 item
  43. Collars 6 items
  44. Wrap Dresses 3 items
  45. Mom Jeans 1 item
  46. Baggy Jeans 1 item
  47. Vests 1 item
  48. Wide Leg Jeans 1 item
  49. Shawl 1 item
  50. Corsets & Tube Tops 76 items
  51. Cold Shoulder Tops 3 items
  52. Corset Dresses 17 items
Colour
Colour
  1. Beige 53 items
  2. Black 225 items
  3. Blue 69 items
  4. Brown 68 items
  5. Gold 5 items
  6. Green 65 items
  7. Grey 35 items
  8. Maroon 2 items
  9. Multi 41 items
  10. Orange 11 items
  11. Pink 75 items
  12. Purple 14 items
  13. Red 71 items
  14. Silver 11 items
  15. White 142 items
  16. Yellow 17 items
Less
Size
Size
  1. 2XL 16 items
  2. 3XL 5 items
  3. 4XL 4 items
  4. 5XL 2 items
  5. FS 12 items
  6. L 235 items
  7. M 227 items
  8. S 211 items
  9. XL 74 items
  10. XS 10 items
  11. XXL 12 items
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 10 items
  3. Rs. 800 - 1000 33 items
  4. Rs. 1000 - 1200 31 items
  5. Rs. 1200 - 1400 32 items
  6. Rs. 1400 - 1600 30 items
  7. Rs. 1600 - 1800 22 items
  8. Rs. 1800 - 2000 15 items
  9. Rs. 2000 - 2500 64 items
  10. Rs. 2500 - 3000 25 items
  11. Rs. 3000 - 3500 8 items
  12. Rs. 3500 - 4000 5 items
  1. T-shirts Remove This Item
  2. Maxi Dresses Remove This Item
  3. Vests And Camis Remove This Item
  4. Skater Skirts Remove This Item
  5. Beige Remove This Item
  6. Black 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=385 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_66280869f20308_76883675` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

278 styles found
  1. 60% Off
    -60%
    Black Tie-up Scoop-back Long Dress
  2. 60% Off
    -60%
    Apricot Tie-up Scoop-back Long Dress
  3. 60% Off
    -60%
    Black Low-cut Back Tank Top
  4. 60% Off
    -60%
    Black Tie-up Open-back Top
  5. 60% Off
    -60%
    Black Buttoned Polka Dot Cami
  6. 60% Off
    -60%
    Black Lace-up Back Embellished Top
  7. 60% Off
    -60%
    Beige Cut-out Detail Long Slip Dress
  8. 60% Off
    -60%
    Black Abstract Pattern Long Dress
  9. 60% Off
    -60%
    Black Contrast-lined Cami Top
  10. 60% Off
    -60%
    Apricot Abstract Pattern Maxi Dress
  11. 60% Off
    -60%
    Black Boxy Fit Rivet T-shirt