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)

File Jackets/Sleeves/Wallets(38)

Paper Towels(38)

Top Tab Colored Folders(38)

Report Covers(36)

Expanding Pockets(35)

Portfolios(30)

Hanging File Folders(27)

Green Hanging Folders(25)

Pressboard Classification Folders(24)

Cups & Mugs(22)

Index Cards(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)

Top Tab Manila Folders(16)

Top Tab Fastener Folders(15)

Expanding Files(15)

Binders(15)

Interior Folders(14)

Bathroom Tissues(13)

Recycling Bins(12)

Stamps(12)

Towels & Wipes(11)

Paper Pads/Note Pads(9)

Calendars(9)

File Guides(8)

Facial Tissues(8)

Literature Organizers/Sorters(8)

Hanging Classification Folders(7)

Pocket Folders(7)

End Tab Folders(7)

Poly Envelopes(7)

Copy & Multi-use Colored Paper(7)

Desk Pads(7)

Pocket Portfolios/Folders(7)

Appointment Books(6)

Mop Heads(6)

Waste Receptacles(5)

Document/Box Files(5)

Top Tab Pressboard Folders(5)

End Tab Fastener Folders(5)

Self-Stick Pads(5)

Office Paper(5)

Storage Boxes & Containers(5)

Hanging Pockets(5)

Envelopes/Mailers(4)

Shredder Bags(4)

Easel Binders(4)

Cup Lids(4)

Storage Drawers & Accessories(4)

Desktop File Folder Sorters(4)

End Tab Pockets(4)

Key Boxes & Cabinets(4)

Mailboxes(3)

Cutlery(3)

Toilet Tissues(3)

Media Storage Cases/Drawers/Wallets(3)

Index Card Files & Cabinets(3)

Clasp Envelopes(3)

Easel Pads(3)

Mailroom Sorters & Tables(3)

Food Containers(3)

Cups(3)

Telephone Message Books & Pads(3)

Partition & Panel Accessories(3)

Filler Papers(2)

Mobile Pedestals(2)

Reception, Side & Guest Chairs(2)

Magazine Files(2)

Pencil Boxes(2)

Clips/Clamps(2)

Scissors(2)

Steno Pads(2)

Cleaning Equipment Parts & Accessories(2)

Binding Systems Covers(2)

Color Jackets(2)

Sprayers(2)

Legal Binders(2)

Wallets(2)

Manila Jackets(2)

Drawer Organizers(1)

Cash Boxes & Drawers(1)

Pencil Cups(1)

Cups & Mugs Accessories(1)

Flat/Media Mailers(1)

Hanging File Folder Racks(1)

Calendar Bases(1)

Boards(1)

Adhesive Note Pads(1)

Nameplates(1)

Hangers/Hooks(1)

Janitorial Organizers(1)

Note Cards(1)

Desk Pad Refills(1)

Binder Pockets(1)

Mobile File Carts & Cabinets(1)

Pre-printed Index Dividers(1)

Sorters(1)

Index Card Guides(1)

Indexed Sorters(1)

Heavy-Duty Staplers(1)

Racks & Organizers(1)

Roll Files(1)

Business Envelopes(1)

Desktop Organizers(1)

Sheet Protectors(1)

Management/Mid-Back Chairs(1)

Poly Expanding Files(1)

Floor Organizers/Sorters(1)

Poly Jackets(1)

Utensils(1)

 
Brand

Pendaflex(326)

Universal(215)

Avery(89)

Oxford(83)

Eco-Products(37)

Cardinal(35)

Rubbermaid Commercial(32)

TOPS(28)

Smead(28)

Safco(25)

ACCO(18)

Seventh Generation(18)

House of Doolittle(17)

Sparco(16)

Ampad(15)

Lion(12)

Marcal(11)

Windsoft(11)

SKILCRAFT(10)

Roaring Spring(9)

Boardwalk(8)

Quality Park(8)

Snap-N-Store(6)

Marcal Pro(6)

Aurora(5)

Pacific Blue Basic(5)

Scott(4)

Bankers Box(4)

Pacific Blue Ultra(4)

Artistic(4)

Globe-Weis(4)

C-Line(3)

Blueline(3)

Acco(2)

Westcott(2)

Redi-Tag(2)

Find It(2)

Post-it®(2)

Pacific Blue Select(1)

Rubbermaid(1)

Adams(1)

Swingline GBC(1)

LEE(1)

Hammermill(1)

Avery®(1)

Sealed Air(1)

Samsill(1)

Buddy(1)

Mead(1)

Marcal PRO(1)

Rapesco(1)

Mayline(1)

MMF(1)

Ex-Cell Kaiser(1)

IdeaStream(1)

GBC(1)

Genuine Joe(1)

Compact(1)

AT-A-GLANCE(1)

 
Color

White(81)

Blue(79)

Black(64)

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)

Violet(8)

Natural(8)

Light Green(7)

Light Blue(7)

Teal(7)

Burgundy(6)

Dark Blue(6)

Bright Green(6)

Kraft(5)

Navy(4)

Cherry(3)

Aqua(3)

Canary(3)

Lavender(3)

Hunter Green(3)

Marble White(2)

Redrope(2)

Mahogany(2)

Transparent(2)

Navy Blue(2)

Purple(2)

Multicolor(2)

Indigo(2)

Gold(2)

Fluorescent Pink(1)

Fluorescent Orange(1)

Goldenrod(1)

Stainless Steel(1)

Fluorescent Green(1)

Fluorescent Yellow(1)

Lime(1)

Putty(1)

Wood Grain(1)

Black Powder Coat(1)

Strawberry(1)

Apple Green(1)

Lemon(1)

Ice(1)

Blueberry(1)

Gray/Green(1)

Brick Red(1)

Scarlet(1)

Platinum(1)

Medium Blue(1)

Silver(1)

Pebble Gray(1)

Dark Green(1)

Charcoal Gray(1)

Pastel(1)

Neon(1)

Tangerine(1)

Ivory(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(600)

No(35)

 
Sheet Size

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

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

8.5 x 11(14)

8 1/2" x 11"(14)

11" Width x 17" Length(10)

3" x 5"(10)

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

5" x 8"(4)

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)

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

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

11" Width x 12" Length(2)

27" x 34"(2)

8" x 5"(2)

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

4" x 8"(2)

6" x 9"(2)

11" x 9 1/2"(2)

20" x 28"(1)

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

7 1/2" x 10"(1)

8 1/2" x 14"(1)

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

11" x 8 1/2"(1)

7" x 5"(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.5 x 14(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