You have posted the whole flow 3 times!
Here is what we mean...
Use CTRL+I to import
[{"id":"a90a8daa731feceb","type":"join","z":"65f1b08076c1fc17","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"5","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":510,"y":220,"wires":[["0bc67f2dc294819e"]]},{"id":"0bc67f2dc294819e","type":"function","z":"65f1b08076c1fc17","name":"Generate SQL INSERT","func":"msg.topic = `INSERT INTO users (Fastener_Type, volume, production_date, batch_number, customer_id) \nVALUES (:Fastener_Type, :volume, :production_date, :batch_number, :customer_id)`\n//NOTE: msg.payload MUST have Fastener_Type, volume, production_date, batch_number & customer_id - use a DEBUG node to check!\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":710,"y":220,"wires":[["bc8eec020307c679","aca8c19392f75c72"]]},{"id":"7068f5728a61cb0c","type":"s7 in","z":"65f1b08076c1fc17","endpoint":"bdf21c90d7e888e0","mode":"single","variable":"Fastener_Type","diff":true,"name":"","x":320,"y":140,"wires":[["a90a8daa731feceb"]]},{"id":"a368340a154d3bea","type":"s7 in","z":"65f1b08076c1fc17","endpoint":"bdf21c90d7e888e0","mode":"single","variable":"volume","diff":true,"name":"","x":330,"y":180,"wires":[["a90a8daa731feceb"]]},{"id":"77d23295fbd0a7cd","type":"s7 in","z":"65f1b08076c1fc17","endpoint":"bdf21c90d7e888e0","mode":"single","variable":"production_date","diff":true,"name":"","x":300,"y":220,"wires":[["a90a8daa731feceb"]]},{"id":"42731e6eb062d973","type":"s7 in","z":"65f1b08076c1fc17","endpoint":"bdf21c90d7e888e0","mode":"single","variable":"batch_number","diff":true,"name":"","x":310,"y":260,"wires":[["a90a8daa731feceb"]]},{"id":"3e1d7e66f01a90a1","type":"s7 in","z":"65f1b08076c1fc17","endpoint":"bdf21c90d7e888e0","mode":"single","variable":"customer_id","diff":true,"name":"","x":310,"y":300,"wires":[["a90a8daa731feceb"]]},{"id":"bc8eec020307c679","type":"mysql","z":"65f1b08076c1fc17","mydb":"91ed457ccb906798","name":"","x":930,"y":220,"wires":[[]]},{"id":"aca8c19392f75c72","type":"debug","z":"65f1b08076c1fc17","name":"CHECK ME","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":930,"y":280,"wires":[]},{"id":"669bd7a7581cd396","type":"comment","z":"65f1b08076c1fc17","name":"For this to work, msg.payload MUST have... \\n * Fastener_Type \\n * volume \\n * production_date \\n * batch_number \\n * customer_id - use a DEBUG node to check \\n NOTE: \\n JavaScript is case sensitive!","info":"","x":830,"y":400,"wires":[]},{"id":"bdf21c90d7e888e0","type":"s7 endpoint","transport":"iso-on-tcp","address":"192.168.1.100","port":"102","rack":"0","slot":"1","localtsaphi":"01","localtsaplo":"00","remotetsaphi":"01","remotetsaplo":"00","connmode":"rack-slot","adapter":"","busaddr":"2","cycletime":"1000","timeout":"2000","name":"PLC1","vartable":[{"addr":"DB7,INT4","name":"Counter_Up"},{"addr":"DB8,INT4","name":"Counter_Down"},{"addr":"DB1,X0.4","name":"Reset"},{"addr":"DB3,INT4","name":"Counter_Right"},{"addr":"DB1,X0.0","name":"Up"},{"addr":"DB1,X0.1","name":"Down"},{"addr":"DB1,X0.2","name":"Right"},{"addr":"DB1,X0.3","name":"Left"},{"addr":"DB1,X0.5","name":"Start"},{"addr":"DB1,X0.6","name":"Stop"},{"addr":"DB1,X0.7","name":"Stop Service"},{"addr":"DB2,S1280.256","name":"Fastener_Type"},{"addr":"DB2,S1536.10","name":"volume"},{"addr":"DB2,S1792.10","name":"production_date"},{"addr":"DB2,S2048.10","name":"batch_number"},{"addr":"DB2,S2304.10","name":"customer_id"},{"addr":"DB6,INT4","name":"Counter_Left"}]},{"id":"91ed457ccb906798","type":"MySQLdatabase","name":"","host":"127.0.0.1","port":"3306","db":"2D_Barcode","tz":"","charset":"UTF8"}]
