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 376 items
Styles
Styles
  1. Asymmetrical Dresses 3 items
  2. Blouses 1 item
  3. Body Suits 3 items
  4. Bodycon 19 items
  5. Crop Tops 5 items
  6. Cropped Jeans 1 item
  7. Denim Dresses 6 items
  8. Denim Tops 4 items
  9. Flare Jeans 12 items
  10. Jumpsuits 7 items
  11. Maxi Dresses 32 items
  12. Maxi Skirts 5 items
  13. Midi Dresses 18 items
  14. Midi Skirts 8 items
  15. Nightwear Set 4 items
  16. Off Shoulder Tops 1 item
  17. Off-shoulder And Bandeau Dresses 10 items
  18. Pencil Dresses 10 items
  19. Pencil Skirts 1 item
  20. Pinafore 1 item
  21. Playsuits And Rompers 5 items
  22. Sets 55 items
  23. Shift Dresses 5 items
  24. Shirt Dresses 4 items
  25. Shirts 4 items
  26. Short And Mini Skirts 7 items
  27. Skater Dresses 5 items
  28. Skater Skirts 1 item
  29. Skinny Jeans 1 item
  30. Straight Jeans 20 items
  31. Swimsuit 4 items
  32. T-shirts 7 items
  33. Tunic Dresses 1 item
  34. Vests And Camis 6 items
  35. Bikini 2 items
  36. Thong 6 items
  37. Sports 4 items
  38. Bralette 1 item
  39. Wrap Dresses 2 items
  40. Baggy Jeans 4 items
  41. Wide Leg Jeans 11 items
  42. Corsets & Tube Tops 6 items
Colour
Colour
  1. Beige 144 items
  2. Black 818 items
  3. Blue 309 items
  4. Brown 225 items
  5. Gold 17 items
  6. Green 214 items
  7. Grey 116 items
  8. Maroon 2 items
  9. Multi 111 items
  10. Orange 52 items
  11. Pink 256 items
  12. Purple 69 items
  13. Red 250 items
  14. Silver 27 items
  15. White 371 items
  16. Yellow 52 items
Less
Size
Size
  1. 25 1 item
  2. 26 3 items
  3. 27 3 items
  4. 28 2 items
  5. 29 1 item
  6. 2XL 72 items
  7. 30 3 items
  8. 32 2 items
  9. 35 2 items
  10. 36 10 items
  11. 37 9 items
  12. 38 9 items
  13. 39 8 items
  14. 3XL 5 items
  15. 40 3 items
  16. 42 0 items
  17. 4XL 3 items
  18. 70ABC-S 1 item
  19. 75ABC-M 1 item
  20. 80ABC-L 1 item
  21. FS 21 items
  22. L 327 items
  23. M 331 items
  24. M/L 2 items
  25. S 305 items
  26. S/M 1 item
  27. XL 173 items
  28. XS 34 items
  29. XXL 18 items
  30. XXXL 3 items
Less
Price
Price
  1. Rs. 200 - 400 8 items
  2. Rs. 400 - 600 1 item
  3. Rs. 600 - 800 5 items
  4. Rs. 800 - 1000 19 items
  5. Rs. 1000 - 1200 24 items
  6. Rs. 1200 - 1400 33 items
  7. Rs. 1400 - 1600 32 items
  8. Rs. 1600 - 1800 42 items
  9. Rs. 1800 - 2000 42 items
  10. Rs. 2000 - 2500 64 items
  11. Rs. 2500 - 3000 66 items
  12. Rs. 3000 - 3500 43 items
  13. Rs. 3500 - 4000 9 items
  14. Rs. 4000 - 4500 5 items
  15. Rs. 5000 - 5500 1 item
  1. Blue Remove This Item
  2. XXL Remove This Item
  3. S Remove This Item
  4. 42 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_66054011373275_01196206` 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

376 styles found
  1. 60% Off
    -60%
    LET ME REMIND YOU BLUE DENIM JACKET
  2. 60% Off
    -60%
    DOTS ALL OVER ME BLUE DRESS
  3. 60% Off
    -60%
    WITH ALL COMFORT BLUE SKIRT
  4. 60% Off
    -60%
    FLOWERS WITH ME BLUE DRESS
  5. 60% Off
    -60%
    LOOK PRETTY EVERYTIME BLUE PLAYSUIT
  6. 60% Off
    -60%
    FLOWERS ON ME BLUE DRESS
  7. 60% Off
    -60%
    FLORAL LUSH BLUE DRESS
  8. 60% Off
    -60%
    TEARED ROUGH LIGHT BLUE DENIM SHORTS
  9. 60% Off
    -60%
    BACK ME UP BLUE DRESS
  10. 60% Off
    -60%
    FIRST LOOK LIGHT BLUE DENIM SHORTS
  11. 60% Off
    -60%
    LIT UP LIGHT BLUE DENIM SHORTS
  12. 60% Off
    -60%
    THIS MOMENT LIGHT BLUE DENIM SHORTS
  13. 60% Off
    -60%
    OFF THE RAMP LIGHT BLUE DENIM SHORTS
  14. 60% Off
    -60%
    SIT TIGHT LIGHT BLUE DENIM SHORTS
  15. 60% Off
    -60%
    COME WITH ME DARK BLUE DENIM SHORTS
  16. 60% Off
    -60%
    TAKE ME AWAY LIGHT BLUE DENIM JEANS
  17. 60% Off
    -60%
    TAKE ME AWAY BLUE DENIM JEANS