<>&! 03TIMIMP1 - REVIEW/UPDATE TIMBERLAND IMPORT FILES 3created from SHOPGET0 3 TIM UPDATES IN EDCSVTIM001 $ST"R$U$VUWJCUST,UW.tpl1U"U,UW X"#R$U$YUWJITEM,UW.tpl1U"U,UW Z"$V$U$[UW JBDEALERS,UW.tpl1U"U,UW \"%T$U$]UWWMSBOM3,UW.tpl1U"U,UW ^"&.$_$,_/u/whp/tss/DATA/CONSEMAILADDR'1VSA`($=$,=JBLHD)$>$,>JBLHH*$?$,?JBLFH2$%<'$,/u/whp/tss/timberland/received/F6$e%CONSNAME:C(1*=9),SHIPDATE:C(1*=9),REFNUM:C(1*=9),CONSADDR1:C(1*=9),CONSADDR2:C(1*=9),CONSADDR3:C(1*=9),CONSCITY:C(1*=9),CONSSTATE:C(1*=9),CONSZIP:C(1*=9),COUNTRY:C(1*=9),PONUM:C(1*=9),TERMS:C(1*=9),SHIPVIA:C(1*=9),QTY:C(1*=9),ITEMCODE:C(1*=9),DESC:C(1*=9),CONSEMAIL:C(1*=9),MESSAGECODE:C(1*=9) den@@ $/admin/products?limit=99$s$+k
"$",0$""F۩(:c(1*),*6$4"" SHOWFILE$ FILENAME".3default to showing the files$3---- validation error.$778 / 8$6~83DISPLAY SHOPIFY INFO IN WINDOW# DOUPDATEYES$5$6$*Shopify$1,۫SHOWFILE0$cat 1 | /usr/local/bin/csv2tab.shU$  2$*PO ID,Name,Comment,Phone_number,Order #,SKU #,Product,Unit Price,Qty,Total Cost,Status,Ship Date,Qty Shipped,Qty Backordered,Shipped to: Acct,Shipped to: Location,Shipped to: Address 1,Shipped to: Address 2,Shipped to: City,Shipped to: State,Shipped to: Zip,Shipping Company,Tracking #,Desired_date 5$BOL#,$0

Timberland Order File: 1

[
۫#M 5E$ width:900px;$width:1000px; background-color:#ccc;3scan through recordsB$ $-  $7 .4$.-   E$..""|.."..|" @/PO ID 3HEADERP 3validateZ63if R.F3$="" THEN LET E$="Missing Comment"; GOSUB 4900\' @3$8Missing Order#$^ @9_`_$8 Invalid Qty$n$8U 8$x$8p 8$ 2: @32.$
 X$< 5 $<} .$۫<. 7$2@3H z .$z.${{Ia۩(Ө@9 ##########۩F @~N۩@~{${{C۩A@~3---------- doneJ$
T 5 X ^z 6o$^

FIX ERROR MESSAGES NOTED BEFORE UPDATING

rY$:; &PGMFUNC=CALL۩# &SHOWFILE=۫SHOWFILE&POPUP=1&DOUPDATE=YES|_$,

)$  3update is complete 3move file 3$mv 1 /u/whp/tss/timberland/processed*U4$
+fp3VERIFY ITEM CODEu$8z$aA@b 1YSAaZ 3CHECK KIT$cSAa۩1]c^8$8INVALID ITEM/KIT CODE8X#3----------- DO THE UPDATE IF READY]$}b 58d {8l d dv$@f@g@h@i$@j@k@l@m@n@o$@p@q@r@s@t$@u@v@wUSA@x@y$@ 3RD PARTY@120${{۩AC****************************,${{۩ACTHIRD PARTY BILLING TO: #${{۩ACACCT# 132719535${{۩A CTIMBERLAND$${{۩AC200 DOMAIN DRIVE'${{۩ACSTRATHAM, NH 03885  ! ORDERUPD1Ad{|}8@3errorJ=$error ۩(Ө at line ۩(Ө" in ۩#E2#(3#<($$, 1LK? #F$>
RAW RESULTS




#P$۫||| #Z63show paths#&H3---------- exit clean&&3done'U'$@AB@/C@3'L(<3ALL "LA_FIND_DUP",WFCUST$,XX$,XXX$,LA_DUP_BL$,LA_DUP_MSG$,LA_DUP_MSG1$'1 POD$8DUPLICATE FOUND IN E'2 REFD$8DUPLICATE FOUND IN E(;U 8(<U 3CODE FROM LA_FIND_DUP(nB$FGHIJKLED(x3HISTORY(%$M>NCO)6$IP(%$M=NCO)6$JP(%$M?NCO)6$KP(%$M>NBO)6$FP(%$M=NBO)6$GP(%$M?NBO)6$HP($DE( L)(! IJK$D REFERENCE(< FGH, D $DPO$DD & PO( KH$EFUTURE(B JG6 E$ECURRENT$EE & CURRENT(B IF6 E$EHISTORY$EE & HISTORY)))63FIND)@$P)J1MON)T)T/$QM) Q N))^ 1MR)h R@)T)r$P)|$LQL)U 8)8*$3-------------- CONTACT THE FTP SITE+-$%exec /usr/local/bin/whp/timberlandftp+ U+=$
+R8.3------------- DISPLAY FILES.($ File,Date, Size, Orders, Action,. *3ftp.2$find , -printf '"%P";"%Tc";"%s";\n'/:U/D$7

Timberland Order Import Files ,

Z
۫#/B$  2d$-/ .4$.-; /$.."/ @///$0Ureview0 *$۫. 00p/2d32x$
2)$ 2&H2U36$3@;$'WFDIRtmp/۩#۩(Өө.TXT3J $ >  2>&13T(3A=SCALL("echo -e ""\n\n"" >>"+OUTFILE$)3^$ $, 33^10031 B?333^1003 4N86&3"get all paths from the json in out2$6*$/usr/local/bin/jq_getpaths.sh 6261$$
7 8@3------ LINK TO STOCKDETAILS@[ @&NAB001$'[ASN@8J  1$!  .!!.
$!!_
$!!,8!] $ ($ܨ8] $$$ө8&]d i4$ өȴ$ȴn>$$Өȴ8Ⱦ] * $ z4$($ܨz8]$  $ b&$ 0$   : $ b8 g]  $ ?%3f$ &%26@8 J]PYYYYYYYY1YYY2YYYYYTAGYYVALYY1YYY0YYY1OUT1OUT2CIURITEXTYYYVCGIURI1COLSTDDTROTRTDDCJ ERRMESSAGETD MYSCALL1OUTFILEAOUT3ZZZZZTPLCOLS2MYSCALLPAGE JBLHD.CUSTNABLINKJBLHDWMS1APISHOW CLOSEGRELOADRECDIRR1R R.F1TIMLINKDOFILE LASTORDER R.F5CTPL DOUPDATE VALIDFILEERRMSGE R.F9CGIURLWFCGI1BOLCOLJBLHDJBLHHJBLFH CUSTOMERWFCUSTPOREFMSGMSG1PO_HPO_CPO_FREF_HREF_CREF_FBLFLFINDKFOUNDKCUSTC WFCOCODEFJCUSTFJCUSTJITEMJITEM JBDEALERS JBDEALERSWMSBOM3WMSBOM3CONSEMAILADDRBLDG_CDIT R.F6KITIRECITPL IREC.CONSNAME RR.F16 IREC.SHIPDATE RR.F24 IREC.REFNUM RR.F5 IREC.CONSADDR1 RR.F17 IREC.CONSADDR2 RR.F18 IREC.CONSADDR3 IREC.CONSCITY RR.F19 IREC.CONSSTATE RR.F20 IREC.CONSZIP RR.F21 IREC.COUNTRY IREC.PONUM RR.F1RRILINESRESULT1BOL1 R.F3 IREC.TERMS IREC.MESSAGECODESUBD8TOJSETXGETGCGIVALDOSCALLCOLHEADURI VERIFY_DUPVERIFY_DUP_RETURN LA_FIND_DUP FIND_RETURN