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 79 items
  2. Bodycon 482 items
  3. Denim Dresses 1 item
  4. Maxi Dresses 296 items
  5. Midi Dresses 129 items
  6. Nightdresses 2 items
  7. Off-shoulder And Bandeau Dresses 189 items
  8. Pencil Dresses 71 items
  9. Shift Dresses 27 items
  10. Shirt Dresses 9 items
  11. Skater Dresses 107 items
  12. Skater Skirts 0 items
  13. Tunic Dresses 7 items
  14. Wrap Dresses 6 items
  15. Corsets & Tube Tops 2 items
  16. Corset Dresses 51 items
Colour
Colour
  1. Beige 35 items
  2. Black 314 items
  3. Blue 71 items
  4. Brown 61 items
  5. Gold 14 items
  6. Green 70 items
  7. Grey 33 items
  8. Maroon 3 items
  9. Multi 34 items
  10. Orange 21 items
  11. Pink 71 items
  12. Purple 24 items
  13. Red 76 items
  14. Silver 19 items
  15. White 92 items
  16. Yellow 11 items
Less
Size
Size
  1. 1XL 13 items
  2. 2XL 17 items
  3. 3XL 15 items
  4. 4XL 7 items
  5. FS 3 items
  6. L 444 items
  7. M 439 items
  8. S 448 items
  9. XL 121 items
  10. XS 44 items
  11. XXL 5 items
  12. XXXL 1 item
Less
Price
Price
  1. Rs. 800 - 1000 9 items
  2. Rs. 1000 - 1200 34 items
  3. Rs. 1200 - 1400 49 items
  4. Rs. 1400 - 1600 79 items
  5. Rs. 1600 - 1800 66 items
  6. Rs. 1800 - 2000 71 items
  7. Rs. 2000 - 2500 116 items
  8. Rs. 2500 - 3000 53 items
  9. Rs. 3000 - 3500 13 items
  10. Rs. 3500 - 4000 3 items
  11. Rs. 4000 - 4500 1 item
  12. Rs. 4500 - 5000 1 item
  13. 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
  5. Black Remove This Item
  6. M 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_6605659e72b0d4_98068237` 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

481 styles found
  1. 60% Off
    -60%
    Black Hollow-out Bodycon Dress
  2. 60% Off
    -60%
    White Cut-out Full-sleeved Dress
  3. 60% Off
    -60%
    White Dangling Neck Short Slim Dress
  4. 60% Off
    -60%
    Black Sleeveless Sheath Short Dress
  5. 60% Off
    -60%
    White Sleeveless Sheath Short Dress
  6. 60% Off
    -60%
    Black Mid-length Sheath 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%
    Y2k Pattern Halter Neck Bodyon Dress
  12. 60% Off
    -60%
    Spaghetti Strap Sequin Black Dress
  13. 60% Off
    -60%
    Black Sequin Embroidery Dress
  14. 60% Off
    -60%
    White Sequin Embroidery Dress
  15. 60% Off
    -60%
    Red Halter Neck Mesh Ruffle Dress
  16. 60% Off
    -60%
    Black Halter Neck Mesh Ruffle Dress
  17. 60% Off
    -60%
    Spaghetti Strap Black Slim Dress
  18. 60% Off
    -60%
    Black Halter Neck Mid Length Dress
  19. 60% Off
    -60%
    Black Backless Lace-up Straps Dress
  20. 60% Off
    -60%
    Red Backless Lace-up Straps Dress