I am facing a very strange problem with custom options import for a product. The custom option with file type is not creating in the product. I have also checked the database for this. There are no rows inserted for the file type whether the other options with other types are saved and also showing in backend and frontend. Also there is another problem that when i import the products they do not show on the frontend because the Website is not set for the product. I didn't find any option to set the website for the product and i have do it manually from the actions dropdown using Update Attributes and setting the product to the website. Please someone help me as it very urgent.
Finally find the solution for the problem with the csv after digging deep into the code.
Posting it here if anybody needs the same.
For the file upload problem go to
and on the line no. 684 uncomment the line
'file' => array('price', 'sku', 'file_extension', 'image_size_x', 'image_size_y'),
I don't understand why this is commented by default in magento.
And the products were not showing on the frontend just because of the indexing. After reindexing all the product tables I got all the products on the frontend