Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('114028')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%Laptop Cases Bags' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Laptop +Cases +Bags' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Laptop +Cases +Bags' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Laptop Cases Bags"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Laptop Cases Bags"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Laptop Cases Bags"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Laptop Cases Bags"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Laptop +Cases +Bags' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Bags',`category_4` ='Bags') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Bags,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Bags', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Laptop Cases Bags

Refine Search

  GO
 
Brand

Samsonite(8)

Solo(5)

ZIPIT(3)

Kensington(2)

Lorell(2)

Swiss Mobility(1)

bugatti(1)

Targus(1)

 
Color

Black(14)

Gray(4)

Red(2)

Orange(2)

Blue(1)

Pink(1)

Olive Green(1)

Brown(1)

Gold(1)

 
Packaged Quantity

1(22)

 
Limited Warranty

3 Year(7)

5 Year(4)

Lifetime(1)

2 Year(1)

 
Weight (Approximate)

2.93 lb(1)

8.60 lb(1)

2.20 lb(1)

1.50 lb(1)

2.60 lb(1)

13.50 oz(1)

3.09 lb(1)

8.84 lb(1)

1.30 lb(1)

 
Warranty

Manufacturer's limited three-year warranty.(1)

 
Compatibility

Apple - iPad(7)

Apple - iPad

(1)

 
For Use With

Laptops(1)

 
Durability

Shock Resistant Interior(4)

Scratch Resistant Interior(4)

Slip Resistant Shoulder Strap(2)

Bump Resistant Interior(1)

Damage Resistant(1)

Drop Resistant Interior(1)

 
Package Type

Retail(2)

 
Carrying Options

Handle(15)

Shoulder Strap(14)

Telescoping Handle(1)

 
Maximum Screen Size Supported

15.6"(6)

17"(5)

14"(4)

16"(3)

17.3"(2)

13.3"(1)

 
Accessibility

Top Loading(1)

 
Checkpoint Friendly

Yes(1)

No(1)

 
Maximum Device Size

15.6"(1)

 
Shoulder Strap

Yes(1)

 
Wheels

No(1)

 
Manufacturer Part Number

EXE9353(1)

CLS3464(1)

TSB705US(1)

TAC1024SM(1)

EXE950-10(1)

UBN1014(1)

ZREVMPWGSPR(1)

ZREVMGGBSPR(1)

ZREVMCCPSPR(1)

UBN300-4(1)

89441-1041(1)

66303-1070(1)

61613(1)

61612(1)

62850(1)

62567(1)

43269-1041(1)

43331-1041(1)

57475-1041(1)

51531-1073(1)

49573-1041(1)

45798-1139(1)

EXB772100(1)

 
Country of Origin

China(21)

Cambodia(1)

CN(1)

 
Material

Polyester(4)

Tricot Interior(2)

Nylon(2)

Ballistic Fabric(2)

Vinyl(2)

Velvet(1)

Poly Ballistic(1)

1680D Ballistic Nylon(1)

Denier Polyester(1)

Neoprene(1)

Ballistic Nylon(1)

Faux Leather(1)

Synthetic Leather(1)

Leather(1)

 
Height

12"(2)

14"(2)

12.8"(1)

14.5"(1)

18.3"(1)

15.5"(1)

11.8"(1)

18"(1)

15.8"(1)

12.5"(1)

16"(1)

10.5"(1)

18 1/2"(1)

19"(1)

13"(1)

 
Width

16.5"(2)

17"(2)

17.8"(2)

16"(1)

16.3"(1)

1"(1)

12.6"(1)

13.3"(1)

13.5"(1)

2.3"(1)

22"(1)

14.5"(1)

12 3/4"(1)

18"(1)

 
Depth

8"(3)

2"(2)

10.5"(1)

6.1"(1)

6.3"(1)

2.5"(1)

10.3"(1)

8.5"(1)

4.5"(1)

16"(1)

1"(1)

4 1/2"(1)

9"(1)

8.6"(1)

 
Color(s)

Black(1)

 
Material(s)

Nylon Twill(1)

 
Style

Briefcase(6)

Roller(4)

Backpack(3)

Messenger(3)

Sleeve(3)

Tote(1)

 
Closure

Zipper(1)

 
Number of Compartments

2(1)

 
Inner Height

18 1/4"(1)

 
Inner Width

12 1/4"(1)

 
Inner Depth

4 1/4"(1)

 
Lining

Polyester(1)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved