Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Import all products ERROR - please help
 
ewule1
Jr. Member
 
Total Posts:  1
Joined:  2012-07-05
 

Hi

Im using magento 1.7 .. i was trying to import a spreadsheet of about 3000 products. I had used opeoffice to save it in csv (utf-8) format.
The first time i tried, the magento import process froze, stopping at line 1080 of the spreadsheet. So i followed the advice in a post online, to spread the product list into 3 spreadsheets (each with about a thousand products). i started the import but this time the import window opened but stayed at 0 without counting up.  ..and afterward, the frontend showed the error message below.  I have read a lot of posts here while seeking a solution but no luck.
please advice

error message -----------------------------

There has been an error processing your request

SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user ‘ufos_722628_0001’@’linweb9.atlas.pipex.net’ for table ‘log_visitor’

Trace:
#0 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `lo...’, Array)
#4 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `lo...’, Array)
#5 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `lo...’, Array)
#6 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(’log_visitor’, Array)
#7 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor))
#8 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Log/Model/Visitor.php(167): Mage_Core_Model_Abstract->save()
#9 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(1338): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#10 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), ‘initByRequest’, Object(Varien_Event_Observer))
#11 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#12 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(528): Mage::dispatchEvent(’controller_acti...’, Array)
#13 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Front/Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(408): Mage_Core_Controller_Front_Action->preDispatch()
#15 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#16 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#18 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#19 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/index.php(87): Mage::run(’’, ‘store’)
#20 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Store_Manager
Enthusiast
 
Avatar
Total Posts:  867
Joined:  2012-07-09
 

Hi!
If you need to import in bulk great numbers of products, and you cannot do it online, I can offer you to try Store Manager for Magento with Bridge connection.  It has no limitations in the number of products you want to upload to your site, so there is no need for you to separate your .csv file into the smaller parts and it can be done locally and changes can be synchronized afterwards.

You can check trial version of the software - http://www.magentocommerce.com/magento-connect/store-manager-for-magento.html
Trial version has the same functionality as full version, so you can experience all the features it possesses.
In any case you can try it and then post your experience here.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top