app-download-header
90% Off on Shoes
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Skirts

Filter
Shopping Options
Styles
Styles
  1. Maxi Skirts 31 items
  2. Midi Skirts 51 items
  3. Pencil Skirts 4 items
  4. Short And Mini Skirts 50 items
  5. Skater Skirts 12 items
Colour
Colour
  1. Beige 36 items
  2. Black 179 items
  3. Blue 82 items
  4. Brown 66 items
  5. Gold 1 item
  6. Green 36 items
  7. Grey 56 items
  8. Maroon 4 items
  9. Multi 19 items
  10. Orange 5 items
  11. Pink 42 items
  12. Purple 8 items
  13. Red 18 items
  14. Silver 10 items
  15. White 85 items
  16. Yellow 7 items
Less
Size
Size
  1. 2XL 14 items
  2. 3XL 6 items
  3. 4XL 5 items
  4. 5XL 2 items
  5. FS 18 items
  6. L 118 items
  7. M 119 items
  8. S 119 items
  9. XL 80 items
  10. XS 23 items
  11. XXL 8 items
Less
Price
Price
  1. Rs. 200 - 400 2 items
  2. Rs. 400 - 600 2 items
  3. Rs. 600 - 800 3 items
  4. Rs. 800 - 1000 1 item
  5. Rs. 1000 - 1200 5 items
  6. Rs. 1200 - 1400 12 items
  7. Rs. 1400 - 1600 16 items
  8. Rs. 1600 - 1800 16 items
  9. Rs. 1800 - 2000 20 items
  10. Rs. 2000 - 2500 20 items
  11. Rs. 2500 - 3000 16 items
  12. Rs. 3000 - 3500 16 items
  13. Rs. 3500 - 4000 4 items
  14. Rs. 4000 - 4500 1 item
Brand
Brand
  1. LULUANDSKY 148 items
  1. Red Remove This Item
  2. Maroon Remove This Item
  3. Purple Remove This Item
  4. Blue Remove This Item
  5. Green Remove This Item
  6. LULUANDSKY 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_669cdd150faa88_84234833` 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

148 styles found
  1. 58% Off
    -58%
    Lace-up Back Slit Reen Maxi Skirt
  2. 60% Off
    -60%
    WITH ALL COMFORT BLUE SKIRT
  3. 59% Off
    -59%
    A-LINE GREEN CARGO MIDI SKIRT
  4. 59% Off
    -59%
    A-LINE ROSE RED CARGO MIDI SKIRT
  5. 60% Off
    -60%
    Distressed Detail Blue Denim Skirt
  6. 60% Off
    -60%
    RIPPED BLUE CENTER SLIT DENIM SKIRT
  7. 60% Off
    -60%
    Vintage Blue Centre Slit Denim Skirt
  8. 60% Off
    -60%
    Green High-rise Mid Length Skirt
  9. 60% Off
    -60%
    Frayed-edge Asymmetric Denim Skirt
  10. 60% Off
    -60%
    HIGH SLIT LIGHT BLUE DENIM SKIRT
  11. 60% Off
    -60%
    HIGH SLIT BLUE DENIM MAXI SKIRT
  12. 59% Off
    -59%
    DENIM MINI BLUE SIDE-ZIPPER SKIRT
  13. 59% Off
    -59%
    GREEN PARACHUTE SHIRRED MAXI SKIRT
  14. 60% Off
    -60%
    Irregular Gradient Denim Blue Skirt
  15. 60% Off
    -60%
    Blue Retro A-line Denim Skirt
  16. 60% Off
    -60%
    Blue Mid-length A-line Denim Skirt