StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow do I have to import products in Magento using a direct connection to the database
text
Body
copied!<p>I have about 50.000 of records to import in a Magento store. What I have already tested: The file is about 50 MB.</p> <ul> <li>Splitted files</li> <li>API</li> <li>Magento Classes</li> </ul> <p>Splitting the file doesn't improve the speed of the importing of the products. Api are very slow. Magento Classes are slow.</p> <p>This is a snipped of code using the Magento Classes:</p> <pre><code>// Build the product $product->setIsMassupdate(true) ->setExcludeUrlRewrite(true) ->setManufacturer($this->addManufacturers(utf8_encode($record[4]))) ->setSku($record[3]) ->setAttributeSetId($this->attribute_set)# 9 is for default ->setTypeId(Mage_Catalog_Model_Product_Type::TYPE_SIMPLE) ->setName(utf8_encode($record[5])) ->setCategoryIds($this->getCategories(array($record[0], $record[1], $record[2]))) # some cat id's, ->setWebsiteIDs(array(1)) # Website id, 1 is default ->setDescription(utf8_encode($record[6])) ->setShortDescription($this->shortText(utf8_encode($record[6]), 150)) ->setPrice($price) # Set some price ->setSpecialPrice($special_price) ->setWeight($record[12]) ->setStatus( Mage_Catalog_Model_Product_Status::STATUS_ENABLED ) ->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH) ->setTaxClassId(2) // default tax class ->setPixmaniaimg($record[10]) ->setStockData(array('is_in_stock' => $inStock, 'qty' => $qty)) ->setCreatedAt(strtotime('now')); $product->save(); $ID = is_numeric($productID) ? $productID : $product->getId(); </code></pre> <p><strong>So the above method is correct but it spends about 5 hours in order to insert only 2300 records!!</strong></p> <p>Which are the simple SQL inserts that I have to execute in the Magento DB in order to add a new product?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload