Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Importing product listings from a text file


DandA

Recommended Posts

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

Link to comment
Share on other sites

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.

Kenneth S

--------------

Customer "Are you a real programmer?"

Me "No, but I did stay at a Holiday Inn Express last night"

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...