Close Extra 5% OFF* On App Only
Use Code: APP5

Special Prices

Upto 90% Off

Sale Ends In
Hours
:
Mins
:
Secs
  • 24 - Hours - Only

Special Prices

Filter
Shopping Options
Brand Name
Brand Name
  1. LULUANDSKY 10 items
Styles
Styles
  1. Blouses 14 items
  2. Bodycon 10 items
  3. Crop Tops 7 items
  4. Dungarees 0 items
  5. Jumpsuits 1 item
  6. Maxi Dresses 1 item
  7. Midi Dresses 1 item
  8. Off Shoulder Tops 2 items
  9. Pencil Dresses 3 items
  10. Sets 15 items
  11. Shift Dresses 3 items
  12. Shirts 12 items
  13. Skinny Jeans 1 item
  14. Swimsuit 1 item
  15. T-shirts 4 items
  16. Tunic Dresses 0 items
  17. Tunic Tops 2 items
  18. Vests And Camis 9 items
Colour
Colour
  1. Blue 3 items
  2. Brown 1 item
  3. Green 4 items
  4. Pink 1 item
  5. Purple 1 item
  6. Red 1 item
Less
Size
Size
  1. 10 0 items
  2. 2XL 1 item
  3. 30 0 items
  4. FS 1 item
  5. L 8 items
  6. M 1 item
  7. S 2 items
  8. XL 10 items
Less
  1. LULUANDSKY Remove This Item
  2. Maxi Dresses Remove This Item
  3. Vests And Camis Remove This Item
  4. Dungarees Remove This Item
  5. Tunic Dresses Remove This Item
  6. 10 Remove This Item
  7. 30 Remove This Item
  8. M Remove This Item
  9. XL 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=642 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_62c3ebe8414a38_00138565` 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

9 styles found
  1. 95% Off
    -95%
    WITH YOU EVERYTHING IS SIMPLE PURPLE TOP
    New
    With You Everything Is Simple Purple Top
    ₹1,999
    ₹99 (95% Off)
  2. 94% Off
    -94%
    BRING IT ON STRAP GREEN TANK TOP
    New
    Bring It On Strap Green Tank Top
    ₹1,799
    ₹99 (94% Off)
  3. 94% Off
    -94%
    BRING IT ON COFFEE TANK TOP
    New
    Bring It On Coffee Tank Top
    ₹1,799
    ₹99 (94% Off)
  4. 94% Off
    -94%
    BRING IT ON NAVY TANK TOP
    New
    Bring It On Navy Tank Top
    ₹1,799
    ₹99 (94% Off)
  5. -0%
    BRING IT ON BLUE TANK TOP
  6. 97% Off
    -97%
    LUSH IN GREEN TOP
    New
    Lush In Green Top
    ₹3,949
    ₹99 (97% Off)
  7. 94% Off
    -94%
    BRING IT ON PINK TANK TOP
    New
    Bring It On Pink Tank Top
    ₹1,799
    ₹99 (94% Off)
  8. 94% Off
    -94%
    BRING IT ON GREEN TANK TOP
    New
    Bring It On Green Tank Top
    ₹1,799
    ₹99 (94% Off)
  9. 96% Off
    -96%
     RED AND BLUETWO FACED  VEST TOP
    New
    Red And Bluetwo Faced Vest Top
    ₹2,449
    ₹99 (96% Off)