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 4 items
  2. Blouses 1 item
  3. Body Suits 3 items
  4. Bodycon 32 items
  5. Crop Tops 5 items
  6. Jumpsuits 2 items
  7. Maxi Dresses 17 items
  8. Maxi Skirts 1 item
  9. Midi Dresses 3 items
  10. Nightdresses 6 items
  11. Nightwear Set 1 item
  12. Off-shoulder And Bandeau Dresses 7 items
  13. Pencil Dresses 2 items
  14. Playsuits And Rompers 1 item
  15. Sets 14 items
  16. Short And Mini Skirts 6 items
  17. Skater Dresses 2 items
  18. Skater Skirts 4 items
  19. T-shirts 1 item
  20. Vests And Camis 6 items
  21. Corsets & Tube Tops 20 items
  22. Corset Dresses 2 items
Colour
Colour
  1. Beige 514 items
  2. Black 2890 items
  3. Blue 1224 items
  4. Brown 823 items
  5. Gold 50 items
  6. Green 792 items
  7. Grey 588 items
  8. Maroon 25 items
  9. Multi 533 items
  10. Orange 199 items
  11. Pink 972 items
  12. Purple 332 items
  13. Red 717 items
  14. Silver 87 items
  15. White 1511 items
  16. Yellow 206 items
Less
Size
Size
  1. 1XL 1 item
  2. 28 0 items
  3. 2XL 2 items
  4. 3XL 1 item
  5. 4XL 1 item
  6. FS 12 items
  7. L 134 items
  8. M 137 items
  9. S 126 items
  10. S-14 0 items
  11. XL 35 items
  12. XS 11 items
  13. XXL 2 items
  14. XXXL 1 item
Less
Price
Price
  1. Rs. 600 - 800 3 items
  2. Rs. 800 - 1000 3 items
  3. Rs. 1000 - 1200 17 items
  4. Rs. 1200 - 1400 20 items
  5. Rs. 1400 - 1600 18 items
  6. Rs. 1600 - 1800 11 items
  7. Rs. 1800 - 2000 19 items
  8. Rs. 2000 - 2500 18 items
  9. Rs. 2500 - 3000 21 items
  10. Rs. 3000 - 3500 13 items
  11. Rs. 3500 - 4000 7 items
  12. Rs. 5000 - 5500 1 item
  1. Silver Remove This Item
  2. Gold Remove This Item
  3. M Remove This Item
  4. 28 Remove This Item
  5. S-14 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_6605f1a12ca050_16617630` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` ASC, `e`.`entity_id` DESC LIMIT 24

150 styles found
  1. 58% Off
    -58%
    OPEN-BACK SILVERY Y2K HALTER VEST
  2. 60% Off
    -60%
    HALTER-TIE METALLIC SILVER CAMI
  3. 58% Off
    -58%
    EMBELLISHING SILVER BACKLESS VEST
  4. 60% Off
    -60%
    GOLD SQUIN-BUTTERFLY CROP TOP
  5. 60% Off
    -60%
    Open-back Slim Golden Shiny Tube Top
  6. 60% Off
    -60%
    SILVER HIGH-RISE SKATER SKIRT
  7. 60% Off
    -60%
    GOLD HIGH-RISE SKATER SKIRT
  8. 60% Off
    -60%
    Metallic Silver Slanted Neck Top
  9. 58% Off
    -58%
    SOLID BUCKLE-DETAIL HALTERENCK VEST
  10. 60% Off
    -60%
    Metallic Silver Slim Fit Crop Top
  11. 58% Off
    -58%
    SILVER HOOD AND VEST CO-ORD SET
  12. 58% Off
    -58%
    CLASSIC SILVERY CUT-OUT TUBE TOP
  13. 58% Off
    -58%
    SQUARE NECK SILVERY FANCY-STRAP VEST
  14. 60% Off
    -60%
    HALTER GOLD SLIT-SIDES BODYCON DRESS
  15. 58% Off
    -58%
    THIGH-CUT-DETAIL SILVERY MIDI DRESS
  16. 58% Off
    -58%
    THIGH-CUT-DETAIL GOLDEN MIDI DRESS
  17. 58% Off
    -58%
    TURTLE NECK SILVERY CUT-OUT BODYSUIT