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 (`pinfo`.`sku` IN ('SPN309004','CNM8750B002','CNM5207B001','CNM5209B001','IVR50448','IVR51510','IVR52458','IVR55025','IVR61025','IVR71670','KMW64370','KMW75227','KTKMA225','SPTHS2020','DYM1982171','BLKF9H71012','TRPTLP366CUBEUS','ALEAEWR3B','ALEAEWR4B','ALEAEWR7B','ALEBR118','ALECC4219','ALECC4219F','ALECGC411','ALECGC511','ALEFAN041','ALEFAN093','ALEFS112','ALEFS212','ALEFS312','ALEHEFF10B','ALEHEFF10W','ALEIN4811','ALEIN4814','ALEIN4815','ALEIN4819','ALEIN49AKB10B','ALELD4824WA','ALELED908B','ALELMP603B','ALELMPD28B','ALELTD4824WA','ALEMB4718','ALEMB4748','ALENT4916','ALEPC1511','ALEPC1551','ALEQAD4232EB','ALEQAD4232GS','ALETE4810','ALETE4817','ALETE4819','ALEVABFES','ALEVABFMC','ALEVABFMY','ALEVABFWA','ALEVTA4810','AVE24000','BICMP11','BICMPE11','BICMPF11','DIX13830','DURMN1300R4Z','DURMN1500B4Z','DURMN1500B8Z','DURMN1604B2Z','DURMN2400B4Z','DURMN2400B8Z','DURMN2400B8ZCT','DURMN9100B2PK','DYM1752264','DYM1790415','DYM2056115','EPI2027153','EPIE554','FEL0070308','FLRFCA21624BK','HAM163120','HEW203000','HEW207010','HONCMY1AACCF10','HONI2M2AMLC10TK','HONSVM1ALC10TK','JDK400065000','JDKK67030','MMM1456','MMM17067CLR9ES','MMM34503','MMM62210SSCY','MMM653AU','MMM65412SSCY','MMM6545UC','MMM6603AU','MMM6605SSCY','MMM6753AUL','MMM6756SSCY','MMM680BBBGA4VA','MMM680PPBGVA','MMM680RYBGVA','MMM6834','MMM6834AB','MMM810H3','MMMC50','MMMC60BK','MMMC91','PAP1945926','PAP1951377','PAP2082957','PIL31020','PIL31021','PIL31022','REDA1081','REDA30C81','SAF2110BL','SAF3254WH','SAN1884739','SAN1920932','SAN1920937','SAN1921559','SAN2011580','SAN2082960','SAN25053','SAU21117','SMD10338','SMD70727','SMD77291','SMD77300','STX61310B01C','STX61312B01C','STX61543U01C','SWI1757393','TOP56872','TOP80220','TOP80284','UNV07050','UNV08852','UNV08866','UNV11000','UNV11289','UNV15542','UNV16166','UNV20060','UNV20061','UNV20062','UNV20064','UNV20541','UNV20543','UNV20544','UNV31026','UNV31203','UNV35693','UNV39910','UNV39911','UNV43040','UNV43403','UNV43418','UNV50504','UNV66350','UNV66351','UNV66352','UNV66353','UNV79000','SPN480602','SPN120204','SPN120404','SPN101804','SPN103504','SPN470202','SPN470402','GEN500','BWK6145','WIN122085RL','VONS920','VON524W','VON88012N','')) 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 '%workfromhome' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('workfromhome' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+workfromhome' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"workfromhome"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"workfromhome"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"workfromhome"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"workfromhome"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+workfromhome' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='workfromhome',`category_4` ='workfromhome') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'workfromhome,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('workfromhome', `pinfo`.`desc_title`)) DESC

Currently Filtered by

work_from_home

Work_from_home

Refine Search

  GO
 
Category Filter

Chairs/Stools(16)

Paper Pads/Note Pads(11)

Pens(9)

Self-Stick Pads(9)

Batteries(8)

Markers(8)

Desks(7)

File Cabinets(6)

Page Flags(5)

Back Supports(5)

Disinfectants(4)

Label Makers(4)

Office Paper(4)

Pencils(4)

Highlighters(4)

Surge Protectors(3)

Footrests(3)

Desktop File Folder Sorters(3)

File Jackets/Sleeves/Wallets(3)

Clean On The Go Captive Dispensing System Products(3)

Pocket Folders(3)

Lamps(3)

Inks & Toners(2)

Packing Tape(2)

Fans(2)

Boards(2)

Desktop Supplies Organizers(2)

Magazine Files(2)

Clips/Clamps(2)

