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 58 items
  2. Bodycon 253 items
  3. Bracelets 0 items
  4. Denim Dresses 16 items
  5. Maxi Dresses 206 items
  6. Midi Dresses 117 items
  7. Off-shoulder And Bandeau Dresses 125 items
  8. Pencil Dresses 53 items
  9. Pinafore 1 item
  10. Shift Dresses 21 items
  11. Shirt Dresses 13 items
  12. Skater Dresses 78 items
  13. Skater Skirts 0 items
  14. Tunic Dresses 9 items
  15. Wrap Dresses 5 items
  16. Corsets & Tube Tops 2 items
  17. Corset Dresses 26 items
Colour
Colour
  1. Beige 26 items
  2. Black 174 items
  3. Blue 76 items
  4. Brown 44 items
  5. Gold 7 items
  6. Green 60 items
  7. Grey 15 items
  8. Multi 32 items
  9. Orange 18 items
  10. Pink 56 items
  11. Purple 16 items
  12. Red 57 items
  13. Silver 7 items
  14. White 73 items
  15. Yellow 13 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 9 items
  3. 3XL 5 items
  4. 4XL 2 items
  5. 5XL 2 items
  6. FS 1 item
  7. L 190 items
  8. M 188 items
  9. S 189 items
  10. XL 48 items
  11. XS 10 items
  12. XXL 2 items
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 10 items
  3. Rs. 1400 - 1600 26 items
  4. Rs. 1600 - 1800 26 items
  5. Rs. 1800 - 2000 17 items
  6. Rs. 2000 - 2500 57 items
  7. Rs. 2500 - 3000 33 items
  8. Rs. 3000 - 3500 13 items
  9. Rs. 3500 - 4000 9 items
  10. Rs. 4000 - 4500 9 items
  11. Rs. 4500 - 5000 3 items
  12. Rs. 5500 - 6000 1 item
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Maxi Dresses Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Blue 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=1955 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_660530c60feff9_31812817` 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

206 styles found
  1. 58% Off
    -58%
    LACE TRIM SLIM MAXI WHITE DRESS
  2. 60% Off
    -60%
    Halter Plunge White Long Sequin Dress
  3. 59% Off
    -59%
    SEQUIN HIGH SLIT MOPPING MAXI DRESS
  4. 59% Off
    -59%
    WHITE A-LINE HIGH SLIT MAXI DRESS
  5. 59% Off
    -59%
    LACE-UP BACKLESS A-LINE MAXI DRESS
  6. 60% Off
    -60%
    White A-line Dress With Contrast Tie
  7. 58% Off
    -58%
    SLIT CORSETRY MAXI RED DRESS
  8. 58% Off
    -58%
    HOLOGRAPHIC EVENING WHITE MAXI DRESS
  9. 60% Off
    -60%
    SEQUIN HIGH SLIT BLUE MAXI DRESS
  10. 60% Off
    -60%
    SEQUIN BLUE CURVED BACK MAXI DRESS
  11. 60% Off
    -60%
    HOLLOW-KNIT HALTER NECK WHITE DRESS
  12. 59% Off
    -59%
    GAUZE WHITE THIGH SLIT MAXI DRESS
  13. 59% Off
    -59%
    BRIDESMAID WHITE LACY MAXI DRESS