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

Manufacturer

Currently Filtered by

Manufacturer

Safco

Refine Search

  GO
Category

Literature Organizers/Sorters(39)

Waste Containers & Accessories(30)

Printer/Fax Stands(27)

Stools & Drafting Chairs(26)

Adjustable Worksurfaces(25)

Desktop Organizers(20)

Training Room Tables(19)

Big & Tall Chairs(17)

Workstations/Computer Desks(16)

Mobile File Carts & Cabinets(16)

Utility/Service Carts(16)

Wall Sorters/Racks(15)

Folding/Stacking Chairs & Carts(14)

Smoking Receptacles(14)

Coat/Garment Hooks(14)

Floor Organizers/Sorters(13)

Wire Shelving(13)

Active Seating(12)

Recycling Bins(11)

Hand Trucks & Dollies(10)

Lockers(10)

Coat/Garment Racks(9)

Task Chairs(9)

Lamps(8)

Industrial & Commercial Shelving(8)

Compact & Student Desks(7)

Roll Files(7)

Lecterns(7)

Wall Files, Pockets & Accessories(7)

Reception, Side & Guest Chairs(6)

Flat/Plan Files(6)

Desktop File Sorters(6)

Panels/Partitions(6)

Suggestion Boxes & Cards(6)

Tabletop Sorters/Racks(5)

Art & Drafting Tables(5)

Arm Sets(5)

Foot Rests(5)

Wood Veneer Bookcases(5)

Reception Area & Accent Tables(4)

Mailroom Sorters & Tables(4)

Letter Trays(4)

Utility & Breakroom Tables(4)

Laminate Bookcases(4)

Executive/High Back Chairs(4)

Backrests & Seat Cushions(3)

Cubicle / Partition Organizers & Accessories(3)

Hooks & Hangers(3)

Drawer Organizers(3)

Signs & Sign Holders(3)

Dry-Erase Boards(3)

Traditional - Laminate(2)

Mobile Racks(2)

Mail Carts(2)

Monitor Stands/Risers(2)

Contemporary - Laminate(2)

TV/VCR Stands & Mounts(2)

Catalog Racks(2)

Multimedia Carts(1)

Mouse & Keyboard Wrist Rests(1)

Business Card Holders(1)

Desk Center Drawers(1)

Projector Stands & Carts(1)

Legs(1)

Portable Storage Files & Bins(1)

Telephone Stands & Holders(1)

Laptop Stands & Pads(1)

Storage Boxes & Containers(1)

Pencil Holders(1)

Strength/Sports Training Equipment(1)

Anti-Fatigue Mats(1)

Extension Cords(1)

Power Strips(1)

Mobile Pedestals(1)

Wall Racks(1)

Casters(1)

Brand

Safco(562)

Focal(4)

Onyx it!(2)

Color

Black(217)

Gray(47)

Silver(30)

Cherry(16)

Mahogany(14)

Clear(14)

White(14)

Tan(12)

Tropic Sand(11)

Medium Oak(9)

Stainless Steel(5)

Dark Gray(5)

Blue(4)

Black Base(4)

Putty(4)

Pewter(3)

Charcoal(3)

Mahogany Base(3)

Black Speckle(3)

Sand(3)

Chrome Hook(2)

Red(2)

Hook(2)

Silver Frame(2)

Wood Grain(2)

Champagne(1)

Matte Black(1)

Chrome(1)

Black Vinyl(1)

Oak(1)

Light Gray(1)

Aluminum(1)

Light Oak(1)

Baltic(1)

Pocket(1)

Wine(1)

Cream(1)

Black Powder Coat(1)

Grass(1)

Size

36" Width(4)

Recycled

No(328)

Yes(34)

Price Range

$0-$499.99(512)

$500-$999.99(49)

$1000-$1499.99(5)

$1500-$1999.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2017-2018 Granite Office, LLC, All Rights Reserved