Mice(2)

Towels & Wipes(2)

Mouse Pads & Wrist Rests(2)

Floor Mats(2)

File Boxes(2)

Adhesives/Glues(2)

Toilet Tissues(2)

File Folders(2)

Shredders(1)

Staplers(1)

Headsets(1)

Food Processing/Handling/Service(1)

Keyboards(1)

Clipboards(1)

Appointment Books(1)

Tape Dispensers(1)

Tapes(1)

Hangers/Hooks(1)

AV Mounts, Arms & Hardware(1)

Desktop Stands(1)

Copier/Fax/Multifunction Machines(1)

Chair Arms(1)

Heaters(1)

Staples(1)

 
Brand

Alera(39)

Universal(28)

Duracell(8)

Sharpie(7)

Innovera(6)

Post-it Flags(5)

Smead(4)

Post-it Notes(4)

Post-it Notes Super Sticky(4)

Scotch(4)

DYMO(4)

Pilot(3)

HON(3)

Paper Mate(3)

Canon(3)

Storex(3)

BIC(3)

TOPS(3)

HP Papers(2)

Black n' Red(2)

Kensington(2)

Blueline(2)

Safco(2)

GBC(1)

Spracht(1)

Belkin(1)

Saunders(1)

Tripp Lite(1)

Boardwalk(1)

Elmer's(1)

Post-it(1)

3M(1)

Bankers Box(1)

Ticonderoga(1)

Command(1)

Avery(1)

Kantek(1)

Krazy Glue(1)

Hammermill(1)

GEN(1)

Floortex(1)

Windsoft(1)

 
Color

Black(4)

Modern Walnut(3)

Black/Silver(1)

Espresso/Black(1)

Gray Oak/Silver(1)

Espresso(1)

Medium Cherry(1)

Mahogany(1)

Gray(1)

 
Height

1.75"(4)

0.75"(2)

9.5"(2)

10"(2)

2.13"(2)

2.75"(2)

5.88"(1)

5.13"(1)

2.5"(1)

12"(1)

5.2"(1)

15"(1)

10.88"(1)

8.25"(1)

1.63"(1)

17.5"(1)

1"(1)

1.38"(1)

10.5"(1)

7 9/10"(1)

13 9/10"(1)

25"(1)

22"(1)

21.5"(1)

3.38" to 5.13"(1)

4.5" to 6.75"(1)

3.75" to 7.5"(1)

11 3/4"(1)

5 1/2"(1)

10.13"(1)

 
Color(s)

Black(21)

White(7)

Vintage Bronze(4)

Canary Yellow(4)

Jaipur Collection(4)

Assorted(3)

Clear(3)

Fluorescent Yellow(2)

Assorted Brights(2)

Assorted Primary(2)

Black/Silver(2)

Tri-Color(1)

Black/Gray(1)

Yellow(1)

Tan Quartz(1)

Fluorescent Green(1)

Blue(1)

Assorted Colors(1)

Black 2-Tone(1)

White/Blue(1)

Smoke(1)

Gray/Black(1)

Clear; Silver(1)

Midnight Black(1)

Steel(1)

 
Depth

17.75"(2)

11.5"(2)

19.13"(2)

15.38"(1)

8.25"(1)

2.88"(1)

13.5"(1)

10.13"(1)

5.3"(1)

9"(1)

14.25"(1)

0.75"(1)

13"(1)

6.5"(1)

11"(1)

8.87"(1)

2.5"(1)

14.13"(1)

16.25"(1)

4 1/5"(1)

20.5"(1)

6"(1)

4.38"(1)

19.63"(1)

4 5/8"(1)

3 3/8"(1)

15.75"(1)

13.63"(1)

 
Size

0.5 x 1.75(2)

1 x 1.75(2)

Letter(2)

2.4w x 5.37d x 7.9h(1)

1.88" x 22.2 yds(1)

Small(1)

1.88" x 54.6 yds(1)

0.5 x 1.75; 1 x 1.75(1)

0.5" x 36 yds(1)

10.75 x 8.5(1)

Legal(1)

 
Packing Type

Roll(1)

Tube(1)

Stick(1)

Carton(1)

 
Overall Width

15.88"(4)

14.75"(2)

32"(1)

10.25"(1)

 
Overall Depth

19.13"(4)

18.25"(2)

13"(1)

6.75"(1)

 
Closure

Lift-Off Lid(2)

 
Diameter

10"(1)

 
Base Color

Black(17)

Matte Black(1)

Chrome(1)

 
Clip Capacity

1.5"(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved