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 22 items
  3. Crop Tops 13 items
  4. Off Shoulder Tops 1 item
  5. Shirts 1 item
  6. Skinny Jeans 0 items
  7. T-shirts 75 items
  8. Vests And Camis 20 items
  9. Corsets & Tube Tops 42 items
Colour
Colour
  1. Beige 5 items
  2. Black 13 items
  3. Blue 9 items
  4. Brown 5 items
  5. Green 8 items
  6. Grey 4 items
  7. Multi 3 items
  8. Orange 1 item
  9. Pink 4 items
  10. Purple 1 item
  11. Red 5 items
  12. White 5 items
Less
Size
Size
  1. 12 0 items
  2. 1XL 4 items
  3. 2XL 23 items
  4. 3XL 4 items
  5. FS 20 items
  6. L 192 items
  7. M 190 items
  8. S 176 items
  9. XL 79 items
  10. XS 5 items
  11. XXL 4 items
  12. XXXL 2 items
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 3 items
  4. Rs. 1000 - 1200 1 item
  5. Rs. 1200 - 1400 2 items
  6. Rs. 1400 - 1600 1 item
  7. Rs. 1600 - 1800 1 item
  8. Rs. 1800 - 2000 3 items
  9. Rs. 2000 - 2500 1 item
Brand
Brand
  1. LULUANDSKY 14 items
  1. Skinny Jeans Remove This Item
  2. Shirts Remove This Item
  3. Crop Tops Remove This Item
  4. Purple Remove This Item
  5. Black Remove This Item
  6. 12 Remove This Item
  7. 3XL Remove This Item
  8. XXL Remove This Item
  9. XXXL Remove This Item
  10. XS Remove This Item
  11. LULUANDSKY 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_66059dfd05c550_34169303` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`created_at` ASC, `e`.`entity_id` DESC LIMIT 24

14 styles found
  1. 60% Off
    -60%
    DANCE ALL NIGHT BLACK CROP TOP
  2. 58% Off
    -58%
    BLACK-WHITE COLOURBLOCK CROP TOP
  3. 58% Off
    -58%
    BLACK PLEATED KNOT-TIE CROP TOP
  4. 58% Off
    -58%
    WIDE STRIPE PRINT BLACK SHIRT
  5. 59% Off
    -59%
    SLIM BLACK CROPPED TANK TOP
  6. 59% Off
    -59%
    OPEN-BACK SLIM BLACK CROP TOP
  7. 59% Off
    -59%
    BLACK DRAWSTRING DETAIL CROP TOP
  8. 59% Off
    -59%
    LIGHT PURPLE DRAWSTRING CROP TOP
  9. 60% Off
    -60%
    SEAMLESS BLACK RIB-KNIT CROP TOP
  10. 60% Off
    -60%
    Deep V-neck Black Lace Crop Top
  11. 60% Off
    -60%
    Plus Size Black Square Neck Crop Top
  12. 60% Off
    -60%
    V-neck Twisted Plus Size Crop Top
  13. 60% Off
    -60%
    Cut-out Crew Neck Plus Size Crop Top
  14. 60% Off
    -60%
    Square Neck Plus Size Black Crop Top