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

Tops

Filter
Shopping Options
Styles
Styles
  1. Blouses 12 items
  2. Body Suits 1 item
  3. Crop Tops 11 items
  4. Off Shoulder Tops 1 item
  5. Shirts 2 items
  6. Skinny Jeans 0 items
  7. T-shirts 82 items
  8. Tunic Dresses 0 items
  9. Vests And Camis 9 items
  10. Corsets & Tube Tops 6 items
  11. Cold Shoulder Tops 1 item
Colour
Colour
  1. Beige 9 items
  2. Black 65 items
  3. Blue 18 items
  4. Brown 15 items
  5. Green 10 items
  6. Grey 13 items
  7. Multi 3 items
  8. Orange 0 items
  9. Pink 12 items
  10. Purple 4 items
  11. Red 7 items
  12. White 52 items
  13. Yellow 5 items
Less
Size
Size
  1. 1XL 4 items
  2. 2XL 68 items
  3. 3XL 23 items
  4. 4XL 6 items
  5. FS 66 items
  6. L 352 items
  7. M 381 items
  8. S 283 items
  9. XL 195 items
  10. XS 11 items
  11. XXL 59 items
Less
Price
Price
  1. Rs. 400 - 600 3 items
  2. Rs. 600 - 800 6 items
  3. Rs. 800 - 1000 10 items
  4. Rs. 1000 - 1200 3 items
  5. Rs. 1200 - 1400 15 items
  6. Rs. 1400 - 1600 4 items
  7. Rs. 1600 - 1800 11 items
  8. Rs. 1800 - 2000 9 items
  9. Rs. 2000 - 2500 17 items
  10. Rs. 2500 - 3000 4 items
  11. Rs. 3000 - 3500 2 items
  1. Skinny Jeans Remove This Item
  2. T-shirts Remove This Item
  3. Tunic Dresses Remove This Item
  4. Purple Remove This Item
  5. Orange Remove This Item
  6. Grey Remove This Item
  7. Black Remove This Item
  8. 3XL Remove This Item
  9. XXL 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=471 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_66056880006916_81037126` 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

82 styles found
  1. 60% Off
    -60%
    Black Round Neck Slim Top
  2. 60% Off
    -60%
    Black Printed Boxy Fit T-shirt
  3. 60% Off
    -60%
    Black Boxy Fit Graphic Tee
  4. 60% Off
    -60%
    Black Cotton Printed Tee
  5. 60% Off
    -60%
    Turtleneck Black Sheer Sleeved Top
  6. 60% Off
    -60%
    Black Letter Print Casual Tee
  7. 60% Off
    -60%
    Black Ruched Sheer Slim Top
  8. 60% Off
    -60%
    Grey Ruched Sheer Slim Top
  9. 60% Off
    -60%
    Black Square Neck Fitted Top
  10. 60% Off
    -60%
    Crew Neck Black Graffiti T-shirt
  11. 60% Off
    -60%
    Black Mesh Splicing Slim Top
  12. 60% Off
    -60%
    Black Graphic Print Boy Fit Tee
  13. 60% Off
    -60%
    Black Short-sleeved Graphic Tee
  14. 60% Off
    -60%
    Black Print Regular Tee
  15. 60% Off
    -60%
    Black Printed Drop-shoulder Tee
  16. 60% Off
    -60%
    Black Letter & Graphic Print T-shirt
  17. 60% Off
    -60%
    Sheer Full Sleeved Black Top
  18. 60% Off
    -60%
    Short Sleeved Grey Turtleneck Top
  19. 60% Off
    -60%
    Short Sleeved Black Turtleneck Top