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 61 items
  2. Bodycon 438 items
  3. Denim Dresses 1 item
  4. Maxi Dresses 255 items
  5. Midi Dresses 136 items
  6. Nightdresses 3 items
  7. Off-shoulder And Bandeau Dresses 143 items
  8. Pencil Dresses 47 items
  9. Shift Dresses 31 items
  10. Shirt Dresses 9 items
  11. Skater Dresses 74 items
  12. Tunic Dresses 8 items
  13. Wrap Dresses 11 items
  14. Corset Dresses 36 items
Colour
Colour
  1. Beige 132 items
  2. Black 980 items
  3. Blue 354 items
  4. Brown 211 items
  5. Gold 30 items
  6. Green 275 items
  7. Grey 90 items
  8. Maroon 8 items
  9. Multi 162 items
  10. Orange 72 items
  11. Pink 289 items
  12. Purple 94 items
  13. Red 320 items
  14. Silver 42 items
  15. White 396 items
  16. Yellow 69 items
Less
Size
Size
  1. 1XL 18 items
  2. 2XL 65 items
  3. 3XL 46 items
  4. 4XL 14 items
  5. 5XL 6 items
  6. FS 24 items
  7. L 1089 items
  8. M 1093 items
  9. S 1090 items
  10. XL 345 items
  11. XS 63 items
  12. XXL 29 items
  13. XXS 1 item
  14. XXXL 9 items
  15. 0XL 3 items
Less
Price
Price
  1. Rs. 200 - 400 52 items
  2. Rs. 400 - 600 2 items
  3. Rs. 600 - 800 5 items
  4. Rs. 800 - 1000 17 items
  5. Rs. 1000 - 1200 44 items
  6. Rs. 1200 - 1400 87 items
  7. Rs. 1400 - 1600 155 items
  8. Rs. 1600 - 1800 179 items
  9. Rs. 1800 - 2000 150 items
  10. Rs. 2000 - 2500 325 items
  11. Rs. 2500 - 3000 201 items
  12. Rs. 3000 - 3500 40 items
  13. Rs. 3500 - 4000 21 items
  14. Rs. 4000 - 4500 8 items
  15. Rs. 4500 - 5000 2 items
  16. Rs. 5000 - 5500 1 item
  1. Green Remove This Item
  2. Black 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=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_6605a7fd9240f6_93409172` 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

1246 styles found
  1. 59% Off
    -59%
    BLACK TROPICAL PRINT MAXI DRESS
  2. 60% Off
    -60%
    Black Bow Decor A-line Bandeau Dress
  3. 60% Off
    -60%
    Black Mid Length Fishtail Dress
  4. 58% Off
    -58%
    PRINTED GREEN LACE-TRIM PENCIL DRESS
  5. 60% Off
    -60%
    PARTY HOURS BLACK BODYCON DRESS
  6. 60% Off
    -60%
    BLACK ASYMMETRICAL SLIT MAXI DRESS
  7. 60% Off
    -60%
    WORK IT GREEN BODYCON DRESS
  8. 58% Off
    -58%
    CASUAL PRINTED GREEN MAXI DRESS
  9. 95% Off
    -95%
    JAZZ IT UP BLACK POLKA DOT DRESS
  10. 60% Off
    -60%
    PRINTED GREEN COWL NECK MAXI DRESS
  11. 58% Off
    -58%
    MESH-WAIST BLACK BODYCON DRESS