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 14 items
  2. Body Suits 2 items
  3. Crop Tops 4 items
  4. Off Shoulder Tops 1 item
  5. Shirts 6 items
  6. Skinny Jeans 0 items
  7. T-shirts 23 items
  8. Vests And Camis 1 item
  9. Corsets & Tube Tops 9 items
Colour
Colour
  1. Beige 16 items
  2. Black 99 items
  3. Blue 26 items
  4. Brown 24 items
  5. Green 14 items
  6. Grey 28 items
  7. Maroon 1 item
  8. Multi 5 items
  9. Orange 2 items
  10. Pink 24 items
  11. Purple 7 items
  12. Red 9 items
  13. White 83 items
  14. Yellow 8 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 13 items
  3. 3XL 6 items
  4. 4XL 1 item
  5. FS 16 items
  6. L 82 items
  7. M 83 items
  8. S 64 items
  9. XL 43 items
  10. XS 3 items
  11. XXL 10 items
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 1 item
  4. Rs. 1000 - 1200 4 items
  5. Rs. 1200 - 1400 5 items
  6. Rs. 1400 - 1600 1 item
  7. Rs. 1600 - 1800 2 items
  8. Rs. 1800 - 2000 3 items
  9. Rs. 2000 - 2500 5 items
  10. Rs. 2500 - 3000 4 items
  11. Rs. 3000 - 3500 1 item
  1. Skinny Jeans Remove This Item
  2. T-shirts Remove This Item
  3. Vests And Camis Remove This Item
  4. Purple Remove This Item
  5. Red Remove This Item
  6. Yellow Remove This Item
  7. XXL Remove This Item
  8. 2XL 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_6606001b06bd26_83733698` 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

24 styles found
  1. 60% Off
    -60%
    PURPLE PRINTED CREW NECK T-SHIRT
  2. 60% Off
    -60%
    Red Cotton Mix Graphic Print Tee
  3. 60% Off
    -60%
    YELLOW PRINTED CREW NECK T-SHIRT
  4. 60% Off
    -60%
    Purple V-neck Regular Linen Mix Cami
  5. 60% Off
    -60%
    Purple Slogan Print Boxy Tee
  6. 60% Off
    -60%
    Red Graphic Print Boy Fit Tee
  7. 60% Off
    -60%
    Irregular Neck Plus Size Slim Top
  8. 60% Off
    -60%
    THIS ONES FOR YOU YELLOW T-SHIRT
  9. 60% Off
    -60%
    Mock Neck Fitted Top
  10. 60% Off
    -60%
    WORLD CHAMPS PURPKE TOP
  11. 60% Off
    -60%
    Yellow Printed Boxy Fit T-shirt
  12. 60% Off
    -60%
    YELLOW RIBBED V-NECK SLIM TOP
  13. 60% Off
    -60%
    PLAYFULL EVERYDAY YELLOW TOP
  14. 60% Off
    -60%
    Striped Round Neck Loose Red T-shirt
  15. 60% Off
    -60%
    PLAY UP THE SUMMER LOOK YELLOW TOP
  16. 60% Off
    -60%
    HEY QUEEN PURPLE TOP
  17. 60% Off
    -60%
    MUSCLE STYLE YELLOW T-SHIRT