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 21 items
  3. Crop Tops 28 items
  4. Off Shoulder Tops 5 items
  5. Shirts 5 items
  6. T-shirts 31 items
  7. Tunic Tops 1 item
  8. Vests And Camis 22 items
  9. Corsets & Tube Tops 46 items
  10. Cold Shoulder Tops 1 item
Colour
Colour
  1. Beige 19 items
  2. Black 83 items
  3. Blue 26 items
  4. Brown 28 items
  5. Green 29 items
  6. Grey 14 items
  7. Multi 16 items
  8. Orange 6 items
  9. Pink 37 items
  10. Purple 9 items
  11. Red 17 items
  12. Silver 1 item
  13. White 74 items
  14. Yellow 10 items
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 1 item
  3. FS 1 item
  4. L 12 items
  5. M 14 items
  6. S 11 items
  7. XL 10 items
  8. XXL 2 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 1 item
  4. Rs. 1000 - 1200 3 items
  5. Rs. 1200 - 1400 3 items
  6. Rs. 1400 - 1600 3 items
  7. Rs. 1600 - 1800 2 items
  8. Rs. 1800 - 2000 2 items
  9. Rs. 2000 - 2500 1 item
  1. Off Shoulder Tops Remove This Item
  2. Blouses Remove This Item
  3. Red Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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_entity` 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_6605428b81dba5_47698618` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

17 styles found
  1. 60% Off
    -60%
    RED MANDARIN-V NECK BLOUSE
  2. 58% Off
    -58%
    SATIN PINK PLEATED BUTTONED BLOUSE
  3. 60% Off
    -60%
    ORGANZA PRINTED PEPLUM RED BLOUSE
  4. 58% Off
    -58%
    PUFF-SLEEVE RED FRONT-TIE BLOUSE
  5. 58% Off
    -58%
    PINK CLASSIC BUTTONED PLEAT BLOUSE
  6. 60% Off
    -60%
    RED TIE-COLLAR FORMAL BLOUSE
  7. 58% Off
    -58%
    RED CHOKER NECK FORMAL BLOUSE
  8. 60% Off
    -60%
    PRINTED PINK OFF-SHOULDER TOP
  9. 60% Off
    -60%
    PINK HANGING-V-NECK BLOUSE
  10. 60% Off
    -60%
    BAGGIER-DAYS WINE BLOUSE
  11. 60% Off
    -60%
    YOU KNOW STYLE WINE TOP
  12. 60% Off
    -60%
    Multicolour Printed Tie-front Blouse
  13. 60% Off
    -60%
    SLIM RED OFF-SHOULDER TOP W/ CHOKER
  14. 60% Off
    -60%
    OFF-THE-SHOULDER CLARET FITTED TOP