I have recently been importing a customers products into Magento with varying success. Hopefully this post will point you in the right direction to avoid many of the pitfalls I have discovered.
I have found that the best way to import your products into Magento is to manually create a single product in each category, export the csv file of products, edit the CSV for the new products and then import again.
Export
From the Admin Panel. ‘System’ -> ‘Import / Export’ -> ‘Profiles’.
For those that aren’t aware, Automattic have created an excellent reference site for WordPress users with howto videos covering a wide range of subjects and tasks.
WordPress.tv is Your Visual Resource for All Things WordPress
WordPress.tv is an excellent site and since virtually all the non e-commerce sites I create now are WordPress based, this will become very handy.
Here are a couple of the most common things I get asked about.