app-download-header
24 Hours Sale - 95% Off on Everything
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Women

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 23 items
  2. Blouses 18 items
  3. Body Suits 28 items
  4. Bodycon 134 items
  5. Cover Ups 1 item
  6. Crop Tops 39 items
  7. Denim Dresses 1 item
  8. Denim Tops 2 items
  9. Dungarees 0 items
  10. Jumpsuits 50 items
  11. Maxi Dresses 100 items
  12. Maxi Skirts 6 items
  13. Midi Dresses 41 items
  14. Midi Skirts 8 items
  15. Nightdresses 25 items
  16. Nightwear Set 28 items
  17. Off Shoulder Tops 16 items
  18. Off-shoulder And Bandeau Dresses 59 items
  19. Pencil Dresses 21 items
  20. Pencil Skirts 0 items
  21. Playsuits And Rompers 21 items
  22. Sets 221 items
  23. Shift Dresses 13 items
  24. Shirt Dresses 2 items
  25. Shirts 26 items
  26. Short And Mini Skirts 9 items
  27. Skater Dresses 28 items
  28. Skater Skirts 3 items
  29. Straight Jeans 4 items
  30. Swimsuit 23 items
  31. T-shirts 98 items
  32. Tunic Dresses 1 item
  33. Vests And Camis 40 items
  34. Cycling Short 3 items
  35. Sports 21 items
  36. Corsets & Tube Tops 37 items
  37. Cold Shoulder Tops 2 items
  38. Corset Dresses 6 items
Colour
Colour
  1. Black 2 items
  2. Blue 8 items
  3. Brown 1 item
  4. Multi 1 item
  5. White 1 item
Less
Size
Size
  1. 26 2 items
  2. 27 2 items
  3. 28 2 items
  4. 29 2 items
  5. 2XL 4 items
  6. 30 2 items
  7. FS 33 items
  8. L 13 items
  9. M 13 items
  10. S 13 items
  11. S/M 0 items
  12. XL 8 items
  13. XS 1 item
  14. XXL 2 items
Less
Price
Price
  1. Rs. 200 - 400 18 items
  2. Rs. 400 - 600 1 item
  3. Rs. 1000 - 1200 7 items
  4. Rs. 1200 - 1400 8 items
  5. Rs. 1400 - 1600 19 items
  6. Rs. 1600 - 1800 13 items
  7. Rs. 1800 - 2000 20 items
  8. Rs. 2000 - 2500 51 items
  9. Rs. 2500 - 3000 92 items
  10. Rs. 3000 - 3500 70 items
  11. Rs. 3500 - 4000 17 items
  12. Rs. 4000 - 4500 6 items
  13. Rs. 4500 - 5000 1 item
  14. Rs. 5000 - 5500 1 item
  1. Midi Skirts Remove This Item
  2. Pencil Skirts Remove This Item
  3. Dungarees Remove This Item
  4. Straight Jeans Remove This Item
  5. Tunic Dresses Remove This Item
  6. S/M Remove This Item
  7. M Remove This Item
  8. XL Remove This Item
  9. Rs. 1600 - 1800 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_660645831440b4_65190138` 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

13 styles found