app-download-header
Valentine's day Sale - Upto 90 Off on Bags
Use Code: LULUSKY10
Use Code: LULUSKY10
HR
:
MN
:
SC
ENDS IN

Bags

Filter
Shopping Options
Category
Category
Colour
Colour
  1. Beige 113 items
  2. Black 1115 items
  3. Blue 352 items
  4. Brown 1123 items
  5. Gold 37 items
  6. Green 206 items
  7. Grey 83 items
  8. Maroon 3 items
  9. Multi 115 items
  10. Orange 33 items
  11. Pink 309 items
  12. Purple 48 items
  13. Red 210 items
  14. Silver 274 items
  15. White 656 items
  16. Yellow 68 items
Less
Price
Price
  1. Rs. 400 - 600 10 items
  2. Rs. 600 - 800 87 items
  3. Rs. 800 - 1000 68 items
  4. Rs. 1000 - 1200 14 items
  5. Rs. 1200 - 1400 30 items
  6. Rs. 1400 - 1600 62 items
  7. Rs. 1600 - 1800 176 items
  8. Rs. 1800 - 2000 289 items
  9. Rs. 2000 - 2500 378 items
  10. Rs. 2500 - 3000 71 items
  11. Rs. 3000 - 3500 12 items
  12. Rs. 3500 - 4000 8 items
  13. Rs. 4000 - 4500 1 item
Brand
Brand
  1. LULUANDSKY 1206 items
  2. STROKES 0 items
  1. Brown Remove This Item
  2. Grey Remove This Item
  3. STROKES Remove This Item
  4. 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`, `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=514 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_67adf540ce06f1_47321651` 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` ASC, `e`.`entity_id` DESC LIMIT 24

1206 styles found
  1. 90% Off
    -90%
    GETTING ALONG KHAKI TRAVEL BAG
  2. 90% Off
    -90%
    MAKING IT WORK KHAKI SLING BAG
  3. 90% Off
    -90%
    PU KHAKI LINED TOTE BAG
  4. 90% Off
    -90%
    OPAL TIMES KHAKI SLING BAG
  5. 90% Off
    -90%
    GOTTA BE EXTRA BROWN BUCKET BAG
  6. 90% Off
    -90%
    KILLIN IT BROWN SLING BAG
  7. 80% Off
    -80%
    DOUBLE HANDLE TEXTURED HANDBAG
  8. 80% Off
    -80%
    KNOT DETAIL BROWN ZIP-UP HOBO BAG
  9. 80% Off
    -80%
    KNOT DETAIL ZIP-UP HOBO BAG
  10. 80% Off
    -80%
    SLOUCHY ADJUSTABLE STRAP HOBO BAG