Close Extra 5% OFF* On App Only
Use Code: APP5
SPECIAL DEAL - UPTO 90% OFF ON WINTER COLLECTION | Till 9pm today
Extra 10% OFF* on Spend ₹4995
Use code: SKY15
Sale Ends In
Hours
:
Mins
:
Secs

New

Filter
Shopping Options
Category
Category
  • Clothing 8 items
Styles
Styles
  1. Asymmetrical Dresses 5 items
  2. Blouses 9 items
  3. Bodycon 18 items
  4. Crop Tops 2 items
  5. Dungarees 1 item
  6. Flared Jeans 1 item
  7. Maxi Dresses 7 items
  8. Midi Dresses 17 items
  9. Midi Skirts 1 item
  10. Mini Skirts 1 item
  11. Off Shoulder Tops 5 items
  12. Off-shoulder And Bandeau Dresses 2 items
  13. Pencil Dresses 4 items
  14. Playsuits And Rompers 1 item
  15. Ripped Jeans 1 item
  16. Sets 5 items
  17. Shirt Dresses 6 items
  18. Shirts 3 items
  19. Skater Dresses 9 items
  20. Straight Jeans 3 items
  21. Swimsuit 2 items
  22. T-shirts 12 items
  23. Tunic Dresses 7 items
  24. Tunic Tops 8 items
  25. Vests And Camis 3 items
Colour
Colour
  1. Beige 1 item
  2. Black 6 items
  3. Blue 2 items
  4. Green 3 items
  5. Grey 1 item
  6. Multi 1 item
  7. Pink 2 items
  8. Red 4 items
  9. White 3 items
Less
Size
Size
  1. 1XL 0 items
  2. L 9 items
  3. M 8 items
  4. S 8 items
  5. XL 9 items
  6. XXL 1 item
  7. 37/3 0 items
Less
Price
Price
  1. Rs. 0 - 1,500 5 items
  1. Maxi Dresses Remove This Item
  2. Playsuits And Rompers Remove This Item
  3. Black Remove This Item
  4. Blue Remove This Item
  5. 1XL Remove This Item
  6. 37/3 Remove This Item
  7. M 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=385 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_61af5e9a4a7bc1_50332775` 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

8 styles found
  1. 80% Off
    PREMIUM
    WRAP FOR THE CHILL BLACK ZONE DRESS
    New
    Wrap For The Chill Black Zone Dress
    ₹18,012
    ₹3,602 (80% Off)
  2. 80% Off
    PREMIUM
    SOLID CLASSY BLACK CHIC DRESS
    New
    Solid Classy Black Chic Dress
    ₹10,425
    ₹2,085 (80% Off)
  3. 80% Off
    PREMIUM
    SWING UP BLACK MAXI DRESS
    New
    Swing Up Black Maxi Dress
    ₹17,786
    ₹3,557 (80% Off)
  4. 90% Off
    -90%
    ROUGH PLAY BLACK ROMPER
    New
    Rough Play Black Romper
    ₹3,149
    ₹315 (90% Off)
  5. 94% Off
    -94%
    FLORAL SWIRL BLACK DRESS
    New
    Floral Swirl Black Dress
    ₹6,799
    ₹399 (94% Off)
  6. 90% Off
    -90%
    BLOSSOM FOR YOUR OWN JOY BODYCON DRESS IN BLACK
  7. 90% Off
    -90%
    SLIP INTO THE SLINK DRESS IN BLUE
    New
    Slip Into The Slink Dress In Blue
    ₹4,949
    ₹495 (90% Off)
  8. 90% Off
    -90%
    SLIP INTO THE SLINK DRESS IN BLACK
    New
    Slip Into The Slink Dress In Black
    ₹4,949
    ₹495 (90% Off)