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 with php
 
naujasdizainas
Sr. Member
 
Avatar
Total Posts:  128
Joined:  2007-11-04
Lithuania, Vilnius
 

Script example like this

<?
   $fcontents 
file ('./spreadsheet.xls')
  
  for(
$i=0$i<sizeof($fcontents); $i++) 
      $line 
trim($fcontents[$i]); 
      
$arr explode("\t"$line); 
     
      
$sql "insert into TABLENAME values ('"
                  
implode("','"$arr) ."')"
      
mysql_query($sql);
      echo 
$sql ."<br>\n";
      if(
mysql_error()) {
         
echo mysql_error() ."<br>\n";
      

}
?>

Question

I want insert only product into table, WHERE TABLE FOR PRODUCT NEED SUBMIT?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Done
Jr. Member
 
Total Posts:  7
Joined:  2008-09-05
 

You want to know the tablename?

 
Magento Community Magento Community
Magento Community
Magento Community
 
naujasdizainas
Sr. Member
 
Avatar
Total Posts:  128
Joined:  2007-11-04
Lithuania, Vilnius
 

Not ... I want know if product insert what is table to submit info and what is info ID name attribute option ,,, etc.

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