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

Currently Filtered by

Manufacturer

ACCO BRANDS INC

Refine Search

  GO
 
Category Filter

Laminator Supplies(41)

Binders(40)

Staplers(37)

Report Covers(31)

Classification Folders(22)

Punches(21)

Shredders(21)

File Fasteners(20)

Binding Systems Covers(19)

Clips/Clamps(16)

Binding Spines(16)

Trimmer Boards(16)

Staples(14)

Laminators(13)

Boards(13)

Punch Accessories(8)

Surge Protectors(6)

Copyholders(5)

Fingertip Pads(4)

Shredder Bags(4)

Mice(4)

Loose-Leaf Book Rings(4)

Binding Machines(4)

Desktop Stands(4)

Locks(3)

Keyboard Drawers/Platforms(3)

Keyboards(2)

Adapters/Chargers(2)

Presenters(2)

Footrests(2)

Cases(2)

Back Supports(2)

Pencil Cups(1)

Card Holders(1)

Magazine Files(1)

Desktop File Folder Sorters(1)

Shredder Lubricants(1)

Staple Removers(1)

Easels(1)

Office Paper(1)

Replacement Blades(1)

 
Brand

GBC(120)

ACCO(118)

Swingline(106)

Kensington(37)

Wilson Jones(15)

Quartet(14)

 
Color

Black(2)

Black/Gray(1)

 
Height

1 3/4"(3)

4.25"(3)

25"(3)

41"(2)

14.25"(2)

3.5"(2)

30"(2)

14"(2)

2"(2)

1"(2)

1 1/2"(2)

32"(2)

24"(2)

15"(2)

4 1/4"(1)

20.3"(1)

16.25"(1)

17"(1)

18"(1)

10 1/2"(1)

37.5"(1)

38"(1)

35"(1)

2 1/4"(1)

10.5"(1)

13.25"(1)

12 1/2"(1)

3.1"(1)

9.31"(1)

5.9"(1)

8 7/8"(1)

14.2"(1)

3.5" to 5"(1)

13 1/2"(1)

16"(1)

2 1/2"(1)

16 3/5"(1)

13"(1)

11.14"(1)

9.25"(1)

8"(1)

3/4"(1)

 
Color(s)

Black(72)

Clear(49)

Black/Silver(16)

Silver(15)

Steel(13)

Gray(8)

Black/Gray(7)

Gold(6)

Amber(4)

Silver/Black(3)

Royal Blue(2)

Brown(2)

Blue(2)

Rio Red(1)

Black/Woodgrain(1)

Polished Chrome(1)

Graphite(1)

Black/Silver/Orange(1)

Lipstick Red(1)

Gray/Putty(1)

Graphite Black(1)

Blue/Silver(1)

Black/Chrome(1)

Gray/Orange(1)

Red/Silver(1)

Assorted(1)

White/Black(1)

Dark Gray(1)

White(1)

Gray/Dark Blue(1)

Gray/Black(1)

Silver/Black/Orange(1)

 
Depth

21"(7)

14"(4)

5.75"(3)

19"(3)

18.5"(3)

26"(2)

2 1/2"(2)

2 3/4"(2)

18"(2)

1 1/2"(2)

12"(2)

4.13"(2)

11 1/2"(2)

16.25"(1)

14.5"(1)

9"(1)

19.3"(1)

17.5"(1)

15"(1)

23"(1)

17"(1)

4 1/2"(1)

10 1/4"(1)

2.5"(1)

16"(1)

15.25"(1)

3"(1)

2.2"(1)

4.8"(1)

4.81"(1)

22.8"(1)

2 1/8"(1)

8"(1)

2 1/4"(1)

12.6"(1)

1.5"(1)

3.7"(1)

1 1/4"(1)

3 1/2"(1)

9 1/2"(1)

18.1"(1)

6 3/4"(1)

6 1/2"(1)

5"(1)

 
Quantity

1 each(2)

 
Size

9" x 11.5"(13)

11 x 8 1/2(12)

11 1/4 x 8 3/4(7)

15/32" Head(5)

9" x 14.5"(3)

11.5" x 17.5"(3)

25" x 500 ft(3)

25" x 250 ft(3)

9" x 12"(3)

8.5" x 11"(2)

27" x 500 ft(2)

2.56" x 3.75"(2)

3.69" x 2.19"(1)

5"w x 5.75"d x 2.5"h(1)

5"w x 5.5"d x 1.75"h(1)

3.5"w x 5.25"d x 1.75"h(1)

9" x 100 ft(1)

3/8" Head(1)

4.13" x 2.94"(1)

5.5" x 3.5"(1)

12" x 200 ft(1)

12" x 300 ft(1)

12" x 100 ft(1)

5.25"w x 2.25"d x 7.88"h(1)

 
Closure

Zipper(1)

Magnetic(1)

 
Binder Sheet Size

11 x 8.5(20)

14.88 x 11(8)

9.5 x 11(5)

14.88 x 8.5(3)

12 x 8.5(2)

11.75 x 8.5(1)

11 x 14.88(1)

 
Binder Style

Non-View(40)

 
 
 

© 2020-2021 Gateway Business Products, All Rights Reserved