I've been trying to import products from Magento 1.7 to 1.9, but have been running into a lot of problems.
When trying to export with System-Import/Export-Export and then Importing through Dataflow Profiles I'm getting the error:
Skipping import row, required field "sku" is not defined.
I tried saving with encoding UTF-8 in Sublime Text 2, but that didn't work.
When trying to export through dataflow profile and then import through dataflow profile the products don't show up, but it does finish the import without errors.
Processed 100% 241/241 records Imported 241 records
Here a person found a solution, but I do not really understand what he did there: https://stackoverflow.com/questions/12953584/product-is-not-displaying-in-listing-in-magento-after-import
EDIT: Products appear under category products and when making new product, you can select them as related product.