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
Styles
Styles
  1. Asymmetrical Dresses 16 items
  2. Blouses 13 items
  3. Body Suits 9 items
  4. Bodycon 55 items
  5. Cover Ups 9 items
  6. Crop Tops 16 items
  7. Jumpsuits 10 items
  8. Maxi Dresses 57 items
  9. Maxi Skirts 4 items
  10. Midi Dresses 30 items
  11. Midi Skirts 1 item
  12. Nightdresses 4 items
  13. Nightwear Set 15 items
  14. Off-shoulder And Bandeau Dresses 17 items
  15. Pencil Dresses 9 items
  16. Pencil Skirts 2 items
  17. Playsuits And Rompers 7 items
  18. Sets 118 items
  19. Shift Dresses 4 items
  20. Shirt Dresses 1 item
  21. Shirts 8 items
  22. Short And Mini Skirts 10 items
  23. Skater Dresses 16 items
  24. Skater Skirts 1 item
  25. Straight Jeans 3 items
  26. Swimsuit 7 items
  27. T-shirts 32 items
  28. Tunic Dresses 1 item
  29. Vests And Camis 15 items
  30. Wayfarers And Square Frame Sunglasses 1 item
  31. Gloves 2 items
  32. Hipster 3 items
  33. Bikini 3 items
  34. Boyshort 1 item
  35. Thong 14 items
  36. Sports 4 items
  37. T-Shirt Bra 1 item
  38. Bralette 1 item
  39. Non Padded 1 item
  40. Collars 1 item
  41. Wrap Dresses 1 item
  42. Mom Jeans 1 item
  43. Wide Leg Jeans 3 items
  44. Corsets & Tube Tops 22 items
  45. Cold Shoulder Tops 2 items
  46. Sarong 1 item
  47. Corset Dresses 5 items
Colour
Colour
  1. Beige 229 items
  2. Black 1188 items
  3. Blue 454 items
  4. Brown 422 items
  5. Gold 29 items
  6. Green 316 items
  7. Grey 173 items
  8. Maroon 7 items
  9. Multi 178 items
  10. Orange 84 items
  11. Pink 389 items
  12. Purple 127 items
  13. Red 347 items
  14. Silver 46 items
  15. White 602 items
  16. Yellow 98 items
Less
Size
Size
  1. 1XL 1 item
  2. 27 1 item
  3. 28 1 item
  4. 29 1 item
  5. 2XL 60 items
  6. 36 16 items
  7. 37 29 items
  8. 38 29 items
  9. 39 22 items
  10. 3XL 11 items
  11. 40 6 items
  12. 4XL 1 item
  13. 70A 1 item
  14. 70B 1 item
  15. 70C 2 items
  16. 70D 1 item
  17. 70E 1 item
  18. 75A 1 item
  19. 75B 2 items
  20. 75C 2 items
  21. 75D 2 items
  22. 75E 1 item
  23. 80A 1 item
  24. 80B 2 items
  25. 80C 2 items
  26. 80D 2 items
  27. 80E 1 item
  28. 85B 2 items
  29. 85C 2 items
  30. 85D 2 items
  31. 85E 1 item
  32. 90C 1 item
  33. 90D 1 item
  34. 95C 1 item
  35. 95D 1 item
  36. FS 35 items
  37. L 474 items
  38. M 488 items
  39. S 468 items
  40. XL 238 items
  41. XS 37 items
  42. XXL 20 items
  43. XXXL 4 items
Less
Heel Size
Heel Size
  1. Flats 2 items
  2. Low Heels 30 items
Price
Price
  1. Rs. 0 - 200 3 items
  2. Rs. 200 - 400 14 items
  3. Rs. 400 - 600 6 items
  4. Rs. 600 - 800 10 items
  5. Rs. 800 - 1000 32 items
  6. Rs. 1000 - 1200 58 items
  7. Rs. 1200 - 1400 75 items
  8. Rs. 1400 - 1600 72 items
  9. Rs. 1600 - 1800 87 items
  10. Rs. 1800 - 2000 62 items
  11. Rs. 2000 - 2500 98 items
  12. Rs. 2500 - 3000 101 items
  13. Rs. 3000 - 3500 44 items
  14. Rs. 3500 - 4000 10 items
  15. Rs. 4000 - 4500 4 items
  16. Rs. 4500 - 5000 2 items
  17. Rs. 5000 - 5500 1 item
  18. Rs. 6000 - 6500 1 item
  1. Green Remove This Item
  2. Pink 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=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_6605e6ce166d88_33373645` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24 OFFSET 72

681 styles found
  1. 60% Off
    -60%
    Pink Backless Tie-up A-line Dress
  2. 60% Off
    -60%
    Green Hollow-out Lace-up Crop Top
  3. 60% Off
    -60%
    TEXTURED SEE-THROUGH BODYSUIT
  4. 60% Off
    -60%
    RUFLLED V-NECK GREEN TOP
  5. 60% Off
    -60%
    HIGH-WAIST FLARED PINK PANTS
  6. 60% Off
    -60%
    ZIPPER-BACK GATHERED ROSE RED DRESS
  7. 60% Off
    -60%
    DARK PINK OPEN BACK MAXI DRESS
  8. 60% Off
    -60%
    PINK POLO NECK MIDI DRESS
  9. 60% Off
    -60%
    DARK GREEN POLO NECK MIDI DRESS
  10. 60% Off
    -60%
    COWL NECK DARK GREEN SEQUIN DRESS
  11. 60% Off
    -60%
    COWL NECK PINK SEQUIN DRESS
  12. 60% Off
    -60%
    GREEN A-LINE MINI SKIRT
  13. 60% Off
    -60%
    PLAID PATTERN GREEN SHOULDER BAG
  14. 60% Off
    -60%
    IMITATION PEARL HANDLE SHOULDER BAG