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 75 items
  2. Bodycon 479 items
  3. Maxi Dresses 284 items
  4. Midi Dresses 140 items
  5. Off-shoulder And Bandeau Dresses 171 items
  6. Pencil Dresses 49 items
  7. Shift Dresses 27 items
  8. Shirt Dresses 11 items
  9. Skater Dresses 90 items
  10. Skater Skirts 0 items
  11. Tunic Dresses 8 items
  12. Wrap Dresses 13 items
  13. Corsets & Tube Tops 2 items
  14. Corset Dresses 44 items
Colour
Colour
  1. Beige 41 items
  2. Black 334 items
  3. Blue 90 items
  4. Brown 78 items
  5. Gold 7 items
  6. Green 94 items
  7. Grey 47 items
  8. Maroon 3 items
  9. Multi 36 items
  10. Orange 23 items
  11. Pink 71 items
  12. Purple 31 items
  13. Red 80 items
  14. Silver 12 items
  15. White 111 items
  16. Yellow 11 items
Less
Size
Size
  1. 1XL 12 items
  2. 2XL 31 items
  3. 3XL 26 items
  4. 4XL 12 items
  5. 5XL 3 items
  6. FS 13 items
  7. L 511 items
  8. M 505 items
  9. S 490 items
  10. XL 154 items
  11. XS 47 items
  12. XXL 12 items
  13. XXXL 4 items
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 800 - 1000 13 items
  3. Rs. 1000 - 1200 45 items
  4. Rs. 1200 - 1400 57 items
  5. Rs. 1400 - 1600 105 items
  6. Rs. 1600 - 1800 79 items
  7. Rs. 1800 - 2000 77 items
  8. Rs. 2000 - 2500 145 items
  9. Rs. 2500 - 3000 73 items
  10. Rs. 3000 - 3500 29 items
  11. Rs. 3500 - 4000 8 items
  12. Rs. 4000 - 4500 6 items
  1. Skater Skirts Remove This Item
  2. Bodycon Remove This Item
  3. Midi Dresses Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Black Remove This Item
  7. Green Remove This Item

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`size`, `e`.`size_value`, `e`.`eancode`, `e`.`wallet_credit_based_on`, `e`.`wallet_credit_based_on_value`, `e`.`wallet_cash_back`, `e`.`hsn_code`, `e`.`dateofupload`, `e`.`heel_size`, `e`.`heel_size_value`, `e`.`product_color`, `e`.`price_filter`, `e`.`price_filter_value`, `e`.`styles`, `e`.`app_special_price`, `e`.`swatch_image`, `e`.`disable_cod`, `e`.`product_tag`, `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_flat_1` 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_666a8f80e4ebe7_50174077` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

619 styles found
  1. 60% Off
    -60%
    BLACK RIB-KNIT SLEEVELESS MIDI DRESS
  2. 60% Off
    -60%
    RED FRINGED HEM BODYCON DRESS
  3. 60% Off
    -60%
    White Cut-out Full-sleeved Dress
  4. 60% Off
    -60%
    White Dangling Neck Short Slim Dress
  5. 60% Off
    -60%
    Black Sleeveless Sheath Short Dress
  6. 60% Off
    -60%
    White Sleeveless Sheath Short Dress
  7. 60% Off
    -60%
    Black Mesh Splicing Velour Dress
  8. 60% Off
    -60%
    Black Halter Neck Bodycon Dress
  9. 60% Off
    -60%
    White Lace Strappy Sheath Dress
  10. 60% Off
    -60%
    Black Lace Short Bodycon Dress
  11. 60% Off
    -60%
    Spaghetti Strap Sequin Black Dress
  12. 60% Off
    -60%
    Black Sequin Embroidery Dress
  13. 60% Off
    -60%
    White Sequin Embroidery Dress
  14. 60% Off
    -60%
    Red Halter Neck Mesh Ruffle Dress
  15. 60% Off
    -60%
    Black Halter Neck Mesh Ruffle Dress
  16. 60% Off
    -60%
    Black Halter Neck Mid Length Dress
  17. 60% Off
    -60%
    Black Backless Lace-up Straps Dress
  18. 60% Off
    -60%
    Red Backless Lace-up Straps Dress
  19. 60% Off
    -60%
    RIBBED GREEN U-NECK BODYCON DRESS