Adding custom options to a product automatically while importing CSV in Magento is quite easy after all.
extend this file: app\code\core\Mage\Catalog\Model\Convert\Adapter\Product.php
look for: public function saveRow(array $importData)
Look for this:
if (!$attribute) {
continue;
}
It's been so many days i have been spending my time trying to figure out how to import products using CSV in Magento.
I recommended client to go for better server and as a result we moved to VPS. But that didn't help. Hosting company was so generous to work along with me to figure out what was actually wrong. They also spent many hours and haven't charged for VPS yet and I am free to use the server as I need. But I am not that good in server settings, but learnt a lot along the way :)
ini_set('memory_limit', '128M');
I mistakenly canceled one order and spent a day to go through magento & different forums and blogs and searching for a solution and this is how i fixed myself after few tries. I am still not sure how to extend the controller so i modified the core file and made a copy so i can paste back if overwritten when upgrade or i can copy when i find the solution how to extend or override a magento controllers.
Create a file @ app\code\local\Codefight\Adminhtml\Block\Sales\Order\Grid.php