Php report

Requirement: existing text file found on the server will be converted to sql data  on a set time
the data will be appended to the server sql the system will match existing item with  branch barcode and add the quantity to the total qty
sample text file
2|sungears sales, inc.|2|estancia|00001000|46|05/31/2020|00001000|gift card|others|giftcard|giftcard|0.00|1000.00
2|sungears sales, inc.|2|estancia|0067500214|0|05/31/2020|0067500214|fsv 1.61 white hmc s:-3.25 C:-1.75|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505198|0|05/31/2020|0067505198|fsv 1.61 as white hmc s:0.25 C:-0.00|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505206|0|05/31/2020|0067505206|fsv 1.61 as white hmc s:0.25 C:-0.25|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505214|0|05/31/2020|0067505214|fsv 1.61 as white hmc s:0.25 C:-0.50|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505222|0|05/31/2020|0067505222|fsv 1.61 as white hmc s:0.25 C:-0.75|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505230|0|05/31/2020|0067505230|fsv 1.61 as white hmc s:0.25 C:-1.00|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505248|0|05/31/2020|0067505248|fsv 1.61 as white hmc s:0.25 C:-1.25|lens|aspheric lens|sv hmc|0.00|0.00
output file will send via excel attachment