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 17 items
  2. Bodycon 78 items
  3. Maxi Dresses 65 items
  4. Midi Dresses 22 items
  5. Nightdresses 3 items
  6. Off-shoulder And Bandeau Dresses 33 items
  7. Pencil Dresses 13 items
  8. Shift Dresses 11 items
  9. Shirt Dresses 2 items
  10. Skater Dresses 25 items
  11. Tunic Dresses 5 items
  12. Vests And Camis 1 item
  13. Corset Dresses 7 items
Colour
Colour
  1. Beige 112 items
  2. Black 855 items
  3. Blue 298 items
  4. Brown 184 items
  5. Gold 26 items
  6. Green 237 items
  7. Grey 78 items
  8. Maroon 6 items
  9. Multi 143 items
  10. Orange 63 items
  11. Pink 247 items
  12. Purple 81 items
  13. Red 263 items
  14. Silver 35 items
  15. White 342 items
  16. Yellow 53 items
Less
Size
Size
  1. 1XL 10 items
  2. 2XL 26 items
  3. 3XL 20 items
  4. 4XL 7 items
  5. 6 0 items
  6. FS 1 item
  7. L 244 items
  8. M 253 items
  9. S 253 items
  10. XL 94 items
  11. XS 20 items
  12. XXL 7 items
  13. XXXL 4 items
Less
Price
Price
  1. Rs. 200 - 400 10 items
  2. Rs. 800 - 1000 2 items
  3. Rs. 1000 - 1200 5 items
  4. Rs. 1200 - 1400 22 items
  5. Rs. 1400 - 1600 32 items
  6. Rs. 1600 - 1800 41 items
  7. Rs. 1800 - 2000 30 items
  8. Rs. 2000 - 2500 66 items
  9. Rs. 2500 - 3000 43 items
  10. Rs. 3000 - 3500 23 items
  11. Rs. 3500 - 4000 6 items
  12. Rs. 4000 - 4500 8 items
  13. Rs. 4500 - 5000 1 item
  1. Maroon Remove This Item
  2. Pink Remove This Item
  3. M Remove This Item
  4. 6 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_66069e63bcaa73_06713017` 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

282 styles found
  1. 60% Off
    -60%
    A SUNNY SUNDAY PINK DRESS
  2. 58% Off
    -58%
    PINK CRISS-CROSS BACKLESS MAXI DRESS
  3. 60% Off
    -60%
    3d Print Long Sheath Dress
  4. 60% Off
    -60%
    A LITTLE SYNCH PINK DRESS
  5. 60% Off
    -60%
    PINK SEAMLESS FISHTAIL MAXI DRESS
  6. 80% Off
    -80%
    BLOOMING HIGH PINK FLORAL DRESS
  7. 58% Off
    -58%
    PINK CUT-OUT-WAIST SLIT MIDI DRESS
  8. 95% Off
    -95%
    BIG FLOWERS PINK DRESS
  9. 60% Off
    -60%
    BUTTERFLY-PRINT BODYCON MAXI DRESS
  10. 60% Off
    -60%
    TWISTED PINK PLEAT-DETAIL MAXI DRESS
  11. 60% Off
    -60%
    FISHTAIL BACKLESS PINK MAXI DRESS
  12. 60% Off
    -60%
    Pink Hooded Sheath Long Dress