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. Crop Tops 1 item
  2. T-shirts 1 item
  3. Vests And Camis 2 items
  4. Corsets & Tube Tops 8 items
Colour
Colour
  1. Beige 157 items
  2. Black 922 items
  3. Blue 205 items
  4. Brown 285 items
  5. Gold 8 items
  6. Green 166 items
  7. Grey 196 items
  8. Maroon 4 items
  9. Multi 100 items
  10. Orange 40 items
  11. Pink 246 items
  12. Purple 70 items
  13. Red 155 items
  14. Silver 26 items
  15. White 618 items
  16. Yellow 44 items
Less
Size
Size
  1. 2XL 1 item
  2. 6 0 items
  3. FS 3 items
  4. L 11 items
  5. M 12 items
  6. S 10 items
  7. UK10 0 items
  8. XL 2 items
  9. XS 1 item
Less
Price
Price
  1. Rs. 800 - 1000 2 items
  2. Rs. 1000 - 1200 2 items
  3. Rs. 1200 - 1400 4 items
  4. Rs. 1400 - 1600 2 items
  5. Rs. 1800 - 2000 2 items
  1. Maroon Remove This Item
  2. Gold Remove This Item
  3. M Remove This Item
  4. UK10 Remove This Item
  5. 6 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_6605b640e705f0_28319018` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

12 styles found
  1. 60% Off
    -60%
    Golden Hook-&-eye Sequin Tube Top
  2. 60% Off
    -60%
    TIE-UP CRIMSON REVERSE TRIM CROP TOP
  3. 58% Off
    -58%
    CRIMSON V-NECK KNOT-DETAIL VEST
  4. 60% Off
    -60%
    GOLD SQUIN-BUTTERFLY CROP TOP
  5. 60% Off
    -60%
    RED CONTRAST LACE TRIM CAMI TOP
  6. 60% Off
    -60%
    Open-back Slim Golden Shiny Tube Top
  7. 60% Off
    -60%
    STRAPLESS METALLIC GOLD CORSET
  8. 60% Off
    -60%
    GOLD METALLIC V-HEM CORSET
  9. 60% Off
    -60%
    Metallic Golden Square Neck Corset
  10. 60% Off
    -60%
    GOLDEN SIDE LACE-UP STRAPLESS CORSET
  11. 60% Off
    -60%
    FAUX LEATHER GOLDEN METALLIC CORSET