Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

My vendors provide spredsheet inventory


CGIMana

Recommended Posts

Posted

I get spredsheet data for iventory..from my daceasy database, and two of my major vendors. ALl in spredsheet .xls format how do I add it to my database easily?

Posted

I'll have an example of the spredsheet tommrow if that would help any. It would be no problem to move it around so that it would be orginized right inorder for import. like item serial# discrption..ect you know what I mean.

Posted

So out of the entire comunity....no one know how to insert spredsheet data into my item database?

Posted
So out of the entire comunity....no one know how to insert spredsheet data into my item database?

Easy Populate is what you want.

 

However, the data you pass to EP needs to be in the correct format and if you are importing data supplied by someone else you may find this awkward.

 

If you are at all interested, I suggest you check this out....

 

http://www.oscommerce.com/community/contributions,2067

 

This contains a number of natty scripts. One of them is called import_data (or import_foreign or something - can't remember now). This does some stuff that will knock your data into the required format. It's not a 2 minute job to set it up, but once you have, it will save you HOURS, even though I say so myself :-)

 

Rich.

Archived

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

×
×
  • Create New...