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
  • Tops 14 items
Styles
Styles
  1. Blouses 4 items
  2. Body Suits 1 item
  3. Crop Tops 11 items
  4. Off Shoulder Tops 1 item
  5. Pencil Dresses 0 items
  6. Sets 1 item
  7. Shift Dresses 0 items
  8. Skater Skirts 1 item
  9. T-shirts 11 items
  10. Vests And Camis 7 items
  11. Bikini 1 item
  12. Thong 5 items
  13. Corsets & Tube Tops 5 items
Colour
Colour
  1. Beige 1 item
  2. Black 22 items
  3. Blue 2 items
  4. Brown 3 items
  5. Green 4 items
  6. Grey 3 items
  7. Maroon 0 items
  8. Multi 2 items
  9. Orange 2 items
  10. Pink 3 items
  11. Purple 1 item
  12. Red 2 items
  13. Silver 1 item
  14. White 15 items
Less
Size
Size
  1. 2XL 2 items
  2. FS 2 items
  3. L 13 items
  4. M 12 items
  5. S 11 items
  6. XL 6 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. 600 - 800 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_6605a707245528_90063943` 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

15 styles found
  1. 58% Off
    -58%
    SLOGA PRINT WHITE FITTED CROP TOP
  2. 58% Off
    -58%
    GRAPHIC PRINT WHITE CROP TOP
  3. 58% Off
    -58%
    OPEN BACK WHITE SLIM CROP TOP
  4. 60% Off
    -60%
    RACER-BACK RIBBED WHITE CROP TOP
  5. 60% Off
    -60%
    WHITE OPEN-BACK HALTER CROP TOP
  6. 60% Off
    -60%
    WHITE U-NECK SLIM CROP TOP
  7. 60% Off
    -60%
    WHITE PRINTED SLEEVELESS BLOUSE
  8. 60% Off
    -60%
    SQUARE FAIR WHITE TOP
  9. 60% Off
    -60%
    YOU KNOW STYLE WHITE TOP
  10. 60% Off
    -60%
    BELLS AND STRIPES WHITE TOP
  11. 60% Off
    -60%
    REEL IT IN WHITE TOP
  12. 60% Off
    -60%
    ROSY NIGHTS WHITE TOP
  13. 60% Off
    -60%
    White Fitted Graphic Crop Top
  14. 90% Off
    -90%
    KNOTS ON ME WHITE CROP TOP