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
  • Dresses 4 items
  • Tops 5 items
Styles
Styles
  1. Asymmetrical Dresses 3 items
  2. Blouses 2 items
  3. Body Suits 2 items
  4. Bodycon 10 items
  5. Crop Tops 3 items
  6. Maxi Dresses 6 items
  7. Maxi Skirts 2 items
  8. Midi Dresses 5 items
  9. Midi Skirts 1 item
  10. Nightdresses 6 items
  11. Nightwear Set 3 items
  12. Off Shoulder Tops 5 items
  13. Off-shoulder And Bandeau Dresses 2 items
  14. Pencil Dresses 1 item
  15. Playsuits And Rompers 3 items
  16. Sets 19 items
  17. Shift Dresses 3 items
  18. Short And Mini Skirts 1 item
  19. Skater Dresses 4 items
  20. Skater Skirts 1 item
  21. Swimsuit 4 items
  22. T-shirts 8 items
  23. Vests And Camis 7 items
  24. Sports 2 items
  25. Sports Bra 1 item
  26. Vests 1 item
  27. Corsets & Tube Tops 3 items
Colour
Colour
  1. Beige 2 items
  2. Black 23 items
  3. Blue 2 items
  4. Brown 5 items
  5. Green 6 items
  6. Grey 2 items
  7. Maroon 0 items
  8. Multi 2 items
  9. Orange 2 items
  10. Pink 3 items
  11. Purple 4 items
  12. Red 4 items
  13. White 9 items
  14. Yellow 1 item
Less
Size
Size
  1. 2XL 1 item
  2. 3XL 1 item
  3. 4XL 1 item
  4. L 9 items
  5. M 7 items
  6. S 8 items
  7. XL 3 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 2 items
  3. Rs. 400 - 600 8 items
  4. Rs. 600 - 800 15 items
  5. Rs. 800 - 1000 35 items
  6. Rs. 1000 - 1200 16 items
  7. Rs. 1200 - 1400 19 items
  8. Rs. 1400 - 1600 14 items
  9. Rs. 1600 - 1800 15 items
  10. Rs. 1800 - 2000 9 items
  11. Rs. 2000 - 2500 20 items
  12. Rs. 2500 - 3000 24 items
  13. Rs. 3000 - 3500 4 items
  14. Rs. 3500 - 4000 2 items
  1. Crop Tops Remove This Item
  2. Pencil Dresses Remove This Item
  3. Shift Dresses Remove This Item
  4. Blouses Remove This Item
  5. White Remove This Item
  6. Maroon Remove This Item
  7. L Remove This Item
  8. Rs. 1800 - 2000 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_66062836d667f9_79347572` 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

9 styles found
  1. 58% Off
    -58%
    RETRO LACE-UP BACKLESS BLOUSE
  2. 60% Off
    -60%
    White Buttoned Sweetheart Neck Dress
  3. 60% Off
    -60%
    TEXTURED WHITE A-LINE SHIFT DRESS
  4. 60% Off
    -60%
    Black Regular Printed Cropped Tee
  5. 60% Off
    -60%
    CROCHET SCOOP NECK WHITE SHIFT DRESS
  6. 60% Off
    -60%
    White Frill-cuffed Sheer Lace Top
  7. 60% Off
    -60%
    White Round Neck Tie-ribbons Top