app-download-header
25% Cashback On Dresses
25% Cashback On Dresses, Use Code: DRESS25
25% Cashback On Dresses
Use Code: DRESS25
HR
:
MN
:
SC
ENDS IN

Skirts

Filter
Shopping Options
Styles
Styles
  1. Maxi Skirts 78 items
  2. Midi Skirts 92 items
  3. Pencil Skirts 5 items
  4. Short And Mini Skirts 110 items
  5. Skater Skirts 27 items
Colour
Colour
  1. Beige 40 items
  2. Black 215 items
  3. Blue 98 items
  4. Brown 79 items
  5. Gold 5 items
  6. Green 60 items
  7. Grey 66 items
  8. Maroon 4 items
  9. Multi 35 items
  10. Orange 5 items
  11. Pink 49 items
  12. Purple 13 items
  13. Red 26 items
  14. Silver 19 items
  15. White 116 items
  16. Yellow 10 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 19 items
  3. 3XL 7 items
  4. 4XL 5 items
  5. 5XL 2 items
  6. FS 27 items
  7. L 249 items
  8. M 254 items
  9. S 243 items
  10. XL 127 items
  11. XS 41 items
  12. XXL 12 items
Less
Price
Price
  1. Rs. 200 - 400 3 items
  2. Rs. 600 - 800 6 items
  3. Rs. 800 - 1000 7 items
  4. Rs. 1000 - 1200 2 items
  5. Rs. 1200 - 1400 23 items
  6. Rs. 1400 - 1600 42 items
  7. Rs. 1600 - 1800 41 items
  8. Rs. 1800 - 2000 46 items
  9. Rs. 2000 - 2500 65 items
  10. Rs. 2500 - 3000 34 items
  11. Rs. 3000 - 3500 28 items
  12. Rs. 3500 - 4000 7 items
  13. Rs. 4000 - 4500 1 item
Brand
Brand
  1. LULUANDSKY 312 items
  1. Red Remove This Item
  2. Blue Remove This Item
  3. Green Remove This Item
  4. Pink Remove This Item
  5. Brown 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` 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_67007cbc190952_02479479` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

312 styles found
  1. 60% Off
    -60%
    Green Ethnic Print Midi Skirt
  2. 60% Off
    -60%
    Khaki Sheath Embellished Skirt
  3. 60% Off
    -60%
    Bubble-hem Colorblock Pattern Skirt
  4. 60% Off
    -60%
    Red Layered Hem Printed Short Skirt
  5. 60% Off
    -60%
    Gradient Pink Drape Sequin Skirt
  6. 60% Off
    -60%
    Gradient Green Drape Sequin Skirt
  7. 60% Off
    -60%
    Pink Plaid Print Short Beach Skirt
  8. 58% Off
    -58%
    BROWN WAIST-DRAWSTRING MINI SKIRT
  9. 60% Off
    -60%
    Printed Picot Trim Short Skirt
  10. 60% Off
    -60%
    Red Drawstring-detail Short Skirt
  11. 65% Off
    -65%
    BROWN Y2K MIDI A-LINE SKIRT
  12. 58% Off
    -58%
    SMOCK-LOW-WAIST VINTAGE MIDI SKIRT
  13. 58% Off
    -58%
    BROWN LOW-RISE MINI BALLOON SKIRT
  14. 58% Off
    -58%
    IRREGULAR HEM Y2K BROWN SKIRT
  15. 60% Off
    -60%
    GREEN FS FRINGED MIDI SKIRT
  16. 60% Off
    -60%
    GAUZE PRINTED TULLE GREEN SKIRT