Importing a spreadsheet
I have a question regarding importing an excel spreadsheet (or would CSV be better?) to the products database. Is there a way?
And I know it will require images (small and large) - so how would I get those added to the products once it's imported? Will I need to upload the images via ftp before hand and then input the full URL to where they are -in the spreadsheet?
If any of this is possible (I'd imagine it has to be to allow for people with huge product lists) - where would I import it - the MySql database? Would I need specific headers or places where the data would need to be?
I'm guessing I could use phpAdmin and export the database once I add one product and then it might give me a reference to know where to put the data? Would that work? Is there an easier way?