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

Index Dividers(99)

File Folders(76)

Classification Folders(54)

Color Hanging Folders(42)

Top Tab Colored Folders(38)

File Jackets/Sleeves/Wallets(38)

Paper Towels(36)

Report Covers(36)

Expanding Pockets(35)

Portfolios(30)

Hanging File Folders(27)

Green Hanging Folders(25)

Pressboard Classification Folders(24)

Index Cards(22)

Cups & Mugs(22)

Hanging Box Bottom Folders(21)

Standard Ring Binders(21)

File Boxes(19)

Memo / Subject Notebooks(18)

Letter, Legal & Jr. Pads(17)

Waste Containers & Accessories(17)

Presentation / View Binders(16)

Binders(16)

Top Tab Manila Folders(16)

Top Tab Fastener Folders(15)

Expanding Files(15)

Interior Folders(14)

Bathroom Tissues(13)

Recycling Bins(12)

Stamps(12)

Towels & Wipes(11)

Paper Pads/Note Pads(10)

Calendars(9)

Literature Organizers/Sorters(8)

Facial Tissues(8)

File Guides(8)

Hanging Classification Folders(7)

Pocket Folders(7)

Pocket Portfolios/Folders(7)

Poly Envelopes(7)

End Tab Folders(7)

Desk Pads(7)

Copy & Multi-use Colored Paper(7)

Appointment Books(6)

Self-Stick Pads(6)

Mop Heads(6)

Office Paper(6)

Waste Receptacles(5)

Hanging Pockets(5)

Top Tab Pressboard Folders(5)

End Tab Fastener Folders(5)

Envelopes/Mailers(4)

Key Boxes & Cabinets(4)

Desktop File Folder Sorters(4)

Shredder Bags(4)

End Tab Pockets(4)

Document/Box Files(4)

Storage Drawers & Accessories(4)

Storage Boxes & Containers(4)

Cup Lids(4)

Easel Binders(4)

Cups(3)

Toilet Tissues(3)

Partition & Panel Accessories(3)

Easel Pads(3)

Media Storage Cases/Drawers/Wallets(3)

Telephone Message Books & Pads(3)

Mailboxes(3)

Clasp Envelopes(3)

Mailroom Sorters & Tables(3)

Index Card Files & Cabinets(3)

Cutlery(3)

Mobile Pedestals(2)

Steno Pads(2)

Cleaning Equipment Parts & Accessories(2)

Manila Jackets(2)

Binding Systems Covers(2)

Wallets(2)

Clips/Clamps(2)

Magazine Files(2)

Legal Binders(2)

Reception, Side & Guest Chairs(2)

Color Jackets(2)

Scissors(2)

Spray Bottles(2)

Filler Papers(2)

Pencil Boxes(2)

Pencil Cups(1)

Poly Expanding Files(1)

Drawer Organizers(1)

Hanging File Folder Racks(1)

Note Cards(1)

Food Containers(1)

Boards(1)

Nameplates(1)

Hangers/Hooks(1)

Desk Pad Refills(1)

Calendar Bases(1)

Management/Mid-Back Chairs(1)

Cups & Mugs Accessories(1)

Pre-printed Index Dividers(1)

Sheet Protectors(1)

Cash Boxes & Drawers(1)

Indexed Sorters(1)

Janitorial Organizers(1)

Business Envelopes(1)

Binder Pockets(1)

Flat/Media Mailers(1)

Poly Jackets(1)

Index Card Guides(1)

Racks & Organizers(1)

Mobile File Carts & Cabinets(1)

Roll Files(1)

Desktop Organizers(1)

Sorters(1)

Utensils(1)

Floor Organizers/Sorters(1)

Heavy-Duty Staplers(1)

 
Brand

Pendaflex(298)

Universal®(215)

Avery®(89)

Oxford(61)

Cardinal(35)

Pendaflex®(28)

Smead®(28)

Rubbermaid Commercial(28)

TOPS(27)

Eco-Products(26)

Safco(24)

Oxford™(20)

ACCO(18)

House of Doolittle™(17)

Seventh Generation(17)

Sparco(16)

Ampad(12)

Lion(12)

Windsoft®(11)

SKILCRAFT(9)

Eco-Products®(9)

Marcal(9)

