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

Waste Containers & Accessories(35)

Literature Organizers/Sorters(34)

Training Room Tables(31)

Stools & Drafting Chairs(27)

Adjustable Worksurfaces(24)

Printer/Fax Stands(23)

Desktop Organizers(19)

Mobile File Carts & Cabinets(16)

Active Seating(16)

Coat/Garment Hooks(16)

Big & Tall Chairs(15)

Utility/Service Carts(15)

Folding/Stacking Chairs & Carts(14)

Wall Sorters/Racks(13)

Desktop File Sorters(11)

Workstations/Computer Desks(11)

Hand Trucks & Dollies(10)

Task Chairs(10)

Reception, Side & Guest Chairs(10)

Floor Organizers/Sorters(9)

Smoking Receptacles(9)

Lamps(8)

Wall Files, Pockets & Accessories(7)

Lecterns(7)

Compact & Student Desks(7)

Roll Files(7)

Industrial & Commercial Shelving(7)

Coat/Garment Racks(7)

Flat/Plan Files(6)

Lockers(6)

Panels/Partitions(6)

Suggestion Boxes & Cards(6)

Wire Shelving(6)

Art & Drafting Tables(5)

Foot Rests(5)

Arm Sets(5)

Laminate Bookcases(5)

Mailroom Sorters & Tables(5)

Letter Trays(4)

Hooks & Hangers(4)

Recycling Bins(4)

Utility & Breakroom Tables(4)

Tabletop Sorters/Racks(3)

Executive/High Back Chairs(3)

Backrests & Seat Cushions(3)

Signs & Sign Holders(3)

Dry-Erase Boards(3)

Cubicle / Partition Organizers & Accessories(3)

Drawer Organizers(3)

Contemporary - Laminate(2)

Mail Carts(2)

Mobile Racks(2)

Traditional - Laminate(2)

Projector Stands & Carts(2)

Mouse & Keyboard Wrist Rests(1)

Portable Storage Files & Bins(1)

Telephone Stands & Holders(1)

Casters(1)

Laptop Stands & Pads(1)

Monitor Stands/Risers(1)

Business Card Holders(1)

Desk Center Drawers(1)

TV/VCR Stands & Mounts(1)

Mailboxes(1)

Pencil Holders(1)

Anti-Fatigue Mats(1)

Extension Cords(1)

Power Strips(1)

Legs(1)

Wood Veneer Bookcases(1)

Strength/Sports Training Equipment(1)

Wall Racks(1)

Reception Area & Accent Tables(1)

Interoffice Mailboxes(1)

Storage Boxes & Containers(1)

Key Boxes & Cabinets(1)

Mobile Pedestals(1)

Brand

Safco(560)

Focal(6)

Onyx it!(3)

Color

Black(214)

Gray(41)

Silver(32)

White(23)

Clear(14)

Cherry(10)

Mahogany(10)

Tan(9)

Medium Oak(9)

Tropic Sand(7)

Blue(6)

Stainless Steel(5)

Charcoal(5)

Black Base(4)

Dark Gray(4)

Mahogany Base(3)

Pewter(3)

Putty(3)

Sand(3)

Black Powder Coat(2)

Red(2)

Black Speckle(2)

Chrome Hook(2)

Charcoal Gray(2)

Wood Grain(2)

Hook(2)

Oak(1)

Chrome(1)

Champagne(1)

Wine(1)

Matte Black(1)

Walnut(1)

Baltic(1)

Aluminum(1)

Cream(1)

Silver Frame(1)

Grass(1)

Black Vinyl(1)

Light Gray(1)

Natural(1)

Recycled

No(375)

Yes(26)

Price Range

$0-$499.99(502)

$500-$999.99(61)

$1000-$1499.99(4)

$1500-$1999.99(2)

$2000-$2499.99(1)

To  GO

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

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