Close Extra 5% OFF* On App Only
Use Code: APP5
REPUBLIC DAY - EXTRA Rs. 350 OFF ON MINIMUM PURCHASE OF Rs. 995 & ABOVE - USE CODE : LULU3 | Till 3pm today
✓Extra 5% off on app only
✓Extra 10% off buy 2 items
Use code: APP5
Use code: EXTRA2
Sale Ends In
Hours
:
Mins
:
Secs

Clothing

Filter
Shopping Options
Styles
Styles
  1. Bodycon 1 item
  2. Sets 1 item
  3. Shift Dresses 1 item
  4. Tunic Dresses 1 item
Colour
Colour
  1. Beige 28 items
  2. Black 118 items
  3. Blue 124 items
  4. Brown 18 items
  5. Gold 3 items
  6. Green 32 items
  7. Grey 35 items
  8. Maroon 6 items
  9. Multi 21 items
  10. Orange 10 items
  11. Pink 54 items
  12. Purple 17 items
  13. Red 58 items
  14. White 107 items
  15. Yellow 31 items
Less
Size
Size
  1. L 2 items
  2. M 3 items
  3. S 2 items
  4. XL 1 item
Less
  1. Gold 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`, `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=389 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_5e2fda903370b3_47360043` 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

3 styles found
  1. 70% Off
    LATER AT NIGHT GOLDEN SHIFT DRESS
    New
    Later At Night Golden Shift Dress
    ₹2,549
    ₹765 (70% Off)
  2. 80% Off
    LIFE IS A PARTY CHAMPAGNE BODYCON DRESS
    New
    Life Is A Party Champagne Bodycon Dress
    ₹3,349
    ₹670 (80% Off)
  3. 80% Off
    SPARKLING ON THE SAND GREY BIKINI
    New
    Sparkling On The Sand Grey Bikini
    ₹2,549
    ₹510 (80% Off)