app-download-header
90% Off on Shoes
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 30 items
  2. Bodycon 154 items
  3. Bracelets 0 items
  4. Maxi Dresses 109 items
  5. Midi Dresses 51 items
  6. Midi Skirts 0 items
  7. Off-shoulder And Bandeau Dresses 67 items
  8. Pencil Dresses 25 items
  9. Shift Dresses 9 items
  10. Shirt Dresses 5 items
  11. Skater Dresses 39 items
  12. Skater Skirts 0 items
  13. Tunic Dresses 5 items
  14. Wrap Dresses 3 items
  15. Corsets & Tube Tops 2 items
  16. Corset Dresses 12 items
Colour
Colour
  1. Beige 16 items
  2. Black 84 items
  3. Blue 42 items
  4. Brown 28 items
  5. Gold 1 item
  6. Green 44 items
  7. Grey 11 items
  8. Multi 16 items
  9. Orange 10 items
  10. Pink 22 items
  11. Purple 10 items
  12. Red 34 items
  13. Silver 3 items
  14. White 46 items
  15. Yellow 8 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 10 items
  3. 3XL 8 items
  4. 4XL 2 items
  5. 5XL 1 item
  6. FS 3 items
  7. L 57 items
  8. M 57 items
  9. S 58 items
  10. XL 20 items
  11. XS 5 items
  12. XXL 1 item
  13. XXXL 1 item
Less
Price
Price
  1. Rs. 400 - 600 2 items
  2. Rs. 600 - 800 3 items
  3. Rs. 800 - 1000 2 items
  4. Rs. 1000 - 1200 3 items
  5. Rs. 1200 - 1400 8 items
  6. Rs. 1400 - 1600 14 items
  7. Rs. 1600 - 1800 4 items
  8. Rs. 1800 - 2000 12 items
  9. Rs. 2000 - 2500 12 items
  10. Rs. 2500 - 3000 10 items
  11. Rs. 3000 - 3500 7 items
  12. Rs. 3500 - 4000 1 item
  13. Rs. 4000 - 4500 3 items
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Midi Skirts Remove This Item
  4. Asymmetrical Dresses Remove This Item
  5. Midi Dresses Remove This Item
  6. White Remove This Item
  7. Red Remove This Item
  8. Gold 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`, `e`.`size_price`, `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=1955 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_6699b8ac49da39_90228165` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` DESC, `e`.`entity_id` DESC LIMIT 24

Page
81 styles found
  1. 58% Off
    -58%
    Balloon Sleeved Textured Sheath Dress
  2. 58% Off
    -58%
    JACQUARD WHITE MIDI A-LINE DRESS
  3. 60% Off
    -60%
    A-line Floral Off-white Midi Dress
  4. 59% Off
    -59%
    WHITE TIERED MIDI TULLE DRESS
  5. 60% Off
    -60%
    White Bell Sleeve Asymmetrical Dress
  6. 60% Off
    -60%
    White Criss-cross Back Midi Dress
  7. 60% Off
    -60%
    EMBELLISHED WHITE ASYMMETRICAL DRESS
  8. 58% Off
    -58%
    OFF-WHITE MERMIAD-CORE MIDI DRESS
  9. 59% Off
    -59%
    PINK MERMIAD-CORE MIDI DRESS
  10. 60% Off
    -60%
    Asymmetrical Claret Long Dress
  11. 60% Off
    -60%
    Asymmetrical White Long Dress
  12. 60% Off
    -60%
    White Tie-up Shoulder Straps Dress
  13. 60% Off
    -60%
    Claret One-shoulder Plus Size Dress
  14. 60% Off
    -60%
    SEQUIN WHITE ASYMMETRICAL SLIM DRESS
  15. 60% Off
    -60%
    Red Plunging Irregular Hem Dress
  16. 60% Off
    -60%
    RED PLUS SIZE PRINTED MAXI DRESS
Page