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 42 items
  2. Bodycon 223 items
  3. Crop Tops 0 items
  4. Denim Dresses 17 items
  5. Maxi Dresses 197 items
  6. Midi Dresses 97 items
  7. Off-shoulder And Bandeau Dresses 107 items
  8. Pencil Dresses 39 items
  9. Pinafore 1 item
  10. Shift Dresses 22 items
  11. Shirt Dresses 23 items
  12. Skater Dresses 70 items
  13. Tunic Dresses 12 items
  14. Wrap Dresses 5 items
  15. Corsets & Tube Tops 1 item
  16. Corset Dresses 21 items
Colour
Colour
  1. Beige 15 items
  2. Black 80 items
  3. Blue 49 items
  4. Brown 21 items
  5. Gold 1 item
  6. Green 41 items
  7. Grey 14 items
  8. Maroon 1 item
  9. Multi 27 items
  10. Orange 6 items
  11. Pink 23 items
  12. Purple 12 items
  13. Red 38 items
  14. Silver 2 items
  15. White 44 items
  16. Yellow 11 items
Less
Size
Size
  1. 2XL 15 items
  2. 3XL 4 items
  3. FS 11 items
  4. L 110 items
  5. M 108 items
  6. S 102 items
  7. XL 61 items
  8. XS 3 items
  9. XXL 7 items
  10. XXXL 1 item
Less
Price
Price
  1. Rs. 200 - 400 7 items
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 1 item
  4. Rs. 1000 - 1200 8 items
  5. Rs. 1200 - 1400 6 items
  6. Rs. 1400 - 1600 11 items
  7. Rs. 1600 - 1800 9 items
  8. Rs. 1800 - 2000 15 items
  9. Rs. 2000 - 2500 31 items
  10. Rs. 2500 - 3000 19 items
  11. Rs. 3000 - 3500 11 items
  12. Rs. 3500 - 4000 4 items
  13. Rs. 4000 - 4500 3 items
  1. Crop Tops Remove This Item
  2. Shirt Dresses Remove This Item
  3. Midi Dresses Remove This Item
  4. Multi Remove This Item
  5. White Remove This Item
  6. Blue Remove This Item
  7. L 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_6606ac910fe937_68273673` 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 OFFSET 24

120 styles found
  1. 60% Off
    -60%
    White Midi Tie-strap Front Dress
  2. 60% Off
    -60%
    Blue Midi Tie-strap Front Dress
  3. 58% Off
    -58%
    CASUAL WHITE A-LINE MIDI DRESS
  4. 58% Off
    -58%
    BLUE SLIT SUSPENDER MIDI DRESS
  5. 60% Off
    -60%
    MULTICOLOUR COLOURBLOCED SHIRT DRESS
  6. 59% Off
    -59%
    OFF-WHITE MERMIAD-CORE MIDI DRESS
  7. 60% Off
    -60%
    TWISTED PLEAT WHITE MIDI DRESS
  8. 58% Off
    -58%
    RETRO FLARED WHITE MIDI DRESS
  9. 58% Off
    -58%
    WHITE SWINGING TARTAN MIDI DRESS
  10. 60% Off
    -60%
    BLUE BUTTON-DOWN BELTED SHIRT DRESS
  11. 58% Off
    -58%
    SOLID BLUE TWISTED BUST MIDI DRESS
  12. 58% Off
    -58%
    TIE-UP SMOCKING PRINTED MIDI DRESS
  13. 60% Off
    -60%
    White Cut-out Detail Lace Midi Dress
  14. 59% Off
    -59%
    PRINTED LAYERED-FRONT MIDI DRESS
  15. 58% Off
    -58%
    SATIN SLIP DARK-BLUE SHIRT DRESS
  16. 60% Off
    -60%
    White Back Slit Cut-out Midi Dress
  17. 60% Off
    -60%
    POLKA-DOT BLUE IRREGULAR MIDI DRESS