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

Sling Bags

Filter
Shopping Options
Category
Category
Colour
Colour
  1. Beige 35 items
  2. Black 303 items
  3. Blue 68 items
  4. Brown 310 items
  5. Gold 19 items
  6. Green 46 items
  7. Grey 14 items
  8. Maroon 1 item
  9. Multi 22 items
  10. Orange 17 items
  11. Pink 84 items
  12. Purple 11 items
  13. Red 62 items
  14. Silver 90 items
  15. White 184 items
  16. Yellow 10 items
Less
Price
Price
  1. Rs. 600 - 800 1 item
  2. Rs. 800 - 1000 8 items
  3. Rs. 1000 - 1200 1 item
  4. Rs. 1200 - 1400 2 items
  5. Rs. 1400 - 1600 5 items
  6. Rs. 1600 - 1800 30 items
  7. Rs. 1800 - 2000 34 items
  8. Rs. 2000 - 2500 23 items
  9. Rs. 2500 - 3000 2 items
  10. Rs. 3500 - 4000 1 item
  1. Orange Remove This Item
  2. 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=522 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_67adede57eb374_20277580` 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

107 styles found
  1. 80% Off
    -80%
    STUDDED PRINTED STRAP SLING BAG
  2. 64% Off
    -64%
    ORANGE PRINTED CROSSBODY SLING BAG
  3. 85% Off
    -85%
    GEOMETRIC-QUILT ORANGE PU SLINGBAG
  4. 60% Off
    -60%
    TEXTURED SILVER PUFFER CROSSBODY BAG
  5. 60% Off
    -60%
    Zip-up Orange Geometric Sling Bag
  6. 60% Off
    -60%
    SILVER DOUBLE HANDLE CROSSBODY BAG
  7. 60% Off
    -60%
    ORANGE CROCHET SMALL CROSSBODY BAG
  8. 60% Off
    -60%
    SILVER BRAID-DETAIL STRAP SLING BAG
  9. 60% Off
    -60%
    GRANNY SQUARE CROCHET CROSSBODY BAG
  10. 60% Off
    -60%
    SILVER RUCHED DETAILS CROSSBODY BAG
  11. 60% Off
    -60%
    NYLON ORANGE QUILTED CROSSBODY BAG
  12. 60% Off
    -60%
    RUCHED BOTTOM CROSSBODY SILVER BAG