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 19 items
  • Tops 62 items
Styles
Styles
  1. Asymmetrical Dresses 18 items
  2. Blouses 16 items
  3. Body Suits 49 items
  4. Bodycon 96 items
  5. Crop Tops 24 items
  6. Cropped Jeans 1 item
  7. Culottes 1 item
  8. Denim Dresses 3 items
  9. Flare Jeans 30 items
  10. Jumpsuits 7 items
  11. Maxi Dresses 34 items
  12. Maxi Skirts 2 items
  13. Midi Dresses 17 items
  14. Midi Skirts 5 items
  15. Nightwear Set 11 items
  16. Off-shoulder And Bandeau Dresses 33 items
  17. Pencil Dresses 7 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 4 items
  20. Ripped Jeans 3 items
  21. Sets 61 items
  22. Shift Dresses 9 items
  23. Shirts 6 items
  24. Short And Mini Skirts 11 items
  25. Skater Dresses 27 items
  26. Skater Skirts 16 items
  27. Skinny Jeans 2 items
  28. Straight Jeans 72 items
  29. Swimsuit 21 items
  30. T-shirts 47 items
  31. Tunic Tops 1 item
  32. Vests And Camis 61 items
  33. Thong 6 items
  34. Bralette 7 items
  35. Wrap Dresses 2 items
  36. Mom Jeans 1 item
  37. Baggy Jeans 1 item
  38. Wide Leg Jeans 44 items
  39. Corsets & Tube Tops 121 items
  40. Corset Dresses 18 items
Colour
Colour
  1. Beige 12 items
  2. Black 13 items
  3. Blue 3 items
  4. Brown 9 items
  5. Green 5 items
  6. Grey 5 items
  7. Maroon 1 item
  8. Multi 2 items
  9. Orange 2 items
  10. Pink 7 items
  11. Purple 2 items
  12. Red 3 items
  13. Silver 1 item
  14. White 16 items
Less
Size
Size
  1. 1XL 7 items
  2. 2XL 21 items
  3. 3XL 16 items
  4. 4XL 3 items
  5. FS 78 items
  6. L 672 items
  7. M 694 items
  8. S 683 items
  9. XL 181 items
  10. XS 76 items
  11. XXL 13 items
  12. XXXL 1 item
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 800 - 1000 8 items
  3. Rs. 1000 - 1200 30 items
  4. Rs. 1200 - 1400 18 items
  5. Rs. 1400 - 1600 2 items
  6. Rs. 1600 - 1800 1 item
  7. Rs. 1800 - 2000 4 items
  8. Rs. 2000 - 2500 6 items
  9. Rs. 2500 - 3000 5 items
  10. Rs. 3000 - 3500 1 item
  11. Rs. 3500 - 4000 2 items
  1. Asymmetrical Dresses Remove This Item
  2. Vests And Camis Remove This Item
  3. XS Remove This Item
  4. 4XL 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_6605d81c7f93c1_25398856` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` DESC, `e`.`entity_id` DESC LIMIT 24

Page
81 styles found
  1. 60% Off
    -60%
    Dark Green Diagonal Hem Long Dress
  2. 60% Off
    -60%
    SEQUIN WHITE ASYMMETRICAL SLIM DRESS
  3. 60% Off
    -60%
    Spaghetti Strap Fancy Sequin Top
  4. 58% Off
    -58%
    ROSE-RED HOLLOW ASYMMETRICAL DRESS
  5. 60% Off
    -60%
    Black Lace Sleeveless Cami Top
  6. 60% Off
    -60%
    White Lace Sleeveless Cami Top
  7. 60% Off
    -60%
    White Asymmetrical Beach Dress
  8. 60% Off
    -60%
    WHITE FLORAL MESH CAMI TOP
  9. 58% Off
    -58%
    BEIGE TIE-UP COTTON CAMI TOP
Page