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 40 items
  2. Bodycon 174 items
  3. Maxi Dresses 128 items
  4. Midi Dresses 74 items
  5. Off-shoulder And Bandeau Dresses 85 items
  6. Pencil Dresses 36 items
  7. Shift Dresses 12 items
  8. Shirt Dresses 6 items
  9. Skater Dresses 57 items
  10. Skater Skirts 0 items
  11. Tunic Dresses 5 items
  12. Wrap Dresses 2 items
  13. Corsets & Tube Tops 2 items
  14. Corset Dresses 18 items
Colour
Colour
  1. Beige 38 items
  2. Black 324 items
  3. Blue 73 items
  4. Brown 65 items
  5. Gold 13 items
  6. Green 71 items
  7. Grey 34 items
  8. Maroon 3 items
  9. Multi 35 items
  10. Orange 22 items
  11. Pink 74 items
  12. Purple 24 items
  13. Red 82 items
  14. Silver 19 items
  15. White 92 items
  16. Yellow 10 items
Less
Size
Size
  1. 1XL 4 items
  2. 2XL 7 items
  3. 3XL 6 items
  4. 4XL 4 items
  5. FS 1 item
  6. L 159 items
  7. M 149 items
  8. S 156 items
  9. XL 45 items
  10. XS 23 items
  11. XXL 3 items
  12. XXXL 1 item
Less
Price
Price
  1. Rs. 800 - 1000 2 items
  2. Rs. 1000 - 1200 13 items
  3. Rs. 1200 - 1400 16 items
  4. Rs. 1400 - 1600 35 items
  5. Rs. 1600 - 1800 23 items
  6. Rs. 1800 - 2000 22 items
  7. Rs. 2000 - 2500 37 items
  8. Rs. 2500 - 3000 20 items
  9. Rs. 3000 - 3500 6 items
  10. Rs. 3500 - 4000 2 items
  11. Rs. 4000 - 4500 2 items
  12. Rs. 5000 - 5500 1 item
  1. Skater Skirts Remove This Item
  2. Bodycon Remove This Item
  3. White Remove This Item
  4. Red 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_6606b5c0c3f154_76511216` 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

174 styles found
  1. 60% Off
    -60%
    CLASSICALLY THRIVING WHITE DRESS
  2. 60% Off
    -60%
    Red Sheer Lace Detail Sheath Dress
  3. 60% Off
    -60%
    Red Sequin Long Strap Dress
  4. 60% Off
    -60%
    White Pentagon Neckline Short Dress
  5. 60% Off
    -60%
    Red Surplice Neck Bodycon Dress
  6. 60% Off
    -60%
    Short Sheath Velvet Dress
  7. 60% Off
    -60%
    White Zip-up Back Lace Dress
  8. 60% Off
    -60%
    SEQUIN EMBROIDERY RED BODYCON DRESS
  9. 60% Off
    -60%
    WHITE SATIN FLORAL MINI SLIP DRESS
  10. 60% Off
    -60%
    WHITE PUFFY RUFFLE BODYCON DRESS
  11. 58% Off
    -58%
    WHITE SATIN PLEATED BODYCON DRESS
  12. 60% Off
    -60%
    Lace Sleeved Red Sheath Dress
  13. 60% Off
    -60%
    Red Irregular Hem Knot-strap Dress
  14. 60% Off
    -60%
    RIBBED RED FREE SIZE HOODED DRESS
  15. 60% Off
    -60%
    SLANTED CUT-OUT SEQUIN BODYCON DRESS
  16. 58% Off
    -58%
    WHITE PLEATED BODYCON DRESS
  17. 60% Off
    -60%
    White Short Slim Fringe Dress