Roaring Spring(8)

Boardwalk®(8)

Snap-N-Store(6)

Marcal Pro(6)

Quality Park(5)

Pacific Blue Basic(5)

Aurora(5)

Bankers Box®(4)

Rubbermaid® Commercial(4)

Pacific Blue Ultra(4)

Scott(4)

Artistic®(4)

Ampad®(3)

Quality Park™(3)

Blueline®(3)

C-Line®(2)

Acco(2)

Marcal®(2)

Globe-Weis®(2)

Roaring Spring®(2)

Redi-Tag®(2)

Samsill®(2)

Globe-Weis(2)

Find It(2)

TOPS™(1)

Safco®(1)

Sealed Air(1)

Rapesco(1)

Swingline® GBC®(1)

Rubbermaid(1)

AT-A-GLANCE®(1)

Marcal PRO™(1)

Genuine Joe(1)

Westcott(1)

Westcott®(1)

Avery®(1)

Buddy(1)

Boise®(1)

C-Line(1)

Ex-Cell Kaiser(1)

GBC®(1)

Compact(1)

Post-it®(1)

Pacific Blue Select(1)

Hammermill®(1)

IdeaStream(1)

LEE(1)

Adams(1)

Mayline(1)

MMF(1)

Post-it® Greener Notes(1)

Mead®(1)

 
Color

White(79)

Blue(79)

Black(62)

Green(42)

Red(40)

Manila(34)

Brown(30)

Standard Green(26)

Yellow(25)

Gray(23)

Red Fiber(21)

Orange(21)

Assorted(18)

Clear(15)

Multi(14)

Pink(9)

Natural(8)

Violet(8)

Light Green(7)

Teal(7)

Light Blue(7)

Dark Blue(6)

Bright Green(6)

Burgundy(6)

Kraft(5)

Navy(4)

Lavender(3)

Hunter Green(3)

Cherry(3)

Aqua(3)

Canary(3)

Redrope(2)

Gold(2)

Transparent(2)

Purple(2)

Multicolor(2)

Mahogany(2)

Navy Blue(2)

Fluorescent Yellow(1)

Fluorescent Green(1)

Tangerine(1)

Black Powder Coat(1)

Putty(1)

Wood Grain(1)

Fluorescent Pink(1)

Stainless Steel(1)

Goldenrod(1)

Ivory(1)

Marble White(1)

Fluorescent Orange(1)

Brick Red(1)

Strawberry(1)

Lime(1)

Lemon(1)

Ice(1)

Blueberry(1)

Gray/Green(1)

Apple Green(1)

Scarlet(1)

Platinum(1)

Medium Blue(1)

Silver(1)

Pebble Gray(1)

Dark Green(1)

Charcoal Gray(1)

Neon(1)

Indigo(1)

 
Size

Letter(21)

Legal(13)

6" Length(3)

22 x 17(3)

11 x 8.5(3)

11 x 8 1/2(2)

Small Format(2)

20 x 26(1)

X-Ray(1)

24 x 37(1)

12 x 12(1)

15.5 x 22(1)

8 x 5(1)

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

18.5 x 13(1)

22 x 18(1)

11.25 x 8.75(1)

3.5 x 6.5(1)

 
Binder Capacity

1"(8)

3"(8)

2"(7)

5"(6)

1 1/2"(5)

6"(3)

4"(3)

3/4"(1)

 
Size

Letter(317)

Legal(77)

Tabloid(8)

A4(4)

Jr.Legal(3)

 
Recycled

Yes(595)

No(35)

 
Sheet Size

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

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

8 1/2" x 11"(15)

8.5 x 11(14)

11" Width x 17" Length(10)

3" x 5"(10)

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

5" x 8"(5)

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

11 x 8.5(4)

11 x 8 1/2(3)

4" x 6"(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)

11" x 9 1/2"(2)

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

6" x 9"(2)

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

8" x 5"(1)

20" x 28"(1)

7 1/2" x 10"(1)

8 1/2" x 14"(1)

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

8.5 x 14(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)

11 x 17(1)

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

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

14 x 8 1/2(1)

8 1/2 x 11(1)

25" x 30"(1)

 
 
 

© 2020-2021 Houdal Corporation, All Rights Reserved