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 18 items
  2. Body Suits 9 items
  3. Crop Tops 30 items
  4. Denim Tops 6 items
  5. Off Shoulder Tops 6 items
  6. Shirts 13 items
  7. T-shirts 55 items
  8. Tunic Tops 2 items
  9. Vests And Camis 42 items
  10. Corsets & Tube Tops 25 items
Colour
Colour
  1. Beige 149 items
  2. Black 897 items
  3. Blue 197 items
  4. Brown 276 items
  5. Gold 7 items
  6. Green 161 items
  7. Grey 187 items
  8. Maroon 4 items
  9. Multi 105 items
  10. Orange 37 items
  11. Pink 249 items
  12. Purple 63 items
  13. Red 150 items
  14. Silver 24 items
  15. White 587 items
  16. Yellow 42 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 27 items
  3. 3XL 11 items
  4. 4XL 5 items
  5. FS 35 items
  6. L 201 items
  7. M 205 items
  8. S 180 items
  9. XL 101 items
  10. XS 19 items
  11. XXL 15 items
  12. XXXL 3 items
Less
Price
Price
  1. Rs. 0 - 200 3 items
  2. Rs. 200 - 400 3 items
  3. Rs. 400 - 600 4 items
  4. Rs. 600 - 800 7 items
  5. Rs. 800 - 1000 26 items
  6. Rs. 1000 - 1200 41 items
  7. Rs. 1200 - 1400 35 items
  8. Rs. 1400 - 1600 26 items
  9. Rs. 1600 - 1800 19 items
  10. Rs. 1800 - 2000 13 items
  11. Rs. 2000 - 2500 18 items
  12. Rs. 2500 - 3000 14 items
  13. Rs. 3000 - 3500 1 item
Brand
Brand
  1. LULUANDSKY 205 items
  2. VAIRE 1 item
  1. Blue Remove This Item
  2. 2XL Remove This Item
  3. 1XL Remove This Item
  4. S 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_6605ad04212dd4_27499605` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

203 styles found
  1. 60% Off
    -60%
    Blue Boxy Fit Cotton Cropped T-ee
  2. 60% Off
    -60%
    Blue Embellished Halter Neck Corset
  3. 60% Off
    -60%
    Blue Stripe Patterned Ruffly Top
  4. 60% Off
    -60%
    Blue Loose Fitted Casual Shirt
  5. 60% Off
    -60%
    Sheer Lace Blue Halter Neck Top
  6. 60% Off
    -60%
    Y2k Blue Printed Off-shoulder Top
  7. 60% Off
    -60%
    Blue Backless Contrast Stitch Top
  8. 60% Off
    -60%
    Blue Strappy Tie-up Front Cami
  9. 60% Off
    -60%
    Light Blue Fray-edge Denim Tube Top
  10. 60% Off
    -60%
    Grey Blue Square Neck Cotton Mix Top
  11. 60% Off
    -60%
    Blue Floral Pattern Strappy Top
  12. 60% Off
    -60%
    Dangling Neck Tie-up Backless Top
  13. 60% Off
    -60%
    Dark Blue Lace-up Back V-hem Top
  14. 60% Off
    -60%
    Blue Halter Neck Sleeveless Top
  15. 60% Off
    -60%
    Blue Graphic Print Curved-hem Tee
  16. 60% Off
    -60%
    Blue Raglan-sleeved Printed T-shirt
  17. 60% Off
    -60%
    Blue Washed-effect Printed T-shirt
  18. 60% Off
    -60%
    Blue Halter Strap Crochet Top
  19. 60% Off
    -60%
    BLUE CONTRAST PRINTED CROP TOP
  20. 60% Off
    -60%
    PRINTED BLUE COTTON VEST TOP