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 58 items
  2. Midi Skirts 38 items
  3. Pencil Skirts 4 items
  4. Short And Mini Skirts 81 items
  5. Skater Skirts 19 items
Colour
Colour
  1. Beige 57 items
  2. Black 309 items
  3. Blue 119 items
  4. Brown 155 items
  5. Gold 5 items
  6. Green 59 items
  7. Grey 114 items
  8. Maroon 3 items
  9. Multi 49 items
  10. Orange 7 items
  11. Pink 61 items
  12. Purple 18 items
  13. Red 54 items
  14. Silver 22 items
  15. White 149 items
  16. Yellow 15 items
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. 5XL 1 item
  5. FS 15 items
  6. L 172 items
  7. M 173 items
  8. S 162 items
  9. XL 50 items
  10. XS 23 items
  11. XXL 2 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 1 item
  3. Rs. 400 - 600 1 item
  4. Rs. 600 - 800 1 item
  5. Rs. 800 - 1000 4 items
  6. Rs. 1000 - 1200 5 items
  7. Rs. 1200 - 1400 22 items
  8. Rs. 1400 - 1600 26 items
  9. Rs. 1600 - 1800 31 items
  10. Rs. 1800 - 2000 24 items
  11. Rs. 2000 - 2500 48 items
  12. Rs. 2500 - 3000 44 items
Brand
Brand
  1. LULUANDSKY 206 items
  1. Maroon Remove This Item
  2. White Remove This Item
  3. Red Remove This Item
  4. 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`, `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_67b4ac94585220_73369317` 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

206 styles found
  1. 60% Off
    -60%
    Asymmetric Hem Midi Skirt
  2. 60% Off
    -60%
    White A-line Polyester Skirt
  3. 60% Off
    -60%
    DENIM MINI WHITE SIDE-ZIPPER SKIRT
  4. 60% Off
    -60%
    Red Maxi Skirt W/ Belt
  5. 60% Off
    -60%
    White Drawstring Waist A-line Skirt
  6. 60% Off
    -60%
    Off-white Short Denim Cargo Skirt
  7. 60% Off
    -60%
    White Long A-line Bubble Skirt
  8. 60% Off
    -60%
    White Knife Pleated Skort W/ Belt
  9. 60% Off
    -60%
    Red Knife Pleated Skort W/ Belt
  10. 60% Off
    -60%
    White Contrast Applique Tiered Skirt
  11. 60% Off
    -60%
    Red A-line Midi Skirt
  12. 60% Off
    -60%
    White Polka-dot Print Skort
  13. 60% Off
    -60%
    Claret Box Pleat Midi Skirt
  14. 60% Off
    -60%
    White Drawstring-waist Short Skirt
  15. 60% Off
    -60%
    Off-white Crinkle-effect Midi Skirt
  16. 60% Off
    -60%
    White Motif Print A-line Midi Skirt
  17. 60% Off
    -60%
    Red Sequinned Back Slit Maxi Skirt
  18. 60% Off
    -60%
    Off-white Side-slit Midi Slip Skirt
  19. 60% Off
    -60%
    White Solid Colour Maxi Skirt
  20. 60% Off
    -60%
    Red Maxi Textured Details Skirt
  21. 60% Off
    -60%
    Mini White Knife Pleat Skater Skirt