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 7 items
  2. Bodycon 37 items
  3. Denim Dresses 1 item
  4. Jumpsuits 0 items
  5. Maxi Dresses 36 items
  6. Midi Dresses 20 items
  7. Off-shoulder And Bandeau Dresses 18 items
  8. Pencil Dresses 5 items
  9. Shift Dresses 4 items
  10. Shirt Dresses 7 items
  11. Skater Dresses 13 items
  12. Tunic Dresses 4 items
  13. Wrap Dresses 1 item
  14. Corset Dresses 1 item
Colour
Colour
  1. Beige 38 items
  2. Black 253 items
  3. Blue 109 items
  4. Brown 58 items
  5. Gold 11 items
  6. Green 89 items
  7. Grey 18 items
  8. Multi 47 items
  9. Orange 25 items
  10. Pink 92 items
  11. Purple 24 items
  12. Red 93 items
  13. Silver 11 items
  14. White 108 items
  15. Yellow 23 items
Less
Size
Size
  1. 2XL 1 item
  2. L 43 items
  3. M 44 items
  4. S 40 items
  5. XL 9 items
  6. XS 3 items
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 3 items
  3. Rs. 1400 - 1600 7 items
  4. Rs. 1600 - 1800 5 items
  5. Rs. 1800 - 2000 7 items
  6. Rs. 2000 - 2500 9 items
  7. Rs. 2500 - 3000 2 items
  8. Rs. 3000 - 3500 3 items
  9. Rs. 3500 - 4000 7 items
  10. Rs. 4000 - 4500 1 item
  1. Shift Dresses Remove This Item
  2. Asymmetrical Dresses Remove This Item
  3. Jumpsuits Remove This Item
  4. Maxi Dresses Remove This Item
  5. Multi Remove This Item
  6. M 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_660554dea0e309_77151691` 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

Page
47 styles found
  1. 58% Off
    -58%
    PRINTED BLUE SLIM MAXI DRESSES
  2. 59% Off
    -59%
    HALTER HANGING NECK MAXI DRESS
  3. 58% Off
    -58%
    COLD-SHOULDER CHIFFON MAXI DRESS
  4. 60% Off
    -60%
    Long Tie-up Shoulder Straps Dress
  5. 60% Off
    -60%
    MULTI-COLOURED FISHTAIL MAXI DRESS
  6. 60% Off
    -60%
    Criss-cross Halter Neck Floral Dress
  7. 60% Off
    -60%
    CASUAL FLORAL-PRINT MAXI DRESS
  8. 60% Off
    -60%
    Floral Print Long Thigh Slit Dress
  9. 58% Off
    -58%
    PRINTED MOPPING MAXI SLIT DRESS
  10. 58% Off
    -58%
    CRISS-CROSS STRAP PRINTED MAXI DRESS
  11. 60% Off
    -60%
    BACKLESS ANIMAL-PRINT MAXI DRESS
  12. 60% Off
    -60%
    MULTICOLOUR TURTLE NECK MAXI DRESS
  13. 60% Off
    -60%
    SMOCKED WHITE PRINTED MAXI DRESS
  14. 58% Off
    -58%
    PRINTED A-LINE PURPLE MAXI DRESS
  15. 59% Off
    -59%
    PRINTED BACKLESS SUMMER MAXI DRESS
  16. 60% Off
    -60%
    FLORAL-PRINT V-NECK MAXI DRESS
  17. 59% Off
    -59%
    MULTICOLOUR STRIPED KNIT MAXI DRESS
Page