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

Handbags

Filter
Shopping Options
Category
Category
Colour
Colour
  1. Beige 37 items
  2. Black 457 items
  3. Blue 137 items
  4. Brown 458 items
  5. Gold 10 items
  6. Green 84 items
  7. Grey 39 items
  8. Maroon 2 items
  9. Multi 27 items
  10. Orange 10 items
  11. Pink 123 items
  12. Purple 17 items
  13. Red 88 items
  14. Silver 89 items
  15. White 254 items
  16. Yellow 34 items
Less
Price
Price
  1. Rs. 400 - 600 3 items
  2. Rs. 600 - 800 60 items
  3. Rs. 800 - 1000 35 items
  4. Rs. 1000 - 1200 11 items
  5. Rs. 1200 - 1400 18 items
  6. Rs. 1400 - 1600 35 items
  7. Rs. 1600 - 1800 84 items
  8. Rs. 1800 - 2000 138 items
  9. Rs. 2000 - 2500 174 items
  10. Rs. 2500 - 3000 62 items
  11. Rs. 3000 - 3500 11 items
  12. Rs. 3500 - 4000 3 items
  1. Purple Remove This Item
  2. Beige Remove This Item
  3. Pink Remove This Item
  4. Black 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` 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=519 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_67adf70a439193_28853238` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24 OFFSET 24

634 styles found
  1. 80% Off
    -80%
    BLACK OVERLAP TOP SHOULDER BAG