app-download-header
Black Friday Sale
20% Off * on Shoes, Use Code: BN20
20% Off * on Shoes
Use Code: BN20
HR
:
MN
:
SC
ENDS IN

Skirts

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Bracelets 0 items
  2. Cropped Jeans 0 items
  3. Maxi Skirts 15 items
  4. Midi Skirts 22 items
  5. Pencil Skirts 3 items
  6. Short And Mini Skirts 20 items
  7. Skater Skirts 10 items
  8. Vests And Camis 0 items
Colour
Colour
  1. Beige 4 items
  2. Black 39 items
  3. Blue 12 items
  4. Brown 19 items
  5. Green 3 items
  6. Grey 9 items
  7. Maroon 1 item
  8. Pink 6 items
  9. Red 3 items
  10. Silver 4 items
  11. White 11 items
  12. Yellow 2 items
Less
Size
Size
  1. 2XL 2 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 3 items
  5. L 19 items
  6. M 22 items
  7. S 17 items
  8. XL 8 items
  9. XS 9 items
Less
Price
Price
  1. Rs. 600 - 800 2 items
  2. Rs. 1000 - 1200 5 items
  3. Rs. 1200 - 1400 4 items
  4. Rs. 1400 - 1600 4 items
  5. Rs. 1600 - 1800 2 items
  6. Rs. 1800 - 2000 4 items
  7. Rs. 2000 - 2500 4 items
  8. Rs. 2500 - 3000 3 items
  9. Rs. 3000 - 3500 2 items
  10. Rs. 3500 - 4000 1 item
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Vests And Camis Remove This Item
  4. Cropped Jeans Remove This Item
  5. Short And Mini Skirts Remove This Item
  6. White Remove This Item
  7. Red Remove This Item
  8. Blue Remove This Item
  9. Silver 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=1964 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_674f616f66e595_02559237` 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

Page
30 styles found
  1. 60% Off
    -60%
    MY OFFBEAT BLUE DENIM SKIRT
  2. 63% Off
    -63%
    Silver Sequin Pleated Skater Skirt
  3. 58% Off
    -58%
    DENIM MINI WHITE SIDE-ZIPPER SKIRT
  4. 64% Off
    -64%
    DENIM MINI BLUE SIDE-ZIPPER SKIRT
  5. 75% Off
    -75%
    WITH ALL COMFORT BLUE SKIRT
  6. 60% Off
    -60%
    Red A-line Plaid Pattern Short Skirt
  7. 60% Off
    -60%
    SILVER SEQUIN SLIM MINI SKIRT
  8. 58% Off
    -58%
    LACE-UP WHITE KNITTED MINI SKIRT
  9. 60% Off
    -60%
    Low-rise White A-line Skater Skirt
  10. 60% Off
    -60%
    WHITE HIGH-WAIST SKATER MINI SKIRT
  11. 58% Off
    -58%
    WHITE A-LINE GAUZE MINI SKIRT
Page