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 20 items
  2. Bodycon 115 items
  3. Maxi Dresses 95 items
  4. Midi Dresses 54 items
  5. Nightdresses 1 item
  6. Off-shoulder And Bandeau Dresses 41 items
  7. Pencil Dresses 10 items
  8. Shift Dresses 14 items
  9. Shirt Dresses 2 items
  10. Skater Dresses 22 items
  11. Tunic Dresses 6 items
  12. Wrap Dresses 2 items
  13. Corset Dresses 3 items
Colour
Colour
  1. Beige 112 items
  2. Black 858 items
  3. Blue 300 items
  4. Brown 184 items
  5. Gold 27 items
  6. Green 239 items
  7. Grey 78 items
  8. Maroon 6 items
  9. Multi 144 items
  10. Orange 63 items
  11. Pink 248 items
  12. Purple 82 items
  13. Red 264 items
  14. Silver 35 items
  15. White 345 items
  16. Yellow 56 items
Less
Size
Size
  1. 1XL 8 items
  2. 2XL 29 items
  3. 3XL 17 items
  4. 4XL 8 items
  5. 5XL 1 item
  6. 6 0 items
  7. FS 9 items
  8. L 347 items
  9. M 349 items
  10. S 347 items
  11. XL 142 items
  12. XS 22 items
  13. XXL 11 items
  14. XXXL 5 items
Less
Price
Price
  1. Rs. 200 - 400 18 items
  2. Rs. 400 - 600 2 items
  3. Rs. 600 - 800 2 items
  4. Rs. 800 - 1000 3 items
  5. Rs. 1000 - 1200 13 items
  6. Rs. 1200 - 1400 27 items
  7. Rs. 1400 - 1600 47 items
  8. Rs. 1600 - 1800 51 items
  9. Rs. 1800 - 2000 35 items
  10. Rs. 2000 - 2500 94 items
  11. Rs. 2500 - 3000 74 items
  12. Rs. 3000 - 3500 20 items
  13. Rs. 3500 - 4000 6 items
  14. Rs. 4000 - 4500 4 items
  15. Rs. 4500 - 5000 1 item
  1. Beige Remove This Item
  2. Green Remove This Item
  3. XXL Remove This Item
  4. 6 Remove This Item
  5. 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=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_6605ff1c680df3_06965022` 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

381 styles found
  1. 58% Off
    -58%
    PRINTED GREEN LACE-TRIM PENCIL DRESS
  2. 60% Off
    -60%
    WORK IT GREEN BODYCON DRESS
  3. 58% Off
    -58%
    CASUAL PRINTED GREEN MAXI DRESS
  4. 60% Off
    -60%
    PRINTED GREEN COWL NECK MAXI DRESS
  5. 60% Off
    -60%
    Halter Neck Hook-&-eye Sheath Dress
  6. 58% Off
    -58%
    MESH BACKLESS CUT-WAIST MIDI DRESS
  7. 60% Off
    -60%
    CLASSIC GREEN FRILL HEM MAXI DRESS
  8. 58% Off
    -58%
    GREEN HIGH-SLIT MAXI DRESS
  9. 58% Off
    -58%
    GREEN DRAPE-KNOT-DETAIL MIDI DRESS
  10. 60% Off
    -60%
    Green 3d Effect Sleeveless Dress
  11. 60% Off
    -60%
    BACKLESS GREEN TIE-DYE MAXI DRESS
  12. 60% Off
    -60%
    Green Metal Chain Straps Long Dress
  13. 59% Off
    -59%
    BACKLESS MERMAID GREEN MAXI DRESS