Importing product listings from a text file

[DandA]

I'd like to set up a store that pulls the products and all related descriptions, prices etc from my manufacturer. They have provided us with a link to a flat file with all the information.

It appears that the file was done in Excel, using a tab deliminated whatever you call it, and uploaded as a .txt file.

 

My question is this:

 

Is there a contribution that pulls this information from the link given, and then imports it into the mysql database? I do not want to have to manually insert products or have to update them at all, I want it all automatic...

 

Anyone have an answer?

 

Thanks,

Anne

[coookie]

Hi there!

 

Have a look at this.

 

Maybe you need to adjust your text file a bit, but this might bring you further.

 

 

Good luck,

Sascha

[KennethS]

I don't think there is a contribution for this. More than likely you would have to write a parsing routin for oscommerce to import the text file (Which is uber annoying). A php coder starting out and needing a little moola could probably write you a script that could parse the text file into a SQL importable format, then you could just import it.

[KennethS]

Or maybe there is a Contribution ;)

[Guest]

you can use excel, write a vbscript which will extract the data from your vendor, place it into the correct format for using easy populate, then you will need to upload easy populate which will update your inventory.

 

the support thread for easypopulate is ere: http://www.oscommerce.com/forums/index.php?showtopic=64945

so if you have any questions AFTER you have read the instructions AND the easypopulate.php file, post at the end of the thread for support.