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 139 items
  2. Midi Skirts 135 items
  3. Pencil Skirts 8 items
  4. Short And Mini Skirts 196 items
  5. Skater Skirts 46 items
Colour
Colour
  1. Beige 16 items
  2. Black 107 items
  3. Blue 35 items
  4. Brown 64 items
  5. Gold 2 items
  6. Green 26 items
  7. Grey 54 items
  8. Maroon 1 item
  9. Multi 19 items
  10. Orange 2 items
  11. Pink 15 items
  12. Purple 6 items
  13. Red 15 items
  14. Silver 6 items
  15. White 61 items
  16. Yellow 3 items
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 12 items
  5. L 148 items
  6. M 156 items
  7. S 146 items
  8. XL 52 items
  9. XS 15 items
  10. XXL 1 item
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 600 - 800 1 item
  3. Rs. 800 - 1000 5 items
  4. Rs. 1000 - 1200 2 items
  5. Rs. 1200 - 1400 18 items
  6. Rs. 1400 - 1600 15 items
  7. Rs. 1600 - 1800 19 items
  8. Rs. 1800 - 2000 30 items
  9. Rs. 2000 - 2500 53 items
  10. Rs. 2500 - 3000 44 items
  1. Maxi Skirts Remove This Item
  2. Skater Skirts Remove This Item
  3. Red Remove This Item
  4. Maroon Remove This Item
  5. Purple Remove This Item
  6. Beige Remove This Item
  7. Blue Remove This Item
  8. Silver Remove This Item
  9. Multi Remove This Item
  10. Green Remove This Item
  11. White 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_67b4e19a78a836_79981173` 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

185 styles found
  1. 60% Off
    -60%
    White A-line Polyester Skirt
  2. 60% Off
    -60%
    GREEN PARACHUTE SHIRRED MAXI SKIRT
  3. 60% Off
    -60%
    Free Size A-line Crochet Maxi Skirt
  4. 60% Off
    -60%
    A-line Voluminous Long Skirt
  5. 60% Off
    -60%
    Red Maxi Skirt W/ Belt
  6. 60% Off
    -60%
    Blue Washed Pleated Skirt
  7. 60% Off
    -60%
    Heavy Wash Denim Skater Skit
  8. 60% Off
    -60%
    White Long A-line Bubble Skirt
  9. 60% Off
    -60%
    Blue A-line Free Size Maxi Skirt
  10. 60% Off
    -60%
    Apricot Knife Pleat Skater Skirt
  11. 60% Off
    -60%
    Sequinned Back Slit Maxi Skirt
  12. 60% Off
    -60%
    Red Sequinned Back Slit Maxi Skirt
  13. 60% Off
    -60%
    Regular Waist Green Parachute Skirt
  14. 60% Off
    -60%
    White Solid Colour Maxi Skirt
  15. 60% Off
    -60%
    Red Maxi Textured Details Skirt
  16. 60% Off
    -60%
    Mini White Knife Pleat Skater Skirt