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 39 items
  2. Bodycon 211 items
  3. Bracelets 0 items
  4. Maxi Dresses 152 items
  5. Midi Dresses 66 items
  6. Midi Skirts 0 items
  7. Off-shoulder And Bandeau Dresses 97 items
  8. Pencil Dresses 32 items
  9. Shift Dresses 17 items
  10. Shirt Dresses 7 items
  11. Skater Dresses 58 items
  12. Skater Skirts 0 items
  13. Tunic Dresses 6 items
  14. Wrap Dresses 3 items
  15. Corsets & Tube Tops 2 items
  16. Corset Dresses 16 items
Colour
Colour
  1. Beige 5 items
  2. Black 28 items
  3. Blue 12 items
  4. Brown 7 items
  5. Gold 1 item
  6. Green 13 items
  7. Multi 5 items
  8. Orange 4 items
  9. Pink 9 items
  10. Purple 1 item
  11. Red 12 items
  12. Silver 2 items
  13. White 17 items
  14. Yellow 3 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 3 items
  3. 3XL 2 items
  4. 4XL 1 item
  5. L 28 items
  6. M 29 items
  7. S 30 items
  8. XL 9 items
  9. XS 4 items
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 1 item
  4. Rs. 1200 - 1400 3 items
  5. Rs. 1400 - 1600 6 items
  6. Rs. 1600 - 1800 3 items
  7. Rs. 1800 - 2000 7 items
  8. Rs. 2000 - 2500 6 items
  9. Rs. 2500 - 3000 6 items
  10. Rs. 3000 - 3500 3 items
  11. Rs. 3500 - 4000 2 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. White Remove This Item
  6. Red Remove This Item
  7. Gold Remove This Item
  8. Pink Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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`, `at_special_price`.`value` AS `special_price` FROM `catalog_product_entity` 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_669f0ba2549894_22929658` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

Page
39 styles found
  1. 60% Off
    -60%
    White Bell Sleeve Asymmetrical Dress
  2. 63% Off
    -63%
    EMBELLISHED WHITE ASYMMETRICAL DRESS
  3. 60% Off
    -60%
    ASYMMETRICAL SLANTED SEQUIN DRESS
  4. 61% Off
    -61%
    Claret One-shoulder Plus Size Dress
  5. 63% Off
    -63%
    Asymmetrical Claret Long Dress
  6. 63% Off
    -63%
    Asymmetrical White Long Dress
  7. 60% Off
    -60%
    SEQUIN WHITE ASYMMETRICAL SLIM DRESS
  8. 63% Off
    -63%
    Red Plunging Irregular Hem Dress
  9. 59% Off
    -59%
    Y2K RUFFLY WHITE ASYMMETRICAL DRESS
Page