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 8 items
  2. Bodycon 36 items
  3. Maxi Dresses 20 items
  4. Midi Dresses 22 items
  5. Off-shoulder And Bandeau Dresses 13 items
  6. Pencil Dresses 9 items
  7. Shift Dresses 6 items
  8. Shirt Dresses 1 item
  9. Skater Dresses 8 items
  10. Tunic Dresses 2 items
  11. Corset Dresses 2 items
Colour
Colour
  1. Beige 38 items
  2. Black 241 items
  3. Blue 125 items
  4. Brown 52 items
  5. Gold 10 items
  6. Green 104 items
  7. Grey 17 items
  8. Maroon 7 items
  9. Multi 48 items
  10. Orange 27 items
  11. Pink 87 items
  12. Purple 25 items
  13. Red 106 items
  14. Silver 7 items
  15. White 101 items
  16. Yellow 25 items
Less
Size
Size
  1. 10 0 items
  2. 1XL 8 items
  3. 2XL 32 items
  4. 3XL 26 items
  5. 4XL 9 items
  6. 5XL 5 items
  7. 8 0 items
  8. FS 4 items
  9. L 270 items
  10. M 263 items
  11. S 267 items
  12. XL 106 items
  13. XS 20 items
  14. XXL 10 items
  15. XXXL 2 items
Less
Price
Price
  1. Rs. 200 - 400 16 items
  2. Rs. 800 - 1000 2 items
  3. Rs. 1000 - 1200 5 items
  4. Rs. 1200 - 1400 7 items
  5. Rs. 1400 - 1600 7 items
  6. Rs. 1600 - 1800 18 items
  7. Rs. 1800 - 2000 13 items
  8. Rs. 2000 - 2500 31 items
  9. Rs. 2500 - 3000 37 items
  10. Rs. 3000 - 3500 4 items
  11. Rs. 3500 - 4000 2 items
  12. Rs. 4000 - 4500 2 items
  1. Red Remove This Item
  2. 8 Remove This Item
  3. 10 Remove This Item
  4. XL 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_6605d3d30a8e02_16936448` 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

127 styles found
  1. 95% Off
    -95%
    FRINGES ON ME RED DRESS
  2. 58% Off
    -58%
    RED HALTER STRAP BODYCON DRESS
  3. 58% Off
    -58%
    SEQUIN RED LACE-UP BODYCON DRESS
  4. 58% Off
    -58%
    ASYMMETRIC SATIN PINK BODYCON DRESS
  5. 60% Off
    -60%
    Red Side Slit Crew Neck Maxi Dress
  6. 60% Off
    -60%
    RED BACKLESS TIE-UP STRAP MAXI DRESS
  7. 58% Off
    -58%
    RED SLIT ASYMMETRIC-NECK MIDI DRESS
  8. 95% Off
    -95%
    YOU GO GIRL WATERMELON RED DRESS
  9. 95% Off
    -95%
    I MEAN BUSINESS RED DRESS
  10. 58% Off
    -58%
    RED V-NECK SLIT MAXI DRESS
  11. 59% Off
    -59%
    PINK IRREGULAR HEM BODYCON DRESS
  12. 59% Off
    -59%
    PRINTED SQUARE NECK RED MIDI DRESS
  13. 58% Off
    -58%
    RED BACKLESS-KNOT-TIE BODYCON DRESS
  14. 60% Off
    -60%
    LAYERED-HEM RED BODYCON DRESS