app-download-header
Valentine's day Sale - Upto 90 Off on Bags
Use Code: LULUSKY10
Use Code: LULUSKY10
HR
:
MN
:
SC
ENDS IN

Skirts

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Maxi Skirts 70 items
  2. Midi Skirts 83 items
  3. Pencil Skirts 7 items
  4. Short And Mini Skirts 121 items
  5. Skater Skirts 28 items
Colour
Colour
  1. Beige 32 items
  2. Black 216 items
  3. Blue 66 items
  4. Brown 99 items
  5. Gold 4 items
  6. Green 39 items
  7. Grey 68 items
  8. Maroon 0 items
  9. Multi 29 items
  10. Orange 5 items
  11. Pink 37 items
  12. Purple 10 items
  13. Red 39 items
  14. Silver 19 items
  15. White 101 items
  16. Yellow 7 items
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 3 items
  3. 4XL 2 items
  4. 5XL 1 item
  5. FS 6 items
  6. L 155 items
  7. M 166 items
  8. S 155 items
  9. XL 85 items
  10. XS 21 items
  11. XXL 4 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 5 items
  4. Rs. 1000 - 1200 2 items
  5. Rs. 1200 - 1400 19 items
  6. Rs. 1400 - 1600 22 items
  7. Rs. 1600 - 1800 27 items
  8. Rs. 1800 - 2000 37 items
  9. Rs. 2000 - 2500 47 items
  10. Rs. 2500 - 3000 29 items
  11. Rs. 3000 - 3500 1 item
  12. Rs. 3500 - 4000 1 item
  1. Maxi Skirts Remove This Item
  2. Short And Mini Skirts Remove This Item
  3. Red Remove This Item
  4. Maroon Remove This Item
  5. Purple Remove This Item
  6. Blue Remove This Item
  7. Pink Remove This Item
  8. Green 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`, `e`.`size_price`, `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=473 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_67b4e170032d92_26581209` 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

191 styles found
  1. 60% Off
    -60%
    GREEN PARACHUTE SHIRRED MAXI SKIRT
  2. 60% Off
    -60%
    Red Bow-knot Detail Short Skirt
  3. 60% Off
    -60%
    Printed Picot Trim Short Skirt
  4. 60% Off
    -60%
    Red Layered Hem Printed Short Skirt
  5. 60% Off
    -60%
    Green Printed Long Sheath Skirt
  6. 60% Off
    -60%
    Short High-rise Skirt W/ Belt
  7. 60% Off
    -60%
    DENIM MINI BLUE SIDE-ZIPPER SKIRT
  8. 60% Off
    -60%
    Dark Blue Sheath Mini Denim Skirt
  9. 60% Off
    -60%
    Pink Check Pattern Skort
  10. 60% Off
    -60%
    Bubble-hem Colorblock Pattern Skirt
  11. 60% Off
    -60%
    Gradient Pink Drape Sequin Skirt
  12. 60% Off
    -60%
    Pink Plaid Print Short Beach Skirt
  13. 60% Off
    -60%
    Red High-rise Short Skirt
  14. 60% Off
    -60%
    Red Pleated Mid-waist Skort
  15. 60% Off
    -60%
    DARK GREEN SATIN MINI SKIRT
  16. 60% Off
    -60%
    GREEN CAMOUFLAGE CARGO MAXI SKIRT
  17. 60% Off
    -60%
    Red Draped-effect Low Skirt
  18. 60% Off
    -60%
    Red Maxi Slip Skirt
    New
    Red Maxi Slip Skirt
    ₹5,585
    ₹2,234 (60% Off)