Close Extra 5% OFF* On App Only
Use Code: APP5
TODAY'S SALE - UPTO 90% OFF ON BAGS | Till 9pm today
Extra 10% OFF* on Spend ₹4995
Use code: SKY15
Sale Ends In
Hours
:
Mins
:
Secs

Women

Filter
Shopping Options
Category
Category
  • Dresses 1 item
Colour
Colour
  1. Pink 1 item
  2. White 1 item
Less
Size
Size
  1. 10 1 item
  2. 12 1 item
  3. 1XL 4 items
  4. 25 8 items
  5. 26 13 items
  6. 27 15 items
  7. 28 12 items
  8. 29 11 items
  9. 2XL 57 items
  10. 30 10 items
  11. 31 8 items
  12. 32 2 items
  13. 32B 55 items
  14. 32C 75 items
  15. 32D 14 items
  16. 34B 75 items
  17. 34C 81 items
  18. 34D 16 items
  19. 36B 71 items
  20. 36C 64 items
  21. 36D 15 items
  22. 38B 62 items
  23. 38C 55 items
  24. 3XL 23 items
  25. 40B 29 items
  26. 40C 21 items
  27. 42B 3 items
  28. 42C 3 items
  29. 4XL 16 items
  30. 5XL 8 items
  31. F-S 2 items
  32. FS 94 items
  33. L 781 items
  34. M 759 items
  35. S 679 items
  36. XL 757 items
  37. XS 39 items
  38. XXL 279 items
  39. XXXL 10 items
Less
  1. 12 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=469 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_61716107bf6ab6_86788276` 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

1 styles found
  1. 94% Off
    TRENDING
    BLOCK ME WITH COLORS PINK TUNIC DRESS
    Sale
    Block Me With Colors Pink Tunic Dress
    ₹3,349
    ₹199 (94% Off)