automatic update from txt file

[Swanfly]

What is the "right" way to update store's database, if i have txt file that contains products ?

 

here is sample how i get products info from agent..

 

BAREBONES	
MSI (MICROSTAR)
HETIS 865GV-E LITE	HETIS 865GV-E LITE, PRESCOTT, AUDIO 5.1	-1	147.70	
HETIS 865GV-E LITEBL	HETIS 865GV-E LITE BLACK, PRESCOTT	-1	147.70	
HETIS 865GV-E, BLACK	HETIS 865GV-E BLACK, PRESCOTT, AUDIO 5.1	-1	152.90	
HETIS 865GV-E, WHITE	HETIS 865GV-E, PRESCOTT, AUDIO 5.1	-1	152.90	
HETIS 915	HETIS S775 I915GL BLACK 7.1 GBLAN FW	-1	184.60	
HETIS 915 BLACK	HETIS S775 I915GL BLACK 7.1 GBLAN FW BL	-1	184.60	

ASUSTEK
P1-PH1 BB. ID1	ASUS BB PUNDIT-PH1 ID1 ATI RS400 S775 P4	-1	155.60	
P2-AE2	ASUS PUNDIT2 S754 VIA K8M800 VGA 6CH	-1	147.20	
PD-AE3	ASUS PUNDIT S754 SIS 760GX VGA 6CH	-1	96.70	
PD-PH3	ASUS PUNDIT S775 I915G VGA 6CH PCI-E16	-1	132.50	
S1-P112	ASUS S-PRESSO STANDARD 865G S478	-1	147.20	
S-PRESSO DELUXE	ASUS BB 865G S-PRESSO DELUXE, S1-P111	-1	168.20	
T2-AE1	ASUS TERMINATOR S754 760GX LAN IEE1394	-1	96.70	
T2-AH1	ASUS TERMINATOR S939 RS482 VGA LAN FW	-1	131.40	
T2-P DELUXE	ASUS TERMINATOR2 I865G S478 7IN1	-1	86.20	


DVD / VIDEO	
SONY
DAVDZ700FW.CE2	SONY-KOTITEATTERIPAKETTI  DAV-DZ700FW	-1	671.30	
DAV-LF1	SONY-KOTITEATTERIPAKETTI DAV-LF1	-1	1913.80	
DVP-LS785V	SONY DVD  DIVX, 12BIT/108MHZ VIDEO DAC	-1	140.00	
DVP-NS955V/B	SONY DVD DVP-NS955V/B,BLACK	-1	346.00	
DVP-NS955V/S	SONY DVD DVP-NS955V/S, SILVER	-1	346.00	
RDRGX210B.EC1	SONY TALL. DVD, RDR-GX210, MUSTA	-1	282.30	
SLVD970PE2S.CED	SONY DVD/VHS SLV-D970	-1	188.30	
SAMSUNG
DVD-R119/XEE	SAMSUNG DVD-R119 TALLENTAVA DVD	-1	176.47	
DVD-HR720	SAMSUNG TALLENTAVA DVD HR720, KOVALEV	-1	340.00	
DVD-HR725	SAMSUNG TALLENTAVA DVD HR725, KOVALEV	-1	571.76	
DVD-HR730/XEE	SAMSUNG TALLENTAVA DVD HR730, 80GB	-1	399.41	

MOVIES	
MUUT
2422	KAIKILLA MAUSTEILLA (EOL)	-1	4.95	
27721	MENNEISYYDEN OTE DVD	-1	6.60	
30916834	SIGNS	-1	6.60	
31104130	KARHUVELJENI KODA DVD	-1	10.30	

MOTHERBOARDS	
SOLTEK
SL-02USB	SOLTEK USB 2.0 CARD	-1	21.50	
MSI (MICROSTAR)
649 NEO-V	MSI S775 SIS649 PCI-E AGR SATA RAID 6CH	-1	54.80	
661FM3-V	MSI S775 SIS661FX MATX LAN VGA(64) AGP 	-1	53.80	
848P NEO2 V	MSI 848P S775 800 6CH LAN SATA AGP	-1	54.80	

INTEL
BLKD101GGCL	INTEL "GRANT COUNTY" VID,AUD,DDR,LAN	12	50.41	
BLKD915GAGLX	INTEL 915G S775 MATX DDR PCIE+VGA	12	67.76	
BLKD915GEV	INTEL "EATONVILLE" VIDEO,AUD,DDR2,BULK	12	68.51	

ASUSTEK
P5GD1	ASUS S775, 915P, PCI EXP.16X/1X, DDR	-1	86.20	
A8N32-SLI DELUXE	ASUS S939 NF4 SLI DDR PCI-E 2*GLAN FW	-1	184.20	
A8N5X	ASUS S939 NF4 PCI-E 8CH GLAN SATA RAID	-1	65.40

[Guest]

use it as a csv file, see this thread,

http://www.oscommerce.com/forums/index.php?showtopic=172479

 

or with the easy populate contribution.