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. 200 - 400 1 item
  2. Rs. 400 - 600 14 items
  3. Rs. 600 - 800 102 items
  4. Rs. 800 - 1000 75 items
  5. Rs. 1000 - 1200 19 items
  6. Rs. 1200 - 1400 38 items
  7. Rs. 1400 - 1600 82 items
  8. Rs. 1600 - 1800 209 items
  9. Rs. 1800 - 2000 322 items
  10. Rs. 2000 - 2500 417 items
  11. Rs. 2500 - 3000 74 items
  12. Rs. 3000 - 3500 14 items
  13. Rs. 3500 - 4000 9 items
  14. Rs. 4000 - 4500 1 item
Brand
Brand
  1. LULUANDSKY 1377 items
  2. STROKES 0 items
  1. Brown Remove This Item
  2. Purple Remove This Item
  3. Green Remove This Item
  4. STROKES Remove This Item
  5. 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_67adf8ca505373_92731928` 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

1377 styles found
  1. 90% Off
    -90%
    TIMELESS PURPLE HANDBAG
  2. 90% Off
    -90%
    GETTING ALONG KHAKI TRAVEL BAG
  3. 90% Off
    -90%
    MAKING IT WORK KHAKI SLING BAG
  4. 90% Off
    -90%
    PU KHAKI LINED TOTE BAG
  5. 90% Off
    -90%
    OPAL TIMES KHAKI SLING BAG
  6. 90% Off
    -90%
    GOTTA BE EXTRA BROWN BUCKET BAG
  7. 90% Off
    -90%
    KILLIN IT BROWN SLING BAG
  8. 90% Off
    -90%
    LOOKING FINE GREEN SLING BAG
  9. 90% Off
    -90%
    CHECKERED GREEN SMALL DUFFLE BAG
  10. 90% Off
    -90%
    BASICALLY YOURS GREEN HANDBAG
  11. 80% Off
    -80%
    DOUBLE HANDLE TEXTURED HANDBAG