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 2 items
  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 3 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 508 items
  2. Black 2916 items
  3. Blue 1243 items
  4. Brown 797 items
  5. Gold 45 items
  6. Green 794 items
  7. Grey 566 items
  8. Maroon 25 items
  9. Multi 541 items
  10. Orange 206 items
  11. Pink 969 items
  12. Purple 334 items
  13. Red 745 items
  14. Silver 90 items
  15. White 1512 items
  16. Yellow 213 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 2 items
  3. 3XL 1 item
  4. 4XL 1 item
  5. FS 12 items
  6. L 134 items
  7. M 137 items
  8. S 126 items
  9. S-9 0 items
  10. XL 35 items
  11. XS 11 items
  12. XXL 2 items
  13. 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 19 items
  9. Rs. 2500 - 3000 21 items
  10. Rs. 3000 - 3500 13 items
  11. Rs. 3500 - 4000 7 items
  12. Rs. 5000 - 5500 2 items
  1. Silver Remove This Item
  2. Gold Remove This Item
  3. S-9 Remove This Item
  4. 4XL Remove This Item
  5. L 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_66060126ae6846_44376247` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`created_at` ASC, `e`.`entity_id` DESC LIMIT 24

152 styles found
  1. 60% Off
    -60%
    OWN THE PARTY GOLD BODYCON DRESS
  2. 60% Off
    -60%
    PARTY ANIMAL SILVER BODYCON DRESS
  3. 60% Off
    -60%
    WAIT AND WATCH GOLD DRESS
  4. 60% Off
    -60%
    COMPROMETIDA LATTE SPARKLED DRESS
  5. 58% Off
    -58%
    TAMARYN BEIGE SPARKLED DRESS
  6. 58% Off
    -58%
    SILVERY SHINY-BUD TWO PIECE SET
  7. 58% Off
    -58%
    BACKLESS SHINE-ON GOLDEN MAXI DRESS
  8. 58% Off
    -58%
    GOLDEN RUCHED EVENING PENCIL DRESS
  9. 58% Off
    -58%
    CLASSIC SILVERY CUT-OUT TUBE TOP
  10. 58% Off
    -58%
    TURTLE NECK SILVERY CUT-OUT BODYSUIT
  11. 58% Off
    -58%
    SOLID BUCKLE-DETAIL HALTERENCK VEST
  12. 58% Off
    -58%
    SQUARE NECK SILVERY FANCY-STRAP VEST
  13. 58% Off
    -58%
    THIGH-CUT-DETAIL GOLDEN MIDI DRESS
  14. 58% Off
    -58%
    THIGH-CUT-DETAIL SILVERY MIDI DRESS
  15. 58% Off
    -58%
    OPEN-BACK SILVERY Y2K HALTER VEST
  16. 60% Off
    -60%
    MOTIF-PRINT GREY POLYESTER BLOUSE
  17. 58% Off
    -58%
    GOLDEN SLIT DRAPEY BODYCON DRESS
  18. 58% Off
    -58%
    SILVER SLIT DRAPEY BODYCON DRESS
  19. 58% Off
    -58%
    Y2K SILVER BACKLESS SKATER DRESS