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 10 items
  2. Body Suits 3 items
  3. Crop Tops 13 items
  4. Off Shoulder Tops 2 items
  5. Shirts 5 items
  6. T-shirts 40 items
  7. Vests And Camis 10 items
  8. Corsets & Tube Tops 13 items
Colour
Colour
  1. Beige 55 items
  2. Black 306 items
  3. Blue 101 items
  4. Brown 97 items
  5. Green 78 items
  6. Grey 69 items
  7. Maroon 2 items
  8. Multi 60 items
  9. Orange 20 items
  10. Pink 95 items
  11. Purple 23 items
  12. Red 60 items
  13. Silver 3 items
  14. White 254 items
  15. Yellow 31 items
Less
Size
Size
  1. 1XL 2 items
  2. 27 0 items
  3. 2XL 27 items
  4. 3XL 9 items
  5. 4XL 1 item
  6. F-S 0 items
  7. FS 39 items
  8. L 238 items
  9. M 246 items
  10. S 234 items
  11. S-9 0 items
  12. XL 95 items
  13. XS 31 items
  14. XXL 10 items
Less
Price
Price
  1. Rs. 400 - 600 2 items
  2. Rs. 600 - 800 7 items
  3. Rs. 800 - 1000 14 items
  4. Rs. 1000 - 1200 13 items
  5. Rs. 1200 - 1400 17 items
  6. Rs. 1400 - 1600 11 items
  7. Rs. 1600 - 1800 15 items
  8. Rs. 1800 - 2000 8 items
  9. Rs. 2000 - 2500 8 items
  10. Rs. 2500 - 3000 7 items
  1. Pink Remove This Item
  2. XL Remove This Item
  3. 27 Remove This Item
  4. S-9 Remove This Item
  5. F-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_6605e3ba5a0902_15459591` 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

Page
96 styles found
  1. 60% Off
    -60%
    Pink Lace Detail Corsetry Bodysuit
  2. 60% Off
    -60%
    PINK CHIFFON PRINTED V-NECK BLOUSE
  3. 58% Off
    -58%
    PEARLY PINK TRANSPARENT CROP TOP
  4. 60% Off
    -60%
    Orange V-neck Knitted Slim Top
  5. 60% Off
    -60%
    Off-the-shoulder Pink Corset Top
  6. 60% Off
    -60%
    Pink Heart-cut Detail Slim Crop Top
  7. 60% Off
    -60%
    Pink Loose Fitted Casual Shirt
  8. 58% Off
    -58%
    FUCHSIA FANCY BOW-TIE TUBE TOP
  9. 60% Off
    -60%
    Pink Hook-&-eye Lace Corset Top
  10. 60% Off
    -60%
    PUFFER ZIP-FLY PINK TUBE TOP
  11. 60% Off
    -60%
    Pink Lace-detail V-neck Slim Top
  12. 60% Off
    -60%
    PLUS SIZE PINK DRAWSTRING T-SHIRT
  13. 58% Off
    -58%
    IMITATION-PEARL PINK TRANSPARENT TOP
  14. 58% Off
    -58%
    PINK SLIMMING STRAP CROPPED CORSET
  15. 60% Off
    -60%
    CASUAL LOOSE FIT ROSE RED SHIRT
  16. 60% Off
    -60%
    Pink Criss-cross Strappy Back Corset
Page