Magento Forum

Poll
Do you think the product import in Magento is too slow?
Yes, it should be improved! 613
No, it’s fine. There are more important things to work on. 19
What are you talking about? 1
Total Votes: 633
You must be a logged-in member to vote
Import Speed / Performance optimization
 
michael_g08
Sr. Member
 
Avatar
Total Posts:  108
Joined:  2009-03-06
Ukraine
 

Sorry, Maggi.
Forgot to add ; in line 43 echo “</table>”

Must be:

echo “</table>”;

Regards, Michael.

 
Magento Community Magento Community
Magento Community
Magento Community
 
YeoMos
Jr. Member
 
Total Posts:  15
Joined:  2009-05-08
Athens, Greece
 

michael YOU are a lifesaver!

I can’t thank you enough!
It works like a charm. I spent hours and hours of “idle” time uploading them stocks and prices. It took me 7 secs to update stocks that usually were updated in 6 hours !!!

I’m working on a “front-end” for this one, a “price-specialprice” updater and many other custom updaters i need for my client.

Thank you!

 
Magento Community Magento Community
Magento Community
Magento Community
 
michael_g08
Sr. Member
 
Avatar
Total Posts:  108
Joined:  2009-03-06
Ukraine
 

@ YeoMos.

You are welcome!

Michael.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nafnaf1000
Sr. Member
 
Total Posts:  209
Joined:  2008-02-21
 

he, I get this error???
Please help.

Fatal error: Uncaught exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TEMP TABLE IF NOT EXIST temp_table (sku CHAR(20), qty INT(32))’ at line 1’ in /home/monkeysc/domains/fiftymonkeys.com/public_html/lib/Zend/Db/Statement/Pdo.php:238 Stack trace: #0 /home/monkeysc/domains/fiftymonkeys.com/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/monkeysc/domains/fiftymonkeys.com/public_html/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array) #2 /home/monkeysc/domains/fiftymonkeys.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’CREATE TEMP TAB...’, Array) #3 /home/monkeysc/domains/fiftymonkeys.com/public_html/import/script.php(59): Zend_Db_Adapter_Pdo_Abstract->query(’CREATE TEMP TAB...’) #4 /home/monkeysc/domains/fiftymonkeys.com/p in /home/monkeysc/domains/fiftymonkeys.com/public_html/lib/Zend/Db/Statement/Pdo.php on line 238

 
Magento Community Magento Community
Magento Community
Magento Community
 
michael_g08
Sr. Member
 
Avatar
Total Posts:  108
Joined:  2009-03-06
Ukraine
 

@ nafnaf1000

Looks like You have permission troubles in mySql. Check it.

Try to run the query via phpMyAdmin or console.

Michael.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nafnaf1000
Sr. Member
 
Total Posts:  209
Joined:  2008-02-21
 

i dont seem to see any.

 
Magento Community Magento Community
Magento Community
Magento Community
 
YeoMos
Jr. Member
 
Total Posts:  15
Joined:  2009-05-08
Athens, Greece
 

@nafnaf1000

did you try `sku` instead of sku and so on?

 
Magento Community Magento Community
Magento Community
Magento Community
 
nafnaf1000
Sr. Member
 
Total Posts:  209
Joined:  2008-02-21
 

it is not a file issue. Looks like it is not even connecting to the db.....

any help please.

I have created new user name and passwords for the db. it has full access. noting is working.

 
Magento Community Magento Community
Magento Community
Magento Community
 
YeoMos
Jr. Member
 
Total Posts:  15
Joined:  2009-05-08
Athens, Greece
 

@ nafnaf1000
It’s not a connection issue

It’s an SQL statement syntax error (as clearly stated)

Try replacing *CREATE TEMP TABLE* with *CREATE TEMPORARY TABLE* in your script
I think this is the call

 
Magento Community Magento Community
Magento Community
Magento Community
 
nafnaf1000
Sr. Member
 
Total Posts:  209
Joined:  2008-02-21
 

I have tried everything… nothing is working for me :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
michael_g08
Sr. Member
 
Avatar
Total Posts:  108
Joined:  2009-03-06
Ukraine
 

@ nafnaf1000

do You have phpMyAdmin?

Try to run the query <code>CREATE TEMP TABLE IF NOT EXIST temp_table (sku CHAR(20), qty FLOAT)</code>

reply if it runs successfully there

Michael;

 
Magento Community Magento Community
Magento Community
Magento Community
 
nafnaf1000
Sr. Member
 
Total Posts:  209
Joined:  2008-02-21
 

Ok so i tried that and got a error. Please see image…

but when i do this there is no problem creating it

DROP TABLE IF EXISTS `temp_table`;
CREATE TABLE `temp_table` (
  `
storeint(32) default NULL,
  `
skuvarchar(24) default NULL,
  `
pricedecimal(12,4)  default NULL,
  `
special_pricedecimal(12,4) default NULL,
  `
qtyint(32) default NULL
ENGINE=MyISAM DEFAULT CHARSET=utf8;

You can see the error on URL

http://www.fiftymonkeys.com/import/script.php

Image Attachments
error.JPG
 
Magento Community Magento Community
Magento Community
Magento Community
 
michael_g08
Sr. Member
 
Avatar
Total Posts:  108
Joined:  2009-03-06
Ukraine
 

@nafnaf1000

Remove quotes “ at begin and the and of the query in phpMyAdmin. And run again.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nafnaf1000
Sr. Member
 
Total Posts:  209
Joined:  2008-02-21
 

CREATE TEMPORARY TABLE IF NOT EXIST temp_table(
`
skuCHAR20 ) ,
`
qtyINT32 )
)

MySQL saidDocumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXIST temp_table (`sku` CHAR(20), `qty` INT(32))' at line 1

Thank you for your help/

 
Magento Community Magento Community
Magento Community
Magento Community
 
YeoMos
Jr. Member
 
Total Posts:  15
Joined:  2009-05-08
Athens, Greece
 

its *EXISTS* not *EXIST*

CREATE TEMPORARY TABLE IF NOT EXISTS
-------------------------------------------------------------|

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