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 46 items
  2. Bodycon 358 items
  3. Crop Tops 0 items
  4. Denim Dresses 1 item
  5. Joggers 0 items
  6. Maxi Dresses 188 items
  7. Midi Dresses 92 items
  8. Midi Skirts 0 items
  9. Nightdresses 2 items
  10. Off-shoulder And Bandeau Dresses 115 items
  11. Pencil Dresses 39 items
  12. Shift Dresses 20 items
  13. Shirt Dresses 7 items
  14. Skater Dresses 61 items
  15. Tunic Dresses 5 items
  16. Wrap Dresses 9 items
  17. Corset Dresses 34 items
Colour
Colour
  1. Beige 40 items
  2. Black 358 items
  3. Blue 83 items
  4. Brown 75 items
  5. Gold 13 items
  6. Green 79 items
  7. Grey 36 items
  8. Maroon 3 items
  9. Multi 40 items
  10. Orange 23 items
  11. Pink 78 items
  12. Purple 26 items
  13. Red 95 items
  14. Silver 19 items
  15. White 104 items
  16. Yellow 14 items
Less
Size
Size
  1. 1XL 9 items
  2. 2XL 11 items
  3. 3XL 9 items
  4. 4XL 3 items
  5. FS 2 items
  6. L 314 items
  7. M 318 items
  8. S 321 items
  9. XL 80 items
  10. XS 21 items
  11. XXL 3 items
Less
Price
Price
  1. Rs. 200 - 400 12 items
  2. Rs. 800 - 1000 6 items
  3. Rs. 1000 - 1200 21 items
  4. Rs. 1200 - 1400 33 items
  5. Rs. 1400 - 1600 51 items
  6. Rs. 1600 - 1800 50 items
  7. Rs. 1800 - 2000 54 items
  8. Rs. 2000 - 2500 84 items
  9. Rs. 2500 - 3000 48 items
  10. Rs. 3000 - 3500 9 items
  11. Rs. 3500 - 4000 3 items
  12. Rs. 4500 - 5000 1 item
  1. Midi Skirts Remove This Item
  2. Crop Tops Remove This Item
  3. Joggers Remove This Item
  4. Bodycon Remove This Item
  5. 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_660657f92a9d92_12536540` 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

356 styles found
  1. 60% Off
    -60%
    PARTY HOURS BLACK BODYCON DRESS
  2. 58% Off
    -58%
    MESH-WAIST BLACK BODYCON DRESS
  3. 75% Off
    -75%
    HUGS PLEASE BLACK BODYCON DRESS
  4. 58% Off
    -58%
    BONING-DETAIL BLACK BODYCON DRESS
  5. 60% Off
    -60%
    Black Turtleneck Bodycon Short Dress
  6. 58% Off
    -58%
    SLIMMING BLACK SHORT BODYCON DRESS
  7. 60% Off
    -60%
    Black Halter Neck Bodycon Dress
  8. 60% Off
    -60%
    Black Cut-out Shoulder Bodycon Dress
  9. 60% Off
    -60%
    ZIPPER-BACK GATHERED BLACK DRESS
  10. 60% Off
    -60%
    SQUARE NECK BLACK MIDI BODYCON DRESS
  11. 60% Off
    -60%
    Shirred Black Long Bodycon Dress
  12. 60% Off
    -60%
    Black Twisted Cut-out Detail Dress
  13. 60% Off
    -60%
    Black Square Neck Long Sleeved Dress
  14. 60% Off
    -60%
    Black Ruched-chest Slim Fitted Dress