Magento – After Importing Products, Products are not editable and also not visible

dataflowimportmagento-1.9

its me again. My question was not solved yesterday after working a lot of hours figuring it out i could import products without errors. But the new error now is, those imported products are shown under it's subcategory but i can't access it and in the frontend it shows only for the category how much products are in there but none is visible.

Backend View:
Admin Backend in the Categorysection:

Frontend View:
Category in the Frontend:

Import without error:

In the Backend under Manage Products there is no product of the imported ones visible.
What should i do?

Best Answer

I've found the solution. I took the link of a not shown product guided by this:

If your products are showing in the database, so try to do the following:

Go to catalog -> manage products. Your current url will look like:

[yoursite.com]/index.php/admin/catalog_product/index/key/[your_key]/

Change this url to [yoursite.com]/index.php/admin/catalog_product/edit/id/[product_id]/key/[your_key]/

You can find the product ids in the database. When you enter this url, you can edit the product and check/edit product attributes, like tax class, status, etc. After that you can check which values are not filled and in this way you can clearly see all little mistakes by the Values in the CSV.

Related Solutions

Magento – magento import not working for products set with visibility of 1 (not visible individually)

after hours of frustration I realized that these items (the ones with visibility set to 1) had descriptions that ended in

"..." (three periods - I actually wrote "loading...").

Apparently these three dots were screwing up the CSV (or the way Magento reads the CSV). Remove the three dots and everything works!!!

I am writing this here on the off chance that someone else encounters this same issue.

Magento – Products not showing in frontend

OP noted that setting the website IDs seems to resolve the issue:

$products = Mage::getModel('catalog/product')->getCollection();

foreach($products as $product){
    $product->load();
    echo "Disabling product: ".$product->getSku()."\n";
    $product->setStatus(2);

    $product->save();

    $product2 = Mage::getModel('catalog/product')->load($product->getId());
    echo "Enabling product: ".$product->getSku()."\n";
    $product2->setWebsiteIds(array(Mage::app()->getStore(true)->getWebsite()->getId()));
    $product2->setStatus(1);

    $product2->save();
}

Best Answer

Related Solutions

Magento – magento import not working for products set with visibility of 1 (not visible individually)

Magento – Products not showing in frontend

Related Topic