Close Extra 5% OFF* On App Only
Use Code: APP5

Clothing

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 1 item
  2. Blouses 10 items
  3. Bodycon 15 items
  4. Crop Tops 1 item
  5. Cropped Jeans 1 item
  6. Dungarees 1 item
  7. Flared Jeans 2 items
  8. Maxi Dresses 5 items
  9. Midi Dresses 14 items
  10. Midi Skirts 2 items
  11. Mini Skirts 3 items
  12. Nightwear Set 51 items
  13. Off Shoulder Tops 6 items
  14. Off-shoulder And Bandeau Dresses 4 items
  15. Playsuits And Rompers 1 item
  16. Ripped Jeans 1 item
  17. Sets 3 items
  18. Shirt Dresses 3 items
  19. Shirts 2 items
  20. Skater Dresses 8 items
  21. Skater Skirts 1 item
  22. Straight Jeans 5 items
  23. Swimsuit 1 item
  24. T-shirts 16 items
  25. Tunic Dresses 9 items
  26. Tunic Tops 8 items
  27. Vests And Camis 8 items
  28. Hipster 22 items
  29. Bikini 21 items
  30. Boyshort 18 items
  31. T-Shirt Bra 1 item
Colour
Colour
  1. Beige 2 items
  2. Black 22 items
  3. Blue 10 items
  4. Brown 5 items
  5. Gold 3 items
  6. Green 6 items
  7. Grey 5 items
  8. Maroon 2 items
  9. Orange 1 item
  10. Pink 9 items
  11. Purple 1 item
  12. Red 10 items
  13. White 15 items
  14. Yellow 9 items
Less
Size
Size
  1. 2XL 3 items
  2. FS 1 item
  3. L 35 items
  4. M 28 items
  5. S 28 items
  6. XL 36 items
  7. XXL 14 items
Less
Price
Price
  1. Rs. 0 - 1,500 35 items
  2. Rs. 1,501 - 3,000 2 items
  1. Tunic Dresses Remove This Item
  2. Tunic Tops Remove This Item
  3. Mini Skirts Remove This Item
  4. Bodycon Remove This Item
  5. Sets Remove This Item
  6. Green Remove This Item
  7. Blue Remove This Item
  8. Black Remove This Item
  9. L Remove This Item
  10. 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=389 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_61f423cc90fb47_77684762` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

Page
38 styles found
  1. 88% Off
    -88%
    PLAYING ON THE WINNING SIDE BLUE SKIRT
    New
    Playing On The Winning Side Blue Skirt
    ₹5,649
    ₹650 (88% Off)
  2. 88% Off
    -88%
    I FEEL ME BLACK TWO PIECE SET
    New
    I Feel Me Black Two Piece Set
    ₹6,599
    ₹759 (88% Off)
  3. 85% Off
    PREMIUM
    IT'S PERFECTION BODYCON DRESS
    New
    It's Perfection Bodycon Dress
    ₹11,755
    ₹1,763 (85% Off)
  4. 88% Off
    -88%
    CELEBRATING THE DIVA GREEN TWO PIECE SET
    New
    Celebrating The Diva Green Two Piece Set
    ₹4,249
    ₹489 (88% Off)
  5. 88% Off
    -88%
    SERENE LIKE LILLIES BLACK BODYCON DRESS
    New
    Serene Like Lillies Black Bodycon Dress
    ₹5,249
    ₹604 (88% Off)
  6. 88% Off
    -88%
    BOSSY SIDE BLACK DRESS
    New
    Bossy Side Black Dress
    ₹5,249
    ₹604 (88% Off)
  7. 89% Off
    -89%
    HAVING FUN BLACK TOP
    New
    Having Fun Black Top
    ₹2,499
    ₹287 (89% Off)
  8. 88% Off
    -88%
    DELIGHTFUL EVENING BLACK DRESS
    New
    Delightful Evening Black Dress
    ₹5,249
    ₹604 (88% Off)
  9. 88% Off
    -88%
    LANGUISH IN LACE BLUE DRESS
    New
    Languish In Lace Blue Dress
    ₹5,249
    ₹604 (88% Off)
  10. 89% Off
    -89%
    POLKA DOT DEEDS BLUE TOP
    New
    Polka Dot Deeds Blue Top
    ₹2,549
    ₹293 (89% Off)
  11. 88% Off
    -88%
    EDGY DELIGHT BLUE DRESS
    New
    Edgy Delight Blue Dress
    ₹5,449
    ₹627 (88% Off)
  12. 88% Off
    -88%
    EDGY DELIGHT BLACK DRESS
    New
    Edgy Delight Black Dress
    ₹5,449
    ₹627 (88% Off)
  13. 88% Off
    -88%
    CARPET APPROPRIATE BLACK DRESS
    New
    Carpet Appropriate Black Dress
    ₹5,449
    ₹627 (88% Off)
  14. 89% Off
    -89%
    LACE ME UP GREEN TUNIC TOP
    New
    Lace Me Up Green Tunic Top
    ₹3,499
    ₹402 (89% Off)
  15. 89% Off
    -89%
    LACE ME UP BLUE TUNIC TOP
    New
    Lace Me Up Blue Tunic Top
    ₹3,499
    ₹402 (89% Off)
  16. 89% Off
    -89%
    LACE ME UP BLACK TUNIC TOP
    New
    Lace Me Up Black Tunic Top
    ₹3,499
    ₹402 (89% Off)
  17. 89% Off
    -89%
    WIND CAUGHT MY DREAMS BLACK TWO PIECE SET
    New
    Wind Caught My Dreams Black Two Piece Set
    ₹4,299
    ₹494 (89% Off)
  18. 88% Off
    -88%
    YOU ARE FORMALLY INVITED BLACK DRESS
    New
    You Are Formally Invited Black Dress
    ₹6,849
    ₹788 (88% Off)
  19. 89% Off
    -89%
    OFF BEAT WAY TO HAVE FUN BLACK DRESS
    New
    Off Beat Way To Have Fun Black Dress
    ₹6,499
    ₹747 (89% Off)
  20. 88% Off
    -88%
    RUFFLE MY HEART IN POLKA DOT NAVY SKIRT
    New
    Ruffle My Heart In Polka Dot Navy Skirt
    ₹6,399
    ₹736 (88% Off)
  21. 89% Off
    -89%
    A CUT OF MY WHIMS BLACK DRESS
    New
    A Cut Of My Whims Black Dress
    ₹6,499
    ₹747 (89% Off)
  22. 89% Off
    -89%
    CHECK THE TREND PARADE GREEN CHECK DRESS
    New
    Check The Trend Parade Green Check Dress
    ₹6,499
    ₹747 (89% Off)
  23. 89% Off
    -89%
    CHECK THE TREND PARADE BLACK CHECK DRESS
    New
    Check The Trend Parade Black Check Dress
    ₹6,499
    ₹747 (89% Off)
  24. 89% Off
    -89%
    THE FLORAL REGION NAVY DRESS
    New
    The Floral Region Navy Dress
    ₹6,499
    ₹747 (89% Off)
Page