Updating Wade’s Sales from xRMS

One click each morning refreshes customer prices, usual items, each customer’s last orders and the customer list for every rep. Do it on a computer, not the iPad.

One-time setup

In Chrome on your computer, turn on the bookmarks bar (Ctrl+Shift+B on Windows, ⌘+Shift+B on a Mac).
Drag this red button up onto the bookmarks bar:
Wade’s Sales update

Can’t drag it? Right-click the bookmarks bar → Add page, name it Wade’s Sales update, and paste the text below as the URL.

javascript:(function()%7B%0Avar%20APP=%22https://wades-sales.pages.dev%22,%20XR=%22https://wades.ncsdsd.net%22;%0Aif(location.origin!==XR)%7B%20alert(%22Open%20xRMS%20(wades.ncsdsd.net),%20sign%20in,%20then%20click%20this%20bookmark.%22);%20return;%20%7D%0Avar%20auth=null;%20try%7B%20auth=JSON.parse(sessionStorage.getItem(%22xrmsUi_authnResult%22));%20%7Dcatch(e)%7B%7D%0Aif(!auth%7C%7C!auth.access_token)%7B%20alert(%22Sign%20in%20to%20xRMS%20first,%20then%20click%20this%20bookmark%20again.%22);%20return;%20%7D%0Aif(window.__wsuRunning)%7B%20alert(%22The%20Wade's%20Sales%20update%20is%20already%20running%20in%20this%20tab.%22);%20return;%20%7D%0Awindow.__wsuRunning=true;%0Avar%20app=window.opener,%20opened=false;%0Aif(!app)%7B%20app=window.open(APP+%22/#xrms-receive%22,%22wadessales%22);%20opened=true;%20%7D%0Avar%20box=document.createElement(%22div%22);%0Abox.style.cssText=%22position:fixed;z-index:2147483647;right:16px;bottom:16px;width:360px;background:#fff;color:#111;border:2px%20solid%20#C8102E;border-radius:12px;padding:14px%2016px;font:14px/1.45%20system-ui,-apple-system,sans-serif;box-shadow:0%208px%2030px%20rgba(0,0,0,.25)%22;%0Abox.innerHTML=%22%3Cb%20style='color:#C8102E;font-size:15px'%3EWade's%20Sales%20update%3C/b%3E%3Cdiv%20class='m'%20style='margin-top:6px'%3EStarting...%3C/div%3E%3Cdiv%20style='height:8px;background:#eee;border-radius:4px;margin-top:10px'%3E%3Cdiv%20class='b'%20style='height:8px;width:0;background:#C8102E;border-radius:4px;transition:width%20.3s'%3E%3C/div%3E%3C/div%3E%3Cdiv%20class='x'%20style='margin-top:8px;font-size:12px;color:#666'%3ELeave%20this%20tab%20and%20the%20Wade's%20Sales%20tab%20open%20until%20it%20says%20Done.%3C/div%3E%22;%0Adocument.body.appendChild(box);%0Afunction%20say(t,p)%7B%20box.querySelector(%22.m%22).textContent=t;%20if(p!=null)%20box.querySelector(%22.b%22).style.width=Math.round(p*100)+%22%25%22;%20%7D%0Afunction%20fail(t)%7B%20say(t,null);%20box.style.borderColor=%22#b45309%22;%20box.querySelector(%22.x%22).textContent=%22Nothing%20was%20changed%20in%20the%20app.%22;%20window.__wsuRunning=false;%20%7D%0Afunction%20H()%7B%20return%20%7BAuthorization:%22Bearer%20%22+JSON.parse(sessionStorage.getItem(%22xrmsUi_authnResult%22)).access_token,%22Content-Type%22:%22application/json%22%7D;%20%7D%0Afunction%20post(path,body)%7B%20return%20fetch(%22/api/%22+path,%7Bmethod:%22POST%22,headers:H(),body:JSON.stringify(body)%7D).then(function(r)%7B%20if(r.status!==200)%20throw%20new%20Error(%22xRMS%20%22+path+%22%20returned%20%22+r.status+(r.status===401?%22%20(reload%20xRMS%20and%20try%20again)%22:%22%22));%20return%20r.json();%20%7D);%20%7D%0Afunction%20wait(type,ms,match)%7B%20return%20new%20Promise(function(res)%7B%20var%20t=setTimeout(function()%7B%20removeEventListener(%22message%22,f);%20res(null);%20%7D,ms);%0Afunction%20f(e)%7B%20if(e.origin===APP&&e.data&&e.data.type===type&&(!match%7C%7Cmatch(e.data)))%7B%20clearTimeout(t);%20removeEventListener(%22message%22,f);%20res(e.data);%20%7D%20%7D%20addEventListener(%22message%22,f);%20%7D);%20%7D%0Afunction%20sleep(ms)%7B%20return%20new%20Promise(function(r)%7B%20setTimeout(r,ms);%20%7D);%20%7D%0Afunction%20clean(s)%7B%20return%20String(s==null?%22%22:s).replace(/[%7C%5Cn%5Cr]/g,%22%20%22).trim();%20%7D%0A(async%20function()%7B%0Atry%7B%0Aif(!app)%7B%20fail(%22Your%20browser%20blocked%20the%20Wade's%20Sales%20window.%20Allow%20pop-ups%20for%20wades.ncsdsd.net%20and%20click%20the%20bookmark%20again.%22);%20return;%20%7D%0Asay(%22Connecting%20to%20the%20Wade's%20Sales%20app...%22,0.02);%0Avar%20ready=null;%0Afor(var%20i=0;i%3C20&&!ready;i++)%7B%20try%7B%20app.postMessage(%7Btype:%22wades-sales-ping%22%7D,APP);%20%7Dcatch(e)%7B%7D%20ready=await%20wait(%22wades-sales-ready%22,1500);%20%7D%0Aif(!ready)%7B%20fail(%22Couldn't%20reach%20the%20Wade's%20Sales%20app.%20Open%20wades-sales.pages.dev,%20sign%20in%20as%20a%20manager,%20then%20try%20again.%22);%20return;%20%7D%0Aif(!ready.ok)%7B%20fail(ready.error===%22not_manager%22?%22The%20Wade's%20Sales%20app%20is%20signed%20in%20as%20a%20rep.%20Sign%20in%20as%20Dave%20or%20Bob%20and%20try%20again.%22:%22The%20Wade's%20Sales%20app%20isn't%20signed%20in.%20Sign%20in%20as%20a%20manager%20and%20try%20again.%22);%20return;%20%7D%0Asay(%22Reading%20customers,%20items%20and%20prices%20from%20xRMS...%22,0.05);%0Avar%20pg=%7BPagination:%7BPageIndex:0,PageSize:50000%7D,Orders:null%7D;%0Avar%20cu=(await%20post(%22customers/display%22,pg)).Items,%20dc=(await%20post(%22dc-items/display%22,pg)).Items,%0Agd=(await%20post(%22price-groups/detail/display%22,pg)).Items,%20cp=(await%20post(%22customer-prices/display%22,pg)).Items;%0Avar%20sl=(await%20post(%22sales/sales-list%22,%7BPagination:%7BPageIndex:0,PageSize:60000%7D%7D)).Sales.Items;%0Avar%20now=new%20Date(),%20D=new%20Date(now.getTime()-now.getTimezoneOffset()*6e4).toISOString().slice(0,10);%0Afunction%20akey(ch,n,sub)%7B%20return%20ch+%22-%22+n+(sub?%22.%22+sub:%22%22);%20%7D%0Avar%20GP=%7B%7D;%20gd.forEach(function(r)%7B%20var%20k=r.Identity.GRPPRCGRP+%22%7C%22+r.Identity.GRPITMNUM;%20(GP[k]=GP[k]%7C%7C[]).push([r.Identity.GRPEFFDTE.slice(0,10),r.GRPENDDTE.slice(0,10),r.GRPEFFPRC.Amount,r.GRPRECTYP]);%20%7D);%0Avar%20G=%7B%7D;%20Object.keys(GP).forEach(function(k)%7B%20var%20p=k.split(%22%7C%22),%20b=null;%20GP[k].forEach(function(x)%7B%20if(x[3]===1&&x[0]%3C=D&&x[1]%3E=D&&(!b%7C%7Cx[0]%3Eb[0]))%20b=x;%20%7D);%20if(b&&b[2]%3E0&&b[2]%3C999)%20(G[p[0]]=G[p[0]]%7C%7C[]).push(p[1]+%22:%22+(+b[2].toFixed(4)));%20%7D);%0Avar%20prices=Object.keys(G).map(function(g)%7B%20return%20g+%22=%22+G[g].join(%22,%22);%20%7D).join(%22%5Cn%22);%0Avar%20active=cu.filter(function(c)%7B%20return%20!c.CUSINACTV;%20%7D);%0Avar%20cg=active.filter(function(c)%7B%20return%20c.CustomerPricePromo&&(c.CustomerPricePromo.CPRPRCGRP%7C%7Cc.CustomerPricePromo.CPRPRCGP2);%20%7D).map(function(c)%7B%20return%20akey(c.Identity.CUSCUSCHN,c.Identity.CUSCUSNUM,c.Identity.CUSSUBCUS)+%22:%22+c.CustomerPricePromo.CPRPRCGRP+%22:%22+c.CustomerPricePromo.CPRPRCGP2;%20%7D).join(%22,%22);%0Avar%20base=dc.filter(function(d)%7B%20return%20d.DCIBASPRC&&d.DCIBASPRC.Amount%3E0&&d.DCIBASPRC.Amount%3C999;%20%7D).map(function(d)%7B%20return%20d.Identity.DCIITMNUM+%22:%22+d.DCIBASPRC.Amount;%20%7D).join(%22,%22);%0Avar%20cf=dc.filter(function(d)%7B%20return%20d.DCICASFAC%3E0;%20%7D).map(function(d)%7B%20return%20d.Identity.DCIITMNUM+%22:%22+d.DCICASFAC;%20%7D).join(%22,%22);%0Avar%20items=dc.filter(function(d)%7B%20return%20!d.DCIITINAC;%20%7D).map(function(d)%7B%20return%20d.Identity.DCIITMNUM+%22%7C%22+clean(d.DCILNGDES%7C%7Cd.DCISHTDES)+%22%7C%22+(d.DCICASFAC%7C%7C0);%20%7D).join(%22%5Cn%22);%0Avar%20cps=JSON.stringify(cp.map(function(r)%7B%20return%20[r.Identity.PRCCUSCHN,r.Identity.PRCCUSNUM,r.Identity.PRCITMNUM,r.Identity.PRCEFFDTE.slice(0,10),r.PRCENDDTE.slice(0,10),r.PRCEFFPRC.Amount,r.PRCRECTYP];%20%7D));%0Avar%20custs=active.map(function(c)%7B%20var%20a=c.ShipAddress%7C%7C%7B%7D,%20id=c.Identity;%0Areturn%20[clean(c.CUSCUSNAM),akey(id.CUSCUSCHN,id.CUSCUSNUM,id.CUSSUBCUS),c.CUSRTENUM?c.CUSRTENUM.RTERTENUM:%22%22,clean(a.CAFADRCTY),clean(a.CAFADRSTA)%7C%7C%22CT%22,clean(a.CAFADRLN1),%22%22,%22%22].join(%22%7C%22);%20%7D).join(%22%5Cn%22);%0Avar%20since=new%20Date(now.getTime()-45*864e5).toISOString().slice(0,10);%0Avar%20byC=%7B%7D;%20sl.forEach(function(s)%7B%20var%20d=s.SLHDELDTE.slice(0,10);%20if(d%3Csince%7C%7Cd%3ED)%20return;%20var%20k=akey(s.SLHCUSCHN,s.SLHCUSNUM,0);%20(byC[k]=byC[k]%7C%7C[]).push(s);%20%7D);%0Avar%20pick=[];%20Object.keys(byC).forEach(function(k)%7B%20var%20L=byC[k];%20L.sort(function(a,b)%7B%20return%20b.SLHDELDTE.localeCompare(a.SLHDELDTE)%7C%7Cb.Identity.SLHSLSNBR-a.Identity.SLHSLSNBR;%20%7D);%20pick.push.apply(pick,L.slice(0,8));%20%7D);%0Avar%20T=%7B%7D,%20done=0,%20errs=0,%20qi=0;%0Aasync%20function%20one(s)%7B%20var%20n=s.Identity.SLHSLSNBR;%0Afor(var%20k=0;k%3C3;k++)%7B%20try%7B%20var%20r=await%20fetch(%22/api/sales/%22+n,%7Bheaders:H()%7D);%20if(r.status!==200)%7B%20await%20sleep(800);%20continue;%20%7D%20var%20j=await%20r.json();%0Avar%20lines=(j.SaleDetails%7C%7C[]).filter(function(x)%7B%20return%20x.IsSaleType&&x.SLDITMNUM;%20%7D).map(function(x)%7B%20return%20[x.SLDITMNUM.ITMITMNUM,%20x.Extension?+x.Extension.SLXCASQTY%7C%7C0:0,%20x.Extension?+x.Extension.SLXUNTQTY%7C%7C0:0,%20+(+x.SLDTRNPRC%7C%7C0).toFixed(4),%20+(+x.SLDTRNAMT%7C%7C0).toFixed(2)];%20%7D).filter(function(l)%7B%20return%20l[1]%7C%7Cl[2];%20%7D);%0Avar%20key=akey(s.SLHCUSCHN,s.SLHCUSNUM,0);%20(T[key]=T[key]%7C%7C[]).push([s.SLHDELDTE.slice(0,10),String(s.SLHTCKNUM%7C%7Cn),s.SLHRTENUM%7C%7C%22%22,+(+s.NetValue%7C%7C0).toFixed(2),lines]);%0Adone++;%20if(done%25200===0)%20say(%22Reading%20delivery%20tickets:%20%22+done.toLocaleString()+%22%20of%20%22+pick.length.toLocaleString(),0.08+0.72*done/pick.length);%20return;%20%7Dcatch(e)%7B%20await%20sleep(500);%20%7D%20%7D%0Aerrs++;%20%7D%0Aasync%20function%20worker()%7B%20while(qi%3Cpick.length)%7B%20await%20one(pick[qi++]);%20%7D%20%7D%0Asay(%22Reading%20delivery%20tickets:%200%20of%20%22+pick.length.toLocaleString(),0.08);%0Aawait%20Promise.all(Array.from(%7Blength:12%7D,worker));%0Asay(%22Working%20out%20usual%20items...%22,0.82);%0Avar%20usual=Object.keys(T).map(function(k)%7B%20var%20tk=T[k],%20it=%7B%7D,%20dates=%7B%7D;%0Atk.forEach(function(t)%7B%20dates[t[0]]=1;%20t[4].forEach(function(l)%7B%20var%20e=it[l[0]]=it[l[0]]%7C%7C%7Bf:0,cs:0,un:0,ld:%22%22,lcs:0,lun:0,lp:0,days:%7B%7D%7D;%0Aif(!e.days[t[0]])%7B%20e.days[t[0]]=1;%20e.f++;%20%7D%20e.cs+=l[1];%20e.un+=l[2];%0Aif(t[0]%3E=e.ld)%7B%20if(t[0]%3Ee.ld)%7B%20e.lcs=0;%20e.lun=0;%20%7D%20e.ld=t[0];%20e.lcs+=l[1];%20e.lun+=l[2];%20e.lp=l[3];%20%7D%20%7D);%20%7D);%0Avar%20n=Object.keys(dates).length;%0Avar%20list=Object.keys(it).map(function(i)%7B%20return%20[i,it[i]];%20%7D).sort(function(a,b)%7B%20return%20b[1].f-a[1].f%7C%7C(b[1].cs+b[1].un/100)-(a[1].cs+a[1].un/100);%20%7D).slice(0,30);%0Areturn%20list.length?%20k+%22%7C%22+n+%22%7C%22+list.map(function(p)%7B%20var%20e=p[1];%20return%20p[0]+%22*%22+e.f+%22*%22+(+(e.cs/e.f).toFixed(1))+%22*%22+(+(e.un/e.f).toFixed(1))+%22*%22+e.lcs+%22*%22+e.lun+%22*%22+e.ld.slice(5).replace(%22-%22,%22%22)+%22*%22+(+(+e.lp).toFixed(4));%20%7D).join(%22;%22)%20:%20%22%22;%20%7D).filter(Boolean).join(%22%5Cn%22);%0Avar%20pulled=(now.getMonth()+1)+%22/%22+now.getDate()+%22/%22+String(now.getFullYear()).slice(2)+%22%20%22+now.toLocaleTimeString([],%7Bhour:%22numeric%22,minute:%222-digit%22%7D);%0Asay(%22Sending%20prices%20and%20customers%20to%20the%20app...%22,0.85);%0Avar%20ackP=wait(%22wades-xrms-ack%22,60000);%0Aapp.postMessage(%7Btype:%22wades-xrms-import%22,data:%7Bprices:prices,cg:cg,base:base,cf:cf,items:items,cp:cps,usual:usual,pulled:pulled,custs:custs%7D%7D,APP);%0Avar%20a1=await%20ackP;%20if(!a1%7C%7C!a1.ok)%7B%20fail(%22The%20app%20didn't%20save%20the%20prices%22+(a1&&a1.error?%22%20(%22+a1.error+%22)%22:%22%22)+%22.%20Try%20again.%22);%20return;%20%7D%0Avar%20rows=Object.keys(T).map(function(k)%7B%20return%20[k,JSON.stringify(T[k].filter(function(t)%7B%20return%20t[4].length;%20%7D).sort(function(a,b)%7B%20return%20b[0].localeCompare(a[0]);%20%7D))];%20%7D);%0Afor(var%20i2=0,seq=0;i2%3Crows.length;i2+=150,seq++)%7B%0Avar%20ackH=wait(%22wades-xrms-hist-ack%22,30000,(function(s)%7B%20return%20function(d)%7B%20return%20d.seq===s;%20%7D;%20%7D)(seq));%0Aapp.postMessage(%7Btype:%22wades-xrms-hist%22,seq:seq,reset:i2===0,rows:rows.slice(i2,i2+150)%7D,APP);%0Avar%20a2=await%20ackH;%20if(!a2%7C%7C!a2.ok)%7B%20fail(%22The%20app%20stopped%20saving%20last%20orders%20partway%20(%22+((a2&&a2.error)%7C%7C%22timeout%22)+%22).%20Run%20the%20bookmark%20again.%22);%20return;%20%7D%0Asay(%22Saving%20last%20orders:%20%22+Math.min(i2+150,rows.length).toLocaleString()+%22%20of%20%22+rows.length.toLocaleString()+%22%20customers%22,0.86+0.14*Math.min(1,(i2+150)/rows.length));%0A%7D%0Asay(%22Done.%20%22+active.length.toLocaleString()+%22%20customers,%20prices,%20usual%20items%20and%20%22+done.toLocaleString()+%22%20tickets%20updated%20(%22+pulled+%22).%22+(errs?%22%20%22+errs+%22%20tickets%20couldn't%20be%20read.%22:%22%22),1);%0Abox.style.borderColor=%22#15803d%22;%20box.querySelector(%22.x%22).textContent=%22Reps%20get%20the%20new%20data%20next%20time%20they%20open%20the%20app.%20You%20can%20close%20this%20tab.%22;%0Awindow.__wsuRunning=false;%0A%7Dcatch(e)%7B%20fail(%22Stopped:%20%22+(e&&e.message%7C%7Ce));%20%7D%0A%7D)();%0A%7D)();

Every morning (about 2 minutes)

Open xRMS (wades.ncsdsd.net) and sign in.
Click Wade’s Sales update on the bookmarks bar.
A Wade’s Sales tab opens (sign in with your manager PIN the first time). A red box in the xRMS tab shows progress.
Leave both tabs open until the box says Done.

You can also start from the app: tap Update from xRMS at the bottom of Wade’s Sales, then click the bookmark in the xRMS tab it opens. Only Dave and Bob (managers) can run the update. Reps get the new data the next time they open the app.

If something goes wrong

“Sign in to xRMS first”: you’re signed out of xRMS. Reload xRMS, sign in, click again.
“Couldn’t reach the Wade’s Sales app”: Chrome blocked the pop-up. Allow pop-ups for wades.ncsdsd.net, or open the app first and use Update from xRMS.
“Signed in as a rep”: sign the Wade’s Sales tab in as Dave or Bob.
If it stops partway, click the bookmark again.