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 ((`desc_short` like 'recycled' OR `desc_long` like 'recycled' OR `desc_title` like 'recycled' OR `keywords` like 'recycled' OR `category_1` like 'recycled' OR `category_2` like 'recycled' OR `category_3` like 'recycled' OR `category_4` like 'recycled' OR `manufacturer_name` like 'recycled' OR `color` like 'recycled') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>recycled>recycleds)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"recycled"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%recycled%' OR `pinfo`.`sku` like '%recycled%' OR (FIND_IN_SET('recycled', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('recycled', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('recycled', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('recycled', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('recycled', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'recycled' ELSE `pinfo`.`desc_title` like 'recycled' END))) 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 '%recycled' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('recycled' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+recycled' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"recycled"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"recycled"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"recycled"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"recycled"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+recycled' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='recycled',`category_4` ='recycled') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'recycled,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('recycled', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Recycled

Refine Search

  GO
 
Category

File Folders(1740)

Armoires & Cabinets(556)

Binders(449)

Racks & Organizers(173)

Shipping & Storage Boxes/Tanks(173)

Art/Writing Pads & Sheets(171)

Stamps(110)

Index Dividers(86)

Calendars & Planners(80)

Tissues & Napkins(70)

Classification Folders(61)

Pens/Markers/Highlighters(51)

Forms & Record Keeping(48)

Mailers & Envelopes(47)

File Jackets/Sleeves/Wallets(47)

Printing Media(43)

Hanging File Folders(43)

Bags(38)

Clipboards(38)

Notes & Flags(35)

Art & Craft Kits(34)

Calendars(33)

Wastebaskets & Trash Cans(33)

Tab Indexes(32)

Towels & Wipes(28)

Cups & Mugs(27)

Mats(23)

Report Covers(19)

Office Paper(19)

Labels(18)

File Boxes(18)

Index Cards(16)

Cups(15)

Paper Pads/Note Pads(14)

Appointment Books(13)

Envelopes/Mailers(12)

Chairs & Seating(11)

Scissors(11)

Toilet Tissues(9)

Self-Stick Pads(9)

File Guides(8)

Staplers(8)

Erase Boards/Films(7)

Pencils(7)

Desk Pads(7)

Pins & Clamps(6)

Art Boards(6)

Waste Receptacles(6)

Magazine Files(6)

Pocket Folders(6)

Notice & Bulletin Boards(6)

Mop Heads(6)

Desktop File Folder Sorters(5)

Lids(5)

Appointment Book Refills(5)

Filing/Binding Accessories(5)

Napkins(4)

Facial Tissues(4)

Calculators(4)

Art Paper(4)

Shredder Bags(4)

Holders(4)

Cup Lids(4)

Wrist/Mouse Pads(4)

Frames(4)

Kitchenware(3)

Kitchen Utensils(3)

Adhesive Tapes(3)

Paper Cutters(3)

Cleaning Equipment Parts & Components(3)

Boards(3)

Resume/Stationery Paper(3)

Partition & Panel Accessories(3)

Food Containers(3)

Correction Tapes(2)

Packing Wraps & Insulations(2)

Duster & Mops Refills(2)

Pencil Cups(2)

Sprayers(2)

Clips/Clamps(2)

Clocks(2)

Binding Systems Covers(2)

Sign & Name Plates(2)

Cleaning Kits(2)

Mouse Pads & Wrist Rests(2)

Hooks & Hangers(2)

Carts & Trolleys(1)

Calendar Refills(1)

Hangers/Hooks(1)

Nameplates(1)

Notes & Flags Dispensers(1)

Calendar Bases(1)

Hanging File Folder Racks(1)

Drawer Organizers(1)

Desk Pad Refills(1)

Letter Openers(1)

Rulers & Tape Measures(1)

Paper Racks(1)

Tape Dispensers(1)

Chair Mats(1)

Paper Towels(1)

Toilet Seat Covers(1)

Erasers(1)

Pens(1)

Broom Heads(1)

Indexed Sorters(1)

Sheet Protectors(1)

Name Badge Kits(1)

Floor Mats(1)

Cash Boxes & Drawers(1)

Desktop Supplies Organizers(1)

Utensils(1)

Household Cleaners(1)

Label Peelers(1)

Lanyards(1)

 
Brand

Smead(867)

Pendaflex(492)

Lorell(290)

HON(231)

SKILCRAFT(226)

Avery®(220)

Universal(215)

Business Source(173)

Bankers Box(99)

Nature Saver(96)

Xstamper(90)

Oxford(88)

Avery(76)

Samsill(72)

Acco(71)

House of Doolittle(67)

Cardinal(67)

Tennsco(63)

At-A-Glance(54)

Rediform(44)

MMF(42)

TOPS(40)

Eco-Products(37)

Safco(35)

Seventh Generation(34)

Rubbermaid Commercial(34)

Post-it®(31)

Pilot(27)

Storex(26)

Fellowes(25)

Deflecto(23)

Jiffy Mailer(23)

QuickFit(22)

Aurora(22)

Pacon(22)

OIC(20)

Steelmaster(20)

Marcal(19)

Sparco(18)

Roaring Spring(17)

Ampad(16)

Geographics(16)

Blueline(15)

Saunders(15)

Riverside(14)

AT-A-GLANCE(14)

Dome(14)

Marcal PRO(13)

MasterVision(13)

Boise(12)

Genuine Joe(12)

Lion(12)

Windsoft(11)

ACCO(11)

Classroom Keepers(10)

Mead(10)

Dart(10)

Hammermill(10)

Iceberg(10)

Westcott(9)

Boardwalk(9)

Wilson Jones(9)

Quality Park(9)

Stout(9)

Scott(8)

Trodat(8)

UCreate(8)

Globe-Weis(8)

Sealed Air(7)

Webster(7)

Alliance Rubber(7)

Marcal Pro(6)

Rubbermaid(6)

Snap-N-Store(6)

Paper Mate(6)

Mobile OPS(6)

Crown Mats(6)

Bostitch(6)

Ekonomik(6)

Ecology(6)

Pacific Blue Basic(5)

SunWorks(5)

GBC(4)

Pentel(4)

Redi-Tag(4)

Highland(4)

Pacific Blue Ultra(4)

Artistic(4)

SJ Paper(3)

C-Line(3)

Victor(3)

CARL(3)

Solo(3)

Royal Brites(3)

Eco Brites(3)

SOLO Cup Company(3)

Chinet(3)

Strathmore(3)

Scotch(3)

Blue Sky(2)

DAX(2)

Adams(2)

3M(2)

Dax(2)

AccuWipe(2)

DAC(2)

Advantus(2)

Xerox(2)

AT-A-GLANCE Day Runner(2)

Find It(2)

Mohawk(2)

Domtar(2)

Guardian Floor Protection(2)

Buddy(2)

Stout by Envision(2)

Southworth(2)

ecolutions(2)

Officemate(2)

xerox(1)

Sharp Calculators(1)

Swingline GBC(1)

Earthsense Commercial(1)

Tombow(1)

Headline Sign(1)

Navigator(1)

MACO(1)

Rapid(1)

Pacific Blue Select(1)

Acme United(1)

Baumgartens(1)

BIC(1)

Day-Timer(1)

Duck Brand(1)

Ex-Cell Kaiser(1)

R-Kive(1)

Ecotex(1)

Fiskars(1)

St. James®(1)

Compact(1)

Georgia Pacific Professional(1)

Rapesco(1)

HP(1)

HOSPECO(1)

IdeaStream(1)

Kleer-Fax(1)

Guardian(1)

Mayline(1)

Post-it Greener Notes(1)

Monarch(1)

Esselte(1)

National(1)

Brownline(1)

Zebra Pen(1)

 
Color

Black(555)

White(408)

Blue(362)

Manila(281)

Green(258)

Red(247)

Yellow(159)

Gray(132)

Putty(124)

Light Gray(110)

Redrope(96)

Brown(74)

Kraft(73)

Charcoal(67)

Standard Green(61)

Assorted(53)

Dark Blue(53)

Clear(50)

Orange(48)

Light Blue(41)

Purple(38)

Light Green(30)

Pink(28)

Bright Red(26)

Navy(25)

Silver(25)

Red Fiber(24)

Sand(24)

Natural(19)

Mahogany(18)

Satin Gold(16)

Medium Gray(16)

Lavender(16)

Multi(15)

Gray/Green(14)

Maroon(14)

Platinum(14)

Teal(14)

Moss(14)

Natural Kraft(13)

Dark Green(13)

Burgundy(11)

Aqua(11)

Navy Blue(11)

Canary Yellow(11)

Brushed Chrome - Handle(10)

Sky Blue(10)

Earth Red(9)

Bright Green(9)

Medium Tone(9)

Violet(8)

Cloud(7)

Chrome - Handle(7)

Gold(7)

Pacific Blue(6)

Parchment(6)

Chartreuse(6)

Executive Red(6)

Goldenrod(6)

Multicolor(6)

Wood Grain(5)

Harvest(5)

Dark Graphite(5)

Charcoal Gray(5)

Turquoise(4)

Brown Kraft(4)

Dark Brown(4)

Hunter Green(4)

Royal Blue(4)

Bright White(4)

Dark Gray(4)

Holiday Red(3)

Dark Red(3)

Blue/Gray(3)

Lime(3)

Evergreen(2)

Graphite(2)

Leaf Green(2)

Hot Pink(2)

Mist Gray(2)

Holiday Green(2)

Lilac(2)

Tropic Sand(2)

Steel Gray(2)

Cherry(2)

Neon(2)

Pastel(2)

Pearl(2)

Camel(2)

Coral(2)

Transparent(2)

Lake Blue(2)

Brite Blue(2)

Marble White(1)

Green Tea(1)

Pastel Blue(1)

Pastel Pink(1)

Pastel Yellow(1)

Pastel Green(1)

Neon Green(1)

Neon Yellow(1)

Black Powder Coat(1)

Natural Brown(1)

Stainless Steel(1)

Ice Blue(1)

Dark Pink(1)

Assorted Bright(1)

Blue Frost(1)

Aluminum(1)

Bright Purple(1)

Ivory(1)

Bright Pink(1)

Blue Moon(1)

Bright Blue(1)

Neon Pink(1)

Pebble Gray(1)

Black Marble(1)

Tinted(1)

Mocha(1)

Natural Maple(1)

Cordova(1)

Metallic Blue(1)

Metallic Gray(1)

Frost(1)

Dark Graphite Hook(1)

Granite(1)

Smoke(1)

Clear Frame(1)

Medium Blue(1)

Semi Clear(1)

Frosted Clear(1)

Buff(1)

Rose(1)

Stone(1)

Aqua Wave(1)

Fluorescent Yellow(1)

Brick Red(1)

Fluorescent Green(1)

Fluorescent Orange(1)

Fluorescent Pink(1)

Strawberry(1)

Lemon(1)

Ice(1)

Blueberry(1)

Apple Green(1)

Neptune Blue(1)

Scarlet(1)

Brite Green(1)

Assorted Drawer(1)

Tangerine(1)

Camouflage(1)

Tan(1)

Orchid(1)

Indigo(1)

 
Brightness

92(23)

94(2)

84(2)

95(1)

 
Size

Letter(26)

Legal(19)

11 x 8 1/2(7)

22 x 17(7)

12 x 12(6)

18 1/2 x 13(5)

12 x 16 1/2(4)

8 1/2 x 4 1/2(3)

6" Length(3)

6 1/4 x 3 1/4(3)

24 x 37(2)

15 x 12(1)

9 x 7(1)

14 7/8 x 12(1)

18 x 24(1)

Small Format(1)

20 x 26(1)

11.25 x 8.75(1)

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

22 x 18(1)

8 x 4 7/8(1)

8 1/2 x 5 1/2(1)

12 x 17(1)

10 7/8 x 8 1/2(1)

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

7 x 8 3/4(1)

10 7/8 x 8 1/4(1)

6 1/8 x 3 1/2(1)

11 x 8 7/8(1)

3 1/2 x 6 1/2(1)

 
Binder Capacity

1"(97)

2"(76)

3"(69)

1 1/2"(54)

5"(40)

4"(39)

6"(33)

1/2"(20)

5/8"(3)

3/4"(1)

 
Size

Letter(1589)

Legal(459)

Tabloid(17)

A4(16)

Ledger(8)

Fanfold(7)

Jr.Legal(6)

German Standard Fanfold(1)

A4+(1)

Ledger/Tabloid(1)

Statement(1)

 
Recycled

Yes(3786)

No(128)

 
Sheet Size

8 1/2" Width x 11" Length(1512)

8 1/2" Width x 14" Length(440)

8 1/2" x 11"(64)

11" Width x 17" Length(27)

8 1/2 x 11(14)

5" x 8"(12)

8 1/2" x 11 3/4"(11)

8 17/64" Width x 11 11/16" Length(10)

6" x 9"(9)

8 1/2" x 14"(9)

3" x 5"(7)

8" Width x 10" Length(7)

9" x 12"(7)

11" Width x 14 7/8" Length(7)

6" x 9 1/2"(6)

11 x 8 1/2(6)

9 1/2" Width x 11" Length(6)

7 1/4" Width x 12 1/4" Length(5)

9 1/4" x 7 1/4"(5)

8 1/2" Width x 10 63/64" Length(5)

8 19/64" Width x 11 45/64" Length(5)

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

9 1/2" Width x 14 5/8" Length(5)

7 1/2" x 9 3/4"(4)

27" x 34"(4)

24" x 32"(4)

25" x 30"(4)

7 1/4" x 9 1/4"(4)

8 1/2" Width x 12" Length(4)

10" Width x 8" Length(3)

6" Width x 9" Length(3)

11" Width x 8 1/2" Length(3)

12" x 18"(3)

11" x 17"(3)

14 3/4" Width x 8 3/4" Length(3)

10" Width x 8 3/4" Length(3)

9" Width x 12" Length(3)

9 1/2" Width x 11 3/4" Length(3)

4" x 8"(2)

7 7/8" x 10 1/8"(2)

4" x 6"(2)

8 1/2" Width x 14 7/8" Length(2)

8 3/8" Width x 10 3/8" Length(2)

18" x 16 1/2"(2)

11" x 8 1/2"(2)

11" Width x 12" Length(2)

7" x 8 1/2"(2)

24" x 16"(2)

10 1/4" Width x 8 1/2" Length(2)

9 1/2" x 6"(2)

3 1/4" Width x 6 1/4" Length(2)

8 3/4" Width x 14 1/4" Length(2)

20" x 23"(2)

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

11" x 9 1/2"(2)

6 1/4" Width x 9 5/8" Length(1)

11 1/4" Width x 14 1/4" Length(1)

9 7/8" Width x 8 1/2" Length(1)

8 1/2" Width x 9 1/8" Length(1)

7 1/8" x 10 1/8"(1)

5 1/4" Width x 11" Length(1)

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

11 1/2" Width x 6" Length(1)

5 1/2" Width x 11" Length(1)

20" x 28"(1)

7 1/2" x 10"(1)

14 3/8" Width x 9" Length(1)

11 3/4" Width x 9 1/2" Length(1)

12 3/8" Width x 10" Length(1)

5" Width x 9 3/4" Length(1)

14 1/2" Width x 18 1/4" Length(1)

4 1/4" Width x 6 3/8" Length(1)

12" Width(1)

3" Width x 5" Length(1)

9" x 11"(1)

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

5 1/2" x 7"(1)

4" x 6 3/4"(1)

7 7/8" Width x 5 1/2" Length(1)

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

8 1/2 x 14(1)

9 1/4" x 11 3/4"(1)

11" Width x 14" Length(1)

9 3/4" Width x 11" Length(1)

10 1/2" Width x 8 1/4" Length(1)

10 1/2" Width x 7 1/2" Length(1)

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

6 1/2" Width x 10" Length(1)

2 1/4" x 55 ft(1)

8 1/10" Width x 10 4/5" Length(1)

5 3/4" x 8 1/2"(1)

7 1/4" x 9 1/2"(1)

8" x 10"(1)

16 1/2" x 18"(1)

11" Width x 17 3/4" Length(1)

8 1/2" Width x 11 3/4" Length(1)

8 1/2 x 8 1/2(1)

14 x 8 1/2(1)

5 1/2 x 8 1/2(1)

7" x 9"(1)

8 1/4" x 5 7/8"(1)

7 1/2" x 9 1/4"(1)

18" x 2400"(1)

8 1/2" Width x 10 7/8" Length(1)

15" Width x 10" Length(1)

10" Width x 15 3/8" Length(1)

10" Width x 15" Length(1)

14" Width x 18" Length(1)

22" x 16"(1)

9" x 6"(1)

18" x 12"(1)

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

18" x 24"(1)

11 x 17(1)

8" x 10 1/2"(1)

5" x 7 1/2"(1)

3 1/4" x 5 1/2"(1)

2 1/4" x 165 ft(1)

8 1/2" Width(1)

8" x 5"(1)

 
 
 

© 2020-2021 Dawkins Office Supplies and Equipment Co., All Rights Reserved