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

Special Prices

Upto 90% Off

Sale Ends In
Hours
:
Mins
:
Secs
  • 24 - Hours - Only

Special Prices

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 13 items
  2. Babydoll 1 item
  3. Blouses 40 items
  4. Body Suits 1 item
  5. Bodycon 16 items
  6. Crop Tops 7 items
  7. Cropped Jeans 10 items
  8. Culottes 0 items
  9. Denim Dresses 4 items
  10. Hats 1 item
  11. Jumpsuits 4 items
  12. Maxi Dresses 6 items
  13. Maxi Tops 1 item
  14. Midi Dresses 16 items
  15. Midi Skirts 5 items
  16. Mini Skirts 11 items
  17. Nightdresses 2 items
  18. Off Shoulder Tops 19 items
  19. Off-shoulder And Bandeau Dresses 8 items
  20. Pencil Dresses 9 items
  21. Pencil Skirts 1 item
  22. Playsuits And Rompers 4 items
  23. Ripped Jeans 1 item
  24. Sets 14 items
  25. Shift Dresses 22 items
  26. Shirt Dresses 2 items
  27. Shirts 1 item
  28. Skater Dresses 27 items
  29. Skater Skirts 17 items
  30. Skinny Jeans 1 item
  31. Straight Jeans 2 items
  32. Swimsuit 8 items
  33. T-shirts 26 items
  34. Tunic Dresses 30 items
  35. Tunic Tops 21 items
  36. Vests And Camis 12 items
  1. Culottes Remove This Item
  2. Maxi Tops 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=642 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_5e8f5ad78cf185_54616463` 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

1 styles found
  1. 85% Off
    WRITTEN IN MY SEQUINS WHITE MAXI TOP
    New
    Written In My Sequins White Maxi Top
    ₹3,299
    ₹495 (85% Off)