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 23 items
  2. Midi Skirts 20 items
  3. Pencil Skirts 1 item
  4. Short And Mini Skirts 32 items
  5. Skater Skirts 1 item
Colour
Colour
  1. Beige 43 items
  2. Black 212 items
  3. Blue 92 items
  4. Brown 99 items
  5. Gold 3 items
  6. Green 38 items
  7. Grey 60 items
  8. Maroon 3 items
  9. Multi 33 items
  10. Orange 5 items
  11. Pink 47 items
  12. Purple 11 items
  13. Red 39 items
  14. Silver 18 items
  15. White 88 items
  16. Yellow 12 items
Less
Size
Size
  1. 2XL 1 item
  2. 3XL 1 item
  3. 4XL 1 item
  4. 5XL 1 item
  5. FS 5 items
  6. L 43 items
  7. M 47 items
  8. S 43 items
  9. XL 20 items
  10. XS 8 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 800 - 1000 5 items
  3. Rs. 1000 - 1200 1 item
  4. Rs. 1200 - 1400 5 items
  5. Rs. 1400 - 1600 7 items
  6. Rs. 1600 - 1800 11 items
  7. Rs. 1800 - 2000 10 items
  8. Rs. 2000 - 2500 9 items
  9. Rs. 2500 - 3000 3 items
  10. Rs. 3000 - 3500 1 item
  1. Pencil Skirts Remove This Item
  2. Midi Skirts Remove This Item
  3. Short And Mini Skirts Remove This Item
  4. Red Remove This Item
  5. Purple Remove This Item
  6. Gold Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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`, `at_special_price`.`value` AS `special_price` FROM `catalog_product_entity` 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_67adde0570b1c1_27230361` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

Page
53 styles found
  1. 60% Off
    -60%
    A-LINE ROSE RED CARGO MIDI SKIRT
  2. 60% Off
    -60%
    Asymmetric Hem Midi Skirt
  3. 60% Off
    -60%
    Red A-line Midi Skirt
  4. 60% Off
    -60%
    Claret Box Pleat Midi Skirt
  5. 60% Off
    -60%
    Red Plaid Midi Skirt
  6. 60% Off
    -60%
    Red Pleated Mid-waist Skort
  7. 60% Off
    -60%
    Short High-rise Skirt W/ Belt
  8. 60% Off
    -60%
    FS PINK FRINGED MIDI SKIRT
  9. 60% Off
    -60%
    Short Sequin Golden Drape Skirt
  10. 60% Off
    -60%
    Claret A-line Midi Corduroy Skirt
  11. 60% Off
    -60%
    Red Gingham Check Print Skirt
  12. 60% Off
    -60%
    Free Size Pleated Midi Skirt
  13. 60% Off
    -60%
    Scallop Lace Trim Midi Skirt
  14. 60% Off
    -60%
    Red A-line Plaid Pattern Short Skirt
  15. 60% Off
    -60%
    Red Plaid Pattern Mini Skirt
  16. 60% Off
    -60%
    Crinkled Texture Midi Skirt
  17. 60% Off
    -60%
    Purple Metallic Sequin Coin Skirt
  18. 60% Off
    -60%
    Check Pattern Red Midi Skirt
  19. 60% Off
    -60%
    Red Bow-knot Detail Short Skirt
  20. 60% Off
    -60%
    Red Midi Pencil Skirt
  21. 60% Off
    -60%
    Pleated A-line Midi Skirt
  22. 60% Off
    -60%
    Printed Red Slip Skirt
Page