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 53 items
  2. Midi Skirts 51 items
  3. Pencil Skirts 1 item
  4. Short And Mini Skirts 64 items
  5. Skater Skirts 12 items
Colour
Colour
  1. Beige 41 items
  2. Black 214 items
  3. Blue 97 items
  4. Brown 81 items
  5. Gold 5 items
  6. Green 57 items
  7. Grey 65 items
  8. Maroon 4 items
  9. Multi 33 items
  10. Orange 5 items
  11. Pink 50 items
  12. Purple 12 items
  13. Red 24 items
  14. Silver 19 items
  15. White 110 items
  16. Yellow 10 items
Less
Size
Size
  1. 2XL 2 items
  2. FS 19 items
  3. L 143 items
  4. M 146 items
  5. S 138 items
  6. XL 68 items
  7. XS 19 items
  8. XXL 3 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 600 - 800 3 items
  3. Rs. 800 - 1000 7 items
  4. Rs. 1000 - 1200 2 items
  5. Rs. 1200 - 1400 20 items
  6. Rs. 1400 - 1600 26 items
  7. Rs. 1600 - 1800 25 items
  8. Rs. 1800 - 2000 34 items
  9. Rs. 2000 - 2500 34 items
  10. Rs. 2500 - 3000 15 items
  11. Rs. 3000 - 3500 12 items
  12. Rs. 3500 - 4000 3 items
  13. Rs. 4000 - 4500 1 item
Brand
Brand
  1. LULUANDSKY 181 items
  1. Red Remove This Item
  2. Purple Remove This Item
  3. Green Remove This Item
  4. Multi Remove This Item
  5. Pink Remove This Item
  6. Gold Remove This Item
  7. 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_6709bbf476fb06_72607087` 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

181 styles found
  1. 63% Off
    -63%
    Bubble-hem Colorblock Pattern Skirt
  2. 63% Off
    -63%
    Red Layered Hem Printed Short Skirt
  3. 63% Off
    -63%
    Gradient Pink Drape Sequin Skirt
  4. 63% Off
    -63%
    Gradient Green Drape Sequin Skirt
  5. 63% Off
    -63%
    Pink Plaid Print Short Beach Skirt
  6. 65% Off
    -65%
    SHIRRED PURPLE SATIN SLIT SKIRT
  7. 63% Off
    -63%
    Red Drawstring-detail Short Skirt
  8. 58% Off
    -58%
    SMOCK-LOW-WAIST VINTAGE MIDI SKIRT
  9. 60% Off
    -60%
    Y2K ASYMMETRIC POLYESTER MIDI SKIRT
  10. 64% Off
    -64%
    GREEN FS FRINGED MIDI SKIRT
  11. 60% Off
    -60%
    GAUZE PRINTED TULLE PURPLE SKIRT
  12. 60% Off
    -60%
    GAUZE PRINTED TULLE GREEN SKIRT
  13. 64% Off
    -64%
    GREEN CAMOUFLAGE CARGO MAXI SKIRT
  14. 58% Off
    -58%
    DARK GREEN SATIN MINI SKIRT
  15. 60% Off
    -60%
    PLAID PINK LOW-RISE MAXI Y2K SKIRT