app-download-header
24 Hours Sale - 95% Off on Everything
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Skirts

Filter
Shopping Options
Styles
Styles
  1. Maxi Skirts 8 items
  2. Midi Skirts 37 items
  3. Short And Mini Skirts 3 items
  4. Skater Skirts 5 items
Colour
Colour
  1. Beige 31 items
  2. Black 43 items
  3. Blue 24 items
  4. Brown 22 items
  5. Gold 1 item
  6. Green 17 items
  7. Grey 23 items
  8. Maroon 0 items
  9. Multi 3 items
  10. Orange 1 item
  11. Pink 19 items
  12. Purple 3 items
  13. Red 7 items
  14. Silver 1 item
  15. White 9 items
  16. Yellow 2 items
Less
Size
Size
  1. 2XL 6 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 53 items
  5. L 73 items
  6. M 70 items
  7. S 71 items
  8. XL 36 items
  9. XS 7 items
  10. XXL 3 items
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 19 items
  3. Rs. 1400 - 1600 14 items
  4. Rs. 1600 - 1800 9 items
  5. Rs. 1800 - 2000 4 items
  6. Rs. 2000 - 2500 6 items
Brand
Brand
  1. LULUANDSKY 53 items
  1. Red Remove This Item
  2. Maroon Remove This Item
  3. Purple Remove This Item
  4. Blue Remove This Item
  5. Green Remove This Item
  6. Yellow Remove This Item
  7. FS Remove This Item
  8. LULUANDSKY 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`, `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_66059decc7ba90_32575820` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

Page
53 styles found
  1. 60% Off
    -60%
    GREEN MIDI PLEATED SWING SKIRT
  2. 60% Off
    -60%
    PURPLE MIDI PLEATED SWING SKIRT
  3. 60% Off
    -60%
    GAUZE PRINTED TULLE GREEN SKIRT
  4. 60% Off
    -60%
    GAUZE PRINTED TULLE PURPLE SKIRT
  5. 59% Off
    -59%
    BLUE FS FRINGED MIDI SKIRT
  6. 59% Off
    -59%
    RED FS FRINGED MIDI SKIRT
  7. 60% Off
    -60%
    GREEN FS FRINGED MIDI SKIRT
  8. 60% Off
    -60%
    FS PINK FRINGED MIDI SKIRT
  9. 58% Off
    -58%
    PLEATED FS BLUE MIDI CHIFFON SKIRT
  10. 60% Off
    -60%
    GREEN PLEATED CHIFFON FS MAXI SKIRT
  11. 58% Off
    -58%
    FLORAL-PRINT YELLOW SWING SKIRT
  12. 58% Off
    -58%
    HOLLOW EMBROIDERY BLUE MIDI SKIRT
  13. 59% Off
    -59%
    FREE SIZE GREEN SKATER TULLE SKIRT
  14. 60% Off
    -60%
    A-LINE MIDI TIERED GREEN SKIRT
  15. 58% Off
    -58%
    LACY HIGH-RISE BLUE A-LINE SKIRT
  16. 60% Off
    -60%
    MESH EMBROIDERED GREEN FS MIDI SKIRT
  17. 60% Off
    -60%
    A BASIC DAY RED SKIRT
  18. 60% Off
    -60%
    MESH EMBROIDERED BLUE FS MIDI SKIRT
Page