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 51 items
  2. Midi Skirts 58 items
  3. Pencil Skirts 1 item
  4. Short And Mini Skirts 63 items
  5. Skater Skirts 14 items
Colour
Colour
  1. Beige 25 items
  2. Black 101 items
  3. Blue 51 items
  4. Brown 52 items
  5. Gold 3 items
  6. Green 44 items
  7. Grey 35 items
  8. Maroon 1 item
  9. Multi 22 items
  10. Orange 2 items
  11. Pink 18 items
  12. Purple 11 items
  13. Red 11 items
  14. Silver 5 items
  15. White 65 items
  16. Yellow 6 items
Less
Size
Size
  1. 2XL 2 items
  2. FS 23 items
  3. L 81 items
  4. M 82 items
  5. S 77 items
  6. XL 32 items
  7. XS 7 items
Less
Price
Price
  1. Rs. 800 - 1000 5 items
  2. Rs. 1000 - 1200 1 item
  3. Rs. 1200 - 1400 5 items
  4. Rs. 1400 - 1600 15 items
  5. Rs. 1600 - 1800 16 items
  6. Rs. 1800 - 2000 14 items
  7. Rs. 2000 - 2500 23 items
  8. Rs. 2500 - 3000 9 items
  9. Rs. 3000 - 3500 10 items
  10. Rs. 3500 - 4000 2 items
  11. Rs. 4000 - 4500 1 item
  1. Maxi Skirts Remove This Item
  2. Midi Skirts Remove This Item
  3. Multi Remove This Item
  4. Pink Remove This Item
  5. Green Remove This Item
  6. Beige 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_6701bf0dbbb4d0_08472822` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` DESC, `e`.`entity_id` DESC LIMIT 24

109 styles found
  1. 58% Off
    -58%
    Lace-up Back Slit Reen Maxi Skirt
  2. 58% Off
    -58%
    A-LINE PINK CARGO MIDI SKIRT
  3. 59% Off
    -59%
    A-LINE GREEN CARGO MIDI SKIRT
  4. 60% Off
    -60%
    Printed Front Slit Denim Maxi Skirt
  5. 60% Off
    -60%
    Green A-line Zipper Slit Skirt
  6. 60% Off
    -60%
    Green Knitted Wavy Front Slit Skirt
  7. 60% Off
    -60%
    Green High-rise Mid Length Skirt
  8. 60% Off
    -60%
    Pink Mid-length Denim Skirt
  9. 59% Off
    -59%
    GREEN PARACHUTE SHIRRED MAXI SKIRT
  10. 60% Off
    -60%
    A-line Voluminous Long Skirt
  11. 60% Off
    -60%
    Faux Leather Free Size Flared Skirt
  12. 60% Off
    -60%
    Regular Waist Green Parachute Skirt
  13. 60% Off
    -60%
    Printed Front Slit A-line Midi Skirt
  14. 60% Off
    -60%
    GREEN LOW-WAISTED SEQUIN MAXI SKIRT
  15. 60% Off
    -60%
    GREEN CAMOUFLAGE CARGO MAXI SKIRT
  16. 60% Off
    -60%
    Raw Hem Denim Maxi Skirt