Hi,
I need to update every hour produced by a txt file, can anyone help?
the file looks like this:

CodProdotto|EAN/UPC|CodProduttore|Brand|Thumbnail|FotoProdotto|FotoZoom|NomeProdotto|Descrizione Breve|Scheda Prodotto|Listino|PromoListino|ScadenzaPromo|ListinoRiservato|ListinoRiservatoPro mo|ScadenzaListinoRiservatoPromo|MacroCategoria|Categoria|Disponibilità|Peso
TR007704|||Acer|http://**.**.***.***/products/{AFF00F37-4B8A-4973-BF8F-C51ED48E497E}|http://**.**.***.***/products/{8042A028-0F5D-4422-828A-7239A78B9D1C}|http://**.**.***.***/products/{099F5883-47EA-42E3-8AAD-FF4DFEFD2100}|Monitor V203HB 20" LCD |DISPLAY 20" - WIDE - 1600 x 900 - 5ms - 10000:1 - 300cd/m² - NERO |http://www.sitoweb.net/pages/addon/basedati/export.asp?id={CEFEDB24-ACEB-432C-B389-14B956D7DE8B}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|111,62|0|||||Monitor e TV|Monitor LCD|2|11
ACLO0413||980-000413|Acer|http://**.**.***.***/products/{B29C26F7-8624-485F-A6EC-E865D6DA8FD2}|http://**.**.***.***/products/{C8AD4667-233C-45AF-81CB-7A1FFDC1B2F7}|http://**.**.***.***/products/{F0B32192-563C-44C9-A76D-F0D185E0C896}|Speaker System Z313|Sistema Audio 2.1 - Compatibile Windows Xp/Vista/7 e Mac|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={A9E1ED7C-F30F-41FC-BF43-58C7F3E452DB}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40|0|||||Audio e Video|Speakers|0|2
TR010042|||Acer|http://**.**.***.***/products/{09947F0C-840B-49D3-8D94-D4F2E949C6F6}|http://**.**.***.***/products/{EEAC067F-24AD-469A-AE77-910AEA1F51AF}|http://**.**.***.***/products/{72186082-5AB7-4993-A737-7FED24BDEAD4}|Aspire AS5732Z|Notebook Acer Aspire 5732Z - 443G50MNN (LX.PMZ02.049) - Cpu Intel T4400 - Display Lcd 15.6 CrystalBrite - Memoria Ram 3 Gb - HD 500 Gb - Wireless Wifi 802.11BGN - Batteria 6 Celle - Webcam - Windows 7 Home - Articolo soggetto a contributo SIAE di euro 2.40|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={8EDB4241-F047-48B2-9BF3-273C13539A0C}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|455,4345|0|||||NoteBook e NetBook|Notebook|0|4
TR010587|||Acer|http://**.**.***.***/products/{2CA54566-33EA-4772-BC81-77551D2E7141}|http://**.**.***.***/products/{CE72BACA-BE5F-4869-8917-C1967AE34584}|http://**.**.***.***/products/{CB9C421E-0B82-4946-88F5-5D5C4450FEB8}|Aspire 5738PG TouchScreen |Notebook Acer 5738PG-664G50MN (LX.PK802.059) - Cpu Intel Core 2 Duo P6600 - Display Lcd 15,6" Wide TOUCHSCREEN - Memoria Ram 4Gb - HD 500Gb - Vga Ati Radeon HD 4570 512MB dedicata - Webcam - Windows 7 Home 64Bit - Articolo soggetto a contributo SIAE di euro 2.40|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={E0B5DEAA-4AB4-4F07-AF18-E2D51DD5F508}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|619,974|0|||||NoteBook e NetBook|Notebook|0|8
TR010417|||Acer|http://**.**.***.***/products/{3D8275D4-6D81-4DA5-81E2-D30107277283}|http://**.**.***.***/products/{91C3D93B-E1EC-4CB5-9259-0A3237DBC3E6}|http://**.**.***.***/products/{35FB29F7-B169-449E-9162-15113EB6425B}|5541-304G32MN |Notebook Acer 5541-304G32MN (LX.PQN02.008) - Cpu Amd Athlon64 X2 M300 - Display Lcd 15.6 LED CB - Memoria Ram 4Gb - HD 320Gb - Wireless Wifi 802.11BGN - Batteria 6 celle - Webcam - Windows 7 Home Premium - Nero - Articolo soggetto a contributo SIAE di euro 2.40|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={7E69C071-8B29-406D-97A8-806231C7FDD4}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|464,1291|0|||||NoteBook e NetBook|Notebook|0|4,9
HWTEL799|8033779006296|715799|Alcatel|http://**.**.***.***/products/{9610D86A-D83C-40BF-AE16-6541676E152B}|http://**.**.***.***/products/{64E55752-32A4-4BD3-B369-0FCC4D3997A9}|http://**.**.***.***/products/{013CAA13-C135-402D-B906-D9AA2AB2A4C8}|X215s Chiavetta internet|TIM 715799 CHIAVETTA Alcatel X215s ROSSO|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={B28CAAEB-AE98-4A42-B886-13D8452C1CA9}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40,83|0|||||Chiavette internet|HSUPA 7,2|0|0,5
HWTEL797|8033779006272|715797|Alcatel|http://**.**.***.***/products/{28F4BC1A-4CE1-4FEF-AE58-682270D390D1}|http://**.**.***.***/products/{C2EBB25F-6189-42BD-8EE7-98CF551B7557}|http://**.**.***.***/products/{5073EE1F-E3B9-4F45-AFEA-6A8E4CD2327C}|X215S Chiavetta internet |TIM 715797 CHIAVETTA X215S Blu|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={CDA5ED64-85CF-4F7C-BCEF-3D108428FEE4}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40,83|0|||||Chiavette internet|HSUPA 7,2|0|0,3
HWTEL798|8033779006289|715798|Alcatel|http://**.**.***.***/products/{654F0870-6E47-45D9-91C8-606CDFB9E001}|http://**.**.***.***/products/{DAF1CD98-7A61-4067-BC22-EFA8DAA51EB6}|http://**.**.***.***/products/{606E8757-68CD-4599-B08B-3036E5AC8FCA}|X215s Chiavetta internet |TIM 715798 CHIAVETTA X215s Azzurro|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={7E142253-C097-4002-9685-9635954FC0F2}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|40,83|0|||||Chiavette internet|HSUPA 7,2|0|0,5
TR008239|||AMD|http://**.**.***.***/products/{F3E917A9-74C9-416D-B6F2-2922DC9D457B}|http://**.**.***.***/products/{A75F8BDD-EB67-40F6-8CB2-9FB6C3216531}|http://**.**.***.***/products/{868B6BDB-A7E1-47FA-B043-07923D49D653}|CPU SEMPRON 140 AM3 BOX|CPU Sempron 140, Single Core, Core Sargas, 45nm, 64bit, 2.7GHz, FSB 2000MHz, Cache L2 1MB, Socket AM3, Box, 45W, attivo|http://www.sitoweb.net/pages/addon/basedati/export.asp?id={9C618E67-7E0D-4D8D-B4EB-A0EAC279B4D7}&uid={7EBB446D-6C27-4FD7-8A08-9BA2A5E02992}|34,3052|0|||||CPU processori|SK AM3|0|0,6


I create a php script, but I do not know MySQL commands and tables on which to operate.
Zencart version is 1.3.8
Thank you.