Banner1 Banner1
 
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_12` 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 (`pinfo`.`sku` IN ('CHAW906L','CHAW906','CHAW904L','CHAW904','CHAW902L','CHAW900L','CHAW900','CHAW865','CHAW864','CHAW862','CHAW860','CHAW857','CHAW856','CHAW854','CHAW8523','CHAW8522','CHAW8521','CHAW8343','CHAW8342','CHAW8341','CHAW8293','CHAW8292','CHAW8291','CHAW827','CHAW8253','CHAW8252','CHAW8251','CHAW824','CHAW8223','CHAW8222','CHAW8221','CHAW818','CHAW776','CHAW772','CHAW6703','CHAW6702','CHAW6701','CHAW6673','CHAW6672','CHAW6671','CHAW665','CHAW6643','CHAW6642','CHAW6641','CHAW6523','CHAW6522','CHAW6521','CHAW6493','CHAW6492','CHAW6491','CHAW6283','CHAW6282','CHAW6281','CHAW6253','CHAW6252','CHAW6251','CHAW621','CHAW619','CHAW616L','CHAW616','CHAW583','CHAW579','CHAW5373','CHAW5372','CHAW5371','CHAW497','CHAW496','CHAW495L','CHAW495','CHAW494L','CHAW494','CHAW493L','CHAW493','CHAW492L','CHAW492','CHAW491L','CHAW491','CHAW4873','CHAW4872','CHAW4871','CHAW477','CHAW476','CHAW475','CHAW474','CHAW472','CHAW471','CHAW470','CHAW468','CHAW467','CHAW464','CHAW463','CHAW462','CHAW461','CHAW458','CHAW457L','CHAW457','CHAW454','CHAW453','CHAW452','CHAW451','CHAW450','CHAW449','CHAW448','CHAW447','CHAW446','CHAW445','CHAW444','CHAW443','CHAW442','CHAW441','CHAW440','CHAW439','CHAW438','CHAW437','CHAW436','CHAW435','CHAW434','CHAW433','CHAW432','CHAW429Y','CHAW428','CHAW424','CHAW422','CHAW419Y','CHAW320','CHAW314','CHAW308','CHAW307','CHAW292','CHAW291','CHAW290','CHATR400','CHATR350','CHATR310','CHATR250','CHATR150','CHAT474Y','CHAT473Y','CHAT331Y','CHAT330Y','CHAT326Y','CHAT325Y','CHAT226Y','CHAT225Y','CHAT125Y','CHAT101Y','CHAT100Y','CHASW13Y','CHASW13','CHAS33BE','CHAS32BE','CHAS31BE','CHAS30BE','CHART9Y','CHART9T','CHART9R','CHART9GR','CHART9G','CHART9BK','CHART9BE','CHART18Y','CHART18T','CHART18R','CHART18GR','CHART18G','CHART18BK','CHART18BE','CHART16Y','CHART16T','CHART16R','CHART16GR','CHART16G','CHART16BK','CHART16BE','CHART14Y','CHART14T','CHART14R','CHART14GR','CHART14G','CHART14BK','CHART14BE','CHARB10C','CHARB10','CHAPR27P','CHAPR27G','CHAPR26P','CHAPR26G','CHAPR25P','CHAPR25G','CHAPR15P','CHAPR15G','CHAPR14P','CHAPR14G','CHAPR13P','CHAPR13G','CHAPR12P','CHAPR12G','CHAPR11P','CHAPR11G','CHAPR10P','CHAPR10G','CHAPN22P','CHAPN22G','CHAPN21P','CHAPN21G','CHAPN20P','CHAPN20G','CHAPN15P','CHAPN15G','CHAPN14P','CHAPN14G','CHAPN13P','CHAPN13G','CHAPN12P','CHAPN12G','CHAPN11P','CHAPN11G','CHAPN10P','CHAPN10G','CHAPL22P','CHAPL22G','CHAPL21P','CHAPL21G','CHAPL20P','CHAPL20G','CHAPL15P','CHAPL15G','CHAPL14P','CHAPL14OB','CHAPL14G','CHAPL13P','CHAPL13G','CHAPL12P','CHAPL12OB','CHAPL12G','CHAPL11P','CHAPL11G','CHAPL10P','CHAPL10OB','CHAPL10G','CHAPK22P','CHAPK22G','CHAPK21P','CHAPK21G','CHAPK20P','CHAPK20G','CHAPH22P','CHAPH22G','CHAPH21P','CHAPH21G','CHAPH20P','CHAPH20G','CHAPH14P','CHAPH14OB','CHAPH14G','CHAPH13P','CHAPH13G','CHAPH12P','CHAPH12OB','CHAPH12G','CHAPH11P','CHAPH11G','CHAPH10P','CHAPH10OB','CHAPH10G','CHAP948P','CHAP948G','CHAP947P','CHAP947G','CHAP946P','CHAP946G','CHAP943P','CHAP943G','CHAP942P','CHAP942G','CHAP941P','CHAP941G','CHAP869P','CHAP869G','CHAP865P','CHAP865G','CHAP862WP','CHAP862OP','CHAP862GG','CHAP859P','CHAP859G','CHAP858P','CHAP858G','CHAP857P','CHAP857G','CHAP856P','CHAP856G','CHAP855P','CHAP855G','CHAP854P','CHAP854G','CHAP849P','CHAP849G','CHAP848P','CHAP848G','CHAP847P','CHAP847G','CHAP846P','CHAP846G','CHAP840P','CHAP840G','CHAP839P','CHAP839G','CHAP838P','CHAP838G','CHAP827P','CHAP827LP','CHAP827LG','CHAP827G','CHAP824W','CHAP824OG','CHAP824KP','CHAP821P','CHAP821LP','CHAP821LG','CHAP821G','CHAP820W','CHAP820LW','CHAP820LKP','CHAP820LGG','CHAP820KP','CHAP820GG','CHAP819P','CHAP819G','CHAP815LW','CHAP815LOG','CHAP815LKP','CHAP812WP','CHAP812OG','CHAP812KP','CHAP811W','CHAP811KP','CHAP811GG','CHAP809P','CHAP809G','CHAP808P','CHAP808G','CHAP801WP','CHAP801WG','CHAP801OP','CHAP801OG','CHAP801LWP','CHAP801LWG','CHAP801LOP','CHAP801LOG','CHAP801LGG','CHAP801GG','CHAP800P','CHAP800G','CHAP799P','CHAP799G','CHAP798P','CHAP798G','CHAP797P','CHAP797G','CHAP796P','CHAP796G','CHAP795P','CHAP795G','CHAP793P','CHAP793G','CHAP792','CHAP791P','CHAP791G','CHAP789P','CHAP789G','CHAP788P','CHAP788G','CHAP787P','CHAP787G','CHAP786P','CHAP786G','CHAP785P','CHAP785G','CHAP783P','CHAP783G','CHAP782P','CHAP782G','CHAP781P','CHAP781G','CHAP778P','CHAP778G','CHAP769P','CHAP769G','CHAP767P','CHAP767G','CHAP765P','CHAP765G','CHAP764P','CHAP764G','CHAP763P','CHAP763G','CHAP762P','CHAP762G','CHAP761P','CHAP761G','CHAP759P','CHAP759G','CHAP757P','CHAP757G','CHAP756P','CHAP756G','CHAP754P','CHAP754G','CHAP753P','CHAP753G','CHAP752P','CHAP752G','CHAP751P','CHAP751G','CHAP749P','CHAP749G','CHAP729P','CHAP729G','CHAP728P','CHAP728G','CHAP726P','CHAP726G','CHAP725P','CHAP725G','CHAP724P','CHAP724G','CHAP723P','CHAP723G','CHAP722P','CHAP722G','CHAP721P','CHAP721G','CHAP720P','CHAP720G','CHAP719P','CHAP719G','CHAP716P','CHAP716G','CHAP715P','CHAP715G','CHAP714P','CHAP714G','CHAP713P','CHAP713G','CHAP712P','CHAP712G','CHAP711P','CHAP711G','CHAP710P','CHAP710G','CHAP689','CHAP686P','CHAP686G','CHAP685P','CHAP685G','CHAP684P','CHAP684G','CHAP683','CHAP672T','CHAP672K','CHAP672C','CHAP668P','CHAP668G','CHAP667P','CHAP667G','CHAP662P','CHAP662G','CHAP661P','CHAP661G','CHAP658P','CHAP658G','CHAP657P','CHAP657G','CHAP652P','CHAP652G','CHAP651G','CHAP642P','CHAP642G','CHAP640P','CHAP640G','CHAP635P','CHAP635G','CHAP634P','CHAP634G','CHAP633P','CHAP633G','CHAP624P','CHAP624G','CHAP623P','CHAP623G','CHAP621P','CHAP621G','CHAP620P','CHAP620G','CHAP619T','CHAP619K','CHAP619C','CHAP618P','CHAP618G','CHAP616P','CHAP616G','CHAP614P','CHAP614G','CHAP613P','CHAP613G','CHAP612P','CHAP612G','CHAP611P','CHAP611G','CHAP610P','CHAP610G','CHAP609T','CHAP609K','CHAP609C','CHAP608T','CHAP608K','CHAP608C','CHAP584T','CHAP584K','CHAP584C','CHAP582P','CHAP582G','CHAP581P','CHAP581G','CHAP580P','CHAP580G','CHAP579P','CHAP579G','CHAP578P','CHAP578G','CHAP577P','CHAP577G','CHAP565P','CHAP565G','CHAP564P','CHAP564G','CHAP562P','CHAP562G','CHAP561P','CHAP561G','CHAP558P','CHAP558G','CHAP557P','CHAP557G','CHAP556P','CHAP556G','CHAP555P','CHAP555G','CHAP552P','CHAP552G','CHAP551P','CHAP551G','CHAP540P','CHAP540G','CHAP534P','CHAP534G','CHAP532P','CHAP532G','CHAP531P','CHAP531G','CHAP530P','CHAP530G','CHAP529P','CHAP529OB','CHAP529G','CHAP528P','CHAP528G','CHAP527P','CHAP527OB','CHAP527G','CHAP526P','CHAP526G','CHAP525P','CHAP525G','CHAP523P','CHAP523LP','CHAP523LG','CHAP523G','CHAP522P','CHAP522G','CHAP521P','CHAP521LP','CHAP521LG','CHAP521G','CHAP520P','CHAP520LP','CHAP520LG','CHAP520G','CHAP519P','CHAP519G','CHAP518P','CHAP518G','CHAP517P','CHAP517G','CHAP516P','CHAP516LP','CHAP516LG','CHAP516G','CHAP515P','CHAP515G','CHAP514P','CHAP514G','CHAP513P','CHAP513G','CHAP512P','CHAP512G','CHAP511P','CHAP511G','CHAP510P','CHAP510G','CHAP509P','CHAP509G','CHAP508P','CHAP508G','CHAP507P','CHAP507G','CHAP506P','CHAP506G','CHAP505P','CHAP505G','CHAP504P','CHAP504G','CHAP503P','CHAP503G','CHAP502P','CHAP502G','CHAP501P','CHAP501G','CHAP486P','CHAP486G','CHAP485P','CHAP485G','CHAP470P','CHAP470G','CHAP411W','CHAP411KP','CHAP411G','CHAP366P','CHAP366LP','CHAP366LG','CHAP366G','CHAP365P','CHAP365LP','CHAP365LG','CHAP365G','CHAP364P','CHAP364LP','CHAP364LG','CHAP364G','CHAP363P','CHAP363LP','CHAP363LG','CHAP363G','CHAP362P','CHAP362LP','CHAP362LG','CHAP362G','CHAP361P','CHAP361LP','CHAP361LG','CHAP361G','CHAP356P','CHAP356LP','CHAP356LG','CHAP356G','CHAP355P','CHAP355LP','CHAP355LG','CHAP355G','CHAP354P','CHAP354LP','CHAP354LG','CHAP354G','CHAP353P','CHAP353LP','CHAP353LG','CHAP353G','CHAP352P','CHAP352LP','CHAP352LG','CHAP352G','CHAP351P','CHAP351LP','CHAP351LG','CHAP351G','CHAP346P','CHAP346LP','CHAP346LG','CHAP346G','CHAP345P','CHAP345LP','CHAP345LG','CHAP345G','CHAP344P','CHAP344LP','CHAP344LG','CHAP344G','CHAP343P','CHAP343LP','CHAP343LG','CHAP343G','CHAP342P','CHAP342LP','CHAP342LG','CHAP342G','CHAP341P','CHAP341LP','CHAP341LG','CHAP341G','CHAP329P','CHAP329G','CHAP328P','CHAP328G','CHAP327P','CHAP327G','CHAP319P','CHAP319G','CHAP318P','CHAP318G','CHAP316P','CHAP316G','CHAP315P','CHAP315G','CHAP314P','CHAP314G','CHAP311P','CHAP311G','CHAP300P','CHAP300G','CHAP294P','CHAP294G','CHAP293','CHAP290P','CHAP290G','CHAP280P','CHAP280G','CHAP276P','CHAP276G','CHAP274P','CHAP274G','CHAP273P','CHAP273G','CHAP271P','CHAP271G','CHAP270P','CHAP270G','CHAP266P','CHAP266G','CHAP263P','CHAP263G','CHAP261P','CHAP261G','CHAP256P','CHAP256G','CHAP253P','CHAP253G','CHAP244P','CHAP244G','CHAP237P','CHAP237G','CHAP227P','CHAP227G','CHAP157P','CHAP157LP','CHAP157LG','CHAP157G','CHAP156P','CHAP156LP','CHAP156LG','CHAP156G','CHAP155P','CHAP155LP','CHAP155LG','CHAP155G','CHAP154P','CHAP154LP','CHAP154LG','CHAP154G','CHAP153P','CHAP153LP','CHAP153LG','CHAP153G','CHAP152P','CHAP152LP','CHAP152LG','CHAP152G','CHAP151P','CHAP151LP','CHAP151LG','CHAP151G','CHAP150P','CHAP150LP','CHAP150LG','CHAP150G','CHAP146W','CHAP146LW','CHAP146LKP','CHAP146LG','CHAP146KP','CHAP146G','CHAP145P','CHAP145LP','CHAP145LG','CHAP145G','CHAP144P','CHAP144LP','CHAP144LG','CHAP144G','CHAP143P','CHAP143LP','CHAP143LG','CHAP143G','CHAP140P','CHAP140G','CHAP123P','CHAP123LP','CHAP123LG','CHAP123G','CHAP122P','CHAP122LP','CHAP122LG','CHAP122G','CHAP121W','CHAP121LW','CHAP121LKP','CHAP121LGG','CHAP121KP','CHAP121GG','CHAP119W','CHAP119LW','CHAP119LKP','CHAP119LGG','CHAP119KP','CHAP119GG','CHAP118W','CHAP118LP','CHAP118LG','CHAP118KP','CHAP118GG','CHAP115P','CHAP115LP','CHAP115LG','CHAP115G','CHAP109W','CHAP109LW','CHAP109LK','CHAP109LG','CHAP109K','CHAP109G','CHAMBC4','CHAMB43','CHAMB42','CHAMB41','CHAM885','CHAM302','CHAM300','CHAM299R','CHAM299A','CHAM298','CHAM297R','CHAM297A','CHAM296','CHAM295R','CHAM295A','CHAM294','CHAM293R','CHAM293A','CHAM292','CHAM291R','CHAM291A','CHAM290','CHAM289','CHAM288','CHAM287R','CHAM287ER','CHAM287EA','CHAM287A','CHAM284R','CHAM284A','CHAM283R','CHAM283A','CHAM282R','CHAM282A','CHAM281','CHAM280','CHAM276R','CHAM276A','CHAM275','CHAM274','CHAM273R','CHAM273A','CHAM271','CHAM270','CHAM269R','CHAM269A','CHAM266R','CHAM266A','CHAM265','CHAM262R','CHAM262A','CHAM249E','CHAM249','CHAM248','CHAM247','CHAM246','CHAM245E','CHAM245','CHAM244','CHAM243','CHAM242','CHAM241E','CHAM241','CHAM240E','CHAM240','CHAM236','CHAM218','CHAM214','CHAM209','CHAM205','CHAM204','CHAM201','CHAM200Y','CHAM200','CHAM187','CHAM186','CHAM167','CHAM163','CHAM142R','CHAM142A','CHAM141','CHAM136R','CHAM136A','CHAM135','CHAM134','CHAM133','CHAM129R','CHAM129A','CHAM124R','CHAM124A','CHAM123R','CHAM123A','CHAM122','CHAM121','CHAM118R','CHAM118A','CHAM113','CHAM112','CHAM109','CHAM108','CHAM107R','CHAM107A','CHAM106','CHAM104CSY','CHAM104CRY','CHAM103','CHAM101','CHAM022','CHAM021','CHAM018','CHAM017','CHAM016','CHAM014','CHAM012','CHAL517','CHAL514','CHAL32','CHAL29','CHAL26','CHAL24','CHAL22','CHAL20','CHAL175','CHAL14','CHAL10','CHAH114W','CHAH114K','CHAH114G','CHAH112W','CHAH112K','CHAH112G','CHAFL80','CHAFL70','CHAFL18','CHAFL16','CHAFL15','CHAFL14','CHAFL12','CHAFL1','CHAD573P','CHAD573G','CHAD552P','CHAD552G','CHAD551P','CHAD551G','CHAD550P','CHAD550G','CHAD538P','CHAD538G','CHAD537P','CHAD537G','CHAD536P','CHAD536G','CHACT9','CHACT18','CHACT14','CHAC23BE','CHAC22','CHAC20','CHAC18','CHAB288','CHAB286Y','CHAB285R','CHAB285N','CHAB285ER','CHAB285EN','CHAB284','CHAB283','CHAB280R','CHAB280N','CHAB279','CHAB274','CHAB272','CHAB271','CHAB269R','CHAB269A','CHAB268','CHAB262ER','CHAB262EA','CHAB259','CHAB258','CHAB257R','CHAB257ER','CHAB257EA','CHAB257A','CHAB256R','CHAB256N','CHAB256ER','CHAB256EN','CHAB255R','CHAB255N','CHAB254R','CHAB254N','CHAB254ER','CHAB254EN','CHAB253R','CHAB253N','CHAB252R','CHAB252A','CHAB251','CHAB250','CHAB249E','CHAB249','CHAB248','CHAB246R','CHAB246ER','CHAB246EA','CHAB246A','CHAB245R','CHAB245A','CHAB241E','CHAB241','CHAB240T','CHAB240N','CHAB240','CHAB238','CHAB237T','CHAB237N','CHAB237','CHAB233E','CHAB233','CHAB232R','CHAB232A','CHAB185','CHAB180','CHAB176','CHAB175Y','CHAB174','CHAB173','CHAB172','CHAB171','CHAB165','CHAB163','CHAB162','CHAB161','CHAB153','CHAB151Y','CHAB147Y','CHAB142Y','CHAB139','CHAB138Y','CHAB137','CHAB136Y','CHAB135','CHAB134','CHAB132','CHAB130YR','CHAB130YN','CHAB127Y','CHAB125','CHAB117','CHAB114','CHAB110','CHAB109','CHAB108','CHAB107','CHAB106','CHAB105','CHAB104YR','CHAB104YN','CHAA997Y','CHAA997W','CHAA997K','CHAA996Y','CHAA996W','CHAA996K','CHAA994Y','CHAA994W','CHAA994K','CHAA987Y','CHAA987W','CHAA987K','CHAA986Y','CHAA986W','CHAA986K','CHAA985Y','CHAA985W','CHAA985K','CHAA984Y','CHAA984W','CHAA984K','CHAA983Y','CHAA983W','CHAA983K','CHAA976Y','CHAA976W','CHAA976K','CHAA975Y','CHAA975W','CHAA975K','CHAA974Y','CHAA974W','CHAA974K','CHAA897Y','CHAA897W','CHAA897K','CHAA896Y','CHAA896W','CHAA896K','CHAA894Y','CHAA894W','CHAA894K','CHAA887Y','CHAA887W','CHAA887K','CHAA886Y','CHAA886W','CHAA886K','CHAA884Y','CHAA884W','CHAA884K','CHAA877Y','CHAA877W','CHAA877K','CHAA876Y','CHAA876W','CHAA876K','CHAA874Y','CHAA874W','CHAA874K','CHAA797Y','CHAA797W','CHAA797K','CHAA796Y','CHAA796W','CHAA796K','CHAA794Y','CHAA794W','CHAA794K','CHAA787Y','CHAA787W','CHAA787K','CHAA786Y','CHAA786W','CHAA786K','CHAA784Y','CHAA784W','CHAA784K','CHAA777Y','CHAA777W','CHAA777K','CHAA776Y','CHAA776W','CHAA776K','CHAA774Y','CHAA774W','CHAA774K','CHAA751Y','CHAA751W','CHAA751K','CHAA750Y','CHAA750W','CHAA750K','CHAA746Y','CHAA746W','CHAA746K','CHAA745Y','CHAA745W','CHAA745K','CHAA743','CHAA741Y','CHAA741W','CHAA741K','CHAA740Y','CHAA740W','CHAA740K','CHAA608Y','CHAA608W','CHAA608K','CHAA422Y36','CHAA422Y30D','CHAA422Y20D','CHAA422W36','CHAA422W30D','CHAA422W20D','CHAA422K36','CHAA422K30D','CHAA422K20D','CHAA421Y36','CHAA421Y30D','CHAA421Y20D','CHAA421W36','CHAA421W30D','CHAA421W20D','CHAA421K36','CHAA421K30D','CHAA421K20D','CHAA420Y36D','CHAA420Y30D','CHAA420Y20D','CHAA420W36D','CHAA420W30D','CHAA420W20D','CHAA420K36','CHAA420K30D','CHAA420K20D','CHAA241Y','CHAA241W','CHAA241K','CHAA240Y','CHAA240W','CHAA240K','CHAA239Y','CHAA239W','CHAA239K','CHAA238Y','CHAA238W','CHAA238K','CHAA237Y','CHAA237W','CHAA237K','CHAA236Y','CHAA236W','CHAA236K','CHAA227Y','CHAA227W','CHAA227K','CHAA221Y','CHAA221W','CHAA221K','CHAA215Y','CHAA215W','CHAA215K','CHA98','CHA97','CHA96','CHA87','CHA86','CHA84','CHA79','CHA78','CHA77','CHA76','CHA73','CHA72','CHA71','CHA66TS','CHA6142','CHA6140','CHA6132','CHA5014','CHA5009','CHA45','CHA42','CHA39','CHA38NY','CHA38NR','CHA38NGR','CHA38NG','CHA38NBL','CHA38','CHA3068','CHA3064','CHA3060','CHA3035','CHA3030','CHA29LK','CHA2948','CHA2946','CHA2942','CHA2928','CHA2926','CHA2922','CHA2918','CHA2916','CHA2912','CHA2817','CHA2814','CHA26','CHA25LK','CHA2354','CHA2353','CHA2352','CHA2273','CHA2133','CHA2131','CHA2130','CHA207TB','CHA1645Y','CHA1641Y','CHA1618','CHA1577Y','CHA1577WH','CHA1577R','CHA1577GR','CHA1577BK','CHA1577BE','CHA1575Y','CHA1575WH','CHA1575R','CHA1575GR','CHA1575BK','CHA1575BE','CHA1573Y','CHA1573WH','CHA1573R','CHA1573GR','CHA1573BK','CHA1573BE','CHA1532','CHA1450','CHA1447','CHA1400','CHA1378','CHA1377','CHA1001','CHA1000','AOSMailStor255','AOSMailStor313','AOSMailStor373','AOSMailStor375','AOSMailStor433','AOSMGR25','AOSMGR259','AOSMGR37','AOSMGR379','AOSPrintGard19','AOSPrintGard25','AOSPrintGard31','AOSSlantFile16','AOSSlantFile9','AOSTrussFile25','AOSTrussFile37','AOSVFile19','AOSVFile25','AOSVFile37','AOSVFile43','AOSVFolder19','AOSVFolder25','AOSVFolder37','AOSVFolder43','')) 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 ('mailproductplanning' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+mailproductplanning' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"mailproductplanning"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"mailproductplanning"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"mailproductplanning"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"mailproductplanning"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+mailproductplanning' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='mailproductplanning',`category_4` ='mailproductplanning') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'mailproductplanning,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('mailproductplanning', `pinfo`.`desc_title`)) DESC

Currently Filtered by

mailproductplanning

Mailproductplanning

Refine Search

  GO
Category

Mail Bags(1)

Price Range

$0-$499.99(261)

$500-$999.99(78)

$1000-$1499.99(14)

$1500-$1999.99(4)

$2000-$2499.99(5)

$2500-$2999.99(4)

$3000-$3499.99(1)

$3500-$3999.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Shop Our Solutions is a Division of American Office Solutions,Inc., All Rights Reserved