app-download-header
90% Off on Shoes
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

Sling Bags

Filter
Shopping Options
Colour
Colour
  1. Beige 15 items
  2. Black 162 items
  3. Blue 37 items
  4. Brown 122 items
  5. Gold 10 items
  6. Green 36 items
  7. Grey 7 items
  8. Multi 6 items
  9. Orange 11 items
  10. Pink 62 items
  11. Purple 8 items
  12. Red 21 items
  13. Silver 49 items
  14. White 115 items
  15. Yellow 14 items
Less
Price
Price
  1. Rs. 400 - 600 23 items
  2. Rs. 600 - 800 2 items
  3. Rs. 800 - 1000 3 items
  4. Rs. 1000 - 1200 22 items
  5. Rs. 1200 - 1400 57 items
  6. Rs. 1400 - 1600 88 items
  7. Rs. 1600 - 1800 220 items
  8. Rs. 1800 - 2000 149 items
  9. Rs. 2000 - 2500 95 items
  10. Rs. 2500 - 3000 13 items
  11. Rs. 3000 - 3500 2 items
  12. Rs. 3500 - 4000 1 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=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_669f7a875f18e7_65170631` 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 48

675 styles found
  1. 60% Off
    -60%
    NYLON PURPLE PUFFER CROSSBODY BAG
  2. 60% Off
    -60%
    NYLON BLUE PUFFER CROSSBODY BAG
  3. 60% Off
    -60%
    NYLON PINK PUFFER CROSSBODY BAG
  4. 60% Off
    -60%
    NYLON BLACK PUFFER CROSSBODY BAG
  5. 60% Off
    -60%
    NYLON WHITE PUFFER CROSSBODY BAG
  6. 60% Off
    -60%
    BLUE CROCHETED NYLON CROSSBODY BAG
  7. 60% Off
    -60%
    GREEN CROCHETED NYLON CROSSBODY BAG
  8. 60% Off
    -60%
    KHAKI CROCHETED NYLON CROSSBODY BAG
  9. 60% Off
    -60%
    WHITE CROCHETED NYLON CROSSBODY BAG
  10. 60% Off
    -60%
    RHOMBUS QUILT BLACK SLING BAG
  11. 60% Off
    -60%
    RHOMBUS QUILT SILVER SLING BAG
  12. 60% Off
    -60%
    OFF-WHITE RHOMBUS QUILT SLING BAG
  13. 60% Off
    -60%
    GREEN RHOMBUS QUILT SLING BAG
  14. 60% Off
    -60%
    RUCHED SMALL OFF WHITE CROSSBODY BAG
  15. 60% Off
    -60%
    RUCHED SMALL BLACK CROSSBODY BAG
  16. 60% Off
    -60%
    RUCHED SMALL SILVER CROSSBODY BAG