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

Dresses

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 37 items
  2. Bodycon 209 items
  3. Denim Dresses 4 items
  4. Maxi Dresses 160 items
  5. Midi Dresses 136 items
  6. Off-shoulder And Bandeau Dresses 93 items
  7. Pencil Dresses 36 items
  8. Shift Dresses 33 items
  9. Shirt Dresses 20 items
  10. Skater Dresses 62 items
  11. Tunic Dresses 13 items
  12. Vests And Camis 1 item
  13. Wrap Dresses 14 items
  14. Corset Dresses 17 items
Colour
Colour
  1. Beige 6 items
  2. Black 38 items
  3. Blue 18 items
  4. Brown 8 items
  5. Green 19 items
  6. Grey 2 items
  7. Maroon 1 item
  8. Multi 7 items
  9. Orange 2 items
  10. Pink 19 items
  11. Purple 4 items
  12. Red 15 items
  13. Silver 1 item
  14. White 17 items
  15. Yellow 7 items
Less
Size
Size
  1. 1XL 8 items
  2. 2XL 16 items
  3. 3XL 19 items
  4. 4XL 15 items
  5. 5XL 10 items
  6. F-S 0 items
  7. FS 2 items
  8. L 425 items
  9. M 421 items
  10. S 422 items
  11. XL 126 items
  12. XS 25 items
  13. XXL 3 items
  14. XXS 2 items
  15. XXXL 1 item
Less
Price
Price
  1. Rs. 200 - 400 29 items
  2. Rs. 800 - 1000 2 items
  3. Rs. 1000 - 1200 5 items
  4. Rs. 1200 - 1400 7 items
  5. Rs. 1400 - 1600 6 items
  6. Rs. 1600 - 1800 21 items
  7. Rs. 1800 - 2000 10 items
  8. Rs. 2000 - 2500 39 items
  9. Rs. 2500 - 3000 49 items
  10. Rs. 3000 - 3500 5 items
  11. Rs. 3500 - 4000 6 items
  12. Rs. 4000 - 4500 1 item
  13. Rs. 4500 - 5000 1 item
  1. Shift Dresses Remove This Item
  2. Off-shoulder And Bandeau Dresses Remove This Item
  3. F-S Remove This Item
  4. XL 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=470 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_662215f26dfa29_98909907` 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

164 styles found
  1. 60% Off
    -60%
    Rose Red Off-shoulder Bodycon Dress
  2. 60% Off
    -60%
    BLACK SLEEVELESS TIERED SHIFT DRESS
  3. 60% Off
    -60%
    Heart Motif Print Short Tent Dress
  4. 60% Off
    -60%
    Pink Back-zip Tulle Bandeau Dress
  5. 60% Off
    -60%
    YELLOW SLEEVELESS TIERED SHIFT DRESS
  6. 80% Off
    -80%
    BLOOMING HIGH PINK FLORAL DRESS
  7. 60% Off
    -60%
    Blue Back-zip Tulle Bandeau Dress
  8. 95% Off
    -95%
    YOU GO GIRL WATERMELON RED DRESS
  9. 95% Off
    -95%
    ARMY GREEN OFF SHOULDER DRESS
  10. 60% Off
    -60%
    Strapless Cut-out Black Sequin Dress
  11. 60% Off
    -60%
    OFF-SHOULDER RUFFLE-TRIM GREEN DRESS
  12. 58% Off
    -58%
    BANDEAU ASYMMETRICAL HEM PU DRESS
  13. 58% Off
    -58%
    BANDEAU MIDI FITTED PU BROWN DRESS