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 57 items
  2. Midi Skirts 82 items
  3. Pencil Skirts 6 items
  4. Short And Mini Skirts 103 items
  5. Skater Skirts 22 items
Colour
Colour
  1. Beige 22 items
  2. Black 155 items
  3. Blue 59 items
  4. Brown 53 items
  5. Gold 4 items
  6. Green 36 items
  7. Grey 43 items
  8. Maroon 2 items
  9. Multi 26 items
  10. Orange 4 items
  11. Pink 31 items
  12. Purple 7 items
  13. Red 19 items
  14. Silver 15 items
  15. White 76 items
  16. Yellow 5 items
Less
Size
Size
  1. 2XL 7 items
  2. 3XL 3 items
  3. 4XL 2 items
  4. 5XL 1 item
  5. FS 7 items
  6. L 140 items
  7. M 143 items
  8. S 135 items
  9. XL 76 items
  10. XS 19 items
  11. XXL 5 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 600 - 800 2 items
  3. Rs. 800 - 1000 5 items
  4. Rs. 1000 - 1200 1 item
  5. Rs. 1200 - 1400 19 items
  6. Rs. 1400 - 1600 29 items
  7. Rs. 1600 - 1800 15 items
  8. Rs. 1800 - 2000 24 items
  9. Rs. 2000 - 2500 38 items
  10. Rs. 2500 - 3000 17 items
  11. Rs. 3000 - 3500 9 items
  12. Rs. 3500 - 4000 3 items
  1. Maxi Skirts Remove This Item
  2. Short And Mini Skirts Remove This Item
  3. Pencil Skirts Remove This Item
  4. Red Remove This Item
  5. Maroon Remove This Item
  6. Purple Remove This Item
  7. Beige Remove This Item
  8. Blue Remove This Item
  9. Pink Remove This Item
  10. Multi 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_6704d995124226_82711875` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

166 styles found
  1. 60% Off
    -60%
    Free Size Crinkled A-line Skirt
  2. 60% Off
    -60%
    Free Size A-line Tiered Maxi Skirt
  3. 60% Off
    -60%
    Black & White Stripes Maxi Skirt
  4. 60% Off
    -60%
    Pink Zip-up Back Mini Skirt
  5. 60% Off
    -60%
    Blue Denim Mini Skirt
  6. 60% Off
    -60%
    High-rise Slip Maxi Skirt
  7. 60% Off
    -60%
    Blue Zipper Detail Short Denim Skirt
  8. 60% Off
    -60%
    Printed Front Slit Denim Maxi Skirt
  9. 60% Off
    -60%
    Red Abstract Print Long Sheath Skirt
  10. 60% Off
    -60%
    Reversible Animal Pattern Slit Skirt
  11. 65% Off
    -65%
    Blue High-rise Maxi Skirt
  12. 60% Off
    -60%
    High-rise Animal Print Slip Skirt
  13. 60% Off
    -60%
    Red Plaid Pattern Short Skirt
  14. 60% Off
    -60%
    Purple Contrast Floral Flocked Skirt
  15. 60% Off
    -60%
    Metallic Red Side Slit Maxi Skirt
  16. 60% Off
    -60%
    Metallic Purple Side Slit Maxi Skirt
  17. 60% Off
    -60%
    Metallic Pink Side Slit Maxi Skirt
  18. 60% Off
    -60%
    Smock-detail Short Skirt
  19. 65% Off
    -65%
    Abstract Print Fringe-trim Skirt