I don't know how this will work for you, but I can tell you what I did for a client of mine with about 3500 items. I exported their product listings as csv files, did any maniuplation, etc. in Excel, then imported the files into Peachtree using the File...Import feature.
Scott