Close Extra 5% OFF* On App Only
Use Code: APP5
FINAL CLEARANCE SALE - UPTO 90% OFF ON SHOES | Till noon today
✓Extra 5% off on app only
✓Extra 30% off buy 4 items
Use code: APP5
Use code: APP30
Sale Ends In
Hours
:
Mins
:
Secs

Clothing

Filter
Shopping Options
Styles
Styles
  1. Blouses 1 item
  2. Bodycon 1 item
  3. Crop Tops 1 item
  4. Mini Skirts 1 item
  5. Shift Dresses 2 items
  6. Skater Dresses 2 items
  7. Skater Skirts 1 item
  8. Swimsuit 1 item
  9. T-shirts 2 items
  10. Vests And Camis 1 item
Colour
Colour
  1. Beige 9 items
  2. Black 36 items
  3. Blue 30 items
  4. Brown 8 items
  5. Gold 1 item
  6. Green 12 items
  7. Grey 12 items
  8. Maroon 5 items
  9. Multi 6 items
  10. Orange 3 items
  11. Pink 12 items
  12. Purple 3 items
  13. Red 15 items
  14. White 24 items
  15. Yellow 8 items
Less
Size
Size
  1. 14 0 items
  2. L 12 items
  3. M 11 items
  4. S 8 items
  5. XL 12 items
Less
  1. Gold Remove This Item
  2. Brown Remove This Item
  3. Purple Remove This Item
  4. XL Remove This Item
  5. 14 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=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_5f6f982c0ef597_32410018` 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

12 styles found
  1. 85% Off
    GRAPH-IC PLOTTER COFFEE T-SHIRT
    New
    Graph-ic Plotter Coffee T-shirt
    ₹2,199
    ₹330 (85% Off)
  2. 85% Off
    CLASS IT UP KHAKI SKATER SKIRT
    New
    Class It Up Khaki Skater Skirt
    ₹2,049
    ₹299 (85% Off)
  3. 85% Off
    FIND ME COZY IN KHAKI JUMPER DRESS
    New
    Find Me Cozy In Khaki Jumper Dress
    ₹2,849
    ₹427 (85% Off)
  4. 85% Off
    CURATING SEASHELLS KHAKI BROWN BIKINI
    New
    Curating Seashells Khaki Brown Bikini
    ₹1,899
    ₹285 (85% Off)
  5. 85% Off
    CAN YOU RIB-PEAT KHAKI RIBBED T-SHIRT
    New
    Can You Rib-peat Khaki Ribbed T-shirt
    ₹2,999
    ₹450 (85% Off)
  6. 85% Off
    NO SHORTCUTS NEEDED TAUPE CROP TOP
    New
    No Shortcuts Needed Taupe Crop Top
    ₹2,699
    ₹405 (85% Off)
  7. 85% Off
    Let's Move On Stripes LILAC Cami Top
    New
    Let's Move On Stripes Lilac Cami Top
    ₹2,899
    ₹435 (85% Off)
  8. 85% Off
    LIFE IS A PARTY CHAMPAGNE BODYCON DRESS
    New
    Life Is A Party Champagne Bodycon Dress
    ₹3,349
    ₹502 (85% Off)
  9. 86% Off
    WE AIM HIGH BROWN SHIFT DRESS
    New
    We Aim High Brown Shift Dress
    ₹2,949
    ₹399 (86% Off)
  10. 86% Off
    GOING LACES ABOUT YOU BROWN MINI SKIRT
    New
    Going Laces About You Brown Mini Skirt
    ₹2,199
    ₹299 (86% Off)
  11. 85% Off
    HEART WARMING CONVERSATION PURPLE SKATER DRESS
    New
    Heart Warming Conversation Purple Skater Dress
    ₹2,799
    ₹420 (85% Off)
  12. 85% Off
    MY LITTLE BUTTERFLYPLUM SKATER DRESSES
    New
    My Little Butterflyplum Skater Dresses
    ₹2,799
    ₹420 (85% Off)