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 60 items
  2. Bodycon 266 items
  3. Denim Dresses 5 items
  4. Maxi Dresses 178 items
  5. Midi Dresses 174 items
  6. Nightdresses 2 items
  7. Off-shoulder And Bandeau Dresses 110 items
  8. Pencil Dresses 68 items
  9. Pinafore 1 item
  10. Shift Dresses 47 items
  11. Shirt Dresses 25 items
  12. Skater Dresses 93 items
  13. Tunic Dresses 18 items
  14. Vests And Camis 1 item
  15. Wrap Dresses 18 items
  16. Corset Dresses 18 items
Colour
Colour
  1. Beige 43 items
  2. Black 258 items
  3. Blue 130 items
  4. Brown 53 items
  5. Gold 10 items
  6. Green 110 items
  7. Grey 17 items
  8. Maroon 7 items
  9. Multi 50 items
  10. Orange 28 items
  11. Pink 98 items
  12. Purple 29 items
  13. Red 114 items
  14. Silver 8 items
  15. White 106 items
  16. Yellow 28 items
Less
Size
Size
  1. 1XL 58 items
  2. 2XL 223 items
  3. 3XL 155 items
  4. 4XL 54 items
  5. 5XL 21 items
  6. FS 69 items
  7. L 3015 items
  8. M 3026 items
  9. S 3022 items
  10. XL 1019 items
  11. XS 208 items
  12. XXL 90 items
  13. XXS 2 items
  14. XXXL 35 items
  15. 0XL 4 items
Less
Price
Price
  1. Rs. 200 - 400 88 items
  2. Rs. 600 - 800 5 items
  3. Rs. 800 - 1000 12 items
  4. Rs. 1000 - 1200 19 items
  5. Rs. 1200 - 1400 72 items
  6. Rs. 1400 - 1600 62 items
  7. Rs. 1600 - 1800 110 items
  8. Rs. 1800 - 2000 95 items
  9. Rs. 2000 - 2500 295 items
  10. Rs. 2500 - 3000 249 items
  11. Rs. 3000 - 3500 75 items
  12. Rs. 3500 - 4000 42 items
  13. Rs. 4000 - 4500 25 items
  14. Rs. 4500 - 5000 4 items
  15. Rs. 5000 - 5500 4 items
  16. Rs. 5500 - 6000 1 item
  17. Rs. 6000 - 6500 1 item
  1. XL Remove This Item
  2. 2XL 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_66058aeaecdf21_91442115` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

1088 styles found
  1. 60% Off
    -60%
    BROWN PRINTED SLEEVLESS MAXI DRESS
  2. 60% Off
    -60%
    BLUE PRINTED SLEEVLESS MAXI DRESS
  3. 60% Off
    -60%
    Printed Tie-up Shoulder Straps Dress
  4. 60% Off
    -60%
    Black Long Zip-up Back Strappy Dress
  5. 60% Off
    -60%
    Empire Silhouette Long Kaftan Dress
  6. 60% Off
    -60%
    Green Floral Print A-line Midi Dress
  7. 60% Off
    -60%
    Brown Halter Strap Long Slip Dress
  8. 60% Off
    -60%
    Black Halter Strap Long Slip Dress
  9. 60% Off
    -60%
    Blue Halter Strap Long Slip Dress
  10. 60% Off
    -60%
    Pink Halter Strap Long Slip Dress
  11. 60% Off
    -60%
    Textured Short Green Bodycon Dress
  12. 60% Off
    -60%
    Cold-shoulder Short Sleeved Dress
  13. 60% Off
    -60%
    DARK BLUE ABSTRACT PRINTS MAXI DRESS
  14. 60% Off
    -60%
    BLUE PRINTED OPEN BACK MAXI DRESS