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_36` 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 ('114069')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%CDDVDCaseInserts' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('CDDVDCaseInserts' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CDDVDCaseInserts' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CDDVDCaseInserts"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CDDVDCaseInserts"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CDDVDCaseInserts"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CDDVDCaseInserts"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CDDVDCaseInserts' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CDDVDCaseInserts',`category_4` ='CDDVDCaseInserts') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CDDVDCaseInserts,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CDDVDCaseInserts', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

CD DVD Case Inserts

Refine Search

  GO
 
Brand

Compucessory(4)

Avery®(2)

Fellowes(2)

C-Line(1)

Cardinal(1)

Vaultz(1)

Quality Park(1)

 
Color

Clear(7)

White(5)

 
Recycled

No(10)

 
Packaged Quantity

10 / Pack(3)

100 / Box(2)

5 / Pack(1)

25 / Pack(1)

250 / Box(1)

50 / Pack(1)

50(1)

10(1)

100 / Pack(1)

 
Limited Warranty

1 Year(6)

 
Weight (Approximate)

1.60 lb(1)

0.16 oz(1)

0.80 oz(1)

24 lb(1)

 
Compatibility

CD/DVD

(1)

 
Mailer/Envelope Length

5"(2)

4 7/8"(1)

 
Mailer/Envelope Type

CD/DVD(3)

 
Mailer/Envelope Width

5"(3)

 
Package Type

Retail(1)

 
Media Type Capacity

1 CD/DVD(5)

4 CD/DVD(1)

6 CD/DVD(1)

 
Supported Binder Type

Ring Binder(3)

 
Accessibility

Slide Insert(1)

 
Manufacturer Part Number

73721(1)

75263(1)

22297(1)

26500(1)

26501(1)

26555(1)

70568(1)

21845(1)

90659(1)

95304(1)

VZ01096(1)

62903(1)

 
Country of Origin

China(7)

United States(2)

Taiwan(2)

Denmark(1)

 
Material

Polypropylene(5)

Vinyl(2)

Plastic(1)

Wove(1)

 
Height

5"(1)

5.8"(1)

11.1"(1)

5.1"(1)

 
Width

0.1"(1)

5"(1)

7.4"(1)

5.1"(1)

 
Depth

0.1"(3)

 
Sheet Size

5" Width x 5" Length(1)

5" Width x 5 3/8" Length(1)

 
Shape

Rectangular(1)

 
Style

Sleeve(2)

 
Capacity

2 x CD/DVD(2)

 
Number of Holes Punched

9(1)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved