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 7 items
  2. Bodycon 26 items
  3. Denim Dresses 6 items
  4. Maxi Dresses 30 items
  5. Midi Dresses 23 items
  6. Off-shoulder And Bandeau Dresses 12 items
  7. Pencil Dresses 9 items
  8. Pinafore 1 item
  9. Shift Dresses 6 items
  10. Shirt Dresses 5 items
  11. Skater Dresses 10 items
  12. Tunic Dresses 3 items
  13. Wrap Dresses 3 items
  14. Corset Dresses 2 items
Colour
Colour
  1. Beige 41 items
  2. Black 245 items
  3. Blue 128 items
  4. Brown 52 items
  5. Gold 10 items
  6. Green 105 items
  7. Grey 17 items
  8. Maroon 7 items
  9. Multi 50 items
  10. Orange 27 items
  11. Pink 93 items
  12. Purple 28 items
  13. Red 109 items
  14. Silver 8 items
  15. White 101 items
  16. Yellow 25 items
Less
Size
Size
  1. 1XL 4 items
  2. 27 0 items
  3. 2XL 28 items
  4. 3XL 16 items
  5. 4XL 7 items
  6. 5XL 4 items
  7. FS 6 items
  8. L 299 items
  9. M 298 items
  10. S 306 items
  11. S-9 0 items
  12. XL 125 items
  13. XS 24 items
  14. XXL 14 items
  15. XXXL 5 items
Less
Price
Price
  1. Rs. 200 - 400 20 items
  2. Rs. 600 - 800 2 items
  3. Rs. 800 - 1000 2 items
  4. Rs. 1000 - 1200 4 items
  5. Rs. 1200 - 1400 13 items
  6. Rs. 1400 - 1600 4 items
  7. Rs. 1600 - 1800 11 items
  8. Rs. 1800 - 2000 8 items
  9. Rs. 2000 - 2500 47 items
  10. Rs. 2500 - 3000 34 items
  11. Rs. 3000 - 3500 5 items
  12. Rs. 3500 - 4000 7 items
  13. Rs. 4000 - 4500 3 items
  1. Blue Remove This Item
  2. XL Remove This Item
  3. S-9 Remove This Item
  4. 4XL Remove This Item
  5. 27 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_66057c263dbe52_11328437` 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

143 styles found
  1. 95% Off
    -95%
    DREAMING OF YOU BLUE DRESS
  2. 60% Off
    -60%
    SATIN BLUE COWL-NECK BODYCON DRESS
  3. 80% Off
    -80%
    SUMMERY VIBES BLUE DRESS
  4. 90% Off
    -90%
    CHARMING AS ALWAYS BLUE DRESS
  5. 58% Off
    -58%
    VELOUR DIAMON-CUT BODYCON DRESS
  6. 60% Off
    -60%
    Blue Back-zip Tulle Bandeau Dress
  7. 59% Off
    -59%
    BLUE TRANSLUCENT SLIT CORSET DRESS
  8. 59% Off
    -59%
    LIGHT-BLUE CORSETRY MIDI DRESS
  9. 59% Off
    -59%
    TIE STRAP A-LINE BLUE MIDI DRESS
  10. 59% Off
    -59%
    PRINTED SQUARE NECK BLUE MIDI DRESS
  11. 59% Off
    -59%
    BLUE ONE-SHOULDER ASYMMETRICAL DRESS
  12. 60% Off
    -60%
    BLUE BACKLESS CRISS-CROSS MAXI DRESS
  13. 58% Off
    -58%
    LAYERED-HEM BLUE BODYCON DRESS
  14. 60% Off
    -60%
    PRINTED BLUE PUFF SLEEVE MAXI DRESS
  15. 58% Off
    -58%
    BLUE BUTTON-DOWN DENIM SHORT DRESS
  16. 60% Off
    -60%
    DEEP-BLUE STRAPLESS DENIM DRESS
  17. 58% Off
    -58%
    BODYCON RUCHED DETAIL BLUE PU DRESS
  18. 58% Off
    -58%
    BLUE SEQUIN BODYCON DRESS
  19. 60% Off
    -60%
    BLUE TIERED HALTER SKATER DRESS
  20. 60% Off
    -60%
    HALTER METALLIC BLUE BODYCON DRESS