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 21 items
  2. Bodycon 142 items
  3. Maxi Dresses 95 items
  4. Maxi Tops 0 items
  5. Midi Dresses 50 items
  6. Nightdresses 1 item
  7. Off-shoulder And Bandeau Dresses 62 items
  8. Pencil Dresses 19 items
  9. Sets 0 items
  10. Shift Dresses 11 items
  11. Shirt Dresses 8 items
  12. Skater Dresses 42 items
  13. Tunic Dresses 5 items
  14. Wrap Dresses 1 item
  15. Corsets & Tube Tops 1 item
  16. Corset Dresses 14 items
Colour
Colour
  1. Beige 54 items
  2. Black 359 items
  3. Blue 138 items
  4. Brown 77 items
  5. Gold 10 items
  6. Green 104 items
  7. Grey 29 items
  8. Maroon 1 item
  9. Multi 69 items
  10. Orange 29 items
  11. Pink 122 items
  12. Purple 27 items
  13. Red 119 items
  14. Silver 16 items
  15. White 169 items
  16. Yellow 24 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 6 items
  3. 3XL 3 items
  4. 6 0 items
  5. L 184 items
  6. M 185 items
  7. S 178 items
  8. UK10 0 items
  9. XL 46 items
  10. XS 14 items
  11. XXL 3 items
  12. XXS 1 item
  13. XXXL 2 items
Less
Price
Price
  1. Rs. 200 - 400 4 items
  2. Rs. 800 - 1000 2 items
  3. Rs. 1200 - 1400 8 items
  4. Rs. 1400 - 1600 22 items
  5. Rs. 1600 - 1800 20 items
  6. Rs. 1800 - 2000 20 items
  7. Rs. 2000 - 2500 51 items
  8. Rs. 2500 - 3000 37 items
  9. Rs. 3000 - 3500 17 items
  10. Rs. 3500 - 4000 10 items
  11. Rs. 4000 - 4500 4 items
  12. Rs. 4500 - 5000 3 items
  13. Rs. 5500 - 6000 1 item
  1. Maxi Tops Remove This Item
  2. Off-shoulder And Bandeau Dresses Remove This Item
  3. Sets Remove This Item
  4. Maxi Dresses Remove This Item
  5. Skater Dresses Remove This Item
  6. White Remove This Item
  7. Maroon Remove This Item
  8. Grey Remove This Item
  9. M Remove This Item
  10. UK10 Remove This Item
  11. 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`, `at_special_price`.`value` AS `special_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_66068610576a74_58347696` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

198 styles found
  1. 58% Off
    -58%
    LACE TRIM SLIM MAXI WHITE DRESS
  2. 59% Off
    -59%
    SEQUIN HIGH SLIT MOPPING MAXI DRESS
  3. 59% Off
    -59%
    WHITE A-LINE HIGH SLIT MAXI DRESS
  4. 59% Off
    -59%
    GAUZE OFF-SHOULDER SLEEVE WHITE DRESS
  5. 59% Off
    -59%
    LACE-UP BACKLESS A-LINE MAXI DRESS
  6. 60% Off
    -60%
    White A-line Dress With Contrast Tie
  7. 60% Off
    -60%
    White Backless Bandeau Dress
  8. 58% Off
    -58%
    HOLOGRAPHIC EVENING WHITE MAXI DRESS
  9. 60% Off
    -60%
    White Lace A-line Tube Dress
  10. 60% Off
    -60%
    White Off-shoulder Sheath Dress
  11. 60% Off
    -60%
    HOLLOW-KNIT HALTER NECK WHITE DRESS
  12. 60% Off
    -60%
    Grey Printed Stand-up Collar Dress
  13. 59% Off
    -59%
    GAUZE WHITE THIGH SLIT MAXI DRESS
  14. 60% Off
    -60%
    White Dress With Knot-tie Cuffs
  15. 60% Off
    -60%
    WHITE LONG TIE-STRAP SKATER DRESS
  16. 60% Off
    -60%
    White Frilly V-neck Skater Dress
  17. 58% Off
    -58%
    WHITE CASUAL MINI SKATER DRESS
  18. 58% Off
    -58%
    WHITED HOLLOW WHITE SKATER DRESS
  19. 59% Off
    -59%
    BRIDESMAID WHITE LACY MAXI DRESS