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(35)

Waste Containers & Accessories(32)

Stools & Drafting Chairs(26)

Adjustable Worksurfaces(25)

Printer/Fax Stands(23)

Desktop Organizers(21)

Training Room Tables(19)

Coat/Garment Hooks(16)

Utility/Service Carts(16)

Big & Tall Chairs(15)

Mobile File Carts & Cabinets(15)

Folding/Stacking Chairs & Carts(14)

Wall Sorters/Racks(13)

Active Seating(12)

Workstations/Computer Desks(11)

Reception, Side & Guest Chairs(10)

Smoking Receptacles(10)

Hand Trucks & Dollies(10)

Desktop File Sorters(9)

Floor Organizers/Sorters(9)

Lamps(8)

Industrial & Commercial Shelving(7)

Roll Files(7)

Wall Files, Pockets & Accessories(7)

Compact & Student Desks(7)

Lecterns(7)

Coat/Garment Racks(7)

Wire Shelving(6)

Flat/Plan Files(6)

Lockers(6)

Suggestion Boxes & Cards(6)

Task Chairs(6)

Panels/Partitions(6)

Art & Drafting Tables(5)

Foot Rests(5)

Mailroom Sorters & Tables(5)

Arm Sets(5)

Recycling Bins(4)

Letter Trays(4)

Tabletop Sorters/Racks(4)

Utility & Breakroom Tables(4)

Laminate Bookcases(4)

Hooks & Hangers(4)

Dry-Erase Boards(3)

Backrests & Seat Cushions(3)

Signs & Sign Holders(3)

Cubicle / Partition Organizers & Accessories(3)

Executive/High Back Chairs(3)

Drawer Organizers(3)

TV/VCR Stands & Mounts(2)

Mail Carts(2)

Mobile Racks(2)

Contemporary - Laminate(2)

Monitor Stands/Risers(2)

Traditional - Laminate(2)

Business Card Holders(1)

Projector Stands & Carts(1)

Desk Center Drawers(1)

Mouse & Keyboard Wrist Rests(1)

Casters(1)

Wood Veneer Bookcases(1)

Wall Racks(1)

Portable Storage Files & Bins(1)

Telephone Stands & Holders(1)

Pencil Holders(1)

Laptop Stands & Pads(1)

Storage Boxes & Containers(1)

Strength/Sports Training Equipment(1)

Anti-Fatigue Mats(1)

Mobile Pedestals(1)

Power Strips(1)

Reception Area & Accent Tables(1)

Legs(1)

Extension Cords(1)

Brand

Safco(514)

Focal(4)

Onyx it!(2)

Color

Black(202)

Gray(40)

Silver(28)

White(18)

Clear(14)

Cherry(11)

Mahogany(10)

Tan(9)

Medium Oak(9)

Tropic Sand(7)

Stainless Steel(5)

Charcoal(5)

Blue(5)

Dark Gray(4)

Black Base(4)

Sand(3)

Mahogany Base(3)

Putty(3)

Pewter(3)

Chrome Hook(2)

Red(2)

Black Speckle(2)

Charcoal Gray(2)

Wood Grain(2)

Hook(2)

Chrome(1)

Aluminum(1)

Champagne(1)

Matte Black(1)

Wine(1)

Oak(1)

Silver Frame(1)

Black Powder Coat(1)

Light Gray(1)

Baltic(1)

Cream(1)

Grass(1)

Black Vinyl(1)

Recycled

No(303)

Yes(26)

Price Range

$0-$499.99(466)

$500-$999.99(47)

$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