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 35 items
  2. Midi Skirts 45 items
  3. Pencil Skirts 3 items
  4. Short And Mini Skirts 48 items
  5. Skater Skirts 5 items
Colour
Colour
  1. Beige 60 items
  2. Black 320 items
  3. Blue 128 items
  4. Brown 167 items
  5. Gold 5 items
  6. Green 66 items
  7. Grey 119 items
  8. Maroon 2 items
  9. Multi 51 items
  10. Orange 7 items
  11. Pink 62 items
  12. Purple 18 items
  13. Red 53 items
  14. Silver 24 items
  15. White 152 items
  16. Yellow 15 items
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 2 items
  3. 4XL 2 items
  4. 5XL 1 item
  5. FS 19 items
  6. L 107 items
  7. M 108 items
  8. S 101 items
  9. XL 45 items
  10. XS 14 items
Less
Price
Price
  1. Rs. 200 - 400 2 items
  2. Rs. 800 - 1000 7 items
  3. Rs. 1000 - 1200 2 items
  4. Rs. 1200 - 1400 10 items
  5. Rs. 1400 - 1600 26 items
  6. Rs. 1600 - 1800 23 items
  7. Rs. 1800 - 2000 15 items
  8. Rs. 2000 - 2500 25 items
  9. Rs. 2500 - 3000 20 items
  10. Rs. 3000 - 3500 5 items
  11. Rs. 3500 - 4000 1 item
  1. Maxi Skirts Remove This Item
  2. Skater Skirts Remove This Item
  3. Midi Skirts Remove This Item
  4. Short And Mini Skirts Remove This Item
  5. Red Remove This Item
  6. Maroon Remove This Item
  7. Purple Remove This Item
  8. Beige 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_67acf93e6a9889_03908077` 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

133 styles found
  1. 60% Off
    -60%
    A-line Red Mini Skirt
  2. 60% Off
    -60%
    Low-rise Long Drape Skirt
  3. 60% Off
    -60%
    SATIN GOLDEN MIDI DIAGONAL-HEM SKIRT
  4. 60% Off
    -60%
    Faux Fur Hem Short Skirt
  5. 64% Off
    -64%
    PUPLE SATIN SLIP PURPLE MIDI SKIRT
  6. 60% Off
    -60%
    Front Slit Knot Detail Midi Skirt
  7. 63% Off
    -63%
    High-rise Drape Sequin Skirt
  8. 60% Off
    -60%
    Apricot Buckle-belt Tweed Skirt
  9. 60% Off
    -60%
    Gingham Pattern Red Maxi Skirt
  10. 60% Off
    -60%
    Red Satin Maxi Slip Skirt
  11. 60% Off
    -60%
    Off-white Side-zip Mini Bow Skirt
  12. 60% Off
    -60%
    Asymmetric Hem Midi Skirt
  13. 75% Off
    -75%
    RED FS FRINGED MIDI SKIRT
  14. 60% Off
    -60%
    PRETTY FLOWERS BURGUNDY SKIRT
  15. 75% Off
    -75%
    PURPLE TWISTED-KNOT MIDI SKIRT
  16. 60% Off
    -60%
    A-line Lace Maxi Skirt
  17. 60% Off
    -60%
    Short High-rise Skirt W/ Belt
  18. 60% Off
    -60%
    SHEER SUPERIORITY CREAM SKIRT
  19. 60% Off
    -60%
    CLASSIC COMFORT APRICOT DENIM SKIRT
  20. 64% Off
    -64%
    Mini Red Embellished Skirt
  21. 60% Off
    -60%
    Red Sequinned Back Slit Maxi Skirt
  22. 60% Off
    -60%
    Printed Picot Trim Short Skirt