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 17 items
  2. Bodycon 75 items
  3. Maxi Dresses 65 items
  4. Midi Dresses 21 items
  5. Nightdresses 2 items
  6. Off-shoulder And Bandeau Dresses 32 items
  7. Pencil Dresses 13 items
  8. Shift Dresses 11 items
  9. Shirt Dresses 2 items
  10. Skater Dresses 25 items
  11. Tunic Dresses 4 items
  12. Vests And Camis 1 item
  13. Corset Dresses 7 items
Colour
Colour
  1. Beige 112 items
  2. Black 856 items
  3. Blue 298 items
  4. Brown 184 items
  5. Gold 28 items
  6. Green 237 items
  7. Grey 78 items
  8. Maroon 6 items
  9. Multi 144 items
  10. Orange 63 items
  11. Pink 247 items
  12. Purple 81 items
  13. Red 262 items
  14. Silver 35 items
  15. White 342 items
  16. Yellow 53 items
Less
Size
Size
  1. 1XL 10 items
  2. 2XL 26 items
  3. 38B 0 items
  4. 3XL 20 items
  5. 4XL 7 items
  6. FS 1 item
  7. L 238 items
  8. M 247 items
  9. M/10 0 items
  10. S 249 items
  11. S/M 0 items
  12. XL 87 items
  13. XS 20 items
  14. XXL 6 items
  15. XXXL 4 items
Less
Price
Price
  1. Rs. 200 - 400 8 items
  2. Rs. 800 - 1000 2 items
  3. Rs. 1000 - 1200 5 items
  4. Rs. 1200 - 1400 22 items
  5. Rs. 1400 - 1600 31 items
  6. Rs. 1600 - 1800 41 items
  7. Rs. 1800 - 2000 28 items
  8. Rs. 2000 - 2500 65 items
  9. Rs. 2500 - 3000 43 items
  10. Rs. 3000 - 3500 22 items
  11. Rs. 3500 - 4000 6 items
  12. Rs. 4000 - 4500 8 items
  13. Rs. 4500 - 5000 1 item
  1. Pink Remove This Item
  2. S/M Remove This Item
  3. M Remove This Item
  4. M/10 Remove This Item
  5. 38B 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_6605a537cb3675_46117464` 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

275 styles found
  1. 58% Off
    -58%
    PINK CRISS-CROSS BACKLESS MAXI DRESS
  2. 60% Off
    -60%
    3d Print Long Sheath Dress
  3. 60% Off
    -60%
    A LITTLE SYNCH PINK DRESS
  4. 60% Off
    -60%
    PINK SEAMLESS FISHTAIL MAXI DRESS
  5. 80% Off
    -80%
    BLOOMING HIGH PINK FLORAL DRESS
  6. 58% Off
    -58%
    PINK CUT-OUT-WAIST SLIT MIDI DRESS
  7. 95% Off
    -95%
    BIG FLOWERS PINK DRESS
  8. 60% Off
    -60%
    BUTTERFLY-PRINT BODYCON MAXI DRESS
  9. 60% Off
    -60%
    TWISTED PINK PLEAT-DETAIL MAXI DRESS
  10. 60% Off
    -60%
    FISHTAIL BACKLESS PINK MAXI DRESS
  11. 60% Off
    -60%
    Pink Hooded Sheath Long Dress
  12. 60% Off
    -60%
    Pink Side-zip Pencil Dress