Total:$0.00

QUICK VIEW 0
 

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

Currently Filtered by

Keyword

Recycled Products

Refine Search

  GO
 
Category

File Folders(435)

Index Dividers(84)

Binders(57)

Tissues & Napkins(56)

Classification Folders(54)

Art/Writing Pads & Sheets(44)

File Jackets/Sleeves/Wallets(30)

Hanging File Folders(27)

Shipping & Storage Boxes/Tanks(25)

Wastebaskets & Trash Cans(24)

Cups & Mugs(22)

Tab Indexes(20)

Report Covers(19)

File Boxes(18)

Racks & Organizers(15)

Index Cards(15)

Towels & Wipes(11)

Paper Pads/Note Pads(10)

Calendars(8)

Desk Pads(7)

Mop Heads(6)

Office Paper(6)

Armoires & Cabinets(6)

Envelopes/Mailers(6)

File Guides(6)

Waste Receptacles(5)

Lids(5)

Pocket Folders(5)

Self-Stick Pads(5)

Calendars & Planners(5)

Cup Lids(4)

Desktop File Folder Sorters(4)

Appointment Books(4)

Shredder Bags(4)

Mailers & Envelopes(4)

Cleaning Equipment Parts & Components(3)

Kitchen Utensils(3)

Partition & Panel Accessories(3)

Chairs & Seating(3)

Toilet Tissues(3)

Cups(3)

Clips/Clamps(2)

Binding Systems Covers(2)

Sprayers(2)

Facial Tissues(2)

Notes & Flags(2)

Forms & Record Keeping(2)

Scissors(2)

Magazine Files(2)

Nameplates(1)

Hanging File Folder Racks(1)

Hangers/Hooks(1)

Boards(1)

Calendar Bases(1)

Desk Pad Refills(1)

Drawer Organizers(1)

Pencil Cups(1)

Utensils(1)

Carts & Trolleys(1)

Staplers(1)

Food Containers(1)

Sheet Protectors(1)

Indexed Sorters(1)

Cash Boxes & Drawers(1)

Paper Racks(1)

 
Brand

Pendaflex(327)

Universal(203)

Avery(76)

Oxford(73)

Cardinal(35)

Eco-Products(35)

Rubbermaid Commercial(32)

Smead(29)

TOPS(28)

Safco(25)

House of Doolittle(19)

Seventh Generation(17)

Avery®(16)

Ampad(15)

Lion(11)

Marcal(11)

Windsoft(11)

ACCO(11)

Acco(10)

Quality Park(9)

Roaring Spring(9)

Sparco(9)

SKILCRAFT(9)

Boardwalk(8)

Marcal Pro(6)

Snap-N-Store(6)

Scott(5)

Pacific Blue Basic(5)

Aurora(5)

Bankers Box(4)

Globe-Weis(4)

Artistic(4)

Pacific Blue Ultra(4)

C-Line(3)

Westcott(2)

Samsill(2)

Redi-Tag(2)

Blueline(2)

Find It(2)

Marcal PRO(1)

Rubbermaid(1)

IdeaStream(1)

Swingline GBC(1)

Adams(1)

Mead(1)

Buddy(1)

Sealed Air(1)

Mayline(1)

Boise(1)

MMF(1)

Compact(1)

Rapesco(1)

Post-it Greener Notes(1)

Rediform(1)

Post-it®(1)

Ex-Cell Kaiser(1)

Hammermill(1)

GBC(1)

Genuine Joe(1)

Pacific Blue Select(1)

AT-A-GLANCE(1)

 
Color

Blue(79)

White(77)

Black(63)

Red(42)

Green(42)

Manila(35)

Brown(29)

Standard Green(26)

Yellow(24)

Gray(23)

Red Fiber(21)

Orange(20)

Assorted(19)

Clear(15)

Multi(14)

Light Blue(9)

Kraft(8)

Natural(8)

Dark Blue(7)

Pink(7)

Light Green(7)

Teal(7)

Bright Green(6)

Violet(6)

Burgundy(6)

Redrope(6)

Navy(4)

Hunter Green(3)

Aqua(3)

Lavender(3)

Dark Green(2)

Gold(2)

Mahogany(2)

Multicolor(2)

Transparent(2)

Purple(2)

Navy Blue(2)

Pastel Pink(1)

Marble White(1)

Pastel Green(1)

Pastel Yellow(1)

Wood Grain(1)

Pastel Blue(1)

Fluorescent Green(1)

Putty(1)

Stainless Steel(1)

Cherry(1)

Black Powder Coat(1)

Fluorescent Yellow(1)

Platinum(1)

Fluorescent Orange(1)

Scarlet(1)

Medium Blue(1)

Dark Gray(1)

Pebble Gray(1)

Charcoal Gray(1)

Neon(1)

Tangerine(1)

Apple Green(1)

Fluorescent Pink(1)

Brick Red(1)

Gray/Green(1)

Blueberry(1)

Ice(1)

Lemon(1)

Lime(1)

Strawberry(1)

Indigo(1)

 
Size

Letter(18)

Legal(10)

11 x 8 1/2(4)

6" Length(3)

22 x 17(3)

12 x 12(1)

11.25 x 8.75(1)

22 x 18(1)

18 1/2 x 13(1)

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

20 x 26(1)

24 x 37(1)

Small Format(1)

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

 
Binder Capacity

6"(9)

1"(8)

3"(8)

2"(7)

5"(6)

1 1/2"(4)

4"(3)

3/4"(1)

 
Size

Letter(333)

Legal(81)

Tabloid(7)

A4(5)

Fanfold(3)

Jr.Legal(2)

German Standard Fanfold(1)

 
Recycled

Yes(626)

No(30)

 
Sheet Size

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

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

8 1/2 x 11(14)

11" Width x 17" Length(9)

8 1/2" x 11"(8)

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

3" x 5"(6)

11 x 8 1/2(5)

5" x 8"(4)

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

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

6" x 9 1/2"(3)

11" Width x 12" Length(2)

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

27" x 34"(2)

4" x 8"(2)

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

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

6" x 9"(2)

11" x 9 1/2"(2)

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

8" x 5"(1)

20" x 28"(1)

8 1/2" x 14"(1)

4" x 6"(1)

7 1/2" x 10"(1)

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

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

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

5 1/2" x 7"(1)

15" Width x 10" Length(1)

10" Width x 15" Length(1)

14" Width x 18" Length(1)

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

8 1/2 x 14(1)

11 x 17(1)

8 1/2" Width x 12" 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)

25" x 30"(1)

 
 
 

© 2020-2021 Houdal Corporation, All Rights Reserved