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 16 items
  2. Bodycon 84 items
  3. Denim Dresses 16 items
  4. Maxi Dresses 86 items
  5. Midi Dresses 46 items
  6. Off-shoulder And Bandeau Dresses 41 items
  7. Pencil Dresses 16 items
  8. Pencil Skirts 0 items
  9. Pinafore 1 item
  10. Shift Dresses 13 items
  11. Shirt Dresses 8 items
  12. Skater Dresses 22 items
  13. Tunic Dresses 4 items
  14. Wrap Dresses 3 items
  15. Corset Dresses 7 items
Colour
Colour
  1. Beige 16 items
  2. Black 123 items
  3. Blue 49 items
  4. Brown 21 items
  5. Gold 2 items
  6. Green 30 items
  7. Grey 10 items
  8. Maroon 1 item
  9. Multi 25 items
  10. Orange 7 items
  11. Pink 40 items
  12. Purple 11 items
  13. Red 39 items
  14. Silver 5 items
  15. White 62 items
  16. Yellow 11 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 5 items
  3. 3XL 3 items
  4. 4XL 2 items
  5. 5XL 1 item
  6. L 43 items
  7. M 41 items
  8. S 44 items
  9. XL 15 items
  10. XS 3 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 800 - 1000 3 items
  3. Rs. 1000 - 1200 3 items
  4. Rs. 1200 - 1400 4 items
  5. Rs. 1400 - 1600 3 items
  6. Rs. 1600 - 1800 5 items
  7. Rs. 1800 - 2000 2 items
  8. Rs. 2000 - 2500 13 items
  9. Rs. 2500 - 3000 10 items
  10. Rs. 3500 - 4000 4 items
  1. Pencil Skirts Remove This Item
  2. Shirt Dresses Remove This Item
  3. Off-shoulder And Bandeau Dresses Remove This Item
  4. Blue 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` 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=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_660520699dc831_90807070` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

Page
49 styles found
  1. 90% Off
    -90%
    CHARMING AS ALWAYS BLUE DRESS
  2. 60% Off
    -60%
    Blue Back-zip Tulle Bandeau Dress
  3. 58% Off
    -58%
    GLITZY BLUE BANDEAU MAXI DRESS
  4. 58% Off
    -58%
    SATIN BLUE OPEN-FRONT SHIRT DRESS
  5. 58% Off
    -58%
    BLUE BANDEAU MINI DENIM DRESS
  6. 58% Off
    -58%
    CORSETRY LAKE-BLUE BANDEAU DRESS
  7. 60% Off
    -60%
    BLUE MIDI BANDEAU DRESS
  8. 60% Off
    -60%
    BLUE BUTTON-DOWN BELTED SHIRT DRESS
  9. 58% Off
    -58%
    SATIN SLIP DARK-BLUE SHIRT DRESS
  10. 60% Off
    -60%
    Blue Long Stripe Print Bandeau Dress
  11. 59% Off
    -59%
    BLUE STRIPE MIDI SLIM BANDEAU DRESS
  12. 59% Off
    -59%
    RUFFLE TRIM SLIM BANDEAU DRESS
  13. 59% Off
    -59%
    BLUE STRAPLESS MIDI DENIM DRESS
  14. 60% Off
    -60%
    DEEP-BLUE DENIM BANDEAU DRESS
  15. 60% Off
    -60%
    BLUE FISHTAIL SHEER BANDEAU DRESS
  16. 95% Off
    -95%
    DRAMA ON POINT BLUE DRESS
  17. 59% Off
    -59%
    BLUE FLAP-BELT MIDI SHIRT DRESS
  18. 59% Off
    -59%
    FLAP-BELT BLUE MIDI SHIRT DRESS
  19. 60% Off
    -60%
    Lake Blue Tube Dress With Slit
  20. 60% Off
    -60%
    Blue Lace A-line Tube Dress
Page