Magento - Products import successfully but do not appear in backend or frontend. - Magento DataFlow - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

Products import successfully but do not appear in backend or frontend.

marktridk Total Posts: 10 Joined: 2012-01-05 Ignore user	It is a very-very common and frustrating problem. I had already saw a lot of posts on it. This post should give an answer why data is not showing up http://www.file2cart.com/blog/6582-what-to-do-when-magento-products-images-categories-do-not-show-up
	Posted: January 29 2013 \| top \| # 46

bill_baroud Total Posts: 4 Joined: 2010-02-11 Ignore user	I resolved it by changing the status value from “1” to “Enabled”.
	Posted: February 7 2013 \| top \| # 47

Monty22 Total Posts: 686 Joined: 2013-01-01 Ignore user	Hi, Products import successfully but do not appear in backend or frontend is comman Issue.I want to suggest one solution for this. Just Rename your .htaccess file inside the /media directory to .htaccess-old. This will absolutely resolve your image issue. I hope this will help many of you and you will not have to surf plenty of sites for such an issue. Monty iLoveMage No 1 Web Development and Magento store. Signature Get 15% discount on all our extensions Use code MON15 \| Risk-free purchase with our 14 days Money Back Guarantee policy!
	Posted: February 11 2013 \| top \| # 48

wahabr Total Posts: 8 Joined: 2010-05-21 Amman Ignore user	An external snippet you run if you dont have a lot of products, or you have a lot of time for a fix. run from shell , drop the file on the root folder of magento. <?php require_once 'app/Mage.php'; umask(0); Mage::app('admin'); $products = Mage::getModel('catalog/product')->getCollection(); foreach($products as $pro){ $pro->setStatus('true'); $pro->save(); unset($pro); $counter++; echo "\r " . $counter; } ?> Signature People think it must be fun to be a super genius, but they don’t realize how hard it is to put up with all the idiots in the world My Website/Blog MySQL/PHP , Wordpress, Drupal, Magento, CSS/XHTML, CakePHP
	Posted: March 5 2013 \| top \| # 49

npoulin Total Posts: 1 Joined: 2013-03-06 Ignore user	I had this issue. I was using import not dataflow, It reported a successful import but some of the products weren’t there. In the system.log however there were some errors. It turned out the problem was the csv file wasn’t UTF-8. Once I fixed that all the products imported correctly. So check your logs maybe there are some errors there that didn’t get reported to the webpage.
	Posted: March 6 2013 \| top \| # 50

ricardoquiroz Total Posts: 1 Joined: 2011-12-12 Ignore user	remyamohan85 - 11 October 2011 09:59 PM Hi All I Found the solution Try to Upload the csv with “status” as value 2. And you can see all ur products on back office but with status as Disabled. Now select all products and Cilck on “Actions” select Update Attributes tou can then changes the status there to Enabled.It works fine for me peacefully for 100 products. Enjoy Coding That did the trick for me. Thanks! People, the issue here is that when importing the data is not actually imported, so what needs to be fix is the importation process, and by importing using status 2 (disabled) and changing it manually does the trick. Ricardo
	Posted: 1 month ago \| top \| # 51

babumsouza Total Posts: 2 Joined: 2011-06-02 Ignore user	SOLUTION IN ENGLISH FOR MAGENTO IMPORT .CSV PRODUCTS For those of you that have felt de frustration after importing a product list in .csv format in Magento, finding all data perfectly imported in Admin, only to find that the products do not appear in the client front view. It happens because Magento uses encryption and identification when configuring your store. The importation script that Magento uses is not considering this encryption. To solve this problem, follow these steps: After importing your product list in .csv format, go to Product Management in Magento Admin. Check the check boxes of the products that you imported and click on “Edit status”, then select “Activate”, and “Send.” Magento will use the activation script, using encrypting and identification. The products should now appear for the end users. It worked fine for us; hope it will help you guys as well. Bruno Monteiro - bruno.monteiro@digisales.com.br Barry Koot - barry.koot@digisales.com.br SOLUTION IN PORTUGUESE - PARA IMPORTAÇÃO DE PRODUTOS VIA .CSV MAGENTO Para vocês que já tiveram a frustração de importar um lista de produtos no formato .csv no magento e ver tudo perfeito no Admin, só que no front view do cliente o produto não aparece, não se desespere! Isso acontece por que o magento utiliza um a chave de criptografia e identificação definida no momento da configuração da loja. Sendo assim, o script de importação utilizado pelo magento, não está considerando esta chave ao importar os produtos. Por isso no Admim aparece tudo perfeito, mas para o usuário final o produto não é visto. Para solucionar este problema siga as seguintes etapas: 1) Após realizar a importação com sucesso da sua lista de produtos no formado .csv, vá a página de gerenciamento de produtos no Magento: Catálogo/Gerenciar Produtos 2) Marque os check-box de todos os produtos que você importou. E clique sobre a Ação: Alterar Status, em seguida selecione o Status: Habilitar. Clique sobre o botão Enviar. 3) Dessa forma o Admin do magento irá processar o script de HABILITAÇÃO do produto, utilizando a chave de criptografia/identificação utilizada no ato da configuração da loja. Ps. Para mim funcionou! Espero poder ajudar vocês. Bruno Monteiro - bruno.monteiro@digisales.com.br Barry Koot - barry.koot@digisales.com.br Image Attachments Click thumbnail to see full-size image
	Posted: 2 weeks ago \| top \| # 52

Magento Community

Magento Community

Back to top

How do I exclude all images on CSV import in Magento 1.5?

Import/export related products and upsells on 1.5.0.1 +