<>$"u 73SHOPITEM1 - COMPARE SHOPIFY PRODUCTS TO 3PLC ITEMS 3created from SHOPGET0 (2$5n@@ $/admin/products?limit=99$#s$dk
SHOPDISPLAY WMSDISPLAYP% CREATESHOPNUMBERp"$2,0$22F۩(:c(1*),*6$222$FILENAME3get all items from 3PLC%3--- might need to GET multiple pagesO$$/customers/12/items?pgsiz=99&pgnum=1GET3PLCGETDEO$$/customers/12/items?pgsiz=99&pgnum=2GET3PLCGETef3------- GET 3PLC RESULTS '3--------- SHOW TABLE OF SHOPIFY ITEMS t$$lProduct ID,Name,Type, Tags, Variant ID, Title, SKU, Qty, 3PL ID, 3PL SKU, 3PL Desc, Classification, 3PL Qty, $ 7

Shopify Products/Variants

[
۫ $3& %$/admin/products.json?limit=99 "GETSHOPGET $6 0"$7 '.products[۩(6]' :JQ178 DE$7 '.products[۩(6&] | .id, .title, .product_type, .tags' NJQ17> S > $> X ?2$?>" b @Bnull< l$QV@B n$@BQ v$< K$7 '.variants[۩(<,] | .id, .title, .sku, .inventory_quantity ' JQ187=  = $=  @2$@="  @Anull@At $^@A  <t $RV@A $@AR H3 f{$7#'.ResourceList[] | select(.Sku == "۩@CA") | .ItemId, .Sku, .Description, .ClassificationIdentifier.Name' pJQ1D7F r F z tJQ1e7F v$ F$F 3no results z G2$GF" &$V@HU $T @H$TV@H $@HT 3CREATE WMS ITEM  @H = @ @C 3****************** testing 33LET IICOUNT=IICOUNT+1; IF IICOUNT>2 THEN GOTO 3590 $TVCreate WMS Item$@gT _3CALL "SHOPDOG2",VID$,SHOPREC$,WMSID$,WMSREC$,RESULT1$; LET W.F1$="WMS Item Created"; GOTO 3590 3-----------2$ '+۫?@G %U&$ @H$IIV,j$<< t$66 0<3doneP$ 
/3------- now get inventory and substitute it in?3--- this could be done faster by having the 3plc itemid in the3--- shopify product record Ihl$)/inventory/stocksummaries?rql=itemid=in=(II)GET3PLCGETJK$LX$7 '.Summaries[۩(L8] | .ItemIdentifier.Id, .Allocated, .Available, .OnHand'JQ1J7M" N2$NM", @Onull^6+$  @PT$LL~#(3DISPLAY SHOPIFY INFO IN WINDOW$WShopify$ SHOPDISPLAY"GETSHOPGETQ$S products0$7'.product.image.src'JQ17S? S3$S"JQHTML 6$ 

W API Query: 

S FP3DISPLAY 3PLC INFO IN WINDOWZ$W 3PL Centrald$ WMSDISPLAYx"GET3PLCGETJQHTMLX2$&/inventory/stocksummaries?rql=itemid==@Y"GET3PLCGET+$7'.Summaries[0]'JQ17JQHTMLZ$[\V$J/inventory/stockdetails?customerid=13&facilityid=1&rql=itemidentifier.id==@Y"GET3PLCGET/3LOOP HERE FOR EACH TRANSACTION9$7'.ResourceList[۩([]'JQ17  JQHTML]$\\]$[[w$ 

W API Query: Item Info

X

Stock Summary

Z

Stock Details

\p*36000 "----------- CALL CREATE WMS ITEMz$_ CREATESHOPNUMBER($ CREATE ۫ CREATESHOPNUMBER SHOPDOG2_`cab=$ 
SHOPIFY ITEM
&JQHTML`X$ XB$ #
3PL CENTRAL ITEM
&JQHTMLaX$ X8 $ d@3errorJ=$*error ۩(Ө at line ۩(Ө" in ۩#E2#(3#<($)$,)1)LK?)#F$ >
RAW RESULTS




#P$ ۫||| #Z63show paths#&3done'310000 "functions'3string$, token$, delimiter$'$'.$'8'$ 'V'B&$ܨ$'L $'V 8'`]'j 't>$ - $'~ $'a$3IF LEN(Y1$) THEN IF Y1$(LEN(Y1$))="." THEN LET Y1$=Y1$(1,LEN(Y1$)-1); GOTO 10122' 8']'';$"":  $(' $'$Ө'$},( $($ө(8(])`3---- this function loads a template with fields names that macth the xml fragment that is sent)  )  ) !$  3SET TO UPPERCASE)$ ө ,)/ N[۩( ]:c(32*)$ )"  ),$ @@)6"V @@ )^*)8 )]2U 36$/3@<$-'WFDIR tmp/3plget0_۩(Өө.json3J $., > - 2>&13T(3A=SCALL("echo -e ""\n\n"" >>"+OUTFILE$)3^$$,-33^10031B?/33^10034N86&3"get all paths from the json in out2$6*$,/usr/local/bin/jq_getpaths.sh 6261$ 4
7 8@3------ LINK TO STOCKDETAILS@[ @9NAB001$:[ASN@8J  01$10 .11.
$11_
$11,(81] $ ($ܨ8]  $$!$!ө"8!&]d i4$ өȴ$ȴn>$$Өȴ8Ⱦ] * $ z4$($ܨz8]$ $ b&$0$: $b8g]  0$00?%3f$00&%26@80J]Y1Y2Y3Y0PY1Y2YYYYYZ1TPLZ2Z1FCOUNTFLISTFLOOPFINFO FLIST.NTLEN FINFO.LLYYY1YYY2YYYYYTAGYYVALYY1YYY0YYY1OUT1OUT2CIURITEXTYYYVCGIURI1COLSTDDTROTRTDDCJ ERRMESSAGETD MYSCALL1OUTFILEAOUT3ZZZZZTPLCOLS2MYSCALLPAGEJROWJFILTEROUT33 JBLHD.CUSTNABLINKJBLHDVROWVROWPROWPV V.F1 P.F1 V.F3WMS1WMS2WROWW W.F1 ITEMIDLISTINV1INV2IROWIROWI I.F1 I.F4 SHOPLINK SHOPLINKVIMGWMSLINKSHOWINVITEMIDAPISHOWTEXT1 CGI.ITEMIDTEXT2WROWTEXT3TEXT3AVIDSHOPNUMSHOPRECWMSRECRESULTWMSID CLOSEGRELOADWMS1AWMS2A W.F3GETXSUBFI1FILLXCOUNTELEMENTSD8TOJSETXGETGCGIVALDOSCALLCOLHEADURI-LCOLHEADURI